Template · Architecture
Door and window schedule
Door and window schedules with types, fire ratings, glazed areas and counts by type and level.
Preview below without an account. Downloads require the $19.85 yearly membership. Already registered? Sign in. XLSX, ODS and XML keep formulas; CSV and Numbers contain values only.
XLSXCSVODSXMLNumbers| Door schedule | |||||||||||
| Example data — replace the blue input cells with your own. | |||||||||||
| Mark | Level | From | To | Type | Width (mm) | Height (mm) | Vision panel area (m²) | Opening area (m²) | Fire rating (min) | Leaf material | Hardware set |
| D01 | Level 1 | Outside | Entrance lobby | D5 | 2,000 | 2,400 | 3.60 | 4.80 | 0 | Aluminium with glazing | HW-4 |
| D02 | Level 1 | Entrance lobby | Reception and waiting | D1 | 900 | 2,100 | 0.00 | 1.89 | 0 | Hollow metal | HW-1 |
| D03 | Level 1 | Reception and waiting | Corridor, ground floor | D1 | 900 | 2,100 | 0.00 | 1.89 | 0 | Hollow metal | HW-1 |
| D04 | Level 1 | Corridor, ground floor | Public WC, accessible | D6 | 1,000 | 2,100 | 0.00 | 2.10 | 0 | Solid timber | HW-2 |
| D05 | Level 1 | Entrance lobby | Multipurpose hall | D3 | 1,800 | 2,100 | 0.90 | 3.78 | 0 | Solid timber | HW-2 |
| D06 | Level 1 | Multipurpose hall | Café servery | D2 | 900 | 2,100 | 0.00 | 1.89 | 0 | Solid timber | HW-1 |
| D07 | Level 1 | Corridor, ground floor | Classroom 101 | D2 | 900 | 2,100 | 0.35 | 1.89 | 0 | Solid timber | HW-1 |
| D08 | Level 1 | Corridor, ground floor | Classroom 102 | D2 | 900 | 2,100 | 0.35 | 1.89 | 0 | Solid timber | HW-1 |
| D09 | Level 1 | Corridor, ground floor | Workshop | D4 | 900 | 2,100 | 0.00 | 1.89 | 60 | Hollow metal | HW-5 |
| D10 | Level 1 | Corridor, ground floor | Commercial kitchen | D4 | 900 | 2,100 | 0.00 | 1.89 | 60 | Hollow metal | HW-5 |
| D11 | Level 1 | Corridor, ground floor | Storage | D1 | 900 | 2,100 | 0.00 | 1.89 | 0 | Hollow metal | HW-6 |
| D12 | Level 1 | Corridor, ground floor | Electrical room | D1 | 900 | 2,100 | 0.00 | 1.89 | 0 | Hollow metal | HW-6 |
Showing the first 16 of 31 rows and 12 of 13 columns. Cells with formulas show the formula on hover.
| Window schedule | |||||||||||
| Example data — replace the blue input cells with your own. | |||||||||||
| Mark | Level | Room | Type | Width (mm) | Height (mm) | Sill height (mm) | Frame width (mm) | Opening area (m²) | Glazed area (m²) | Glazing (from type) | Operation (from type) |
| W01 | Level 1 | Reception and waiting | W1 | 2,400 | 1,500 | 900 | 60 | 3.60 | 3.15 | Double glazed, low-E | Fixed |
| W02 | Level 1 | Reception and waiting | W1 | 1,800 | 1,500 | 900 | 60 | 2.70 | 2.32 | Double glazed, low-E | Fixed |
| W03 | Level 1 | Multipurpose hall | W4 | 2,400 | 2,100 | 600 | 80 | 5.04 | 4.35 | Triple glazed | Fixed |
| W04 | Level 1 | Multipurpose hall | W4 | 2,400 | 2,100 | 600 | 80 | 5.04 | 4.35 | Triple glazed | Fixed |
| W05 | Level 1 | Multipurpose hall | W5 | 2,400 | 600 | 2,400 | 60 | 1.44 | 1.09 | Double glazed | Fixed |
| W06 | Level 1 | Classroom 101 | W2 | 1,500 | 1,200 | 900 | 50 | 1.80 | 1.54 | Double glazed, low-E | Casement |
| W07 | Level 1 | Classroom 101 | W2 | 1,500 | 1,200 | 900 | 50 | 1.80 | 1.54 | Double glazed, low-E | Casement |
| W08 | Level 1 | Classroom 102 | W2 | 1,500 | 1,200 | 900 | 50 | 1.80 | 1.54 | Double glazed, low-E | Casement |
| W09 | Level 1 | Classroom 102 | W2 | 1,500 | 1,200 | 900 | 50 | 1.80 | 1.54 | Double glazed, low-E | Casement |
| W10 | Level 1 | Workshop | W5 | 1,200 | 900 | 2,300 | 50 | 1.08 | 0.88 | Double glazed | Fixed |
| W11 | Level 1 | Café servery | W1 | 1,800 | 1,200 | 1,000 | 50 | 2.16 | 1.87 | Double glazed, low-E | Fixed |
| W12 | Level 2 | Library | W4 | 2,400 | 1,500 | 900 | 80 | 3.60 | 3.00 | Triple glazed | Fixed |
Showing the first 16 of 26 rows and 12 of 13 columns. Cells with formulas show the formula on hover.
| Door and window summary | |||||||
| Blue cells are the type definitions. Counts and areas are calculated from the Doors and Windows tabs. | |||||||
| Door types | |||||||
| Type | Description | Fire rating (min, 0 = none) | Leaf material | Doors (count) | Opening area (m²) | Vision panel area (m²) | |
| D1 | Single leaf, hollow metal, 900 x 2100 mm | 0 | Hollow metal | 6 | 11.34 | 0.00 | |
| D2 | Single leaf, solid timber, 900 x 2100 mm | 0 | Solid timber | 9 | 17.01 | 2.50 | |
| D3 | Double leaf, solid timber, 1800 x 2100 mm | 0 | Solid timber | 2 | 7.56 | 2.10 | |
| D4 | Fire-rated single leaf, hollow metal, 60 min | 60 | Hollow metal | 6 | 11.34 | 0.00 | |
| D5 | Entrance, double leaf, glazed aluminium | 0 | Aluminium with glazing | 1 | 4.80 | 3.60 | |
| D6 | Accessible single leaf, solid timber, 1000 x 2100 mm | 0 | Solid timber | 2 | 4.20 | 0.00 | |
| Total | 26 | 56.25 | 8.20 | ||||
| Check: every door has a type on this list | OK | ||||||
| Window types | |||||||
| Type | Description | Operation | Glazing | Windows (count) | Opening area (m²) | Glazed area (m²) | Share of glazed area |
Showing the first 16 of 30 rows and 8 of 8 columns. Cells with formulas show the formula on hover.
| Door and window schedule |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Two schedules for an example two-level building: every door and every window with its level, location, type, size and hardware or glazing. A summary counts the openings by type and by level and totals the opening areas, vision panels and g… |
| How to use it |
| 1. Choose or check the door and window types on the Summary tab. Each type has a description, fire rating or glazing and operation. |
| 2. On the Doors tab, enter each door's mark, level, the two rooms it connects, its type, width and height, vision panel area and hardware set. |
| 3. On the Windows tab, enter each window's mark, level, room, type, width, height, sill height and frame width. |
| 4. Read the counts and areas on the Summary tab. The check cells should say OK. |
| 5. Add openings by inserting rows inside the tables; the counts and areas include them. |
| Formulas and method |
| Door opening area = width × height. Vision panel area is entered per door. |
| Window opening area = width × height. Glazed area = (width − 2 × frame width) × (height − 2 × frame width), with a minimum of zero. |
Showing the first 16 of 31 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
This workbook keeps a door schedule and a window schedule for a two-level building. Each opening has its level, the rooms it connects or serves, its type, size and hardware or glazing. Door types carry a fire rating and leaf material. Window types carry the operation and glazing. Changing a type updates every opening that uses it.
The sheets calculate opening areas (width times height), the vision panel area of each door, and the glazed area of each window, which is the clear glass after the frame is deducted on all sides. A summary counts doors and windows by type and by level and totals their areas, with check cells that confirm every opening has a type from the list.
The example has 26 doors and 19 windows in a fictional building. It suits early schedules, takeoffs and quantity checks. Confirm sizes, fire ratings, glazing and hardware against the specification and the code before ordering.
What’s inside
- Door and window schedules with type, size, level, location and hardware or glazing
- Fire rating and leaf material looked up from the door type table with INDEX and MATCH
- Glazed area = (width − 2 × frame) × (height − 2 × frame) for each window
- COUNTIF and SUMIF totals by type and by level
- Check cells confirm every opening has a type from the list
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Doors | One row per door with level, rooms, type, width and height, vision panel area, opening area, fire rating and hardware set. |
| Windows | One row per window with level, room, type, size, sill height, frame width, opening area and glazed area. |
| Summary | Door and window types with counts and areas, totals by level, and the check cells. |
| Notes | What the workbook does, how to use it, the formulas, the assumptions and the professional-verification note. |
What formulas does this template use?
This template holds 220 formulas in 748 cells across 4 tabs, so 29% of its cells calculate. They use 10 distinct functions; the longest formula is 99 characters and 133 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 162 | one result when a test is true, another when false |
IFERROR | 90 | swaps an error for a fallback value |
INDEX | 90 | value at a position in a range |
MATCH | 90 | position of a value in a range |
MAX | 38 | largest value |
SUMIF | 26 | adds values meeting one condition |
COUNTIF | 15 | counts cells meeting one condition |
SUM | 15 | adds numbers |
COUNTA | 4 | counts non-empty cells |
AND | 1 | true when every test is true |
Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- On the Summary tab, review the door and window types and edit their descriptions if needed.
- On the Doors tab, enter each door's mark, level, the rooms it connects, its type and its size.
- On the Windows tab, enter each window's mark, room, type, size, sill height and frame width.
- Read the counts and areas by type and by level on the Summary tab.
- Confirm the check cells say OK after adding or changing openings.
What is it good for?
- Building a door and window schedule for early design
- Estimating glazing area for a quote or an energy calculation
- Checking that every opening has a fire rating or glazing type
- Preparing quantities for ordering hardware and glazing
Questions about this sheet
How is glazed area worked out?
For each window the frame width is deducted from both sides of the width and of the height, and the remaining rectangle is the glass area. Set the frame width for each window.
How do I add a new door type?
Insert a row inside the door type table on the Summary tab, enter the code and description, and copy the count formulas down. The drop-down on the Doors tab then offers it.
What does the vision panel area count?
The glazed area in a door, such as a view panel. It is entered per door and totalled on the Summary tab.
Does the schedule check code compliance?
No. It records the openings you enter. Clear widths, fire ratings, accessibility and glazing performance need checking against the code and the specification.