Schedules
Door schedule takeoff, keyed by the mark on the drawing
The schedule comes off the page into a real spreadsheet grid, one row per door mark. Hardware and finish are not separate lists that happen to share door numbers -- they attach to the same row, so a change to what door 102 is made of lands on door 102 everywhere it is used.
Door schedule
A-601 · SAMPLE DATAHow it works
-
01
Extract, or select tables
Draw rectangles around the schedule on the page and pull it into an editable grid, or point at a PDF and the column holding door numbers.
-
02
Edit the grid
A real spreadsheet: type into a cell, add or reorder columns, filter, sort. Nothing here is a read-only preview.
-
03
Attach hardware and finish
A hardware set and a finish code on the row are more than text -- they are chips that open what they mean: the linked product, the price, the finish specification.
-
04
Review before it ships
A consolidated summary groups the schedule by floor and door type for a quick read, and unusual values are shaded so you look at them before the bid goes out, not after.
What it does
- Keyed by Number
- Every row is identified by the door mark on the drawing, the same key the hardware and finish schedules use, so the three stay in step with each other.
- A consolidated summary
- Grouped by floor, then door type, then matching dimensions -- a rollup for reading, computed fresh every time, never saved over the row data underneath it.
- Every row points at its page
- A row is not a cell someone typed. It carries the page it was read from, and opens there.
Common questions
Does editing the summary change the schedule?
No. The consolidated summary is computed fresh from the schedule every time you open it and is never written back. Edit the schedule itself to change a row.
What keys a row to its hardware and finish?
The door Number on the schedule. Hardware sets and finish codes are matched against that same column, so 102 in the door schedule, the hardware sheet and the finish sheet are the same door.
Can I add or remove columns?
Yes. It is a spreadsheet grid: add a column, reorder them, or mark one as a special column the schedule groups by.
More of the workspace
- Schedules Hardware sets A hardware set breaks into items, each one matched to a catalog part, priced, and chosen.
- Schedules Room finishes Finish codes read from the specification, one record per code, tied to the doors that carry them.
- Millwork Millwork takeoff Trace casework and trim on the floor plan at a calibrated scale, and price it against your own shop rates.
See it on your own set
Create a workspace for your shop and put a real drawing through it.