: Most Kerala PWD data is now synced with the CPWD Delhi Schedule of Rates (DSR) 2018 (updated with 2021 cost indices) or specialized MORTH specifications for roads and bridges. Alternative Formats (Excel and Linked Data)
Once you have downloaded the Kerala PWD data book in Excel format, you can use it to analyze and manipulate the data. Here are some tips on how to use the data book: kerala+pwd+data+book+in+excel+format+new
The Kerala Public Works Department (PWD) Data Book is a foundational document used for estimating construction and maintenance costs in the state. While the official manuals are typically published as PDFs, current engineering workflows often require this data in Excel format for dynamic rate analysis and estimation. Key Features of the PWD Data Book : Most Kerala PWD data is now synced
: It typically covers chapters such as Excavation, Brickwork, RCC Works, and Site Development. While the official manuals are typically published as
| Column | Header Name | Description / Formula Logic | | :--- | :--- | :--- | | | 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 |