Custom Construction Estimating Spreadsheet
Budget: £250 – £750 GBP
I need an Excel workbook that lets me generate accurate total-project cost estimates from my raw data. I will supply quantity takeoffs, current supplier quotes, and up-to-date labor rates; the sheet should pull all three together and return a clear breakdown of every cost line and the overall figure.
Key functions I expect:
• Cost-per-unit formulas that recalculate instantly when I update quantities or prices
• Markup and profit calculations that I can adjust with a single percentage input
• Automatic roll-ups so the grand total, subtotals, and profit column refresh without manual intervention
A clean, intuitive layout is important—separate input areas for quantities, supplier prices, and labor, with protected formula cells to avoid accidental edits. I’d also like a summary dashboard that highlights total material, labor, markup, profit, and final project cost at a glance.
Deliver the finished .xlsx file, ready for me to drop my numbers in and start estimating right away.
Key functions I expect:
• Cost-per-unit formulas that recalculate instantly when I update quantities or prices
• Markup and profit calculations that I can adjust with a single percentage input
• Automatic roll-ups so the grand total, subtotals, and profit column refresh without manual intervention
A clean, intuitive layout is important—separate input areas for quantities, supplier prices, and labor, with protected formula cells to avoid accidental edits. I’d also like a summary dashboard that highlights total material, labor, markup, profit, and final project cost at a glance.
Deliver the finished .xlsx file, ready for me to drop my numbers in and start estimating right away.