Tender · Free Excel template

Device spec comparison matrix

Two datasheets never use the same words. Put two to four trackers or MDVRs in one grid, set your requirement for each row and let the sheet say Meets, Below or No data. Then read which device meets every must-have.

Free: enter your name and email and we send you the file. English and Arabic. The vendor columns are blank on purpose. Works in Excel, Google Sheets and LibreOffice Calc.
  • 53 specification rows
  • A check per device and row
  • Must-have verdict
How it reads

Three imaginary devices on the same rows

These devices and figures are made up to show the checks. The real file has no products in it.

Meets all must-haves

Device A (example)

Lowest supply voltage (must-have, 10 V or less)
9 V Meets
Highest supply voltage (must-have, 30 V or more)
36 V Meets
Backup battery (500 mAh or more)
800 mAh Meets
Ingress protection (IP67 or better)
IP67 Meets
Over-the-air updates (must-have, Yes)
Yes Meets
Strongest on the checks and not the cheapest.
Misses a must-have

Device B (example)

Lowest supply voltage (must-have, 10 V or less)
12 V Above
Highest supply voltage (must-have, 30 V or more)
30 V Meets
Backup battery (500 mAh or more)
450 mAh Below
Ingress protection (IP67 or better)
IP65 Below
Over-the-air updates (must-have, Yes)
Yes Meets
Lowest cost, but it fails a must-have.
Misses a must-have

Device C (example)

Lowest supply voltage (must-have, 10 V or less)
10 V Meets
Highest supply voltage (must-have, 30 V or more)
28 V Below
Backup battery (500 mAh or more)
600 mAh Meets
Ingress protection (IP67 or better)
IP67 Meets
Over-the-air updates (must-have, Yes)
No data
One must-have missed and one has no data.

Made-up figures. Not real products and not a benchmark.

Rows

53 specification rows in 11 groups

Every row has a unit or a hint on how to read it, a rule and a Must-have flag. Add your own rows if you need them.

Row groups in the Compare sheet
GroupRowsFirst rows
Device identity5Supplier · Model name · Hardware and firmware version
Connectivity5Cellular technology · Fallback to 2G or 3G · Cellular bands supported
Positioning (GNSS)5Satellite systems · Receiver sensitivity · Position accuracy, open sky
Memory and storage2Internal memory · Records stored when there is no coverage
Power5Lowest supply voltage · Highest supply voltage · Backup battery capacity
Inputs, outputs and sensors8Digital inputs · Digital outputs · Analog inputs
Environment3Ingress protection (the number after IP) · Lowest operating temperature · Highest operating temperature
Software and updates5Firmware updates over the air (FOTA) · Configuration by SMS command · Rules and alerts run on the device with no network
Video (MDVR only)8Camera channels · Highest resolution per channel · Storage medium
Certificates and approvals3Certificates shown in the supplier's documents · Certificate numbers and expiry dates · Holds the approval your tender requires
Warranty and supply4Warranty · Supply commitment for this model · Delivery lead time
Rules

Four rules decide every check

Pick the rule per row. The check columns then read Meets, Below, Above, Differs, Check value or No data.

  1. Rule ≥

    The device value must be at least your requirement. Memory, battery, channels, warranty.

  2. Rule ≤

    The device value must be at most your requirement. Lowest voltage, lowest temperature, sensitivity in dBm, lead time.

  3. Rule =

    The device must say the same thing. Yes or No rows and text you type exactly.

  4. Rule Info

    No check. Use it to store text such as the supplier name or the bands.

  • Meets
  • Below
  • Above
  • Differs
  • Check value
  • No data

Why put every device in one grid?

One datasheet quotes sensitivity in dBm, another talks about a cold-start time, a third leaves the backup battery out. Side by side on the same rows, the gaps show up. A blank cell is an answer too: it means the supplier did not say.

How to use it

  1. Name the devices. Fill Supplier and Model name. A column counts only after its model name is entered.
  2. Set your requirement. Type it, choose the rule, and mark the rows that are must-haves.
  3. Copy the supplier figures. From the datasheet or the quote, with the document and page in Source.
  4. Read the Result sheet. Share of requirements met and the verdict on the must-haves.

Certificates and approvals

Copy only what the supplier's documents show, with the number and expiry date. Ask the issuing body or your regulator to confirm it if your tender requires. The file does not state that any device holds an approval.

Blank by design.

The file holds no competitor product and no Tracom figures. Every number comes from the documents you hold, so you can defend each one.

Limits

A datasheet states what a device can do under test conditions. The matrix compares claims. It does not test a device, so ask for a trial unit before you decide.

Related Tracom solution

Put a Tracom device in the grid

Ask Tracom for the datasheet of the ST100 tracker or the M1N MDVR and fill its column like any other. We answer the rows the datasheet covers and tell you which ones it does not.

  • Trial unit. Test the rows that matter on your own vehicle before you decide.
  • Over-the-air updates. The Software group has a FOTA row. Ask every supplier the same question.
  • No internet? No problem. The row about rules running without a network is there for this.
  • Second-by-second data. Ask each supplier how the record around an event is kept.
Questions

Comparison matrix questions, answered

Comparing quotes now? Talk to Tracom.

Does the file include real products?

No. The device columns are empty. The worked example uses three imaginary devices with made-up figures.

How many devices can I compare?

Two to four. A column counts only after you enter its model name.

What does the Rule column do?

It tells the sheet how to compare: at least your value, at most your value, or the same. Info rows are not checked.

Does the matrix compare prices?

No. It compares what the datasheets say. Put the prices side by side in a quote comparison, after you know which devices meet your must-haves.

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 and compares what suppliers state. It does not say that any product, Tracom's included, meets a standard or holds an approval.

Next step

Want the Tracom column filled in?

Send us the rows that matter for your tender. We will answer from the datasheet and say where it is silent.

Related tools and templates

Keep going on the comparison

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