Advanced Use Cases for Quantity Link in Bluebeam Revu
Let’s take those Quantity Link connections a bit further this week. I want to follow up with some advanced use cases for Quantity Link by…
Let’s take those Quantity Link connections a bit further this week. I want to follow up with some advanced use cases for Quantity Link by…
Let’s take those Quantity Link connections a bit further this week. I want to follow up with some advanced use cases for Quantity Link by elaborating on the points I introduced in my article on Bluebeam’s Built Blog “Top 5 Reasons to Use Quantity Link in Revu.”
Just to recap, the 5 reasons I listed were:
Before I break each one down, hopefully, you put my last blog post to use “How To Easily Set Up Quantity Link in Bluebeam Revu” and you gave it a practice run. You created some custom tools and linked them to a blank practice spreadsheet to see the live connection in action.
If you run into any trouble or have questions, don’t forget to join the free Brainery community to get those answers to propel you forward.
In the steps last week, I think we covered “Standardization and Consistency” by showing you how to build custom markup tools your entire team can use. When you're ready to share those tools with your team, check out my tips in the Brainery thread "Sharing Toolsets & Profiles". Then we connected those custom markup tools to a spreadsheet. I hope this was descriptive enough to help you navigate linking to your “Legacy Spreadsheets.” To wrap things up, let's look at the remaining three reasons starting with the easiest to implement followed by the more advanced. Don't be intimidated by "Advanced". Instead, be inspired by the possibilities. I'm always here to help.
I see a lot of users marking up drawings with simple dimensions and taking notes off to the side which creates a nightmare when a revision comes in. They have to figure out what all the scribbles and colored highlighters meant on a specific day. I’ve seen others do great markups in Revu, only to start over with the revised print.
In Revu, when a revision comes in, you don’t have to search to find the differences in the drawings while cursing out the designers for never clouding the changes. You'll find Bluebeam Compare Documents in the menus under Document > Document Compare you’re able to point to the original and revised drawings and Revu will cloud all the changes for you!
Once you find where all the changes are, there is also a tool for Bluebeam Overlay. Go to Document > Overlay Pages, point to the same drawings, and Revu will show each in different colors so you can see what changed. Check out Bluebeam Document Compare/Overlay & Tip where I show the steps below to combine these two features into one document.
Now that you’ve pinpointed where and what was changed, how do you get all your old markups to the revised sheet without starting over? It’s easy, check this out!
Now, simply look at those clouded areas and use the yellow grips at the corner of your measurements to update the existing markups (Remember to hold down your Shift key to add grips if the new shape requires more flexibility). It’s very important now to reset the source file in the spreadsheet to look at the revised drawing. Now that your markups are updated, the source file is linked, you should see the difference in the cost and totals of those particular materials.
Let’s run with last week’s example regarding a new development “Land Use” presentation. In our presentation to the public, we need to give a visual breakdown of which areas will be used for what purpose. We also need to include which areas will be left “green” or undeveloped.
The steps are really no different from what were introduced to last week:
Next is the part I want to focus more attention on. I’m not an expert at Microsoft Excel, so I’ll keep this pretty simple:
Pretty cool integration of tools, don’t you think? Now don’t limit your ideas to the cost of materials or land use. This can be used for just about anything. For instance, occupancy loads, or maybe your calculating cut/fill ratios so you know how much material you need to bring in. In that case, if your chart is anywhere off of 50/50, you’re either hauling out or hauling in materials. Also, if you are creating PDF's to show in a PowerPoint-type situation, don't forget about Bluebeam Presentation Mode. This can be found in the menu Window > Presentation (CTRL+ENTER). This setting will remove all the tools to just show the document. Use your up/down arrows to advance pages.
I hope you made it this far in the article because this is where we might just blow your mind. I have no idea if anyone even reads what I publish. Let me know you made it this far by giving me a like down below.
I don’t want to derail my article, but I’d like to introduce you to a new section of my articles. I’m not sure how often she will appear, I’m going to call it “But Troy”
“But Troy,” you say, "do I have to create a tool for every single piece of material? Do I need a tool for anchor bolts, studs, nails, and truss clips?"
The answer is NO because we can build assemblies to account for those materials. The facts are in the formulas, my friend. Let’s start with the end in mind and create an estimate for a single exterior wall. To build that wall we need 2x6 treated base, double 2x6 top plate, 2x6 studs at 16”oc, maybe ½”x12” anchor bolts at 48”oc, 5/8” OSB sheathing on the exterior, batted insulation, and ½” sheetrock on the interior. Did I catch everything?
More than likely, we’re measuring linear feet of wall on a plan view, so we use the Polylength tool to create an “Exterior 2x6 Wall” tool. Next, we link that custom tool into our spreadsheet. After the link is established the cell will shade itself grey, indicating the content is pulling from Revu. Next, we build the spreadsheet to include all those different materials.
As you can see, all the materials are simply a factor of the linear footage of the wall. You can take it as far as you want adding material cost, totals as you see above, or even add a column for labor cost.
You can see in column "F" in the spreadsheet you have the freedom to update the individual item prices as often as needed and the formulas will provide new totals. No more outdated price lists or complicated software to updates. Also notice in column "E" you have your cut list to order materials. All you did was trace a line over the walls on the plan!
In this second image, notice I updated the length of the wall in cell B3, and all the material quantities and total costs adjusted automatically. I know this is a professional group, but to the guy in the back who just mumbled “Holy $h!t” under his breath, we heard you, and the whole class is laughing in agreement. And that seems like a good place to end. Leave me a comment to let me know your thoughts, I’d love to hear from you!
Obviously, these are just a few examples of advanced use cases for Quantity Link in Bluebeam Revu. If you’d like to hand off tool creation, linking, training, or any piece of your implementation, please don’t hold back a chance for me to geek out on your business workflows. Click here to schedule a free introduction call.
Also, I have upcoming training for these topics as well, grab a seat.
Bluebeam Material Takeoffs & Estimates – Basics
Bluebeam Material Takeoffs & Estimates – Advanced
There was a problem reporting this post.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.