Free tender levelling template (Excel)
Download the free Excel template below. Put the pricing schedule down the left, enter each supplier's rates, and it works out values, subtotals and the grand total, checks it against the stated tender sum, then adds the adjustments to give a levelled total and a ranking.
What's in the template
- Pricing schedule and estimate
- Ref, description, quantity and unit in sections, each with a subtotal, and a grand total. Add pre-tender estimate rates to compare against. Yellow cells are for filling in; the rest are formulas.
- A block per supplier
- Qty, unit, rate and value, with value worked out as quantity × rate.
- Highlights
- Red where a supplier's unit differs from the pricing schedule, yellow where an item isn't priced, and green on the lowest price for each item.
- Tender sum check
- The tender sum stated on the form of tender against the grand total of the lines, and the difference between them.
- Itemised adjustments
- One row per adjustment (omitted items, changed quantities, items not asked for, qualifications) with spare rows for more.
- Levelled totals
- Each tender sum plus its adjustments, ranked, with the gap to the lowest in pounds and per cent, and each against the estimate.
The worked example
The template opens with a small tender, preliminaries, substructure, electrical services and provisional sums, priced by three suppliers, so each formula can be seen working before the example is cleared.
- Supplier C has the lowest tender sum by about £45,000, but leaves the lighting unpriced. Added at the average of the other two returns, it drops to third.
- Supplier B priced 380 m² of formwork against a scheduled quantity of 420 m². The difference is re-rated at their own rate.
- Supplier A priced small power per nr instead of per point, which is highlighted red to check.
- Supplier B's stated tender sum is £1,000 more than its lines add up to, which the difference row shows, and B excludes dewatering, priced as a qualification.
How to use it
- Replace the example items with the real pricing schedule, at the revision issued.
- Rename the suppliers and enter each return's quantity, unit and rate on every item. Leave an item empty where it isn't priced, and add a note.
- Add rows or sections by copying existing ones, then check each subtotal's SUM covers them.
- Enter each tender sum as written on the form of tender and look at the difference row.
- Fill in the adjustments, with a note for each, and compare the levelled totals.
- Keep the notes up to date. They become the working for the tender analysis report.
Where a spreadsheet falls short
The template does the sums, but someone still has to type every return onto the pricing schedule. Suppliers renumber items, split and merge them, price their own quantities and send PDFs. On a large package that retyping is most of the time, and every revised return means doing it again.
Skip the typing with TenderNorm
The top half of the template is a real TenderNorm Excel export of the example. TenderNorm reads each return in the supplier's own Excel or PDF format, places every price on the pricing schedule, checks the sums and flags omitted items and changed quantities, with each price linked to its line in the supplier's document. Exported to Excel, it is the same sheet, already filled in, ready for the adjustments.
Questions
- Is the template free?
- Yes. Download it, use it on any number of tenders, and change it freely. No sign-up needed.
- Does it work in Google Sheets?
- Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas carry over.
- Can more suppliers be added?
- Yes. Copy a supplier's three columns to the right, then extend the summary and rank formulas to include them.