Easily insert new items or modify existing ones to suit specific project needs without redrafting the entire sheet.
⚠️ The full Kerala PWD Data Book (~500 pages of road/bridge/culvert data) isn’t publicly distributed as a single Excel file due to its size and frequent updates. You may need to combine multiple departmental Excel exports.
The Kerala PWD heavily utilizes the PRICE (Project e-Information and Cost Estimation) software interface. Ensure that your Excel item descriptions, units of measurement (cum, sqm, kg), and standard item coding match the PRICE system exactly to prevent data rejection during upload. kerala+pwd+data+book+in+excel+format+new
Ensure the data book is linked to the correct SOR year (e.g., 2026-27).
Tailored explicitly to Kerala PWD highway standards, this vital module features parameters for Sub-Base (GSB), Wet Mix Macadam (WMM), Dense Bituminous Macadam (DBM), and Bituminous Concrete (BC), adjusting for machinery hiring hours and bitumen grade traits. How to Build a Dynamic Rate Analysis Template in Excel Easily insert new items or modify existing ones
A master list of labor wages (unskilled, skilled, specialized) and material costs (cement, steel, aggregate).
Use formulas to multiply the Master Constants by the Live Market Rates. The Kerala PWD heavily utilizes the PRICE (Project
To obtain the most accurate data for Kerala PWD works, you should reference the following official portals:
Details of hourly or daily rental charges for machinery like mixers, vibrators, excavators, and dumpers. 5. Analysis Tabs (The Core Formula) These tabs calculate the cost per unit.
: The official PRICE Software is the primary tool for digitizing the Schedule of Rates (SOR) and generating data books dynamically based on the current DSR (e.g., DSR 2018 or 2021).
: Access the official notification for the 2024 Schedule of Rates from the Government of Kerala.