Project Estimation Template

A clean spreadsheet for early-stage cost estimates with formulas wired in. Built for small-to-mid-size contracting jobs.

Description

A practical, no-frills cost estimation template. The columns and formulas are set up for a typical regional contracting estimate — direct costs, indirect costs, contingency, profit, and a clean total at the bottom.

What's in it

  • Direct costs — materials, labour, plant, subcontracts.
  • Indirect costs — site overhead, mobilisation, supervision, insurance, bonds.
  • Risk and contingency — separate row, with a note on when to bump it up.
  • Profit margin — calculated as a percentage of total cost, easy to flex.
  • Cashflow checkpoints — milestones where billings and costs should match up.

It's deliberately simple. There's nothing fancy, no macros, no plug-ins. Open it in Excel, Google Sheets, or LibreOffice and start filling in numbers.

What it isn't

  • Not a substitute for proper cost engineering on large projects.
  • Not a BOQ tool — it's for the high-level estimate that goes to the owner-manager, not a line-by-line takeoff.
  • Not connected to any AI service. Numbers stay on your machine unless you choose to share them.

Who it's for

Estimators and PMs producing first-pass cost estimates for residential or small commercial projects in the GCC and Egypt.

How to use

  1. Download the CSV and open it in your preferred spreadsheet tool.
  2. Replace the example values in column B with your project's actual numbers.
  3. Adjust the contingency percentage based on the risk profile of the project.
  4. Use the cashflow checkpoint rows to track that your billings keep up with costs as the project runs.
  5. Save a copy per project. Don't reuse the same workbook across jobs — version drift will get you eventually.

If you want to use AI to sanity-check a finished estimate, see prompt #7 in the Contracting Prompt Pack.

Data and security

The template is a simple CSV file. It contains no telemetry, no scripts, and no external connections. Once you download it, the data lives wherever you save it — usually your laptop or your firm's drive.

If you upload the filled-in template to any AI tool for review, treat the data inside as you would any internal cost document: redact client names, anonymise project IDs, and check that your tool's data handling matches your firm's policy.