Takeoff & Estimating Tip for Excel: Sample Attached
System
Posts: 5 ✭ Administrator
in Peer Support
This discussion was created from comments split from: 📢 What's New in Bluebeam University: A Fresh Look & New Course - "Start Using Bluebeam"!.
0
Comments
-
Takeoff & Estimating Tip for Excel: Sample Attached
This is an advanced use of Excel and PowerQuery's, the attached file(s) contain a simple example
- Execute a formula created in Bluebeam Revu custom column in Excel via PowerQuery using Expression.Evaluate
Bluebeam formula columns [Notes] which contain ⇒ [Wall Area] * 12/16 + [Count] * [Depth] * 2
Excel via PowerQuery custom column with this expression
= Expression.Evaluate([Notes], Record.Combine({[_=_], #shared})) - You could use items<formula>; items<formula> format. See sample for more on this
I've attached three sample files (pdf, excel & bluebeam config)
4 - Execute a formula created in Bluebeam Revu custom column in Excel via PowerQuery using Expression.Evaluate
-
@Nextakeoff I can follow what you are doing but if you are going down this route you may find it easier to let Excel (inc Power Query) do all of the 'heavy' work for you as complicated formulas in Revu can become quite tricky. You can also use Excel to add additional details for you.
Here's an example of one of the workflows that I am currently working with https://youtu.be/wx-_vWoZI5E
1
Categories
- All Categories
- Certifications Overview ↗
- Bluebeam Certified Professional (BCP) ↗
- BCP User Group
- BCI User Group
- Welcome Guide
- Join the Discussion
- 3.4K Discussion Topics
- 313 Peer Support
- 565 Product Ideas & Feedback
- 2.5K Community Hub
- 11 What's New?
- Release Notes Website ↗
- Built Blog ↗
- Product Support
- 68 Bluebeam User Groups
- User Groups by Location
- United States
- Canada
- Europe
- Asia Pacific
- User Groups by Interest
- Architecture & Design
- Construction
- Engineering
- Subcontractors & Trades
- User Groups by Specialty Role
- Academic Educators
- Bluebeam Certified Instructors (BCIs)
- Bluebeam Certified Professionals (BCPs)
- Construction Owners & Owner Representatives
- Fresno State Student BUG (Fresno BUG)
- Global Bluebeam User Group Champions
- Government
- Product Ideas & Feedback