Shop / Spreadsheets & Workbooks / Siding Estimate Workbook — Takeoff, Cost Calculator, Customer Quote & Job Profit Ledger (Excel)

Why your siding quote shows dashes instead of a price

Measure a siding replacement job, price it from your own price book, and hand the customer a clean quote — a macro-free Excel workbook whose quote stays locked until 17 built-in self-checks pass. The first time it happens it looks like a bug: you open the Quote tab and every money cell shows an em dash. It is not a bug. It is the safety gate working — the quote only prints money after all 17 self-checks pass and you paste the final review key as a value. Any later edit to any input locks it again, so an out-of-date or broken number cannot slip into a quote you send.

What the gate checks

The siding workbook is six tabs — Cover, Price Book, Takeoff, Estimate, Quote and a 25-job Ledger — and the checks run from the Price Book to the Quote:

The Ledger sits beside the quote: a per-job profit log — contract price against actual costs — so the job's margin is tracked after the quote goes out, not guessed at the end of the year.

A real sample house, priced end to end

This is the workbook's worked example — audit every number in the included NUMBERS guide before you trust it with a real job:

Sample house — 2-story, 40 ft x 28 ft, 2,422 sq ft net, vinyl at $450/square with 10% waste: 27 squares ordered, materials $15,275.76, total job cost $25,329.36, quote total $31,661.70 with 25% markup, deposit $9,498.51, balance $22,163.19. Sample rates are illustrative, not verified supplier quotations.

Sample data above is fictional, shown so you can judge the output before buying.

Two storeys, 40 ft by 28 ft, 2,422 sq ft net, vinyl at $450 per square with 10% waste: 27 squares ordered, materials $15,275.76, total job cost $25,329.36, quote total $31,661.70 with 25% markup — deposit $9,498.51, balance $22,163.19. Every Price Book figure is a sample: replace material prices, waste factors and labor rates with your own supplier and crew rates, and enter your company details on the Quote sheet.

What the workbook does not do

It prices one rectangular four-wall section at a time — multi-section or non-rectangular houses need separate takeoffs. No sales tax, permit or jurisdiction-specific charges are added automatically; the Quote lists standard exclusions, so apply your local taxes and required charges before issuing a binding proposal. And this release is Microsoft Excel desktop only (2019, 2021 or Microsoft 365): it uses current Excel functions, including the review-key check, that Google Sheets does not support reliably.

The tool for this job

Siding Estimate Workbook — Takeoff, Cost Calculator, Customer Quote & Job Profit Ledger (Excel) — Measure a siding replacement job, price it from your own price book, and hand the customer a clean quote — a macro-free Excel workbook whose quote stays locked until 17 built-in self-checks pass.

$34.99 Buy on Payhip See the full product page →

Instant download after checkout. Sold and delivered by Payhip. More tools like this live on the Spreadsheets & Workbooks shelf.

Questions

Does it work in Google Sheets?

No. This release is built and checked for Microsoft Excel 2019, 2021 or Microsoft 365 on desktop, and uses current Excel functions (including the review-key check) that Google Sheets does not support reliably. Google Sheets is not a supported platform for this workbook.

Why does the Quote show dashes instead of the price?

That is the safety gate working. The quote only prints money after all 17 self-checks pass AND you paste the final review key as a value — any later edit to any input locks it again, so an out-of-date or broken number cannot slip into a quote you send.

What do I need to replace before using it for a real customer?

Every Price Book figure is a sample: replace material prices, waste factors and labor rates with your own supplier and crew rates, and enter your company details on the Quote sheet.

Does it include taxes or permit fees?

No — no sales tax, permit or jurisdiction-specific charges are added automatically. The Quote lists standard exclusions; apply your local taxes and required charges before issuing a binding proposal.