Free templates

Free deviation list, compliance matrix and TBE templates

Spreadsheet templates for manufacturers answering engineered-equipment tenders, and for the evaluators who score them. Free to use under CC BY 4.0.

Last reviewed by the OdysseyGPT team

The short answer

Download four free templates: a technical deviation list, a clause-by-clause compliance matrix, a technical bid evaluation (TBE) matrix, and a cover letter for clarifications and deviations. The spreadsheets come as CSV and XLSX with drop-down status values and two example rows you delete before use.

Key Takeaways

  • Each spreadsheet uses the same status values: Complies, Clarification, Deviation, Not offered.
  • The deviation list carries only exceptions; the compliance matrix carries every clause.
  • Example rows use an invented specification (PS-VAL-001). Delete them before use.
  • If the tender supplies its own form, copy your rows into that form instead.

Download the templates

To open a CSV in Google Sheets, choose File, then Import, then Upload. The XLSX files open in Excel, Google Sheets, LibreOffice and Numbers.

Which template to use

TemplateWho fills it inRowsWhen
Technical deviation listManufacturerOnly the clauses where the offer differsWith every technical offer. See the deviation list guide.
Compliance matrixManufacturerEvery clause in the specificationWhen the tender asks for a full clause-by-clause statement. See compliance matrix guide.
TBE matrixEPC or owner evaluatorEvery evaluation criterion, side by side for each bidderDuring technical bid evaluation.
Cover letterManufacturerOne pageOn top of the deviation list, in both priced and unpriced copies.

Columns in the deviation list template

ColumnFill in
ItemRunning number. Refer to it in the cover letter.
Spec clauseDocument number, revision and clause.
RequirementThe requirement in short, with the key value.
OfferedWhat you offer, in the same terms.
StatusComplies, Clarification, Deviation or Not offered (drop-down).
Deviation / clarificationThe difference, stated once.
JustificationThe technical reason the offer is acceptable.
Cost of withdrawalPrice and lead-time change if you must comply instead.
Evidence referenceDatasheet, certificate or report, with page.
Buyer responseLeft blank for the buyer: accepted, rejected or query.

Use the templates with OdysseyGPT

The templates work on their own. If you would rather start from a draft, OdysseyGPT checks each customer requirement against your own datasheets, gives it a status with a quote from the source page, sheet or cell, and exports an editable compliance matrix and deviations & clarifications list. A bid engineer, proposal engineer or project manager then decides every open item and adds the justification and cost of withdrawal. See OdysseyGPT for manufacturing.

Frequently asked questions

Are these templates free to use commercially?

Yes. They are published under the Creative Commons Attribution 4.0 licence, so you can use and adapt them, including in paid bids, as long as you keep the attribution.

Is there a technical bid evaluation template in Excel?

Yes. The TBE matrix template is an XLSX file that compares three bidders side by side against each evaluation criterion, with status drop-downs and columns for weight and score.

What is the difference between the deviation list and the compliance matrix templates?

The compliance matrix has a row for every clause in the specification. The deviation list carries only the rows where the offer does not fully comply.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages