Div08 Consulting

Door hardware schedule template

A free Excel template for a door schedule and the hardware sets that go with it. Fill in one row per opening, assign each a hardware set, and list each set item by item. No sign-up.

Download the template (.xlsx)

What is in it

  • Door Schedule tab: one row per opening, with dropdowns for handing, fire rating, keying and electrified hardware.
  • Hardware Sets tab: each set written out item by item with quantity, description, function and BHMA finish.
  • Example rows in grey, including a rated stair door and an access-controlled entry, so you can see how a filled-in schedule reads.

Door schedule columns

ColumnWhat goes in it
Opening No.Matches the number on the floor plan
From / to roomWhich spaces the door separates; sets the egress direction
Width, height, thicknessNominal door size, for example 3'-0" x 7'-0" x 1-3/4"
Door and frame typeElevation and profile codes from the drawings
Door and frame materialHollow metal, wood, aluminum
Fire ratingFrom the life safety plan (dropdown)
HandingLH, RH, LHR or RHR, read from the outside (dropdown)
Hardware setThe set number defined on the Hardware Sets tab
Keyed, electrifiedFlags for the keying meeting and the security drawings

For how each column is used, read door schedules, door hardware sets and door handing. For a filled-in example, see the sample hardware set.