Build a tender estimate in Excel

A tender estimate needs items, unit prices, markups and totals that add up correctly. Yesper sets up the estimate in Excel with ready-made formulas – ready to fill with your prices. Most valuable in the tendering stage.

How to do it in Yesper

  1. State or add the estimate items.
  2. Ask Yesper to build a tender estimate in Excel.
  3. Fill in the unit prices – totals and markups are calculated automatically.
  4. Review in Yesper and download the file if needed.

Settings & tips

  • Ask for separate rows for subcontractors, materials, machinery and own hours.
  • Ask for rows for risk and markups.

Example prompts

Simple

Build a tender estimate in Excel for groundworks.

Advanced

Build a tender estimate in Excel based on the bill of quantities in Secure folders with items for excavation, fill, sub-base, water and sewer and reinstatement, subtotals per building part and rows for risk and markups.

FAQ

Does the file calculate automatically?

Yes, with built-in formulas.

Can I start from a bill of quantities?

Yes, add it.

Can I split by resource type?

Yes, state the breakdown.