Keep measurements, calculations and presentation connected. A spreadsheet is most useful when a changed quantity updates the correct line amount and summary without manual retyping.
Enter
Numeric quantities and rates; unit labels in their own column.
Reconcile
Line amounts → room totals → project item subtotal.
Issue
Save the workbook revision and export the selected schedule.
Set up a workbook that is easy to audit
Use separate areas or sheets for project details, measurements, item rates, the quotation schedule and the client summary. Give each item a stable code so you can trace a total back to its measurement. Keep assumptions beside the inputs, including whether dimensions are in feet, inches or millimetres.
In the quotation schedule, use columns A to H for item code, room, description, unit, quantity, rate, amount and scope note. Enter numeric quantities and rates without embedding unit text in the cells. Store the unit in its own column so formulas can work with the numbers.
Use simple formulas and visible checks
With quantity in E2 and rate in F2, the line amount in G2 can be =ROUND(E2*F2,2). Copy the formula through the item rows and use =SUM(G2:G20) for a schedule ending at row 20. Adjust that range to the actual schedule; adding rows outside a fixed range can leave work out of the total.
Build a check that compares the sum of room subtotals with the project item subtotal. A difference should be zero before issue. Keep discounts, delivery and other adjustments in clearly labelled rows. Verify the applicable tax treatment for the actual project instead of hard-coding a rate into every template.
Measure consistently before calculating
If an approved cabinet elevation is 8 feet wide and 7 feet high, its face area is 56 square feet. That arithmetic is only useful when the quotation says that face area is the agreed measurement basis. Do not apply the same area calculation to hardware sold per piece or a kitchen quoted by running length.
Separate base units, wall units, tall units and lofts where their specifications or measurement methods differ. For every conversion, keep the original measurement available. Rounding each small component too early can create a different result from rounding the final item quantity.
Protect the master and issue a readable copy
Visually distinguish input cells from formula cells, and protect formula ranges against accidental edits where appropriate. Keep a clean template without previous client details. Before each issue, check for missing rates, duplicate item codes, hidden rows and optional items accidentally included in the total.
Save a revision of the workbook, then export the client schedule and terms as PDF. Sharing an editable workbook can be useful during collaboration, but the approval record should identify the precise quantities and rates accepted.
What to include
- Every quantity has a unit
- No blank rates on included items
- Room totals reconcile with the summary
- Optional items are outside the selected total
- Print area includes terms and all columns
Worked example
Check a calculation before it reaches the summary
Consider a cabinet measured on its front elevation: 8 ft × 7 ft = 56 sq ft. The rate must use that same square-foot basis. The figures below demonstrate spreadsheet arithmetic only; they are not a market rate or a project estimate.
Too vague to approve
Quantity entered as “56 sq ft”, rate typed with text, amount manually overwritten.
A clearer version
Unit cell D2: sq ft. Quantity E2: 56. Illustrative rate F2: 100. Formula G2: =ROUND(E2*F2,2). Calculated amount: 5,600. If the verified quantity changes to 60, the amount becomes 6,000 without retyping the total.
The point of a formula is to keep the amount connected to the inputs. Extend that connection to the room and project totals. After adding or removing an item, check that the sum range includes exactly the selected work. Keep an independently checked total for the first issue and repeat the reconciliation when the scope changes.
Sample schedule
Use these fields to organize your own scope. Add the verified quantities, project-specific rates and selected specifications before issue.
E2: Quantity
Measured quantity for one item
- Unit / type
- number
- Review point
- Use one declared unit
F2: Rate
Rate per matching unit
- Unit / type
- number
- Review point
- Do not type currency text into the value
G2: Amount
=ROUND(E2*F2,2)
- Unit / type
- formula
- Review point
- Copy down through included items
Summary
=SUM(G2:G20)
- Unit / type
- formula
- Review point
- Extend range when adding rows
| Item | What to specify | Unit / type | Review point |
|---|---|---|---|
| E2: Quantity | Measured quantity for one item | number | Use one declared unit |
| F2: Rate | Rate per matching unit | number | Do not type currency text into the value |
| G2: Amount | =ROUND(E2*F2,2) | formula | Copy down through included items |
| Summary | =SUM(G2:G20) | formula | Extend range when adding rows |
Before you send it, catch these mistakes
- Typing totals over formulas
- Leaving new rows outside the sum range
- Applying an area rate to a running-length quantity
- Hiding exclusions on a sheet the client never receives
Get your quotation inputs ready
Tick off what you have, then copy the list into your project notes. Use the unchecked items to guide your next site visit or client conversation.
Use this while reading. Your selections reset when you leave this page.
Frequently asked questions
Is Excel enough for a small interior business?
It can be enough when one person owns the master and reviews each issue carefully. Repeated edits by several people may require more structured version and approval controls.
Should I share Excel or PDF with the client?
Use the workbook when editable collaboration is intended. For formal review, export a readable PDF and reference the saved workbook revision.