OdysseyGPT

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, with no sign-up.

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

The short answer

Download six free templates. Four are for the bid: a technical deviation list, a compliance matrix, a technical bid evaluation (TBE) matrix and a deviations cover sheet. Two are for after award: a vendor document register and a requirements traceability matrix (RTM). Each comes as XLSX and CSV, with drop-downs and a filled-in example.

Key Takeaways

  • The templates share one set of status values: Complies, Clarification, Deviation, Not offered and Not applicable.
  • The deviation list carries only exceptions; the compliance matrix carries every clause.
  • Example rows use an invented specification (PS-VAL-001) and sit on their own sheet, apart from the blank one you fill in.
  • If the tender supplies its own form, copy your rows into that form instead.

The six templates

TemplateWho fills it inRowsWhen
Technical deviation listManufacturerOnly the clauses where the offer differsWith every technical offer. See the deviation list guide.
Compliance matrixManufacturerEvery requirement in the specificationWhen the tender asks for a full clause-by-clause statement. See the compliance matrix guide.
TBE matrixEPC or owner evaluatorEvery evaluation criterion, side by side for three biddersDuring technical bid evaluation. Manufacturers use it to check how an offer will be scored.
Clarifications and deviations cover sheetManufacturerOne page, plus the items that need an answerOn top of the deviation list, in both priced and unpriced copies.
Vendor document registerManufacturer (document controller or project manager)One per document on the customer's vendor data requirements list (VDRL)After award, until the final data book. See the manufacturing record book guide.
Requirements traceability matrix (RTM)Manufacturer (project or quality engineer)One per requirement, linked to design, verification and evidenceAfter award, when the contract asks you to prove each requirement was met.

Each template page shows the example rows, explains every column and gives the steps to fill it in.

Download the templates

XLSX

Technical deviation list

Spec clause, verbatim requirement, offered, status, alternative, justification, impact, cost of withdrawal and customer response.

CSV

Technical deviation list

The same columns as plain CSV, for Google Sheets or any tool.

XLSX

Clause-by-clause compliance matrix

One row per requirement, with type, offered value, status, evidence and deviation list item.

CSV

Clause-by-clause compliance matrix

The same columns as plain CSV.

XLSX

TBE matrix (three bidders)

Evaluator-side matrix: criterion, mandatory flag, weight, and response, compliance, score and comments per bidder, with a calculated summary.

CSV

TBE matrix (three bidders)

The same columns as plain CSV.

XLSX

Clarifications and deviations cover sheet

Documents reviewed, calculated counts and the items that need the customer's answer.

CSV

Clarifications and deviations cover sheet

The items table as plain CSV.

DOCX

Clarifications and deviations cover letter

The same content as a one-page letter, for buyers who want a letter.

Markdown

Clarifications and deviations cover letter

The same letter as plain text.

XLSX

Vendor document register

Post-award register: VDRL code, document, purpose, due date, revision, transmittal, review code, status, next action and data book section.

CSV

Vendor document register

The same columns as plain CSV.

XLSX

Requirements traceability matrix (RTM)

Requirement ID, source clause, agreed deviation, design reference, verification method and reference, evidence and status.

CSV

Requirements traceability matrix (RTM)

The same columns as plain CSV.

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

What is in each spreadsheet

  • A blank working sheet with a header block for project, customer, RFQ number, revision and who prepared and checked it.
  • A filled-in example sheet for an invented 6-inch Class 600 trunnion ball valve specification (PS-VAL-001), or the invented order placed against it (PO-EX-3105). Delete it before you send the file.
  • A How to use sheet with the steps, the status values and what to write in each column.
  • Drop-downs for status and other fixed values, colour-coded Deviation and Clarification rows, a frozen header row, filters and print settings.

The CSV files carry the example rows only. Every example value is invented; standards such as API 6D and ISO 15848-1 are named but not quoted.

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, or try the free spec requirement extractor on a few pages of specification text.

Want OdysseyGPT to fill these in from your tender package?

Bring one of your own past tenders to a demo. Managed plans start from $999/month.

Request a demo

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 drop-downs, weights, scores and a calculated summary.

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

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

Do I have to sign up to download?

No. Every file downloads directly from this page and from each template's page.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages