The Real Way to Link Bluebeam Revu and Microsoft Excel
HTML-код
- Опубликовано: 22 авг 2024
- **Special Offer: Buy Bluebeam from ZenTek Consultants, Get Takeoff Tools Free for 1 Year! Learn more at zentekconsulta...
Bluebeam Revu's "Quantity Linking" feature lets you tie measurements from Bluebeam Revu to a Microsoft Excel spreadsheet for real-time updates when you edit graphics on screen. It's a QTO/estimating tool for folks who want to create measurement items in Bluebeam, and have the results instantly pushed to Excel. The problem is a lot of us struggle with getting this system setup and working in a reliable way that can be repeated from job to job. It seems easy when we see it online, but the actual process can be confusing. Don’t worry, ZenTek Consultants, your premiere Bluebeam partner and support experts can help.
We’ll show you the practical process of making Quantity Linking work for you.
Good
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!
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.
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
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