BIMtopia_Logo

Schedules and Quantities

BIM for Architecture, Engineering, and Construction Curriculum

Exercise 2.5.1: Creating and Presenting Model Schedules

In this exercise, students will learn how to:

  • Create schedules of model elements such as doors, windows, roofs, walls, curtain walls, furniture objects, and so on.
  • Configure schedules by changing their fields, sorting logic, grouping, and format.
  • Place schedules into printable sheets either alone or with appropriate graphical displays.
  • Export the schedules in common formats, such as delimited text files, which can be used in Microsoft® Excel®.
Figure 2.5.1 - Adding fields to a door schedule

Video Tutorial



Student Exercise

Download Unit2_Lesson5_Exercise1_Start.zip: Imperial or Metric
Revit 
  • Create a schedule of the floor elements that includes the following fields: level, family, type, and area. 
  • Sort and group the schedule rows first by level and then by type. Configure the grouping and sorting to display subtotals for each level and for each type within a level. In addition, display a grand total at the bottom of the schedule.
  • Format the schedule to calculate totals for the area field. 
  • Export the schedule as a delimited text file and import it into Microsoft Excel or another spreadsheet program.

 

Figure 2.5.2 - Floor schedule grouped and sorted by level and type with area subtotals

Exercise 2.5.2: Enhancing and Adding Information to Schedules

In this exercise, students will learn how to:

  • Add parameters to building elements to capture additional design information needed for analysis.
  • Define new parameters as calculated values.
  • Use formulas to compute values based on other parameters.
Figure 2.5.3 - Entering information into the new window parameter

Video Tutorial



Student Exercise

Download Unit2_Lesson5_Exercise2_Start.zip: Imperial or Metric
Revit
    • Open the Curtain Wall Panel Schedule and add two new parameters: 
      • Orientation: A text field describing the compass orientation of the panel, similar to the field added in the video tutorial.
      • Glazing Area: A calculated value showing the exposed glazing area for each panel. For this calculation, assume the exposed glazing area is 95 percent of the panel area.

 

  • Open the Exterior Curtain Panels view and assign the orientation to each panel by filling in values for the new orientation property. 
  • Filter the schedule to only show exterior curtain wall panels, which all have a type mark of A.
  • Group the schedule rows by the orientation field and display subtotals for each orientation as well as a grand total for the entire schedule.
  • Format the schedule to calculate totals for the Glazing Area field.
  • Export the schedule as a delimited text file and import it into Microsoft Excel or another spreadsheet program.

 

Figure 2.5.4 -Curtain Wall Panel Schedule grouped by orientation