Using Schedules for Preliminary Cost Estimates |
| |
Since we are in still in preliminary design for this project, we have probably not gone through the rigor of cost estimating the project yet. Nonetheless, we can use some of the scheduling tools to help us calculate a rough cost of the building based on a cost per sq. ft. assessment. The disclaimer here is that Revit is not a cost-estimating package. It is a database that can count, total, and tally the num-ber of items, areas, or other properties within the model. Cost estimating itself is part counting and part experience; we can work on the counting part with the BIM model.
Since we have already created gross area plans earlier, let’s go ahead and create a new schedule to analyze the area plans and give us a rudimentary cost estimate based on the building square foot-age. Let’s only include the Level and Area fields, but in the Fields tab. Next, we need to add a parameter for Cost. That parameter is not a standard property of the areas so we will need to add it to the list. |
- To add the Cost parameter, use the Add Parameter button on the Fields tab. What this allows you to do is to add a new custom parameter to the Areas field. We need to add one for Cost and we need the parameter type to be a number so we can get a cost per sq. ft. See Figure 13.27 for the dialog box properties.
|
Figure 13.27
Adding a new parameter |
|
- We are now going to use the Calculated Value button to add a new field to the schedule. The button will display a new dialog box (Figure 13.28) where you can create new fields that are basically custom formulas defined by combining numerical values with other fields.
In our example, we want Revit to calculate a total cost for our project based on a cost per square foot we consider close to accurate based on previous experience
|
Figure 13.28
Calculated value fields |
|
- For our Type setting we made the type an Area. In Revit, you need to make sure the types of fields are compatible so you are not multiplying length times something like material. Also, as we mentioned before, the fields are case sensitive. In the formula line, you will need to type in Area * Cost to get the total project cost. Click OK to exit the dialog box.
- Finally, on the Sorting tab, check the box for Grand totals, and on the Formatting tab, high-light the Cost per sq. ft. field we just created and check the box to calculate totals. Once you enter an estimated cost of $169.00 for each floor, the final schedule will look like Figure 13.29
|
Figure 13.29
Building cost per sq. ft |
|
| Now we have a constantly updated area of each floor of the building multiplied by our esti-mated cost per sq. ft. for a continuously accurate total, based on those metrics. However, the costs are being reported as SF values and not dollar amounts. We can fix that problem in the Schedule Properties dialog box. |
|