The Kerala PWD Data Book is now available in Excel format, making it easily accessible and usable for various stakeholders. The Excel format allows for easy data analysis, visualization, and sharing. This move is part of the government's effort to promote transparency, accountability, and data-driven decision-making.
: The department periodically releases revised manuals and codes, such as the PWD Manual Revised Edition 2021 and Vigilance Awareness Hand Book 2026. Accessing the Data Book in Excel Format
The best way to use the spreadsheet is to keep a locked "master copy" and use a working copy for your specific project. In the working copy, update the table to reflect the current market prices. The formulas will cascade through the rest of the sheets and update the comprehensive item rates automatically. 3. Factor in Location and Terrain Modifiers
The Kerala PWD Data Book is an official regulatory document. It outlines the standard specification of materials, labor requirements, and machinery hours needed for various construction activities. From building foundations to highway paving, it breaks down every task into its core components. kerala+pwd+data+book+in+excel+format+new
Total Cost for Item=Project Quantity×Analyzed Rate per UnitTotal Cost for Item equals Project Quantity cross Analyzed Rate per Unit Step 5: Apply Statutory Additions
Many Scribd uploads include the latest Schedule of Rates for 2024-25, which can be downloaded and converted to Excel using online OCR or PDF-to-Excel tools. Summary of Latest Reference Data (as of April 2026)
Hire charges for concrete mixers, excavators, tippers, rollers, etc.. 3. Observed Data Sheets (Item-wise Analysis) The Kerala PWD Data Book is now available
The Kerala Public Works Department (PWD) Data Book is the foundational blueprint for civil engineering cost estimation, project planning, and tender preparation across the state. Transitioning this massive repository of engineering items, materials, and labor constants into an editable Microsoft Excel format completely revolutionizes the workflow for contractors, estimators, and engineers.
Remember to build dedicated percentage rows at the bottom of your analysis summaries for Contractor's Profit (CP), Overhead Charges (OH), and applicable GST or construction worker welfare cesses.
The PWD Data Book, often referred to along with the , contains the theoretical analysis of rates for various construction items. It breaks down the cost into: Material cost (Cement, steel, aggregate, etc.) Labor cost (Skilled, unskilled, technicians) Machinery/Equipment hire charges Overheads and Contractor’s Profit (OH & CP) : The department periodically releases revised manuals and
(Project Rate Information and Costing Estimation) for preparing estimates. Availability
The Kerala PWD data book in Excel format can be utilized in various ways, including:
Historically, the Kerala PWD maintained its own state-specific data books. However, in , the Government of Kerala transitioned to adopting the Delhi Schedule of Rates (DSR) and Delhi Analysis of Rates (DAR) provided by the Central Public Works Department (CPWD) for all public works.
: Use tools like the Adobe PDF to Excel Converter to import tables from the official 2024 SoR PDF into Excel.
: Traditionally a physical manual, the digital version—specifically in Excel—automates complex calculations like labor constants and material requirements.