In this exercise, students will learn how to:
|Figure 2.5.1 - Adding fields to a door schedule|
- 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