Takeoff & Estimating Tip for Excel: Sample Attached

System
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"!.

Comments

  • Nextakeoff
    Nextakeoff Posts: 4

    Takeoff & Estimating Tip for Excel: Sample Attached

    BatchConfig.bcf
    Takeoff & Estimate Tip for Beambeam and Excel.xlsx
    Takeoff & Estimating Tip for Bluebeam and Excel.pdf

    This is an advanced use of Excel and PowerQuery's, the attached file(s) contain a simple example

    1. 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}))
    2. You could use items<formula>; items<formula> format. See sample for more on this

    I've attached three sample files (pdf, excel & bluebeam config)

  • vfrench
    vfrench Posts: 40
    edited October 31

    @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

Categories