The Kerala PWD Data Book is a structured collection of public works information maintained by the Kerala Public Works Department (PWD). Typical contents include:
For experienced users, the new Excel data book can be integrated with VBA macros to:
In the bustling world of infrastructure and civil engineering, the "Data Book" is not just a register; it is the bible. For engineers, contractors, and quantity surveyors operating under the Kerala Public Works Department (PWD), this document is the final arbiter of cost, the standard of quality, and the blueprint for estimation.
For years, the industry ran on paper and rigid PDFs. But the search query "Kerala PWD Data Book in Excel format new" signals a massive shift in how Kerala builds its future. It represents a transition from static reference to dynamic calculation. Let’s crack open the spine of this digital volume and see what makes the "new" Excel format so sought after.
Below is the recommended column structure for the SoR Master Data sheet. This structure aligns with the Kerala PWD Standard Data Book format. kerala+pwd+data+book+in+excel+format+new
| Column | Header Name | Description / Formula Logic |
| :--- | :--- | :--- |
| A | Sl. No. | Serial Number of the item. |
| B | Item Code | Unique PWD Code (e.g., PM 1.1.1 for Pre-mixed gravel). |
| C | Category | E.g., Earthwork, Concrete, Steel, Wood, Roads. |
| D | Description of Item | Full specification of the work item. |
| E | Unit | Measurement unit (cu.m, sq.m, Kg, Each, etc.). |
| F | Basic Rate (₹) | The raw rate found in the Data Book. |
| G | Cost Index % | The percentage increase/decrease based on current GO (Government Order). |
| H | Indexed Rate | =F + (F * G/100) or specific PWD indexation formula. |
| I | Quantity | Input field (Used when linking to Abstract). |
| J | Amount | =H * I |
Q1: Is the Excel data book legally valid for tender quoting?
Yes, if downloaded from the official PWD site. However, the signed hard copy of the SoR overrides any formula error. Always cross-check 10% of rates manually.
Q2: How often is the “new” version released?
Usually during April-May (start of financial year). Mid-year corrigenda are released as separate Excel files for download.
Q3: Can I get the data book in Malayalam Excel format?
The item descriptions are often in English, but the latest new versions include a bilingual header (Malayalam/English) for field engineers. The Kerala PWD Data Book is a structured
Q4: I am a student. Can I use this for academic projects?
Absolutely. Many civil engineering colleges in Kerala – from CET Thiruvananthapuram to NIT Calicut – use the official Excel data book for estimation labs. However, watermark it as “Academic Use Only”.
If you are building this from scratch or updating an old file, ensure you include these specific Kerala PWD sections:
1. Earthwork (Lead & Lift Calculations) Kerala PWD calculates earthwork based on initial lift and lead.
2. Cost Indexation (The "New" Factor) Kerala PWD rates are frequently updated via Cost Index (CI) or Price Index (PI). Q1: Is the Excel data book legally valid for tender quoting
3. Abstract Sheet Format This is the sheet you print for estimates.
Traditionally, the data book was a 200+ page PDF or a printed hard copy. The Excel format offers transformative advantages:
| Feature | PDF/Hard Copy | Excel Format | | :--- | :--- | :--- | | Searchability | Basic text search | Multi-conditional search (VLOOKUP, FILTER) | | Cost Estimation | Manual calculator entry | Instant auto-sum, pivot tables, macros | | Data Updates | Print new edition | Dynamic linking to master file | | Tender Preparation | Copy-paste prone to errors | Formula-driven, error-free BOQ generation | | Analysis of Rates | Hidden calculations | Transparent formulas visible in cells |
The new Kerala PWD Data Book in Excel format is particularly valued because it allows junior engineers to generate approximate estimates in minutes instead of hours.