• Blog posts

    Bio

    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

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_1.PNG

    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

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_2.PNG

    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.

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_3.PNG

    In the filter tab, select the following using Material: Name, equals, Masonry – Brick.

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_4.PNG

    In the Sorting/Grouping tab, sort by Material: Name and select Footer

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_5.PNG

    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

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_6.PNG

    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

    Revit_-_Create_a_Material_Take-off_Schedule_-_Part_2_-_7.PNG

    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.