Below is the recommended column structure for the SoR Master Data sheet. This structure aligns with the Kerala PWD Standard Data Book format.
| 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 |
Solution: Always trust the official PDF notification as the source of truth. The Excel version is a derived tool. Notify the PWD Data Centre at datacell@pwd.kerala.gov.in. kerala+pwd+data+book+in+excel+format+new
A significant portion of these searches leads to third-party tools developed by enterprising engineers. The TECH-NIQ software, for instance, is a famous offline/offline tool that exports Kerala PWD data into Excel. The "New" formats found online are often custom-built templates that sit on top of official data, offering:
Important Warning: Do not download from random file-sharing sites (e.g., DocStoc, scribd, or unknown blogspot links). These often contain outdated (pre-2020) or manipulated rates that can void a tender. Below is the recommended column structure for the
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 | Solution: Always trust the official PDF notification as
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.