SPLITGLASS · Morocco public tenders

Free BPU, DQE and BPDE Excel template for public tenders in Morocco

If your tender file provides its own model of the price schedule (BPU, DQE or BPDE, in Excel or Word), that is the model to submit. This free Excel workbook is for calculating and checking, above all when the schedule only exists as a PDF or a scan: copy the lines of the file's model exactly (paste them if the model can be copied; from a scan, retype them word for word and proofread), enter your prices, then transfer them into the file's model. Any difference in wording, unit or quantity leads to the bidder's exclusion (decree no. 2-22-431, art. 43-I-2).

Up to 1,000 price lines, chapter headings and subtotals, a framework-contract sheet, totals excluding VAT, VAT and including VAT, the amount in words (in French) and line-by-line checks. No registration and no macro.

The workbook and its download page exist in French and Arabic only: this English page describes the workbook, and the links to them in its text are marked (French) or (French and Arabic).

Updated Free · no registration

Download the workbook

Direct download: no form, no email address, no registration. The workbook and its labels are in French and Arabic.

File:
modele-bpu-dqe-bpde-maroc.xlsx
Size:
509 KB

Workbook page (French) · Workbook page (Arabic)

Download the Excel workbook (509 KB)

What you get, for free

  • Ten linked sheets: instructions, parameters, BPU, DQE, BPDE, framework-contract DQE, price breakdown, checks, line details, and a hidden sheet that writes the amounts in words.
  • A thousand lines per sheet, chapter headings, subtotals, VAT, totals excluding and including VAT.
  • The amount in words, in French, calculated by formula.
  • Automatic checks: missing price, price with more than two decimals flagged in red, duplicate numbers, an overwritten formula that distorts a total.
  • A framework-contract sheet with minimum and maximum quantities (art. 7-1).
  • In French and Arabic, without macros, with sheets protected against formula errors.
  • Tested in Microsoft Excel for Windows and recalculated in LibreOffice; verified by control calculations and independent checks before publication.

Several days of design and checking, given for free.

What the file is, in short

A free Excel workbook of ten sheets (the sheet names are in French). The yellow cells are the ones you fill in; the calculated cells are protected against accidental edits, without a password. In the BPU you copy the wording and the units of the file's model exactly and enter your prices; in the DQE you enter only the quantities.

The dark tabs (BPU, DQE, BPDE, framework-contract DQE) are the sheets to submit only when the file does not provide an editable model of its own; otherwise, submit the file's model. They are set up for printing on A4.

Limits

  • It is a generic model: it does not replace the model of your tender file, the CPS, the consultation rules or legal advice.
  • The checks find input and arithmetic errors; they do not guarantee that an offer is compliant. They cannot detect a price that is wrong but well formed.
  • Capacity: 1,000 price lines per sheet; one workbook per lot. Not covered: labour detail for guarding and cleaning contracts, tenders at a discount or mark-up, columns in foreign currency.
  • Tested in Microsoft Excel 365 (Windows) and LibreOffice; not tested on older versions of Excel, Excel for Mac or online, WPS or Google Sheets.

Free, without registration

All the free tools · About SPLITGLASS · Moroccan tender directory (French and Arabic)