Tender · Free Excel template

GPS tracker and MDVR tender clarification log and deviation schedule

Keep every question you send to the buyer of a tracker or MDVR tender, and every place your offer differs from it, in one file. See which questions need a chase and which rows still need evidence.

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.
  • 26 starter questions
  • Reply chase date calculated
  • Legal-review note inside
tracom-tender-clarification-log-deviation-schedule-en.xlsx
ClauseQuestionStatus
3.2SIM cards: who supplies them?Waiting for reply
5.4Equivalent devices allowed?Answered
6.1Where is data hosted?Chase now
ClauseResponseStatus
4.1Meets with deviationDeviation stated
4.2MeetsEvidence missing
6.3Needs clarificationAwaiting reply
Example rows only, to show how the Status column reads. They are not from a real tender.
What's inside

What is inside the file?

Yellow cells are yours. Gray cells are calculated.

  1. 01

    Start here

    Seven steps, the color key and the legal-review note.

  2. 02

    Tender details

    Tender, buyer, bidder, deadlines and the report date the log reads.

  3. 03

    Clarification log

    One row per question, with the assumption you will make if nobody answers, dates and the reply.

  4. 04

    Deviation schedule

    One row per requirement: response, what differs, what you offer instead, impact and evidence.

  5. 05

    Summary

    Counts by status and by topic, and a one-line result. Nothing to type.

  6. 06

    Question bank

    26 starting questions in 10 topics, each with the reason it matters.

  7. 07

    Settings

    Drop-down labels and the number of days before you chase, all editable.

Logic

How the Status column decides

Response, evidence and the buyer's decision set the status. Saying "Meets" is not enough: the row needs a document and a page.

  • Nothing to fix
  • Needs action
  • Does not meet or rejected
Status logic of the Deviation schedule
ResponseConditionStatus
MeetsEvidence givenOK
MeetsNo evidenceEvidence missing
Meets with deviationDeviation and offer writtenDeviation stated
Meets with deviationDeviation or offer emptyComplete the deviation
Does not meetAnyNon-compliance declared
Needs clarificationNo clarification numberLink a clarification
Needs clarificationClarification number givenAwaiting reply
AnyBuyer decision: acceptedAccepted by buyer
AnyBuyer decision: rejectedRejected by buyer
Question bank

26 starting questions in 10 topics

The number is how many questions each topic has. They are general. Ask only what your tender leaves open.

SIM and connectivity3Platform and data3Integration3Installation and access3Acceptance and testing2Support and warranty3Delivery and schedule1Documents and evidence2Alternatives and deviations3Contract terms3

Why keep a clarification log?

Bidders often send questions by email, get answers in an addendum, and later cannot show what they assumed. A log puts the question, the date, the answer and your assumption in one row.

It also makes the deviation schedule honest. Each deviation can point to the question that led to it.

What should you ask the buyer?

Ask about what the tender leaves open, and about anything that changes the price of delivery or the scope of the work. The Question bank gives a start.

  • Who supplies the SIM cards, the static IP and the data plan.
  • Where the platform and the data are hosted, and who owns the data afterwards.
  • Whether an equivalent product is allowed, and in which form a deviation must be written.

How does the chase date work?

Enter the date you sent a question. The file adds the number of days in Settings (5 is a typical start) to give the Chase on date. When the report date in Tender details reaches that date and there is no reply, the status turns to Chase now.

Chase on = Date sent + days to waitExample: 2 Nov + 5 days = 7 NovTypical start: 5 days. Change it in Settings. The file never checks the buyer's own deadline for questions, so read it in the tender.

How should you write a deviation?

A deviation is a place where your offer differs from the written requirement. Write it so the buyer can decide without calling you.

  1. Copy the requirement as written, with its clause number.
  2. State what differs in one plain sentence.
  3. State what you offer instead and the effect on the buyer.
  4. Name the document and the page that shows it.

When are deviations refused?

Some tenders reject deviations.

A tender may disqualify a bid that deviates from a mandatory clause, or accept only its own deviation form, or ask for deviations to be listed without prices. Ask first, using the Question bank, and follow the answer. Do not assume that a deviation is allowed.

Limits

  • The file keeps records and counts rows. It does not decide whether a bid is compliant, and it is not an approval of any product or supplier.
  • The questions are general and are not taken from one tender. Check each against yours.
  • The chase date uses the report date you type. It does not read your computer clock.
  • The file has no prices and no margins. Keep prices in your own pricing sheet.
Related Tracom solution

Answer the tender with a device maker beside you

If your tender asks about tracking, video or driver monitoring, Tracom can help you answer with datasheet pages. Where the datasheet does not show it, we say so.

  • Over-the-air updates. Bring new firmware to devices in the field.
  • SCMS portal. Manage device settings and configuration files in one place.
  • Second-by-second data. Records how the vehicle moves in fine detail.
  • No internet? No problem. The device keeps deciding on the vehicle without a connection.
Questions

Clarification log questions, answered

Have a live tender? Talk to Tracom.

Can I send the file to the buyer?

Only if the tender allows it. Most tenders have their own form or portal for questions and for deviations. Use this file to prepare, then copy the text into the buyer's form.

Why are the example rows not counted?

They are gray, above the first input row, and sit outside the ranges the Summary reads. Overwrite or delete them.

How do I change the labels or the chase days?

Open the Settings sheet. Every drop-down label and the number of days are there, and all sheets follow them.

Should every deviation be priced?

This file holds no prices. Some tenders ask for unpriced deviations, others for priced ones. Ask the buyer, and keep prices in your own sheet.

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 file is neutral and is not legal advice. It does not say that any supplier or product, Tracom's included, meets a tender or holds an approval.

Next step

Send Tracom your tender questions

Have a tender with a closing date? Send the clauses and the date, and we will reply 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