Workflow “Quality Control” – what’s your process?

  • Workflow “Quality Control” – what’s your process?

    Posted by David Cutler on August 20, 2024 at 12:45 pm

    Currently my workflow has 4 basic steps:

    1. Complete Takeoff in Revu

    2. Export Markups List as a .CSV and wash data using Power Query in Excel (thank you @Doug McLean )

    3. Import into B2W (our estimating package – AKA Bid 2 Win)

    4. Refine the estimate in B2W and prepare proposal

    On a recent proposal I found an issue where I identified an additional area of pavement mill & overlay after step 2 above, so the additional quantity didn’t make it into my .CSV export and into B2W with my import. I missed adding it after the import was complete.

    While it isn’t going to make or break the job, I’m embarrassed that I allowed it to happen. I’ve added a line into my “Bid Process” spreadsheet that indicates “ENSURE THAT ANY QUANTITIES MEASURED AFTER EXPORT FROM REVU/IMPORT HAVE BEEN UPDATED”, but figured it would be worth asking the community how you avoid/check to catch these type of issues.

    Thoughts?

    David Cutler replied 4 months ago 3 Members · 8 Replies
  • 8 Replies
  • Troy DeGroot

    Organizer
    August 20, 2024 at 1:10 pm
    Points: 23,739
    Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown Belt III

    I always have checklists. They get so long, that I have categories and sub-categories🤣.

    • David Cutler

      Member
      August 21, 2024 at 7:03 am
      Points: 26,754
      Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

      I’m at just under 160 steps in my process @troy-degroot ….

      There is more detailing to be done though… 🙂

  • Doug McLean

    Member
    August 21, 2024 at 4:01 pm
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    The best part about Power Query is that you can simply refresh it once you have a new Markup Summary

  • Doug McLean

    Member
    August 21, 2024 at 4:10 pm
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    (I subscribe to the GIGO philosophy)

    My QC starts right when I’m building my tools. If they’re set up right, so many steps become easier all the way through the process.

    Reviews at certain steps. Although check points don’t improve quality, they do make sure that its right before it passes to the next step.

    I keep a standard BatchConfig file to consistently output only the required data.

    Regular updates. Always be looking for ways to improve.

    Team reviews. We always review all of our bids as a team. It really helps in making sure that you have everything

    Above all else, don’t try to be perfect. You’ll make a mistake. Learn from that mistake, and try not to make it a second time.

    • David Cutler

      Member
      August 22, 2024 at 6:51 am
      Points: 26,754
      Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

      “Above all else, don’t try to be perfect. You’ll make a mistake. Learn from that mistake, and try not to make it a second time.”

      I may have to print that out and hang it on my wall @Doug McLean

    • Troy DeGroot

      Organizer
      August 22, 2024 at 5:13 pm
      Points: 23,739
      Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown Belt III

      A team review is a great training opportunity as well. new people, new tools, new workflows. You make the most progress with an implementation when you show what’s possible beyond the current.

      • Doug McLean

        Member
        August 23, 2024 at 8:10 am
        Points: 15,212
        Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

        Funny you should mention that because that happened this past week.

        We had a really odd set of plans from an apartment complex where the elevations didn’t make sense. So we tried to do an overlay with the 1st 2nd and 3rd level floor plans to try and figure it out.

        For whatever reason the gridlines weren’t lining up properly using the Overlay, so I switched over to using snapshots.

        All of my team are reasonably good Revu users, but I don’t think I’d ever shown them this technique before and it was pretty cool.

      • David Cutler

        Member
        August 23, 2024 at 8:40 am
        Points: 26,754
        Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

        We basically have 2 teams with 1 person on each team. I try not to talk to myself too much so the “team reviews” are pretty quick with little opportunity to show new tool approaches… 🙂

        I rely on my UChapter2 “team” for sharing of innovative ideas…

Log in to reply.