ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / Bid Evaluation Matrix
Free Excel template

Bid Evaluation Matrix

Free Excel bid evaluation matrix for tenders and RFPs: weighted price, technical value and lead time, price score relative to the lowest bid, technical pass mark, ranking and recommended award.

Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

Get the template by e-mail, and its updates.

Keep the six files of « Bid Evaluation Matrix » in your inbox, to find or share them later. The direct download stays free, no sign-up.

  • The France, Québec and Africa versions, in French and English.
  • If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
  • Your details are never sold, one-click unsubscribe.
Contents

What the workbook contains.

Bids

Eligibility, price, lead-time and technical scores, final score, rank, recommendation

Technical scoring

Points per sub-criterion, capped, scaled to 100

Summary

Recommended bid, gap with the lowest bid, rationale, signatures

Settings

Weights with a 100% check, technical pass mark, sub-criteria

Instructions

Get started in 3 minutes, cells protected without password

Print

Summary as a one-page record, grids in landscape

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, set the price, technical and lead-time weights (100% in total), the minimum technical score and the sub-criteria.

  2. 02

    In the Bids sheet, enter each bidder: net amount, lead time in days, compliant file or not.

  3. 03

    In the Technical scoring sheet, score each sub-criterion; the score is scaled to 100.

  4. 04

    Non-compliant or below-minimum bids are excluded, the others ranked. The Summary gives the recommended award, to justify and have signed.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
The most common method compares each bid with the lowest: price score = lowest price / bid price x 100. The cheapest bid gets 100, a bid 20% more expensive about 83. Lead time is scored the same way, and the final score weights price, technical value and lead time.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.