Drastically reduces the time required to prepare complex estimates compared to manual calculations.
: Defines the exact quantity of materials (cement, sand, steel, etc.) required for a unit volume or area of work. Equipment Use Rates
To calculate the actual estimate, follow this step-by-step process:
When using the Excel data book, users must verify the following columns and formulas: Kerala Public Works Department Manual kerala+pwd+data+book+in+excel+format+new
Utilizing the is a strategic move for any construction professional working in Kerala in 2026. It ensures compliance with official standards while offering the speed and flexibility required in modern project management. By keeping your Excel data updated with the latest Schedule of Rates, you can ensure accurate, competitive, and profitable projects. Need Help with Estimation?
The Kerala PWD Data Book provides the "standard data" or rate analysis for hundreds of construction items, ranging from simple excavation to complex reinforced concrete work. While the official department often releases these as PDFs, the Excel version allows users to: Automate Calculations : Link quantities directly to rates for instant totals. Adjust for Market Rates
Here I used placeholder “[Insert link]” for downloading , replace it with actual link Drastically reduces the time required to prepare complex
Modifying a base rate (e.g., the cost of cement or a skilled mason's daily wage) instantly updates every item across the workbook utilizing that resource.
: The Kerala PWD has largely adopted CPWD Data and National Building Code Guidelines for civil works estimates where specialized state data is unavailable.
It's also a key part of the PWD's broader "E-Knowledge" portal, which includes the PWD Manual and various administrative policies. The periodical updating of the Standard Data Book is a matter of official policy, typically approved by the Chief Engineer (Administration and Designs). It ensures compliance with official standards while offering
In your main data sheet, use formulas to link back to the "Rates" sheet, for example: =Material_Qty * Rates!Cell_Address .
: It functions alongside the Kerala PWD Manual (Revised 2022) , which provides the administrative and work methodology for investigations, design, and maintenance. Accessing the Data
To maximize utility, professionals incorporate the digitized PWD Data Book into standard project management workflows.
Standard Excel-linked files allow for automatic calculation when current market rates or the Schedule of Rates (SoR) are updated. You can typically find these through: old.kseb.in Official Portals : Documents such as the Kerala PWD Schedule of Rates are periodically updated on the official Kerala PWD website E-Tendering Site : Bidders can download the Bill of Quantities (BoQ) and estimate templates in Excel format from the Kerala e-GP portal Secondary Sources