OdysseyGPT

Free template

Bid tabulation template for engineered equipment (Excel and CSV)

Three supplier offers side by side against one RFQ: what each bidder offers on every line, its compliance status and price, and a levelling note so the totals compare like for like.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A bid tabulation puts every bidder's answer to the same requirement in one row, so offers compare like for like. This free Excel template has offered, compliance and price columns for three bidders, a levelling note for scope differences, and totals as quoted and as levelled. The example tabulates an invented valve RFQ.

Key Takeaways

  • Compare every bidder against the RFQ line, not against another bidder.
  • Level a row only with a figure you can point to, such as the bidder's own option price. Otherwise ask.
  • Keep the total as quoted and the levelled total, so the approver sees what was adjusted.
  • The example has 14 rows for an invented valve package (RFQ-EX-3105) and three invented bidders.

Download the bid tabulation template

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX.

What it is for and who uses it

Offers for engineered equipment rarely cover the same scope. One bidder leaves out a line, another prices documents separately, a third offers a different certificate type. A bid tabulation shows those differences row by row before anyone compares totals. For the method, see the bid tabulation guide.

  • Procurement and package engineers at EPC contractors and end users, who build the tabulation and recommend an award.
  • Manufacturers buying castings, forgings, actuators or instruments from their own suppliers.
  • Bid engineers at equipment makers, who use it to see how their offer will be levelled against competitors.

The tabulation sits next to the technical bid evaluation (TBE). The TBE decides which offers are technically acceptable. The tabulation levels scope, price and terms across them.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Gas Compression Station, Phase 2 (fictional)
BuyerExample EPC Contractor Ltd (fictional)
RFQ no.RFQ-EX-3105 Rev 0 (fictional)
Material requisitionMR-VAL-001 Rev 1
Governing specificationPS-VAL-001 Rev 2
Bid tabulation no.BT-EX-3105
RevisionA
Date2026-10-06
CurrencyUSD
Delivery terms (Incoterms) and placeFCA supplier works
Bidder AExample Bidder A (fictional), offer dated 2026-09-28
Bidder BExample Bidder B (fictional), offer dated 2026-09-29
Bidder CExample Bidder C (fictional), offer dated 2026-09-25
Prepared byProcurement lead
Checked byPackage engineer

Example rows: three offers for valve package RFQ-EX-3105

Invented example rows; each bidder cell shows offered, compliance and price (some columns omitted)
ItemRequirement lineBidder ABidder BBidder CLevelling noteStatus
1Ball valve, trunnion-mounted, 6 in, ASME Class 600, RF flanged, gear operated; PEEK seatsFigure A-TB-600; PEEK seats (Complies): 81000Figure TB-600-6; RPTFE seats (Deviation): 74400Figure C-T6-600; PEEK seats (Complies): 86700No price adjustment. If the RPTFE seats are not accepted, Bidder B to confirm its PEEK option: no price change, 2 weeks longer.Clarify
2Ball valve, floating, 2 in, ASME Class 600, RF flanged, lever operatedFigure A-FB-600 (Complies): 9200Figure FB-600-2 (Complies): 8600Figure C-F2-600 (Complies): 9900None.Like for like
3Gate valve, 8 in, ASME Class 300, RF flanged, handwheelFigure A-GV-300 (Complies): 14800Figure GV-300-8 (Clarification): 13900Figure C-G8-300 (Complies): 15600None until Bidder B confirms the impact test temperature.Clarify
4Check valve, dual plate, 6 in, ASME Class 600, waferFigure A-DC-600 (Complies): 6100Not offeredFigure C-D6-600 (Complies): 6500Bidder B does not make this valve. Add 6500 to Bidder B (the highest price offered by the others) or buy the line separately.Not comparable
5Commissioning sparesSeat and seal kits per tag (Complies): 2600Seat and seal kits per tag (Complies): 2300Seat and seal kits per tag (Complies): 2900None.Like for like
6Documentation to the VDRL, including the final data bookPer VDRL (Complies): IncludedPer VDRL; data book electronic only (Clarification): IncludedPer VDRL (Complies): 4000None. Bidder C prices documents as a separate line; the others include them.Like for like
7EN 10204 type 3.2 certificates for pressure-containing partsType 3.2 (Complies): IncludedType 3.1; type 3.2 as a priced option (Deviation): Not includedType 3.2 (Complies): IncludedAdd 3000 to Bidder B: its own option price for type 3.2 certificates. Inspector fees by the buyer in all three offers.Levelled
8Pressure tests witnessed by the buyerIncluded; 10 working days' notice (Complies): IncludedIncluded; 10 working days' notice (Complies): IncludedIncluded; 5 working days' notice (Clarification): IncludedNone. Ask Bidder C to confirm the notice period the RFQ asks for.Clarify
9Delivery, FCA supplier works: 24 weeks or better24 weeks (Complies)26 weeks (Deviation)22 weeks (Complies)No price adjustment. Bidder B is 2 weeks late against the required date.Clarify
10Quotation validity: 90 days90 days (Complies)60 days (Deviation)90 days (Complies)Ask Bidder B to extend validity to 90 days.Clarify
11Payment terms as the RFQ conditionsAccepted (Complies)30% advance payment requested (Deviation)Accepted (Complies)Not priced here. Finance to say whether an advance payment is acceptable and at what cost.Clarify
12Warranty period as the RFQ conditionsAccepted (Complies)Accepted (Complies)Accepted (Complies)None.Like for like
Total as quoted11370099200125600Before levelling. Bidder B's total leaves out line 4 and the type 3.2 certificates.Not comparable
Levelled total113700108700125600Bidder B: plus 6500 (line 4) and 3000 (line 7). Open clarifications are not priced.Levelled

In the file, each bidder has separate offered, compliance and price columns. It also has Section, RFQ reference, Qty and Remarks columns. Bidder B looks cheapest as quoted, but it left out line 4 and priced type 3.1 certificates, so two adjustments are added before the totals are compared. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Columns and what to write

ColumnWhat to write
ItemLine number. Keep RFQ line numbers for the RFQ lines, then add rows for scope and commercial terms.
SectionTechnical, Scope or Commercial (drop-down).
Requirement lineWhat every bidder was asked to offer, in one line. This is the baseline all three are compared against.
RFQ referenceThe RFQ line, requisition section or specification clause the row comes from.
QtyQuantity and unit, where the row is priced.
Bidder A / B / C: offeredWhat the bidder offers against the line: model, material, term or value, from its offer and deviation list.
Bidder A / B / C: complianceComplies, Clarification, Deviation, Not offered or Not applicable (drop-down), as the technical evaluation found it.
Bidder A / B / C: priceExtended price for the line in the tabulation currency, or Included or Not included. Leave blank on rows that carry no price.
Levelling noteWhat you add, remove or ask so the three offers cover the same scope, and where the figure comes from.
StatusLike for like, Levelled, Clarify or Not comparable (drop-down). Not comparable rows turn red; Clarify rows amber.
RemarksClarification numbers, or anything the approver needs to know.

Row status values

StatusMeaning
Like for likeAll bidders offer the same scope on this row. The prices compare as they stand.
LevelledOne or more offers differed, and you have added or removed a stated amount so the row compares fairly.
ClarifyYou cannot compare the row until a bidder answers a question. Raise the clarification and note its number.
Not comparableA bidder left the row out or offered something different, and no fair adjustment is agreed yet.

How to use the template

  1. Fill in the header block: RFQ number and revision, requisition, governing specification, currency, delivery terms and the three bidders with their offer dates.
  2. Add one row per RFQ line, keeping the RFQ line numbers. Then add rows for scope items the offers treat differently (spares, documents, certificates, witnessed tests) and for the commercial terms.
  3. Write the requirement line once, as the RFQ states it. Every bidder is compared against that baseline, not against another bidder.
  4. For each bidder, enter what is offered, the compliance status from the technical evaluation and the extended price. Write Included or Not included where there is no separate price.
  5. Where offers differ in scope, write a levelling note: the amount you add or remove and where it comes from, such as the bidder's own option price. Do not level a row on a guess; set it to Clarify and ask.
  6. Set the status of each row. Not comparable rows turn red and Clarify rows amber.
  7. Add a Total as quoted row and a Levelled total row under the table. Keep both, so the approver sees what was adjusted.
  8. Close every Clarify row in writing before you recommend an award, and file the answers with the tabulation.

Before and after the tabulation

  • Issue the enquiry with the RFQ template. Its supplier columns come back in the same order as the tabulation rows.
  • Score technical acceptability with the technical bid evaluation (TBE) template, then carry each compliance status into the tabulation.
  • In OdysseyGPT's Tender & Quotation module, Technical Bid Evaluation (beta) compares supplier offers against one requirement baseline, with each finding cited to its page. Tools marked beta are open on request, and we onboard each team ourselves.

See how OdysseyGPT reviews a tender

Tell us how your team reviews tenders today. We can walk through an example together.

Book a call

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is a bid tabulation?

A side-by-side table of every bidder's answer to the same requirements. Each requirement, scope item or commercial term is a row and each bidder is a set of columns, so differences in scope, price and terms are visible before the totals are compared.

Is there a free bid tabulation template in Excel?

Yes. This XLSX template has a blank tabulation for three bidders, a filled-in example for an invented valve package and a How to use sheet. A CSV of the same columns is also free under CC BY 4.0.

What does levelling a bid mean?

Adjusting the offers so they cover the same scope. If one bidder left out an item the others priced, you add a stated amount for it, or ask the bidder to quote it, before comparing totals. Record where each adjustment comes from.

What is the difference between a bid tabulation and a technical bid evaluation?

A technical bid evaluation decides whether each offer is technically acceptable against the specification. A bid tabulation compares the acceptable offers on scope, price, delivery and terms. Practice varies by company, and some combine the two in one workbook.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages