Room and area schedules for architects, from BIM export to summary
How to build a room and area schedule that stays consistent with BIM exports, with net vs gross area, BOMA and IPMS, room numbering and summary formulas.
A room schedule is a table with one row per room: a unique number, a name, a level, a department, a net area and the finishes. An area schedule rolls those rows up into totals by level and department and compares them with the gross area and the space program. The schedule stays reliable when four rules hold. Every room has a unique number that never gets reused. The area comes from one source, usually the BIM model. The finishes use codes from a legend. The summaries are formulas, never typed totals.
This article walks through the columns, the area definitions, the measurement standards, the link to door and window schedules, and a worked summary for a two-level building.
What should a room schedule track?
The minimum useful set is five columns: room number, room name, level, department (or program zone) and net area. Most teams add these:
- Use or occupancy type, which feeds code checks such as occupant load.
- Ceiling height, needed for volumes and for finish quantities.
- Finish codes for floor, base, walls and ceiling.
- Notes and status, such as "existing to remain" or "new".
- Door and window counts, calculated, not typed.
The room number is the key. Everything else, including door numbers, finish takeoffs and the program comparison, hangs from it.
What is the difference between net area and gross area?
Net area is the usable area of a room, measured inside its walls. Gross area is the whole floor area of the building, including interior wall thickness, circulation, shafts and mechanical space. Where the exterior wall is counted depends on the standard. The ratio gross / net is the grossing factor, and net / gross is the efficiency. See what is a grossing factor.
The International Building Code defines both terms in Chapter 2. Gross floor area is the area within the inside perimeter of the exterior walls, without deducting corridors, stairways, closets or the thickness of interior walls and columns. Net floor area is the actual occupied area, excluding unoccupied accessory areas such as corridors, stairways, toilet rooms, mechanical rooms and closets. Code uses these terms for occupant load, so many schedules carry a net area per room and a gross area per level.
The example building has 13 rooms on two levels:
| Number | Name | Level | Department | Net area (SF) |
|---|---|---|---|---|
| 101 | Reception | Level 1 | Public | 420 |
| 102 | Waiting | Level 1 | Public | 360 |
| 103 | Exam room | Level 1 | Clinical | 140 |
| 104 | Exam room | Level 1 | Clinical | 140 |
| 105 | Procedure room | Level 1 | Clinical | 190 |
| 106 | Office | Level 1 | Administration | 120 |
| 107 | Restroom | Level 1 | Support | 70 |
| 108 | Storage | Level 1 | Support | 90 |
| 201 | Open office | Level 2 | Administration | 880 |
| 202 | Conference room | Level 2 | Administration | 260 |
| 203 | Break room | Level 2 | Support | 180 |
| 204 | Server room | Level 2 | Support | 110 |
| 205 | Restroom | Level 2 | Support | 70 |
Level 1 nets 1,530 SF and Level 2 nets 1,500 SF, for 3,030 SF in total. The model reports gross floor areas of 2,050 SF and 1,900 SF, or 3,950 SF in total. The grossing factor is 3,950 / 3,030 = 1.30, and the efficiency is 76.7%.
Which area measurement standard should a room schedule use?
Net and gross areas are only comparable if everyone measures the same way. Three families of standards come up in practice.
ANSI/BOMA Z65.1. BOMA (Building Owners and Managers Association International) publishes Z65.1, "Office Buildings: Standard Methods of Measurement", an ANSI standard. Landlords and tenants use it to measure rentable area. It measures to the dominant portion of the inside finished surface of the permanent outer walls, treats vertical penetrations such as stairs and shafts separately from usable floor area, and allocates shared space to tenants through a load factor. BOMA publishes separate standards for other building types, and the office standard has been issued in several editions. A lease or contract should name the standard and the edition.
IPMS. The International Property Measurement Standards, published by the IPMS Coalition, aim at one global method. For offices they define three measures: IPMS 1 measures to the external dominant face of the building, IPMS 2 to the internal dominant face, and IPMS 3 concerns the area an occupier exclusively occupies. The coalition has also published standards for other building types, including residential. Read the definitions in the standard that applies to your building type.
Design and code measures. The program areas used by designers, the IBC areas used by code officials, and the rentable areas used by owners are different quantities. The same building gives different numbers under each. None of them is wrong, but they cannot be added or compared directly.
Label the area column in your schedule with what it measures, for example "Net area, to finish face", and keep that label if the file is passed on.
How should room numbers be assigned in a schedule?
There is no single national standard for room numbers, but these practices avoid most problems:
- One number, one room. Numbers are unique in the building and are never reused when a room is deleted.
- Level in the leading digit. 101 to 199 on level 1, 201 to 299 on level 2. Use B01 or a similar pattern below grade.
- Consistent direction. Number clockwise from the main entrance or stair, and leave gaps so that adding a room does not force a renumber.
- Doors follow rooms. A door takes the number of the room it opens into, with a letter suffix when a room has several: 105, 105A, 105B.
- Text, not numbers. Store room numbers as text so that 0101 and B01 survive an export and an import. See how to keep leading zeros in CSV.
How do you set up finish columns in a room schedule?
Use short codes that point to a finish legend instead of free text: floor FL-1, base B-1, walls P-2, ceiling C-1. A data validation list on each column keeps the codes consistent. A legend sheet maps each code to a description, and the description in the schedule is a lookup: =XLOOKUP(G2, LegendCode, LegendText) or, in older workbooks, =INDEX(LegendText, MATCH(G2, LegendCode, 0)), where LegendCode and LegendText are named ranges over the two legend columns. See VLOOKUP vs XLOOKUP.
Codes also make quantity takeoffs easy. The floor finish area for code FL-1 is =SUMIFS(Area, FloorCode, "FL-1"), and that quantity feeds the finishes lines of a cost estimate by CSI division.
How do you link room numbers to door and window schedules?
A door schedule has one row per door with its number, the room it serves, size, type, fire rating and hardware set. A window schedule works the same way. Because both reference the room number, two checks catch most errors. The formulas use named ranges: RoomNumbers is the room number column of the room schedule, and DoorRooms is the room column of the door schedule.
- Orphan doors: with the door's room in D2,
=COUNTIF(RoomNumbers, D2)=0is true when a door points to a room that does not exist. - Rooms with no door:
=COUNTIF(DoorRooms, A2)=0is true when a room has no door. Some rooms, such as open areas, legitimately have none, so flag them instead of rejecting them.
Door and window counts in the room schedule should also be formulas: =COUNTIF(DoorRooms, A2). A ready-made door and window schedule pairs with the room schedule.
How do you keep a room schedule consistent with BIM exports?
In Revit, room areas depend on the Area and Volume Computations setting, which computes at wall finish by default, among other options. Unenclosed rooms report zero area. If you export schedules, the export is a delimited text file (a .txt by default, with a choice of field delimiter) that opens in a spreadsheet.
- Keep a raw sheet. Import the export into a sheet nobody edits. All other sheets read from it by formula.
- Import with the right types. Bring room numbers in as text. If areas arrive with a unit symbol, convert them to numbers. See open CSV in Excel without breaking data.
- Use a stable key. The room number is the key. If your template also exposes an ID parameter, import that too, so a renumbered room is not mistaken for a new one.
- Add checks. Flag duplicates with
=COUNTIF($A$2:$A$200, A2)>1and zero areas with=E2=0. Compare the row count with the model's room count. - Stamp the version. Record the model name, the export date and the area computation setting on the summary sheet.
- Reconcile every time. After each import, compare net area by level with the model's gross area. A change in the grossing factor of a few percent between exports is a prompt to look at the model.
How do you summarize room areas by level and department?
With the raw data in A2:E14 (number, name, level, department, area), these formulas build the summary:
- Area by level:
=SUMIFS($E$2:$E$14, $C$2:$C$14, $H3) - Rooms by level:
=COUNTIFS($C$2:$C$14, $H3) - Area by level and department:
=SUMIFS($E$2:$E$14, $C$2:$C$14, $H3, $D$2:$D$14, I$2) - Grossing factor:
=Gross/Net - Variance to program:
=Actual-Target
For the example:
| Level | Public | Clinical | Administration | Support | Net total | Gross | Grossing factor |
|---|---|---|---|---|---|---|---|
| Level 1 | 780 | 470 | 120 | 160 | 1,530 | 2,050 | 1.34 |
| Level 2 | 0 | 0 | 1,140 | 360 | 1,500 | 1,900 | 1.27 |
| Total | 780 | 470 | 1,260 | 520 | 3,030 | 3,950 | 1.30 |
If the program called for 1,200 SF of administration, the schedule shows 1,260 SF, which is 60 SF or 5.0% over. With departments in I2:L2, the net total in column M and the total row in row 5, department shares are =I5/$M$5 and so on: Public 25.7%, Clinical 15.5%, Administration 41.6% and Support 17.2%.
Room and area schedule checklist
- Fix the area definition (net to finish face, or the standard you are using) and label the column.
- Make room numbers unique text, never reused.
- Use finish codes with a legend, not free text.
- Compute door, window and finish quantities from the room key.
- Keep a raw import sheet and make every summary a formula.
- Check for duplicates, zero areas and orphan doors after each import.
- Reconcile net area to gross area by level and watch the grossing factor.
The Room and area schedule and Space program calculator templates from Sheet Reserve give you a room table and a net-to-gross calculation to start from, with example data.