What Makes a BOQ “CPWD Compliant”?
A CPWD BOQ isn’t just a list of items and prices. It follows a specific structure defined under IS 1200 measurement rules and CPWD’s own schedule format:
- Item description as per DSR nomenclature — not your own wording. Each line item must match the exact phrasing used in the current DSR (e.g., “Providing and laying in position cement concrete of specified grade…”).
- Standard unit of measurement — Cum for concrete, Sqm for plaster/flooring, Rmt for pipes/conduits, Ton for steel — matched exactly to the DSR unit, not a converted or rounded one.
- Quantity derived from a quantity takeoff sheet, with visible calculation (length × breadth × height/depth), not a single typed-in number.
- DSR base rate + cost index / market variation — CPWD rates are revised periodically; your BOQ needs to reference the correct DSR year and apply the applicable cost index for your state/city.
- Abstract of cost — a summary sheet rolling up every BOQ item into a single tender value, usually with contingency and GST shown separately.
Miss any one of these and a tender evaluator can — and often will — flag your submission as non-compliant before they even look at your price.
How DSR Rate Analysis Actually Works
Rate analysis is the process of proving how you arrived at the rate for each BOQ item. For government work, you can’t just quote a number — CPWD expects a breakdown of:
- Material cost — quantity of cement, steel, aggregate, etc. per unit of work, priced at current market or DSR rates.
- Labour cost — mason, mazdoor (helper), bar-bender days per unit, priced per DSR labour rates.
- Machinery/equipment cost — mixer, vibrator, or crane hire apportioned per unit of work where applicable.
- Contractor’s profit and overheads — typically 10-15%, added as a percentage on top of the base cost as per CPWD norms.
Add these four together and you get the analyzed rate for that one BOQ item. Multiply by quantity, and repeat for all 100-150+ items in a typical residential or small commercial project — that’s the manual process that eats 2-3 full working days per estimate.
💡 Where most contractors lose time
Rate analysis is the single most repetitive part of building a CPWD BOQ — the same four-step calculation, done manually, 100+ times per project, every time DSR rates update. This is exactly the part our Civil Work Estimate & BOQ Template automates: enter the quantity, and the rate analysis sheet calculates material, labour, machinery and profit automatically, with a DSR-vs-market-rate toggle built in.
Common CPWD BOQ Format Mistakes
| Mistake | Why it matters |
|---|---|
| Using outdated DSR year rates | Bids evaluated against current DSR; stale rates make your quote look unrealistic or get you disqualified |
| Rounding quantities without showing the takeoff | Evaluators can ask for backup calculation; “no takeoff sheet” is an easy rejection reason |
| Mixing units (e.g., Sqft instead of Sqm) | CPWD works in metric units per IS 1200 — mismatched units flag the whole BOQ for review |
| No separate abstract of cost sheet | Tender committees want one summary number backed by the detailed BOQ, not a single combined sheet |
A Faster Way to Build CPWD-Compliant BOQs
You can build all of this manually in Excel from scratch — many contractors do, and it works, but it typically takes 20-40 hours per estimate to set up the formulas, DSR rate tables, and rate analysis correctly, and one broken formula can throw off your entire tender price.
Our Professional Civil Work Estimate & BOQ Template is a ready-built, CPWD/DSR/IS-1200-compliant Excel and Google Sheets template with:
- Main BOQ sheet with auto-calculated totals
- Rate Analysis sheet (material + labour + machinery + profit, auto-computed)
- 2026 market rates database (UP-focused, PAN-India usable) with a DSR-vs-market-rate toggle
- Quantity Takeoff sheet with visible formula backup
- Bar Bending Schedule (auto-generated)
- Abstract of Cost sheet for quick tender submission
- GST, contingency & profit auto-calculation
It’s used by 2,450+ civil engineers and contractors across India, including several who’ve used it to win government tenders on the strength of the compliant, professional documentation it produces.
Special Launch Offer
Get the CPWD-Compliant BOQ Template — ₹249 ₹999
One-time payment • Lifetime updates • Instant download • 11 fully interconnected sheets
Frequently Asked Questions
What is a CPWD BOQ?
A Bill of Quantities prepared in the format and rate structure specified by the Central Public Works Department, using DSR rates and IS 1200 measurement standards — required for most Indian government civil work tenders.
What is rate analysis in civil engineering?
It’s the detailed breakdown of material, labour, machinery, and profit cost used to arrive at the price for one unit of a BOQ item (e.g., cost per Cum of RCC M25).
Which DSR should I use for 2026 tenders?
Use the latest published DSR for your state/department — CPWD DSR 2024 is the current base most PWD and municipal tenders reference as of 2026, with cost-index adjustments applied for your city.
Can I use Excel for CPWD tender submissions?
Yes. Excel-based BOQs are standard practice — what matters is that the format, units, and rate analysis follow CPWD/DSR/IS 1200 norms, which is exactly how our BOQ template is built.
Related: BOQ Format in Excel for Construction · BOQ Format for Civil Work in Excel · Best BOQ Excel Sheet for Building Construction