IREPS Railway Tenders Bid Freezing & BOQ Upload Error Fix
Submitting financial offers on the Indian Railways E-Procurement System (IREPS - ireps.gov.in) requires precise preparation of Excel-based Bill of Quantities (BOQ) financial templates and execution of the final Bid Freezing procedure. Failure to correctly freeze a bid or resolving BOQ macro errors can result in technical disqualification.
This guide provides technical solutions for railway contractors to successfully submit financial bids on IREPS.
1. Understanding IREPS BOQ & Bidding Architecture
The financial evaluation on IREPS relies on pre-formatted Excel BOQ files containing automated rate calculations, tax inclusions, and percentage rebate formulas.
[Download Tender BOQ Excel] ➔ [Enable Macros in Excel] ➔ [Enter Financial Rates & Taxes] ➔ [Save BOQ (Do Not Rename)] ➔ [Upload to IREPS] ➔ [Freeze Bid]
2. Resolving Common BOQ Upload Errors on IREPS
Error 1: "Invalid BOQ File / Sheet Protected Error"
- Cause: Renaming the downloaded BOQ file or altering header row structures.
- Solution:
- Download a fresh copy of the BOQ Excel file from the tender document page.
- Do NOT rename the file name or edit protected column headers.
- Enter values only in un-shaded input cells.
Error 2: "Macros Disabled / Security Alert Error"
- Cause: Microsoft Excel blocking VBA macros in downloaded files.
- Solution:
- Open Microsoft Excel ➔ Go to File ➔ Options ➔ Trust Center ➔ Trust Center Settings....
- Under Macro Settings, select Enable all macros (or Disable VBA macros with notification).
- Under Protected View, uncheck Enable Protected View for files originating from the Internet.
Error 3: "Invalid Rate / Formula Error on Tax Columns"
- Cause: Inputting currency symbols (₹, $) or text values in numeric rate fields.
- Solution: Enter plain numbers only (e.g.,
1450.50). Do not include commas or currency signs.
