Skip to content
Estimateria

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 DATA
ABCDEF
MarkTypeSizeHardwareFinishPage
101 Hollow metal 3'0" × 7'0" HW-01 PT-1 p.3
102 Solid core wood 3'0" × 6'8" HW-04 ST-2 p.3
103 Hollow metal 3'0" × 7'0" HW-01 PT-1 p.3
104 Storefront pair 6'0" × 8'0" HW-07 AN-1 p.4
105 Solid core wood 3'0" × 6'8" HW-04 ST-2 p.4
106 Hollow metal 3'0" × 7'0" HW-02 PT-1 p.4

How it works

  1. 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.

  2. 02

    Edit the grid

    A real spreadsheet: type into a cell, add or reorder columns, filter, sort. Nothing here is a read-only preview.

  3. 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.

  4. 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.

Open sign-up · bring your team

See it on your own set

Create a workspace for your shop and put a real drawing through it.