Measured costs to a reviewable quote

Trades Quotation & Estimating Calculator

An original working XLSX estimator with twelve cost lines, fictional example data, validation, contingency, markup, gross profit and margin. VAT and the total including VAT stay blank until you configure a rate.

Designed for: Builders, electricians, plumbers, decorators, landscapers and other trade businesses
Practical outcome: Prepare a measured estimate and clearer customer quotation using your own figures.

Genuine workbook preview

See the formulas and workflow inside

A real formula excerpt from Estimate worksheet — formula map. The complete paid workbook is not publicly exposed.

Estimate worksheet — formula map

Preview excerpt

Net line cost = quantity × unit cost
Direct cost = labour + materials + plant + subcontractors + other
Contingency = direct cost × your chosen rate
Markup = estimated cost incl. contingency × your chosen rate
Net quotation = estimated cost incl. contingency + markup
VAT = net quotation × your configured rate (otherwise blank)

Worked example: £1,097 direct cost → £1,382.22 net quotation.
All example inputs are fictional and editable.

Compatibility

Genuine XLSX workbook plus editable supporting files in one ZIP
Created for Microsoft Excel and recalculation-tested with LibreOffice
Google Sheets can import XLSX; validation, printing and layout may differ

Before you use it

Replace all fictional examples and business placeholders before real use
VAT is deliberately unset; choose the applicable rate and confirm your own tax treatment
General organisational templates, not accounting, tax, contractual or construction advice

Included files

4 resources, each with a job to do

The following files are prepared for the product. Paid archives stay private and unlock only through a verified order.

Complete product files

START-HERE.md

Setup order, formula map and pre-send checks.

trades-quotation-estimating-calculator.xlsx

Labour, materials, plant and subcontractor estimate with contingency, markup, margin and configurable VAT.

quotation-cover-template.md

Editable scope, exclusions, programme, price and acceptance structure.

pre-quote-site-visit-checklist.md

Measure the work and resolve assumptions before pricing.

Free XLSX sample · available now

Try a working mini-estimate

Download a genuine XLSX mini-estimate with three editable cost lines, markup and configurable VAT, plus a quote-preparation checklist and instructions. No email, account or payment details required.

Download free sample

Free sample only. Paid workbooks and archives are not publicly downloadable.

Try the free files first

The sample is a real download available now. It does not start an order, create an account or add you to a marketing list.