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

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

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