How to Fill a BOQ Excel Sheet Properly Without Validation Errors on e-Tender Portals
One wrong keystroke, renamed file, or broken Excel formula can block your upload 10 minutes before deadline. Master safe NIC & CPPP BOQ entry rules.
In This Guide (Quick Navigation)
NIC e-Procurement BOQ files (BOQ_xxxx.xls) use Excel-protected macro templates so the server can read quoted figures automatically upon Financial Opening.
Meaning & Definition
Depending on the tender, a BOQ works either as an Item-Rate BOQ (enter exact rupee price per line item) or a Percentage BOQ (choose Excess (+) or Less (-) % vs. buyer Department Schedule of Rates).
Why It Matters for Bidders & Suppliers
Editing protected headers, converting .xls to .xlsx, leaving empty mandatory rows without 0, or failing macro validation stops financial encryption cold.
Step-by-Step Process
-
1
Enable Macros cleanly when opening in Microsoft Excel (
Options -> Enable Content). -
2
Type your Legal Firm Name accurately in the top "Bidder Name" field (never insert special symbols like
/ \ < > &). - 3 Fill ONLY the colored/unprotected entry columns (Rate In Figures, GST %/Amount if unlocked, Freight if separate).
- 4 Verify Total Amount In Figures AND Automatically Generated Words match expectations.
- 5 If there is a "Validate" macro button in the sheet, click it—ensure zero red validation warnings.
-
6
Save using
Ctrl+Skeeping exact original.xlsfilename (BOQ_12345.xls, NOTBOQ_12345 (1).xls!).
Common Mistakes to Avoid
- ⚠Downloading the BOQ twice in browser so Windows names it
BOQ_12345 (1).xls—portals reject filenames containing(1)! - ⚠Entering rates INCLUDING GST in a "Basic Rate Excluding GST" column—double-taxing your own bid by 18%!
Frequently Asked Questions
What do I type if I offer a specific line item free of cost or bundled?
Read the NIT rule carefully: in Item-Rate BOQs, leaving a cell completely blank sometimes treats the quote as incomplete/disqualified or invalid! Follow explicit NIC instructions (0 vs valid positive rate).