Quantity Link……..

  • Quantity Link……..

    Posted by rob gibson on September 26, 2023 at 10:27 am

    hi all, hoping for some guidance……………..

    finally had a scenario where i had some substructure take offs

    where all descriptions and heights would be the same from plot to plot….approx 30 plots

    lengths are the only thing that change from plot to plot and air brick counts, some items omit………..

    so i set up an excel template with my descriptions-created a toolbox to correspond with those descriptions-did all the linking to the sheet……..first take off ……..happy days all as expected all totals link and back check correctly—-save and close.

    so, i want to move on to the next plot, so i call up the template(xls) change the pdf it links to in the resources dialogue(and remove the old sheet link) within excel…………

    cannot re use the template without some error or other(various)

    My question…………how do i reuse the xls template i have created with a fresh pdf.

    appreciate any steer.

    Troy DeGroot replied 6 months ago 6 Members · 12 Replies
  • 12 Replies
  • Vince

    Member
    September 26, 2023 at 11:07 am
    Points: 12,043
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    Hi Rob. I’m not 100% following what you are doing but happy to have a chat tomorrow if you are about.

  • Doug McLean

    Member
    September 26, 2023 at 2:06 pm
    Points: 12,843
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    Hi Rob

    Without knowing a bit more it would be hard to answer.
    Did you do anything more than have it link to a specific tool?
    i.e. a floor, space, etc?

  • Jose Rodriguez

    Member
    September 26, 2023 at 2:40 pm
    Points: 405
    Rank: UC2 Brainery Newbie UC2 Brainery Newbie Belt Rank

    Just so I understand…

    You are using the same Excel template and Bluebeam tools and markups?

  • rob gibson

    Member
    September 27, 2023 at 2:46 am
    Points: 1,365
    Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

    thanks all……………

    as all the subs on all plots are exactly the same descriptions, same heights…..(lengths and counts differ)….. etc

    i just wanted a template that i can call up, link to a new pdf – carry out a take off—then save as a seperate excel sheet for later incorporation into a global workbook

    so plot 1 take off, plot 2 take off. etc

    the sheet i have created links to a tool box only, with matching descriptions-no spaces, batch links or anything else– just pure tools.

    will do a quick screen record this mornig to show the problem

    i think i am missing something, or not understanding what i think quant link can do…..

  • rob gibson

    Member
    September 27, 2023 at 3:12 am
    Points: 1,365
    Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

    hopefully this explains whats puzzling me?

    https://www.dropbox.com/scl/fi/75eyjqh93ai6omv50ovcw/bandicam-2023-09-27-08-57-21-019.mp4?rlkey=zpi6imengrvgp5512rzg1hmg5&dl=0

    • Jose Rodriguez

      Member
      September 27, 2023 at 2:03 pm
      Points: 405
      Rank: UC2 Brainery Newbie UC2 Brainery Newbie Belt Rank

      After watching your video, it seems to me that you are using 2 different PDF’s.

  • Doug McLean

    Member
    September 27, 2023 at 1:51 pm
    Points: 12,843
    Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

    Your File Names are different.
    In the Excel file you selected 12&13(one half)
    in Revu you selected 12&13 Pair

    • rob gibson

      Member
      September 28, 2023 at 2:17 am
      Points: 1,365
      Rank: UC2 Brainery Yellow Belt I UC2 Brainery Yellow Belt I

      thanks guys, vince pointed that out yesterday

      when we chatted………………..i will repost

      • Doug McLean

        Member
        September 28, 2023 at 2:29 pm
        Points: 12,843
        Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

        I missed the reply 😳

        • Vince

          Member
          September 29, 2023 at 12:21 am
          Points: 12,043
          Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

          Hi @Doug. Don’t worry, you didn’t miss my reply – I spoke to Rob on the phone!

          🤣

    • David Cutler

      Member
      September 28, 2023 at 10:42 am
      Points: 23,742
      Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown Belt III

      Details, details @Doug McLean … 🤣

  • Troy DeGroot

    Organizer
    November 21, 2023 at 12:33 pm
    Points: 21,197
    Rank: UC2 Brainery Brown Belt I UC2 Brainery Brown Belt I

    I’m having the same issue. I built a bunch of custom tools to match up with a custom Excel workbook, made all the links and saved them. When I copy the template Excel file into a new folder, link it to a new drawing, and perform my markups, the quantities don’t link. I’m not sure what I’m missing.

Log in to reply.