Excel Construction Estimating Workbook

Job ID: 39846800

Budget: $750 – $1,500 CAD

I’m consolidating my construction estimating process into one purpose-built Excel workbook. The first release must let me enter quantities and instantly see calculated material and labour costs, then carry those figures forward so I can track every change order against the original budget. All costs will initially pull from my own historical project data; however, the structure should stay flexible so I can plug in supplier quotes or industry databases later without rebuilding formulas.

Key functions I need right away revolve around:
• Material cost estimation with editable unit-price tables
• Labour cost estimation tied to crew rates and productivity factors
• Change order log that timestamps and tracks every request through approval, automatically adjusting the running total
• A space for submittals and other project documents so I have everything in one file

Please build this in clean, clearly labeled worksheets, using only native Excel tools (formulas, named ranges, tables, Power Query or PivotTables where helpful—no macros unless you see a compelling reason and clear it with me first). I will also need brief in-sheet notes so anyone on my team can understand how to update rates and add new items.

Once the core workbook is solid, I plan to expand it into full project management—schedule tracking, RFIs, etc.—so logical, modular design is important. If you can deliver a file that meets the above requirements, is easy to audit, and leaves room for future tabs, we’re a perfect fit.