Tender · Free Excel template

IVMS and MDVR tender spec compliance matrix

Send one matrix to every bidder. Each answers 106 requirements and names the page that proves the answer. You read a calculated status, a score and a mandatory gate.

Free: enter your name and email and we send you the file. English and Arabic. Works in Excel, Microsoft 365, Google Sheets and LibreOffice Calc. No macros.
  • 106 requirements in 17 sections
  • Status and score calculated
  • No claim without evidence
tracom-ivms-mdvr-tender-spec-compliance-matrix-en.xlsx
RequirementResponseStatus
Driver IDCompliantAccepted
Seat beltPartialClarify
JammingCompliantEvidence missing
Offline logNon-compliantFail
Example answers only, to show how the Status column reads. They are not from a real bid.
What's inside

What is inside the compliance matrix?

Yellow cells are yours or the bidder's. Everything else is calculated.

  1. 01

    Start here

    Six steps, the meaning of each status and how the score works.

  2. 02

    Matrix

    106 requirements. Required value, your clause, type, response, evidence reference, status and points.

  3. 03

    Summary

    Counts by status and by section, the score and the mandatory gate, with a chart.

  4. 04

    Clarifications

    One line per question to the bidder, with dates and the outcome.

  5. 05

    Worked example

    Thirteen made-up answers that show every status the matrix can give.

  6. 06

    Settings

    Drop-down labels and the scoring weights, all editable.

Coverage

17 sections, from approvals to installation

The number is the count of requirements in each section. Mark each one Mandatory or Optional.

Approvals and registrations5Driver identification5Tamper and power6Speed6Seat belt3Harsh acceleration, braking and cornering6Black box and collision4Emergency button4GNSS and jamming5Night driving, fatigue and continuous driving6In-cab voice alert5Storage, resend and retention6Reports and platform10Hardware, firmware and lifecycle12Video (MDVR, DSM and ADAS)11Privacy and data protection6Installation, support and service6
Logic

How the Status column decides

Type, response and evidence decide the status. Ticking Compliant is not enough: the bidder must name a document and a page.

  • Accepted
  • Needs action
  • Not met
  • Not scored
Status logic
TypeResponseEvidence referenceStatus
MandatoryCompliantGivenAccepted
MandatoryCompliantEmptyEvidence missing
MandatoryPartialAnyClarify
MandatoryNon-compliantAnyFail
OptionalNon-compliantAnyNot met (optional)
AnyN/AAnyN/A
AnyNo answerAnyOpen
Mandatory gate

Three outcomes, whatever the score is

One mandatory row marked Fail closes the gate. The score then only ranks bids that pass.

All mandatory requirements accepted

Every mandatory row is Accepted. Read the score to rank the bids.

65 of 65
Not decided: mandatory items are still open

Some mandatory rows are Open, Clarify or Evidence missing. Send the questions.

58 of 65
Does not pass: a mandatory requirement is not met

At least one mandatory row is Fail. Record the reason in Buyer notes.

1 Fail

Figures are examples to show the three states.

Why compare bids in a matrix?

One bidder answers in a table, another in a letter, a third in a brochure. You end up comparing styles, not devices. A matrix puts every bidder on the same rows.

It also changes what counts as an answer. A claim with no document and no page is not accepted. That one rule removes most of the arguments at the evaluation meeting.

How to use it

  1. Fill the header. Tender number, bidder and date. Keep one copy of the file per bidder.
  2. Adjust the rows. Change the required values, set each row to Mandatory or Optional and add your clause numbers. There are 10 free rows for your own requirements.
  3. Send it to the bidder. The bidder fills Supplier response and Evidence reference.
  4. Read the Status column. It is calculated. Send the questions for every Clarify and Evidence missing row.
  5. Read the Summary. Counts by status and section, the score and the mandatory gate.

How the score works

Every row has a maximum equal to its weight. The answer earns a share of it.

Points = weight x factor Max = weight Score = total points / total maxExample: 22.5 / 34 = 66%Typical defaults: mandatory 3, optional 1. A Compliant answer with evidence scores 1, Partial 0.5, Compliant without evidence 0.5, Non-compliant 0. Open rows count as 0 and N/A rows leave the maximum. Change every value in Settings.

Choosing mandatory rows

Mark a row Mandatory only when a miss should end the bid. If everything is mandatory, no bidder passes and the gate means nothing. Keep the rest Optional and let the score rank them.

Typical values

Some rows carry a typical starting value, such as 10 to 30 V DC or a 120-minute continuous driving alert. They are typical starting points, not verified against IOGP Report 365 or any named standard or tender. Replace them with the values in your own tender.

Source and date checked.

The typical values are not requirements and are not taken from one client standard. Check them against your regulator's text and your client's current IVMS or road safety standard, such as IOGP Report 365, Land transportation safety recommended practice (iogp.org, last checked 2026-11-03). Approval and certificate numbers are left blank for the bidder.

Limits

The matrix records answers and calculates a result. It does not test a device. A datasheet states what a device can do under test conditions, so ask for a trial unit before you award.

Related Tracom solution

Invite Tracom to answer your matrix

Tracom makes the ST100 tracker and the M1N MDVR. If you invite us to bid, we answer row by row with datasheet pages. Where the datasheet does not show it, we say so.

  • Over-the-air updates. Section 14 asks for FOTA. Ask each bidder for the datasheet page.
  • Emergency panic alerts. Section 8 asks about the panic input and the alert path.
  • Driver behavior monitoring with voice alerts. Sections 4, 5, 6 and 11 cover speed, belt, harsh events and in-cab alerts.
  • Second-by-second data. Section 7 asks for the record around a collision.
  • SCMS portal. Section 13 asks about reports, roles and exports.
Questions

Compliance matrix questions, answered

Have a live tender? Talk to Tracom.

Can bidders use it too?

Yes. A bidder can fill it in before submitting, to find rows with no evidence. The buyer then scores the same file.

Does it contain my client's thresholds?

No. Some rows carry typical starting values, not taken from a named standard. Replace them with the values in your tender.

Why does a Compliant answer show Evidence missing?

Because the bidder gave no document and page. The row earns half the points until the evidence arrives. You can change that in Settings.

Can I change the weights and labels?

Yes. Weights, factors and every drop-down label are in Settings, and all sheets follow them.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. It also works in Excel and LibreOffice Calc.

What is Tracom's role here?

Tracom makes tracking and video hardware. The matrix is neutral. It does not say that any supplier or product, Tracom's included, meets a standard or holds an approval.

Next step

Send Tracom your matrix

Have a tender with a closing date? Send the matrix and the date, and we will answer with datasheet references.

Related tools and templates

Keep going on the tender

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top