Example Output
This is what your excel takeoff looks like. Complete door schedule with separated tabs for door, frame, hardware takeoffs.
Door ScheduleHardware TotalsTab 1 of 2
| LEVEL | DOOR NO. | ROOM / AREA | TYPE | HW GRP | FIRE RATING | DOOR MAT | FRAME MAT | IN SCOPE | DOOR PREPS | FRAME PREPS |
|---|---|---|---|---|---|---|---|---|---|---|
| LEVEL 1 | ||||||||||
| L1 | 101 | Main Entry Lobby | A | 1 | — | HM | HM | YES | Hinges, Mortise Lock, Closer | Hinges, ASA Strike, Closer |
| L1 | 102 | Office 1A | A | 2 | — | HM | HM | YES | Hinges, Mortise Lock, Closer | Hinges, ASA Strike, Closer |
| L1 | 103 | Stair 1 | B | 5 | 90 | HM | HM | YES | Hinges, Mortise Lock, Closer | Hinges, ASA Strike, Closer |
| L1 | 104 | Storefront Entry | C | 9 | — | GL | AL | NO | — | — |
| L1 | 105 | Conference Room | A | 3 | — | WD | HM | NO | — | — |
In-scope rows highlighted yellow · Out-of-scope rows gray · Level dividers blue
Door ScheduleHardware TotalsTab 2 of 2
| HARDWARE ITEM | TOTAL QTY | HW SETS | OPENINGS |
|---|---|---|---|
| HINGE 5BB1 4.5 X 4.5 NRP 652 IVE | 18 | 1, 2, 5 | 101, 102, 103 |
| CYLINDRICAL LOCKSET ND53PD 626 SCH | 3 | 1, 2 | 101, 102 |
| FIRE EXIT HARDWARE 99NL 626 VON | 1 | 5 | 103 |
| SURFACE CLOSER 4040XP 689 LCN | 3 | 1, 2, 5 | 101, 102, 103 |
| WALL STOP WS406 CCV 630 IVE | 2 | 1, 2 | 101, 102 |
| KICK PLATE 8400 10X28 630 IVE | 3 | 1, 2, 5 | 101, 102, 103 |
In-scope openings only · Alternating row shading · Aggregated quantities across all hardware groups