Article contents 17 sections
A smart lock door schedule connects each physical opening to its surveyed condition, required operation and proposed hardware. It answers one question for the buyer, the lock maker and the installer alike: which configuration belongs at this door?
Build it as one row per opening with a stable opening ID, then add the door and leaf arrangement, measured dimensions and preparation, handing, required operation, power and connection, and the hardware set. Keep survey facts, requirements and product data in separate fields, and keep every issued revision.
A list of model names and quantities shows how many locks were ordered; it does not show which doors need a different mounting kit, which opening has two leaves, or where an existing cutout stops the proposed lock from fitting. The schedule does.
For the wider quotation package, commercial response and supply responsibilities, see the smart lock project specification and RFQ guide.
What Is a Smart Lock Door Schedule?
A door schedule is an organized record of the project's openings. In a smart lock project, it also connects the physical door information to access requirements, power and connectivity arrangements, hardware selection and installation status.
A spreadsheet is enough; the links it keeps do the work, whatever the software.
Three records are easy to confuse:
| Record | Main purpose | Example information |
|---|---|---|
| Door schedule | Identify each opening and its requirements | Opening ID, location, leaf arrangement, dimensions and hardware-set reference |
| Hardware-set schedule | Define the components and functions assigned to a group of openings | Lock assembly, mounting parts, receiving hardware and configuration |
| Installed asset register | Identify the individual equipment actually installed | Opening association, device identity, relevant version and installation record |
They can live in different tabs or files as long as they share references. A hardware set serves several doors; a device serial number belongs to one installed device; the opening ID stays with the door location when that device is replaced.
UFGS 08 71 00 links door numbers to hardware sets and keeps hardware schedules, shop drawings and product data separate. UFGS door hardware specification
1. Decide What One Row Represents
Use one row per opening with a unique opening ID, and write that rule into the schedule instructions so nobody enters single leaves while others enter whole openings.
A pair of doors can remain one opening row with two identified leaves. If the project needs separate leaf records, put them in a linked detail table under the parent opening ID. Mixing the two methods without saying so causes counting errors.
Record whether the scope covers a new installation, replacement of existing hardware, retained hardware or an excluded opening. Keep excluded openings visible so the schedule reconciles with the architectural drawings, and keep them out of the purchase totals.
A row for “all doors on this floor” only works with a separate list of every included opening and its exceptions. Group totals help purchasing; installers still need a location for each lock.
2. Assign Stable Opening IDs
Use the project's existing door numbers where they exist. A second numbering system makes drawings, photos, packages and installation reports harder to connect.
Where there is none, agree a short convention such as building, level and door number. The syntax is up to the project; the ID just has to be unique.
Store IDs as text, so leading zeros survive and spreadsheets keep them as typed instead of turning them into dates or numbers.
Keep room names and room numbers in separate fields. If a store room becomes an office, update its use and requirements and keep the opening ID. Where a project-wide renumbering is necessary, preserve an old-to-new cross-reference.
Keep the lock model out of the opening ID, so the door keeps its identity when the product is replaced. The same goes for an app's device name: the opening ID, kept in the schedule, is the link between a door and its records.
Link photos and survey sheets to the opening ID when they are taken. Six close-ups of lock bodies are useless once nobody knows which door each one shows.
3. Keep Survey Facts, Requirements and Product Data Separate
Use different fields or linked tables for three kinds of information:
Survey facts describe what is present: a measured door thickness, existing preparation or observed frame condition.
Project requirements describe what is needed: authorized card entry, a particular inside operating sequence or a required connection to another system.
Product data describes what is proposed: a lock body, mounting kit, compatible thickness range or gateway dependency.
A lock's mounting range describes the lock and the survey describes the door; a request for remote access is a requirement until the chosen configuration is shown to have it. Keeping them in separate fields is what lets you compare them.
Record the source and date of each measurement. A survey reading, a design drawing and an estimate from a photo have different uses, and when a value changes the reviewer can see why.
Keep the measured value next to the chosen configuration: the kit is chosen for a thickness range, while the survey keeps the door's own thickness. The kit description never replaces the measurement.
4. Select the Fields That Affect the Project
Put short, structured values in the main table and link the detailed drawings, functional descriptions and records, so the sheet stays readable.
| Field group | Information to capture | Why it matters |
|---|---|---|
| Identity and scope | Opening ID, location, work package and included/excluded status | Prevents omissions, duplicate purchases and unclear installation destinations |
| Door and leaf arrangement | Material, profile, leaf count and active/inactive relationship | Establishes the assembly being equipped |
| Dimensions and preparation | Thickness, stile space, lock preparation and drawing reference | Supports physical compatibility review |
| Direction and handing | Defined viewpoint, hinge side, swing direction and agreed handing designation | Reduces interpretation errors between the lock maker and installers |
| Frame and receiving hardware | Strike or keeper arrangement, gaps, closer and existing condition | Captures factors affecting closing and locking |
| Required operation | Entry method, inside operation, locking sequence and special modes | Defines the function separately from the product name |
| Power and connection | Power arrangement, connection path and shared-equipment reference | Identifies installation and system dependencies |
| Special requirements | Fire, egress, accessibility or exposure requirements and review reference | Makes opening-specific constraints visible |
| Product assignment | Hardware set, chosen configuration and its revision | Connects each opening to the supply package |
| Delivery and installation | Phase, package association, installer and completion record | Supports staged work and receiving checks |
| Verification and change | Data source, unresolved issue, review state and revision | Prevents incomplete or superseded information being treated as final |
Define how the schedule shows three states: not applicable, still to survey, awaiting a decision. They are three different states, and none of them is a zero.
Keep unknowns visible: a survey question with an owner and a date beats a guessed dimension.
5. Record Dimensions with Unambiguous Meaning
Label units and measurement references. “Width: 900” is incomplete unless the reader knows whether it describes a leaf, frame opening or clear passage, and whether the unit is millimeters.
On paired doors with unequal leaves, record each leaf width; the lock sits on one leaf, so the combined width says little.
Smart lock fit comes down to door thickness, profile space, backset, operating centers, faceplate dimensions, lock-body space, fixing positions and spindle or cylinder interfaces. Choose the fields that apply and link a drawing where one value cannot describe the geometry. On our A2 IP66 waterproof smart lock, for instance, the lock-body field takes one of 6068, 4585, Russian 6585 or Russian 6085, and the thickness field has to sit inside 40–120 mm.
HOPPE's purchase checklist treats door thickness, spindle and operating centers as separate inputs, which keeps one familiar dimension from standing in for the whole interface. HOPPE purchase checklist
The schedule guides the order; machining follows the accepted preparation drawing, with its revision noted. For measurement definitions and lock-body interfaces, refer to the mortise, backset and lock-body guide.
Record Direction Before Relying on Handing Abbreviations
State the viewpoint used for hinge side and swing, and add a sketch or marked photo where teams use different handing conventions.
Match the final handing to the lock maker's convention and the actual opening. A reversible lock still has preparation, trim or other hardware that can be handed.
For a pair, identify the active leaf by a fixed description and a drawing reference. “Left door” without a viewpoint invites an installation error. The full method is in how to identify door handing.
6. Describe How Each Opening Must Operate
Record entry, inside operation and locking behavior separately. “Card lock” does not say whether the inside handle releases the mechanism, whether the door relocks automatically, or how temporary access is removed.
Where several openings share the same requirements, give them a functional profile defined in a companion table, and keep exceptions on the opening row. A store room's privacy function should not spread to every office just because the panels look alike.
For connected functions, name the route and the shared equipment: local phone operation, remote operation through a gateway and an interface to another system are three different things.
Record power per assembly. A battery-powered lock and a separately powered gateway or reader are separate items; the gateway does not power the lock.
Link doors to a system record for shared gateways and count the gateways there, once for the system. Gateway coverage comes from the site design and testing; a fixed number of doors per gateway is a guess. On a TTLock version, every door that needs remote access has to be within reach of a TTLock gateway with Wi-Fi.
Keep credentials out of the door schedule. It can name a permission profile or key group without holding usable PINs or passwords.
7. Build Hardware Sets Without Hiding Differences
A hardware set is a repeatable group of items with an ID, a contents list and a function. It keeps the door schedule short.
Define sets by their parts; looks can match across different sets. Two locks with the same panel can need different lock bodies, mounting kits or receiving parts, and then they are different sets.
Handed variants can sit inside one set if the definition says how each is chosen, or become separate set variants. Pick whichever lets the factory and installer find the right parts without guessing.
When an exception changes a part that affects fit or function, make it a set variant or a linked exception. A note in a comments column is too easy to miss when ordering a different spindle or lock body.
Before counting, decide what “one set” includes: only new lock hardware, or all door hardware including retained parts. Mark each part as new supply, retained, supplied by others or excluded.
A Worked Door Schedule Example
A small office project has six openings: four offices, one paired store room and one corridor door that stays under a separate work package. The operating requirements for the offices and store room are already set by the project.
Opening Register
Thickness values are leaf measurements in millimeters. For hinge side, the viewpoint is from the corridor toward the named room. Each in-scope leaf swings into that room. The paired opening's arrangement is additionally identified in its leaf record.
| Opening ID | Location and arrangement | Leaf thickness | Hinge/active-leaf information | Work scope and set |
|---|---|---|---|---|
| O-001 | Office 101; single leaf | 45 | Hinges left from stated viewpoint | Replace lock hardware; HS-A |
| O-002 | Office 102; single leaf | 45 | Hinges right from stated viewpoint | Replace lock hardware; HS-A |
| O-003 | Office 103; single leaf | 45 | Hinges left from stated viewpoint | Replace lock hardware; HS-A |
| O-004 | Office 104; single leaf | 50 | Hinges right from stated viewpoint | Replace lock hardware; HS-B |
| O-005 | Store room; paired leaves | 50 each | Leaf A active, hinges right; leaf B inactive, hinges left | Active-leaf smart lock replacement; HS-C |
| O-006 | Corridor; single leaf | 45 | Hinges left from stated viewpoint | Retained under separate package; no new smart lock |
Linked Hardware Definitions
A real procurement record would also link the accepted part numbers and preparation drawings.
| Set | Applicable openings | New supply covered by this set | Retained or separately controlled items |
|---|---|---|---|
| HS-A | O-001, O-002, O-003 | One smart lock assembly per opening, matched lock body and receiving parts, mounting kit for the surveyed 45 mm leaf, handing variant confirmed per opening | Existing hinges and closer, subject to condition check |
| HS-B | O-004 | One smart lock assembly, matched lock body and receiving parts, mounting kit for the surveyed 50 mm leaf | Existing hinges and closer, subject to condition check |
| HS-C | O-005 | One active-leaf smart lock assembly and mounting kit; receiving components matched to the accepted pair arrangement | Inactive-leaf hardware and closing coordination checked as part of the complete opening |
The required base operation is local staff-card entry, with credential-free inside handle operation and locking behavior defined in the project's accepted functional profile. No remote function or gateway is included. Handing is matched to the lock maker's convention per opening.
The schedule contains six openings and seven leaves, because O-005 has two leaves. It calls for five new smart lock assemblies: three HS-A, one HS-B and one HS-C. O-006 is visible for coordination but contributes no new lock to this supply package.
The inactive leaf at O-005 needs no second smart lock here: the scope puts one lock on the active leaf, and the inactive leaf's hardware is checked as part of the opening. Other projects can differ.
If O-001 and O-005 are selected for a pilot and remain in the final installation, they are two of the five assemblies. The remaining new supply is three assemblies, not five more. User cards and spare parts are counted in separate records.
8. Check Quantities Against the Scope, Not Just the Row Count
Create a purchasing summary from the current opening assignments and hardware definitions. Reconcile included openings, leaf arrangements, retained items and the quantity basis of each component.
Openings, leaves, locks and user credentials are four different counts, and shared equipment is a fifth.
If a door appears in two phases, check whether it is one installation listed twice or two separate deliveries; pilots are often counted twice this way.
Keep alternative proposals out of the base totals until one is chosen. Two options for the same opening are still one lock.
For a revised set, check which parts change: a new mounting kit can leave the lock count the same and change the accessory quantities.
9. Link Each Opening to Its Evidence and Decisions
Link the schedule to survey sheets, drawings, photos, accepted product data and issue records with short references that name the file and revision, not a folder of alternatives.
One opening can have several sources: thickness from the site survey, operation from the design brief, mounting kit from the lock maker's submittal. A single “approved” column cannot cover all three.
Use review states that name the decision: surveyed, compatibility reviewed, released for procurement, installed, verified in service. Give each a definition and an owner; surveyed is not the same as released.
When sources conflict, keep both until an authorized correction is recorded, and never pick the value that suits the preferred product.
For a door you cannot reach, keep the drawing value marked as drawing information with a site measurement still to do. It is fine for a budget, not for machining.
10. Maintain Revisions Without Erasing the History
Give each released schedule an issue ID and date, record changes by opening ID with who authorized them, and keep the previous issue so the factory and installer can see what changed.
Drawings and schedules often have their own revision numbers, so keep an issue index that lists which versions belong together.
A change record gives the old value, new value, reason and effect. “Updated schedule” tells procurement nothing about whether to change the order.
Example: One Door Moves to a Different Mounting Set
Continuing the schedule above, suppose a later accepted door replacement changes O-003 from a 45 mm leaf to a 50 mm leaf. Its location remains O-003, but its mounting assignment moves from HS-A to HS-B after the relevant compatibility review.
The purchasing summary changes from three HS-A and one HS-B to two HS-A and two HS-B. HS-C remains one. The total new smart lock quantity remains five, while the mounting-kit allocation changes.
If the order is already placed, send the change to the lock maker, list the affected goods and settle the kit swap before installation. If the preparation changes too, update the drawing and review record.
Mark canceled openings as canceled instead of deleting them, so earlier quotations and delivery notes still reconcile.
11. Make the Working File Usable for Other Teams
Use consistent field names, units and permitted values, one meaning per column. A cell reading “45 mm, maybe 50, ask site” cannot be sorted, counted or compared; split it into measurement, source and issue fields.
Protect calculated summaries from manual edits, and check that filters or hidden rows do not drop openings from an export.
Avoid merged cells in the data table, which break sorting and import. Group things visually in a separate presentation view.
Separate input fields, calculated fields and responses from the lock maker, and agree which party may change which fields. Survey data then stays as surveyed.
Exchange copies should keep opening IDs, units, revisions and set definitions. Send a PDF for review and the editable file for sorting and reconciliation.
12. Carry the Schedule into Installation and Maintenance
Use the opening IDs on installation records and carton labels. Before fitting, check the kit against the door and the current schedule: the right carton at the wrong door causes the same problem as the wrong kit.
Record the device installed at each opening alongside the opening ID. If a device is swapped during commissioning, update the link and keep the history.
Keep proposed, purchased and installed configurations separate. A substitution approved on site goes into the final record with its reason, so maintenance staff never order parts for a lock that was not installed.
NIBS describes COBie as structured facility asset information for operation and maintenance. Its split between asset information and project deliverables is a good reason to plan handover data early, even without COBie. NIBS COBie guidance
At handover, the schedule connects the opening to the installed hardware, its instructions, service-part references and check records. Store account credentials and other sensitive access material through a separate controlled process. Spares are then ordered from the same groups, as set out in spare parts planning.
Common Door Schedule Mistakes to Catch Before Issue
Before issuing, check for:
- duplicate IDs, openings without a location and hardware sets assigned but not defined;
- doors missing or repeated against the floor plans;
- assumed measurements shown as surveyed, unexplained blanks, handing without a viewpoint, product data in site-condition columns;
- paired doors, excluded openings, retained hardware, shared gateways and pilot units, where row counts and purchase quantities most often part ways;
- rows linked to an old preparation drawing, which send the wrong instruction to the factory even when the row itself is right.
Frequently Asked Questions
What fields are essential in a smart lock door schedule?
Opening ID, location, scope, door and leaf arrangement, dimensions and preparation, handing, required operation and hardware set. Add power, connectivity, review status and delivery as the project needs, with the source and revision of each value.
Can several doors share one hardware set?
Yes, when the set and its variants cover every door's actual requirements. Keep the individual door rows and their exceptions; matching panels can hide different lock bodies, mounting parts or functions. On our G1 apartment smart lock projects we survey one door from each group and record its full mortise designation, strike and handing for that reason.
Does a paired door require two smart locks?
In most pairs one, on the active leaf, with the inactive leaf's bolts or keeper checked as part of the opening. Count from the hardware set; the number of leaves overstates it.
How should the schedule change after installation?
Keep the opening ID, and add the installed device, accepted changes and verification record. Superseded configurations go into the history; the final record shows what is actually in service.
References
- UFGS 08 71 00 — Door Hardware. Door-number and hardware-set relationships within a project-editable guide specification.
- HOPPE — Purchase Checklist. Separate selection inputs for door thickness, spindle and operating-center relationships.
- NIBS — COBie. Structured facility asset information and handover planning for operation and maintenance.