Project Input Form
Use the fields below to estimate lockset demand, packaging, cost, and labor.
Example Data Table
| Opening Type | Input Count | Locksets per Opening | Subtotal Locksets | Note |
|---|---|---|---|---|
| Office / classroom singles | 18 | 1 | 18 | Standard single-leaf rooms. |
| Entry / keyed singles | 9 | 1 | 9 | Controlled access points. |
| Pair openings, one active leaf | 6 | 1 | 6 | Inactive leaf hardware excluded. |
| Pair openings, two active leaves | 3 | 2 | 6 | Both leaves require locksets. |
| Electrified / special sets | 5 | 1 | 5 | Special hardware counted separately. |
| Example Base Locksets | 64 | Before allowances. | ||
| Example Adjusted Locksets | 72 | Includes 7% spares and 4% future allowance. | ||
Formula Used
Office + Entry + Privacy + Passage + Storeroom + Pair One Active + (2 × Pair Two Active) + Sliding + Electrified
Ceiling[ Base Locksets × (1 + Spare % / 100) × (1 + Future % / 100) ]
Ceiling[ Adjusted Locksets ÷ Sets per Carton ]
Adjusted Locksets × Average Unit Cost
Adjusted Locksets × Labor Hours per Set
This method estimates locksets only. Hinges, closers, cylinders, exit devices, strikes, readers, wiring, thresholds, and similar items should be counted separately.
How to Use This Calculator
- Enter counts for each opening group based on your door schedule or design drawings.
- Count pair openings carefully. One active leaf equals one lockset. Two active leaves equal two.
- Add sliding or electrified sets only when they are outside your regular opening counts.
- Apply spare stock and future change allowances to match procurement strategy.
- Enter sets per carton to estimate packaging units for ordering and site logistics.
- Use average unit cost and labor hours to build a quick budget and installation forecast.
- Review the chart, summary values, and export buttons after calculation.
Frequently Asked Questions
1. What does this calculator estimate?
It estimates lockset demand from single doors, active leaves in pairs, sliding sets, electrified openings, spares, cartons, budget, and installation hours. Use it during budgeting, coordination, or procurement planning.
2. How are pair doors counted?
A pair with one active leaf uses one lockset. A pair with two active leaves uses two. Inactive leaves usually need separate hardware, such as flush bolts, and are not counted here.
3. Should electrified openings be included?
Yes. Enter electrified or special locksets separately when they are not already included in your regular door counts. This improves purchasing, coordination, and labor forecasting accuracy.
4. Does this replace a hardware schedule?
No. This is a planning tool. Final quantities should match the approved door schedule, handing, function codes, fire ratings, access control scope, and project specifications.
5. Why add spare and future allowances?
Spare stock helps cover breakage, replacements, and handover needs. A future allowance helps when design development, tenant revisions, or late door additions are expected.
6. What does cartons needed mean?
It estimates packaging units for ordering, shipping, receiving, and storage. The calculator divides adjusted locksets by your sets-per-carton value and rounds the result upward.
7. Can I use the cost and labor fields for budgeting?
Yes. They turn the quantity takeoff into a quick planning model. Replace the default values with supplier pricing and actual crew productivity for better project forecasting.
8. What is not included in this calculator?
It does not count hinges, closers, cylinders, strikes, panic devices, thresholds, readers, wiring, or low-voltage accessories unless you account for them in a separate takeoff.