How do you roll up markups across a whole set of PDFs?

  • How do you roll up markups across a whole set of PDFs?

    Posted by Troy DeGroot on October 4, 2026 at 6:44 pm

    Here’s a question I love asking, because I never get the same answer twice.

    You’ve got a whole set of PDFs, maybe a full drawing package, and every sheet has markups on it. You need one clean list of everything. How do you get there?

    I’ve seen people combine the set first so there’s only one Markups List to work from. I’ve seen others keep the files separate and let Excel pull it all together with Power Query. I’ve seen setups where the columns are built so the data lines up no matter who marked up which sheet. I have my own preference, but I keep hearing versions I hadn’t thought of.

    So what’s your move? And if you’ve got a trick for keeping the data clean on the way in, I’d love to hear that too.

    Come
    learn alongside the rest of us.

    Doug McLean replied 3 weeks, 3 days ago 4 Members · 10 Replies
  • 10 Replies
  • David Cutler

    Member
    October 6, 2026 at 7:30 am
    Points: 35,150
    Rank: UC2 Brainery Red Belt UC2 Brainery Red Belt Rank

    At this point we work in one master PDF file. Any sheet that we have applied takeoff markups is in that “single point of truth” file. We use a coversheet with “standard” items that establishes our custom columns and we then use our custom tools to ensure that the collected data populates the correct columns.

    Once we have our takeoff complete we export our markups to a .CSV file and then use Power Query (thank you @Doug McLean !) to wash the data an prepare an .XLS file for upload into our estimating software.

    • Troy DeGroot

      Organizer
      October 6, 2026 at 5:03 pm
      Points: 30,641
      Rank: UC2 Brainery Advanced Brown Belt II UC2 Brainery Advanced Brown Belt II

      Sounds like it’s time-tested and humming like a bird. Thanks for the breakdown. What is the estimating software you import into again?

      • David Cutler

        Member
        October 7, 2026 at 6:59 am
        Points: 35,150
        Rank: UC2 Brainery Red Belt UC2 Brainery Red Belt Rank

        The process works pretty well @troy-degroot !

        We use an estimating software by the name of “B2W” – formerly known as “Bid 2 Win”.

        • Troy DeGroot

          Organizer
          October 7, 2026 at 9:39 am
          Points: 30,641
          Rank: UC2 Brainery Advanced Brown Belt II UC2 Brainery Advanced Brown Belt II

          So I assume you built your custom columns in Bluebeam to match the format in B2W, so the import matched up automatically? What do you mean when you say “cleaning” in PowerQuery? Are you converting data, reformatting, cleaning up blank cells, or something else?

          • David Cutler

            Member
            October 7, 2026 at 1:26 pm
            Points: 35,150
            Rank: UC2 Brainery Red Belt UC2 Brainery Red Belt Rank

            Yes @troy-degroot – I have custom columns to match the import values required in B2W. Each custom tool includes values in these required columns.

            The “cleaning” in PowerQuery is mainly subtotaling process. Once I change the source location and select “close and load” PowerQuery runs through a series of steps to subtotal my markup quantities and remove unnecessary columns from my upload file. So it “cleans” my rough markup export file so that it is ready for upload.

            Before I learned the basics of PowerQuery from @Doug McLean I would manually sort and subtotal the data and then copy the subtotal information to a new sheet for upload. What once would take hours to do manually Power Query completes in less than a minute! 😎

  • Vince

    Member
    October 8, 2026 at 1:38 am
    Points: 17,066
    Rank: UC2 Brainery Advanced Blue Belt II UC2 Brainery Advanced Blue Belt II

    I am the same as @DavidCutler – everything in one master Bluebeam file.

    Then export out to a csv file and dragged into Excel via Power Query. However, this process is in the midst of being changed now – more on this to come!!!

    • David Cutler

      Member
      October 8, 2026 at 7:05 am
      Points: 35,150
      Rank: UC2 Brainery Red Belt UC2 Brainery Red Belt Rank

      Looking forward to seeing what you put together @Vince ! 🍿

      • Doug McLean

        Member
        October 22, 2026 at 2:37 pm
        Points: 19,387
        Rank: UC2 Brainery Advanced Blue Belt IIII UC2 Brainery Advanced Blue Belt IIII

        he told me this morning, its pretty cool

    • Doug McLean

      Member
      October 22, 2026 at 2:39 pm
      Points: 19,387
      Rank: UC2 Brainery Advanced Blue Belt IIII UC2 Brainery Advanced Blue Belt IIII

      The one headache I see to this Vince is on projects where we’re not allowed to use AI on.

      Our company policy is that we’re not permitted to use AI agents on projects that we’re under an NDA on, which leaves out one of our largest contracts.

      People are still going to need to know how to actually do something when the AI goes all awry

  • Doug McLean

    Member
    October 22, 2026 at 2:41 pm
    Points: 19,387
    Rank: UC2 Brainery Advanced Blue Belt IIII UC2 Brainery Advanced Blue Belt IIII

    I actually have two separate data files.
    One that has my ‘punch list’ items (my scope list symbols) and then there is another with all my markups.

    I eventually bring these together later however

Log in to reply.