By Garry Stockton
Following on from my previous blog, where I created a Wall Material Take-off, this 2nd document is more definitive and extends into how many bricks are required.
Using the previous process and select Calculated Parameter
Once you have selected Calculated Value and set the following parameters (as shown below). Make sure you leave a space after each name in the formula, also after the colon.
- Name: Total Units of Bricks
- Discipline: Common
- Type: Number
- Formula: (Material: Area/ 1) *60
Once you have created your new Take-off, you will note how ‘Total Units of Bricks’ is calculated. We will need to go the properties and make amendments in Filter, Sorting & Grouping and Formatting.
In the filter tab, select the following using Material: Name, equals, Masonry – Brick.
In the Sorting/Grouping tab, sort by Material: Name and select Footer
In the Formatting tab, in the Fields list, select Material: Area, Total Cost per SM and Total Units of Brick. In the Field formatting area, select
You will note above that the Total Units of Bricks and Total Cost of Square Metres have 6 decimal points.
In Properties next to Formatting, select edit
Following the same process, select Total Units of Bricks, click Field Format. In the Format dialogue box untick Use default settings option. Set the units to Fixed and Rounding to 0 decimal places and click OK.
Back in the schedule view, go to the Material cost and change from 4 to 3 for example and the total cost changes.