The six templates
| Template | Who fills it in | Rows | When |
|---|---|---|---|
| Technical deviation list | Manufacturer | Only the clauses where the offer differs | With every technical offer. See the deviation list guide. |
| Compliance matrix | Manufacturer | Every requirement in the specification | When the tender asks for a full clause-by-clause statement. See the compliance matrix guide. |
| TBE matrix | EPC or owner evaluator | Every evaluation criterion, side by side for three bidders | During technical bid evaluation. Manufacturers use it to check how an offer will be scored. |
| Clarifications and deviations cover sheet | Manufacturer | One page, plus the items that need an answer | On top of the deviation list, in both priced and unpriced copies. |
| Vendor document register | Manufacturer (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 evidence | After 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.
