Build a cost estimate basis in Excel from quantities

Quantities become useful only when you can price them. Yesper structures quantities into a cost estimate basis in Excel with unit price columns, formulas and totals. Most valuable in the estimating and tender stage.

How to do it in Yesper

  1. Add or paste in the quantities.
  2. Ask Yesper to create an Excel estimate with unit price and total columns.
  3. Fill in the unit prices – the formulas calculate automatically.
  4. Review in Yesper and download the file if needed.

Settings & tips

  • Ask for subtotals per building part or AMA code.
  • Ask for formulas for markups and indexation.

Example prompts

Simple

Make a cost estimate basis in Excel from our quantities.

Advanced

Create a cost estimate basis in Excel from the bill of quantities in Secure folders with columns for unit price and total, subtotals per building part and AMA code, and rows for markups and indexation.

FAQ

Do I get formulas or just values?

Formulas, so the estimate recalculates when prices change.

Can I group per AMA code?

Yes, state the grouping.

Does it start from a bill of quantities?

Yes, add it.