Great Video! If I am understanding this correctly, it doesn't matter the type of Excel spreadsheet you use. As long as the correct cells are being assigned to the tool you are using everything should fill in correctly?
Hey, I am using a sketch to scale rectangle tool to estimate block walls and intend to use the width variable as the length of the wall. This way I can adjust the width of the tool on a floor plan to the length of the wall. To determine the wall area and, consequently, the qty of block, I figured I would manually enter the height of the wall in the depth field of the tool. However, quantity link does not allow me to select depth as one of the readable measurements in excel. Can you help?
Your best bet here would be to generate a custom column in Bluebeam, using a formula that multiplies the length x depth fields rather that trying to handle the calculations in Excel.
Hi, great video! I tried it, however I have the following issue: when I add a new document, the link between excel is lost, so I can not do the measurements and have to link the whole excel again. Any advice? Thanks.
The key is to create a ‘Master PDF’ and a ‘Master Workbook’ and link them together. Place one (1) of every tool you have in the Master PDF and link them to the Master Workbook. Now, once you get a new job, save the Master Workbook to that job folder and change the source file to the construction documents. All the values will go to zero (0) but once you start adding in the tools into the CDs, the values auto-populate. The key to this whole process is well developed tool sets, which is something we can help you with here at ZenTek!
How about when the same type of measurement is used from cell to cell? example: sidewalk 1, sidewalk 2 .. and so on; each its own measurement and link in each cell, all made from the same tool saved in the toolbox. :) Also, how can you restrict the transfer data to only transferring a data type? example: I only want SQFT in my cell not a count as well in an adjacent cell that overrides the data there. Data transfer limited to one cell. (data of my choice?)
Hi, During the link process, you can filter for specific fields (i.e. Area or Length only) for specifically labeled items (i.e. SW1/SW2) but you need to do each in its own cell. There’s no logical way for it to sort different labels into the same cell, Excel would have no idea which you’d be looking for.
Thank you for the quick response. I would be moving from cell to cell so renaming will be the key. Thank you.. as to Bluebeam transferring more info than needed to my spreadsheet and overriding adjacent cells, any help there would be apricated.
The issue is the measurement and the measurement unit need to be split because in Excel, “4” is a number and “4 ft” is text, so Revu splits it and inserts two columns to handle that. Easiest thing is to insert a blank column to the right of your linked cells when creating the Workbook, then delete it after you’re done.@@scurry31a
Without details it’s hard to say for sure but this can happen if you move the Excel file from the original location you linked it from. In other words, if you create the links when the PDF/Excel files are in Folder “A”, then move the excel file to sub-folder “b”, the links can’t resolve.
@@ZenTekConsultants Thanks, usually happens if I close excel and reopen it will say “links suspended” or it says “links connected” but it does not update when I add markups to the pdf so I have reconnect each cell ..very frustrating
@@joes2805 Not sure what your issue might be, but I’d check to make sure the plugin for your current version of Revu is enabled in the Bluebeam Administrator program and that you have the Complete version installed as it’s the current requirement for quantity linking. Hope that helps!
@@ZenTekConsultants Thanks I think I figured it out. Is it possible to link cells to specific pages of a document set ? Lets say a 4 floor building with 6” pipe on each floor .. can I link a cell to 6” pipe in the 1st floor and a cell to 6” pipe on the 2nd fl (page) etc. within the same excel sheet ?
@@joes2805 Glad issue’s resolved! Yes, you can link to measured items in spaces, by subject, by label, etc. pretty much any Revu category can be filtered for quantity links. This is something we do for a lot of clients here at ZenTek - helping them develop tools to link to their current workbooks. Let us know if we can help!
Great Video! If I am understanding this correctly, it doesn't matter the type of Excel spreadsheet you use. As long as the correct cells are being assigned to the tool you are using everything should fill in correctly?
That’s correct. You can tie this into your existing Excel estimating sheets, or ZenTek can help you do that!
Hey, I am using a sketch to scale rectangle tool to estimate block walls and intend to use the width variable as the length of the wall. This way I can adjust the width of the tool on a floor plan to the length of the wall. To determine the wall area and, consequently, the qty of block, I figured I would manually enter the height of the wall in the depth field of the tool. However, quantity link does not allow me to select depth as one of the readable measurements in excel. Can you help?
Your best bet here would be to generate a custom column in Bluebeam, using a formula that multiplies the length x depth fields rather that trying to handle the calculations in Excel.
Got it, thank you! I was able to find a work around using wall area.@@ZenTekConsultants
I get it now, thanks! But is there any way to link the entire markup table to a table in excel?
Unfortunately, no. The linking can only be done on a cell-by-cell basis.
Hi, great video! I tried it, however I have the following issue: when I add a new document, the link between excel is lost, so I can not do the measurements and have to link the whole excel again. Any advice? Thanks.
The key is to create a ‘Master PDF’ and a ‘Master Workbook’ and link them together. Place one (1) of every tool you have in the Master PDF and link them to the Master Workbook. Now, once you get a new job, save the Master Workbook to that job folder and change the source file to the construction documents. All the values will go to zero (0) but once you start adding in the tools into the CDs, the values auto-populate. The key to this whole process is well developed tool sets, which is something we can help you with here at ZenTek!
@@ZenTekConsultants Hi, thank you very much, I got it to work! Seems that what I've been doing wrong is saving them in same file location.
How does this linking work with let’s say rebar. Let suppose plan shows 2 #4 in footing . How can you account for that
The links work for any numeric column (built-in or custom) so if you link to the Count or Length of “2” Rebar” into a cell, the link will work.
How about when the same type of measurement is used from cell to cell? example: sidewalk 1, sidewalk 2 .. and so on; each its own measurement and link in each cell, all made from the same tool saved in the toolbox. :)
Also, how can you restrict the transfer data to only transferring a data type? example: I only want SQFT in my cell not a count as well in an adjacent cell that overrides the data there. Data transfer limited to one cell. (data of my choice?)
Hi, During the link process, you can filter for specific fields (i.e. Area or Length only) for specifically labeled items (i.e. SW1/SW2) but you need to do each in its own cell. There’s no logical way for it to sort different labels into the same cell, Excel would have no idea which you’d be looking for.
Thank you for the quick response. I would be moving from cell to cell so renaming will be the key. Thank you..
as to Bluebeam transferring more info than needed to my spreadsheet and overriding adjacent cells, any help there would be apricated.
The issue is the measurement and the measurement unit need to be split because in Excel, “4” is a number and “4 ft” is text, so Revu splits it and inserts two columns to handle that. Easiest thing is to insert a blank column to the right of your linked cells when creating the Workbook, then delete it after you’re done.@@scurry31a
Cool video .. why do my quantity link keep getting disconnected ?
Without details it’s hard to say for sure but this can happen if you move the Excel file from the original location you linked it from. In other words, if you create the links when the PDF/Excel files are in Folder “A”, then move the excel file to sub-folder “b”, the links can’t resolve.
@@ZenTekConsultants Thanks, usually happens if I close excel and reopen it will say “links suspended” or it says “links connected” but it does not update when I add markups to the pdf so I have reconnect each cell ..very frustrating
@@joes2805 Not sure what your issue might be, but I’d check to make sure the plugin for your current version of Revu is enabled in the Bluebeam Administrator program and that you have the Complete version installed as it’s the current requirement for quantity linking. Hope that helps!
@@ZenTekConsultants Thanks I think I figured it out. Is it possible to link cells to specific pages of a document set ? Lets say a 4 floor building with 6” pipe on each floor .. can I link a cell to 6” pipe in the 1st floor and a cell to 6” pipe on the 2nd fl (page) etc. within the same excel sheet ?
@@joes2805 Glad issue’s resolved! Yes, you can link to measured items in spaces, by subject, by label, etc. pretty much any Revu category can be filtered for quantity links. This is something we do for a lot of clients here at ZenTek - helping them develop tools to link to their current workbooks. Let us know if we can help!
Good