Template · Architecture

Door and window schedule

Door and window schedules with types, fire ratings, glazed areas and counts by type and level.

See download membership

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.
MarkLevelFromToTypeWidth (mm)Height (mm)Vision panel area (m²)Opening area (m²)Fire rating (min)Leaf materialHardware set
D01Level 1OutsideEntrance lobbyD52,0002,4003.604.800Aluminium with glazingHW-4
D02Level 1Entrance lobbyReception and waitingD19002,1000.001.890Hollow metalHW-1
D03Level 1Reception and waitingCorridor, ground floorD19002,1000.001.890Hollow metalHW-1
D04Level 1Corridor, ground floorPublic WC, accessibleD61,0002,1000.002.100Solid timberHW-2
D05Level 1Entrance lobbyMultipurpose hallD31,8002,1000.903.780Solid timberHW-2
D06Level 1Multipurpose hallCafé serveryD29002,1000.001.890Solid timberHW-1
D07Level 1Corridor, ground floorClassroom 101D29002,1000.351.890Solid timberHW-1
D08Level 1Corridor, ground floorClassroom 102D29002,1000.351.890Solid timberHW-1
D09Level 1Corridor, ground floorWorkshopD49002,1000.001.8960Hollow metalHW-5
D10Level 1Corridor, ground floorCommercial kitchenD49002,1000.001.8960Hollow metalHW-5
D11Level 1Corridor, ground floorStorageD19002,1000.001.890Hollow metalHW-6
D12Level 1Corridor, ground floorElectrical roomD19002,1000.001.890Hollow metalHW-6

Showing the first 16 of 31 rows and 12 of 13 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?

TabWhat it holds
DoorsOne row per door with level, rooms, type, width and height, vision panel area, opening area, fire rating and hardware set.
WindowsOne row per window with level, room, type, size, sill height, frame width, opening area and glazed area.
SummaryDoor and window types with counts and areas, totals by level, and the check cells.
NotesWhat 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.

FunctionUsesWhat it does
IF162one result when a test is true, another when false
IFERROR90swaps an error for a fallback value
INDEX90value at a position in a range
MATCH90position of a value in a range
MAX38largest value
SUMIF26adds values meeting one condition
COUNTIF15counts cells meeting one condition
SUM15adds numbers
COUNTA4counts non-empty cells
AND1true 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?

  1. On the Summary tab, review the door and window types and edit their descriptions if needed.
  2. On the Doors tab, enter each door's mark, level, the rooms it connects, its type and its size.
  3. On the Windows tab, enter each window's mark, room, type, size, sill height and frame width.
  4. Read the counts and areas by type and by level on the Summary tab.
  5. 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.