Window Pricing & Breakdown Worksheet
An estimator worksheet for a window installer. Product price books for five product lines feed a breakdown sheet where each opening is priced by size, options and features, with custom size and cut-down calculators.
- Industry
- Construction / Windows
- Deliverable
- Pricing Spreadsheet.xlsm
- Built with
- Excel formulas, VBA
Before
Each window opening was priced by looking up five separate price books.
After
Price books feed one breakdown sheet that prices every opening by size, options and features.
More like this
Related projects
Health Plan Quote Builder (Excel to Word)
Insurance
Builds self-funded health plan quotes. Premiums, claims forecasts and fees are calculated in Excel and a single click exports the finished quote into a formatted Word…
View project
Fire Sprinkler Estimating Workbook
Construction / Fire Protection
A full estimating workbook for sprinkler and alarm contracts. Unit entries, cost books, parts lists, rentals and subcontracts roll up to the contract value, cost per…
View project
On-Demand Courier Pricing Calculator
Logistics
A quoting calculator for a same-day courier business. Mileage, vehicle type, weight, pallets and service level are combined with editable rate tables to produce a total…
View project