Kerala+pwd+data+book+in+excel+format+new Fixed Jun 2026

This section outlines the rules for utilizing the data book. It usually specifies that you must adjust parameters like or OH (Overhead charges) depending on the terrain and the nature of the project. It also reminds users that if an item isn't in the new book, the existing legacy manuals should be referenced. 2. Basic Rates of Materials and Labor

: It includes detailed breakdowns of labor, material, and equipment required for specific units of work. Cost Indices & Centage : Current rates often incorporate a cost index centage charges

| Table | Description | | :--- | :--- | | | Detailed rates for different skilled categories (e.g., Mason ₹X/day, Carpenter ₹Y/day). | | Material Rates | Standardized costs for materials like cement, steel, bricks, ready-mix concrete (RMC). | | Equipment Hire Charges | Standard hire rates for equipment like excavators, dump trucks, and concrete mixers. | | Transportation Costs | Itemized cost tables for conveying materials by lorry, boat, or head load. | | Basic Item Rates (BOQ Items) | The foundational unit rates for thousands of individual construction items (e.g., "Earthwork in excavation in ordinary soil"). | kerala+pwd+data+book+in+excel+format+new

Instead of manually multiplying material constants by current market prices, Excel formulas ( =SUM , =PRODUCT , VLOOKUP ) automate the entire process. If the price of cement changes, updating one cell recalculates your entire project estimate instantly. 2. Seamless Integration with DSR and PRICE Software

| Item Code | Description | Unit | Current Rate (₹) (2024-25) | |-----------|-------------|------|----------------------------| | 4.2.1 | Granular Sub-base (GSB) | cum | 1250 | | 5.3.3 | Bituminous Concrete (BC) | cum | 9250 | This section outlines the rules for utilizing the data book

Kerala PWD rates are frequently updated via Cost Index (CI) or Price Index (PI).

: If a specific item is missing in a newer version, you should refer to the preceding version of the PWD Data Book of the PWD Schedule of Rates or tips on automating your Excel estimates | | Material Rates | Standardized costs for

This article provides a comprehensive overview of the new Kerala PWD Data Book, how to utilize it in Excel, and its importance for modern construction projects. What is the Kerala PWD Data Book?

The file uses newer Excel functions (XLOOKUP, FILTER). Open with Excel 2019 or later, or use LibreOffice (with caution). Convert .xls to .xlsx.