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)