Project quantity reconciliation
Room-Type Fixture Quantity Calculator
Build quantities from the room schedule: rooms × fixtures per room, plus the spares you enter. Lines are grouped only when fixture, specification revision and unit match exactly, so different revisions never merge into one total. No wastage percentage is added.
Enter records → review differences or arithmetic → resolve missing evidence. No order or approval is generated.
Enter your records
Every field is required for a complete record. Enter 0 only when zero is deliberate; missing values remain unresolved. Use non-confidential references only.
Record fields
- Room type
- Number of rooms (whole number)
- Fixture
- Specification and revision
- Unit (e.g. piece, set)
- Fixtures per room (whole number)
- Spares for this line (0 if none)
Reviewable result
Enter records to begin.
Worksheet processing stays in this page. Inputs are not uploaded or stored, and reloading clears them. Page analytics are disabled here. Contact links and the quote form are separate actions; review the result before choosing to share it.
Worked example
A procurement lead for a hotel fit-out totals fixtures from the room schedule before sending an RFQ, with one revision mismatch left in on purpose.
Example figures are invented for illustration. They are not product data, prices or a quotation.
Example inputs
| Room type | Number of rooms (whole number) | Fixture | Specification and revision | Unit (e.g. piece, set) | Fixtures per room (whole number) | Spares for this line (0 if none) |
|---|---|---|---|---|---|---|
| Room type K1 | 40 | Wall-mounted vanity | Drawing rev B | piece | 1 | 2 |
| Room type K2 | 24 | Wall-mounted vanity | Drawing rev C | piece | 1 | 1 |
| Room type K1 | 40 | Shower enclosure | Drawing rev B | set | 1 | 2 |
Result from the worksheet
Room-Type Fixture Quantity Calculator LOCAL WORKSHEET — review before using Line 1 · Room type K1 / Wall-mounted vanity: 42 piece (Drawing rev B). Line 2 · Room type K2 / Wall-mounted vanity: 25 piece (Drawing rev C). Line 3 · Room type K1 / Shower enclosure: 42 set (Drawing rev B). Group: Wall-mounted vanity / Drawing rev B: 42 piece Group: Wall-mounted vanity / Drawing rev C: 25 piece Group: Shower enclosure / Drawing rev B: 42 set REVIEW ITEMS Different specification revisions for Wall-mounted vanity: groups kept separate. No product, order, installation or commercial approval is generated.
How to read it
Each line is rooms x fixtures per room + spares: Room type K1 vanities are 40 x 1 + 2 = 42 piece. The one review item is that the wall-mounted vanity appears under Drawing rev B and Drawing rev C, so the tool kept 42 and 25 as separate groups instead of merging them. Before an RFQ, the buyer should confirm which revision is current.
Start from the current room schedule
Use the agreed count for each room type and name the fixture’s specification. A similar product name isn’t enough when handing, finish or another option that defines the order differs; put that difference in the specification reference. If one room type has two fixture configurations, use two lines.
Enter spares deliberately
Each line is rooms × fixtures per room + spares. Enter 0 only when no spares are intended; a blank spares field leaves the line incomplete. The tool doesn’t suggest a spare percentage, and a calculated quantity says nothing about stock availability.
Check the groups before sending an RFQ
Grouping is exact on fixture, specification revision and unit, ignoring spaces at the start and end. Different revisions of the same fixture stay in separate groups and are flagged. Repeated identical room and fixture lines are flagged too, because they may count a room twice. The result is an arithmetic check, not a purchase order.
Project quantity reconciliation questions
Does the calculator add a default spare allowance?
No. Enter the spares you intend, including 0 when there are none.
Are different specification revisions combined?
No. Each revision stays in its own group.
What if one room type has two different basin models?
Use a separate line for each, with its own specification reference.
Does the calculated quantity confirm stock?
No. Availability and order scope need separate confirmation.
Can repeated room lines double-count quantities?
Yes. Check the repeated-line warning before relying on the totals.
Discuss the reviewed requirement
Use the result to identify questions for WNS Global. Offered products, specifications and commercial conditions still require separate confirmation.