Lockset Quantity Calculator

Inputs

Project Name (optional)

Spare Percentage

%

Applied to each line item before pack rounding.

Pack Size for Ordering

Rounds each lock type up to full packs.

Default Cylinders per Lockset

Default Keys per Lockset

Extra Cylinders

Master Keys

Control Keys

Notes (optional)

---

Door Groups and Hardware Mix

Enable rows you want included. Use per-row overrides if needed.

Add Row Calculate

Area / Group	Doors	Lock Type	Locksets / Door	Cylinders / Set	Keys / Set	Include
		Cylindrical Mortise Deadbolt Electronic Exit Device Trim Sliding Door Storeroom Classroom
		Cylindrical Mortise Deadbolt Electronic Exit Device Trim Sliding Door Storeroom Classroom
		Cylindrical Mortise Deadbolt Electronic Exit Device Trim Sliding Door Storeroom Classroom

Tip: Set “Cylinders / Set” to 0 for keypad-only hardware.

Example Data Table

Formula Used

Averaging uses the spare-adjusted rows for each lock type, then scales after pack rounding.

How to Use This Calculator

1. Enter spare percentage and ordering pack size.
2. Set default cylinders and keys per lockset.
3. Add rows for each door group and choose lock type.
4. Override cylinders or keys per row when necessary.
5. Enable only the rows you want included.
6. Click Calculate to see totals and lock-type breakdown.
7. Download CSV or PDF to share with procurement.

Professional Guide to Lockset Quantity Planning

1) Why lockset quantity accuracy matters

Door hardware is small compared with concrete or steel, yet it can stop handover on the last week. Missing locksets delay punch lists, affect occupancy inspections, and create expensive express freight. Over-ordering increases carrying cost and storage risk, especially when finishes must match.

2) Start with door groups, not floor area

Count doors by functional group: offices, corridors, stairs, risers, plant rooms, and security zones. Each group usually has a predictable lock type and keying approach. This calculator lets you capture that mix with multiple rows, then summarizes totals by lock type for cleaner purchasing.

3) Apply spares as a controlled policy

A spare allowance covers damaged units, late design changes, and commissioning swaps. A common approach is 5–10% spares, but critical areas may warrant more. Here, spares are applied per row before ordering pack rounding, giving a realistic buffer where it is needed.

4) Pack rounding keeps orders practical

Many suppliers ship locksets in cartons or packs. If packs are 10, ordering 21 locksets still becomes 30. Rounding by lock type avoids mixing cartons across different finishes or functions. Use the Pack Size input to match your vendor’s packaging standard.

5) Cylinders and keys drive the real scope

Locksets are only part of the hardware story. Cylinders may vary by function (single, double, interchangeable core), while key quantities depend on occupancy, security, and maintenance plans. The calculator estimates cylinders and keys using your per-row settings and adds master and control keys as separate allowances.

6) Example data walkthrough

Using the sample rows: Level 1 Offices (24 doors, Cylindrical, 7% spares) produces 26 rounded locksets. Stairwell Doors (6 doors, Mortise) yields 7 rounded locksets. IT Room (2 doors, Electronic) yields 3 rounded locksets. These values illustrate how spares and rounding affect totals.

7) Typical estimating checks

Before issuing purchase orders, compare totals against door schedules, addenda, and security matrices. Confirm which doors require two locksets (e.g., double-leaf active/passive) by setting Locksets per Door above 1.0. Validate cylinder formats and confirm whether electronic sets require mechanical override cylinders.

8) Procurement-ready outputs

After calculating, export CSV for quick takeoff review and vendor comparison, or PDF for approvals. Keep notes for assumptions such as keying hierarchy, finish codes, and critical spare policies. Well-documented counts reduce rework and support faster submittal cycles.

FAQs

1) What does “Locksets per Door” mean?

It represents how many locksets are required for each door opening. Use 1.0 for most single doors. Use 2.0 when two separate sets are needed, or when your scope includes both a lockset and an auxiliary set.

2) How should I choose the spare percentage?

Use a consistent policy such as 5–10% for general areas, and adjust for high-risk zones or late design changes. If your project has strict finish matching, keep spares conservative and well-documented in notes.

3) Why is rounding applied by lock type?

Lock types often differ in function, finish, and packaging. Rounding each type separately prevents ordering partial cartons or mixing incompatible items. It also aligns the totals with vendor ordering units and reduces site handling complexity.

4) How are cylinders calculated for mixed rows?

The calculator averages cylinders per set within each lock type using your enabled rows, then applies that average to the rounded lockset quantity. This mirrors typical takeoff practice when door groups share the same lock type but vary slightly in cylinder needs.

5) Can electronic locks have zero cylinders and keys?

Yes. For keypad-only or card-only hardware, set Cylinders per Set and Keys per Set to 0 for that row. If a mechanical override is required, enter the cylinder and key quantities that match the specified override format.

6) What are master and control keys used for?

Master keys support supervisory access across multiple doors, while control keys may be needed for rekeying systems or interchangeable cores. These counts are added on top of the calculated keys so they remain visible as separate allowances.

7) What should I do if my door schedule changes?

Update the affected rows, re-run the calculation, and export a new CSV/PDF for revision tracking. Record the revision date and assumptions in Notes. This keeps procurement aligned with the latest door schedule and addenda.