Creating a Schedule to Analyze Exterior Surface Area

You have designed masses to explore a conceptual design for a building. You want to determine exterior surface areas around the perimeter of each floor.

This information will allow you to estimate costs for the building exterior using various materials.

Use the following procedure to create a schedule for analyzing the exterior surface areas of masses in a conceptual design. Specific steps may vary depending on the information that you want to show in the schedule.

To create a schedule to analyze exterior surface area

  1. Create mass floors.
  2. Click View tabCreate panelSchedules drop-down (Schedule/Quantities).
  3. In the New Schedule dialog, do the following:
    1. For Category, click Mass Floor.

      If Mass Floor does not display by default, select Show model categories in this view. For Filter list, select Architecture.

    2. For Name, specify the schedule name.
    3. Select Schedule building components.
    4. Click OK.
  4. On the Fields tab of the Schedule Properties dialog, do the following:
    1. For Scheduled fields (in order), add the following fields:
      • Usage
      • Comments
      • Level
      • Mass: Type
      • Exterior Surface Area
    2. Click Calculated Value.
    3. In the Calculated Value dialog, for Name, enter Exterior Surface Area %.
    4. Select Percentage.
    5. For Of, select Exterior Surface Area.
    6. For By, select Grand total.
    7. Click OK twice.
  5. In the schedule, assign values to the Usage and Comments columns for each mass floor.

    Use Comments to indicate the exterior building material. Use consistent values so that you can use this field for sorting.

    Next, sort and subtotal the schedule by exterior material (using the Comments field), as follows.

  6. In the Properties palette, access properties for the schedule.
  7. For Sorting/Grouping, click Edit.
  8. On the Sorting/Grouping tab of the Schedule Properties dialog, do the following:
    1. For Sort by, select the following:
      • Comments
      • Ascending
      • Footer
      • Title, count, and totals
      • Blank line
    2. For Then by, select both Usage and Ascending.
    3. At the bottom of the dialog, select the following:
      • Grand totals
      • Title and totals
      • Itemize every instance
  9. Click the Formatting tab, and do the following:
    1. Under Fields, select Exterior Surface Area.
    2. For Alignment, select Right.
    3. Select Calculate totals.
    4. Specify formatting for Exterior Surface Area %: under Fields, select Exterior Surface Area %. For Alignment, select Right. Select Calculate totals.
    5. (Optional) Specify formatting for Comments, Usage, Level, and Mass: Type: under Fields, select a field name. Then for Alignment, select Center.
  10. Click OK.

The schedule updates to sort and subtotal the rows accordingly. It shows the percentage of surface area for each exterior material, as well as square units.

In this example, the exterior surface areas for some mass floors (such as Square Level 4 and Wedge Level 6) are larger than those for other mass floors because they are calculated differently.

Also, where the masses are joined, the inner surfaces between masses are deducted from the exterior surface area.