Skip to main content

Quantity Takeoff & 2D-3D

Takeoff, from the properties you choose.

The quantities you choose, colour-coded on the model they came from.

Takeoff goes wrong when the quantities and the elements live in different tools. You measure in one place, report in another, and reconciling the two is the job.

How it’s made

There is no takeoff template to download. This report was built the same way 4D and 5D were — out of the Starter template. Filter to the elements being measured, pivot the properties worth totalling into columns, and the takeoff is an ordinary Power BI report.

How Frame builds it

This one started as the Starter template

Route A · Power Query Duplicate assets filter to your scope Merge properties then pivot to columns Route B · export it Export to CSV from the assets query Ask an AI to join the quantities you measure Your report external ID intact
Whichever route you take, the external ID has to survive the reshaping — it is what links your table back to the model and drives selection in the viewer.

We built this one by exporting the asset query and having an AI assistant do the reshaping, with one instruction that matters: keep the external ID. That is what holds a total to its elements — click the number and see what it is made of, colour-coded in the model. Change the filter and the takeoff follows.

Read more

Build reports that drive action

Discover the benefits of Frame today.