Pro Tip: The filename usually follows a pattern –
Kerala_PWD_SoR_YYYY_Excel.xlsx. The “new” version will have the current financial year (e.g., 2025-2026).
The release of the new Kerala PWD Data Book in Excel format marks a paradigm shift. No longer do engineers need to flip dog-eared pages or keep outdated rate lists. With dynamic arrays, district-level customized rates, and error-checking formulas, the Excel data book reduces tender preparation time by over 60%.
As the Kerala government pushes for e-Governance 2.0, expect the next iteration to be an online API or a Power BI dashboard connected to live material market rates. But for now, the Excel format remains the most accessible, powerful, and offline-capable tool for every PWD stakeholder.
Call to Action:
Visit the official Kerala PWD website today. Search for “Data Book 2025 Excel New”. Download it, watch a 10-minute YouTube tutorial on VLOOKUP, and transform your estimation workflow. Remember – accurate estimation is the first step to a profitable and compliant public works project.
Have you found a better way to organize the Kerala PWD data book? Share your Excel templates or tips in the comments below (if applicable on your platform). Stay updated – bookmark this page for future announcements regarding the 2026 edition.
Disclaimer: Rates and procedures mentioned are based on public information as of 2025. Always confirm with the latest Kerala PWD circular. The author is not affiliated with the Kerala Government.
The Kerala PWD Data Book is a vital resource used by the Public Works Department to standardize the preparation of estimates, outlining descriptions and quantities for various civil work items. Modern versions are designed as Excel-linked files, allowing users to automatically generate detailed estimates by inputting current material and equipment rates. Key Components of the PWD Data Book
The data book typically includes the following sections to assist in engineering and administrative workflows:
Excel-Linked Format: New versions provide a soft copy in Excel where data for estimates can be prepared by filling in columns for equipment costs, fuel, and current Schedule of Rates (SOR). Standard Chapters:
Excavation and Allied Works: Includes details on soil removal, conveyance by tipper, and lift considerations.
Construction Materials: Specifications for steel formwork, brickwork, and concrete (CC, DPC).
Rates and Mark-ups: Comprehensive tables for labor charges, material costs, and overheads based on terrain.
Manual Integration: 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 obtain or use the latest files, users generally refer to the following official and departmental resources:
Official Downloads: Many files are available through the Kerala PWD e-Knowledge Portal or specialized repositories like KSEB's Civil Works section.
E-Tendering Documents: When bidding on Kerala PWD tenders, contractors can often download specific Excel spreadsheets for bid forms directly from the Kerala Water Authority (KWA) or PWD e-tender sites. Important Guidelines for Use
Equipment Rates: Users must fill in prevailing charges and fuel costs under the "Use rate of equipments" columns in the Excel file.
Overheads (HA and OH): These should be adjusted based on the specific terrain and nature of the work being estimated.
Missing Items: If a specific item is not in the new Data Book, the existing PWD Data Book or the PWD Schedule of Rates (SOR) should be used as a fallback. Kerala Public Works Department Manual
While the official Kerala PWD website typically provides the Schedule of Rates (SOR) and Data Books in PDF format, here are the most effective ways to access or generate that data in Excel: 1. PRICE Software (Project Information and Cost Estimation)
The Kerala PRICE Portal is the official software developed by NIC Kerala for estimate preparation. It is the primary tool for PWD engineers and contractors to access the latest data book information.
Dynamic Generation: The software is designed to dynamically generate the data book whenever a new Delhi Schedule of Rates (DSR) is published.
Excel Export: Most modules within PRICE allow users to export the Bill of Quantities (BOQ) and detailed estimates directly into Excel format. 2. KSEB Linked Excel Data Book
The Kerala State Electricity Board (KSEB) provides a version of the Data Book for Civil Works that is explicitly prepared in an excel linked format.
It is designed so that data for estimates can be prepared using the soft copy provided.
If a specific item isn't in this version, it recommends referring to the standard PWD Data Book. 3. Community and Third-Party Resources
Various engineering communities host converted Excel versions of the latest SOR. You can find these shared on platforms such as:
Google Drive Shares: There are publicly indexed Google Drive links specifically titled "Kerala PWD Data Book In Excel Format."
Scribd & Civil Engineering Forums: 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)
Current Standard: Estimates are largely based on the DSR 2018/2022 with updated cost indices for Kerala.
GST Exclusion: Most latest SOR values published on official portals are exclusive of GST, which must be added separately during estimate preparation. Home Page - PRICE ELECTRICAL - Price Kerala
The Kerala PWD Data Book is a critical technical document used by engineers and contractors for preparing estimates for various public works like roads, buildings, and bridges. While traditionally a printed manual, it is now primarily managed and accessed through digital platforms to ensure accuracy and real-time updates. Key Digital Access Points
Excel Formats: Many engineers use linked Excel-based versions for automatic calculation of estimates. These templates allow for filling in "Use rate of equipment," fuel costs, and labor charges based on current Schedule of Rates (SOR).
PRICE Portal: The Project Information and Cost Estimation (PRICE) software is the official government tool for dynamically generating the Data Book and SOR. It allows for online estimate submission and technical sanctions.
PDF References: For offline use or verification, historical and approved observed data documents are often found on repositories like Scribd or Google Drive. Data Book Structure & Usage
Linked Estimation: The digital Data Book is often designed as an Excel-linked format where modifying one base rate (e.g., cement price) updates all related work estimates automatically.
Chapter Organization: It typically covers chapters such as Excavation, Brickwork, RCC Works, and Site Development.
Adoption of Standards: The Kerala PWD has largely adopted CPWD Data and National Building Code Guidelines for civil works estimates where specialized state data is unavailable.
Field Specifics: It includes detailed instructions for equipment charges, fuel costs, and adjustments for terrain (HA and OH charges). Important Resources for Contractors
Data Book for Civil Works - Kerala State Electricity Board Limited
Why is the query "Kerala PWD Data Book in Excel format new" so popular? Because access has traditionally been gatekept. While the PDF versions are readily downloadable from the official Kerala PWD website (keralapwd.gov.in), the native Excel files are the gold dust.
These files are coveted because:
Pro Tip: The filename usually follows a pattern –
Kerala_PWD_SoR_YYYY_Excel.xlsx. The “new” version will have the current financial year (e.g., 2025-2026).
The release of the new Kerala PWD Data Book in Excel format marks a paradigm shift. No longer do engineers need to flip dog-eared pages or keep outdated rate lists. With dynamic arrays, district-level customized rates, and error-checking formulas, the Excel data book reduces tender preparation time by over 60%.
As the Kerala government pushes for e-Governance 2.0, expect the next iteration to be an online API or a Power BI dashboard connected to live material market rates. But for now, the Excel format remains the most accessible, powerful, and offline-capable tool for every PWD stakeholder.
Call to Action:
Visit the official Kerala PWD website today. Search for “Data Book 2025 Excel New”. Download it, watch a 10-minute YouTube tutorial on VLOOKUP, and transform your estimation workflow. Remember – accurate estimation is the first step to a profitable and compliant public works project.
Have you found a better way to organize the Kerala PWD data book? Share your Excel templates or tips in the comments below (if applicable on your platform). Stay updated – bookmark this page for future announcements regarding the 2026 edition.
Disclaimer: Rates and procedures mentioned are based on public information as of 2025. Always confirm with the latest Kerala PWD circular. The author is not affiliated with the Kerala Government.
The Kerala PWD Data Book is a vital resource used by the Public Works Department to standardize the preparation of estimates, outlining descriptions and quantities for various civil work items. Modern versions are designed as Excel-linked files, allowing users to automatically generate detailed estimates by inputting current material and equipment rates. Key Components of the PWD Data Book
The data book typically includes the following sections to assist in engineering and administrative workflows:
Excel-Linked Format: New versions provide a soft copy in Excel where data for estimates can be prepared by filling in columns for equipment costs, fuel, and current Schedule of Rates (SOR). Standard Chapters:
Excavation and Allied Works: Includes details on soil removal, conveyance by tipper, and lift considerations.
Construction Materials: Specifications for steel formwork, brickwork, and concrete (CC, DPC). kerala+pwd+data+book+in+excel+format+new
Rates and Mark-ups: Comprehensive tables for labor charges, material costs, and overheads based on terrain.
Manual Integration: 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 obtain or use the latest files, users generally refer to the following official and departmental resources:
Official Downloads: Many files are available through the Kerala PWD e-Knowledge Portal or specialized repositories like KSEB's Civil Works section.
E-Tendering Documents: When bidding on Kerala PWD tenders, contractors can often download specific Excel spreadsheets for bid forms directly from the Kerala Water Authority (KWA) or PWD e-tender sites. Important Guidelines for Use
Equipment Rates: Users must fill in prevailing charges and fuel costs under the "Use rate of equipments" columns in the Excel file.
Overheads (HA and OH): These should be adjusted based on the specific terrain and nature of the work being estimated.
Missing Items: If a specific item is not in the new Data Book, the existing PWD Data Book or the PWD Schedule of Rates (SOR) should be used as a fallback. Kerala Public Works Department Manual
While the official Kerala PWD website typically provides the Schedule of Rates (SOR) and Data Books in PDF format, here are the most effective ways to access or generate that data in Excel: 1. PRICE Software (Project Information and Cost Estimation)
The Kerala PRICE Portal is the official software developed by NIC Kerala for estimate preparation. It is the primary tool for PWD engineers and contractors to access the latest data book information. Pro Tip: The filename usually follows a pattern
Dynamic Generation: The software is designed to dynamically generate the data book whenever a new Delhi Schedule of Rates (DSR) is published.
Excel Export: Most modules within PRICE allow users to export the Bill of Quantities (BOQ) and detailed estimates directly into Excel format. 2. KSEB Linked Excel Data Book
The Kerala State Electricity Board (KSEB) provides a version of the Data Book for Civil Works that is explicitly prepared in an excel linked format.
It is designed so that data for estimates can be prepared using the soft copy provided.
If a specific item isn't in this version, it recommends referring to the standard PWD Data Book. 3. Community and Third-Party Resources
Various engineering communities host converted Excel versions of the latest SOR. You can find these shared on platforms such as:
Google Drive Shares: There are publicly indexed Google Drive links specifically titled "Kerala PWD Data Book In Excel Format."
Scribd & Civil Engineering Forums: 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)
Current Standard: Estimates are largely based on the DSR 2018/2022 with updated cost indices for Kerala.
GST Exclusion: Most latest SOR values published on official portals are exclusive of GST, which must be added separately during estimate preparation. Home Page - PRICE ELECTRICAL - Price Kerala The release of the new Kerala PWD Data
The Kerala PWD Data Book is a critical technical document used by engineers and contractors for preparing estimates for various public works like roads, buildings, and bridges. While traditionally a printed manual, it is now primarily managed and accessed through digital platforms to ensure accuracy and real-time updates. Key Digital Access Points
Excel Formats: Many engineers use linked Excel-based versions for automatic calculation of estimates. These templates allow for filling in "Use rate of equipment," fuel costs, and labor charges based on current Schedule of Rates (SOR).
PRICE Portal: The Project Information and Cost Estimation (PRICE) software is the official government tool for dynamically generating the Data Book and SOR. It allows for online estimate submission and technical sanctions.
PDF References: For offline use or verification, historical and approved observed data documents are often found on repositories like Scribd or Google Drive. Data Book Structure & Usage
Linked Estimation: The digital Data Book is often designed as an Excel-linked format where modifying one base rate (e.g., cement price) updates all related work estimates automatically.
Chapter Organization: It typically covers chapters such as Excavation, Brickwork, RCC Works, and Site Development.
Adoption of Standards: The Kerala PWD has largely adopted CPWD Data and National Building Code Guidelines for civil works estimates where specialized state data is unavailable.
Field Specifics: It includes detailed instructions for equipment charges, fuel costs, and adjustments for terrain (HA and OH charges). Important Resources for Contractors
Data Book for Civil Works - Kerala State Electricity Board Limited
Why is the query "Kerala PWD Data Book in Excel format new" so popular? Because access has traditionally been gatekept. While the PDF versions are readily downloadable from the official Kerala PWD website (keralapwd.gov.in), the native Excel files are the gold dust.
These files are coveted because: