Kerala+pwd+data+book+in+excel+format+new Direct
The latest Kerala Public Works Department (PWD) estimates are prepared using the PRICE (Project Information and Cost Estimation) software, which dynamically generates data based on the Delhi Schedule of Rates (DSR) adjusted for local Cost Indices. 🛠️ Official Access and Data Sources
To obtain the most accurate data for Kerala PWD works, you should reference the following official portals:
PRICE Software Portal: 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).
Kerala Forest Department: For specific regional rates, you can find the PWD SoR - Kerala Forest Department listings, which are updated periodically.
Local Self Government Department (LSGD): The PRICE LSGD portal provides information on Cost Indices (excluding GST) and updates regarding the transition to newer DSR versions. 📊 Excel Format Availability
While official government websites typically publish data in PDF format to ensure integrity, you can find Excel versions of the foundational DSR through professional engineering repositories:
DSR 2021 (Civil): A comprehensive Delhi Schedule Rate 2021 is often the base for Kerala estimates. Editable Excel formats for these rates are frequently shared on community platforms like Scribd or Academia.edu.
Manual Conversion: If an official Excel file is unavailable, most users utilize OCR (Optical Character Recognition) tools or specialized PDF-to-Excel converters to extract tables from the official PDF documents found on the Kerala PWD website. 💡 Key Information for Estimates
Cost Index: As of recent updates, Kerala uses specific cost indices to normalize DSR rates for various districts. For example, Munnar and Idukki typically have higher indices due to terrain.
GST Implementation: Current estimates are usually prepared exclusive of GST at the base level, with GST added as a separate provision in the final estimate.
Market Rate Justification (LMR): For items not covered in the standard data book, engineers use Local Market Rates which must be supported by current vouchers. A template for Rate Analysis based on Kerala PWD standards? Instructions on how to export data from the PRICE software?
Unlocking Efficiency: A Guide to the Kerala PWD Data Book For civil engineers, contractors, and architects in Kerala, accuracy in cost estimation isn't just a requirement—it’s the foundation of a successful project. The Kerala Public Works Department (PWD) Data Book
is the gold standard for these calculations, and having it in an Excel format is a game-changer for modern workflows. Why the Kerala PWD Data Book Matters
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
: Easily update material or labour costs to reflect the current Cost Index or Local Market Rates (LMR). Seamless Integration
: Many engineers use these sheets as a bridge to the official PRICE (Project Information and Cost Estimation) software used by the Kerala government. Key Features of the New Excel Data Book
The latest iterations of these data books, often derived from the Revised PWD Manual , include several vital sections: Revised Edition 2021 - KERALA PWD 1 Feb 2012 —
The Kerala Public Works Department (PWD) Data Book is a foundational document for civil and electrical engineers, contractors, and government officials in the state. It serves as a standardized guide for estimating project costs by detailing the specific labor, material, and machinery requirements for various construction activities. Overview of the Kerala PWD Data Book
Historically, the Kerala PWD maintained its own state-specific data books. However, in October 2013, 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.
This shift ensures that infrastructure projects in Kerala align with national standards for quality and technical specifications. Latest Updates for 2025-2026
Adoption of DSR 2021: As of April 1, 2025, the state has mandated the adoption of the Delhi Schedule of Rates 2021 (DSR 2021) for preparing estimates.
Local Cost Indices: To account for regional price variations (e.g., labor costs in Thiruvananthapuram vs. Kozhikode), the Kerala PWD applies specific Cost Indices to the base DSR rates.
PRICE Software Integration: Estimates are now strictly prepared using the PRICE (Project Information and Cost Estimation) software. This system dynamically generates the data book for a specific project based on the latest uploaded schedule of rates. Why Professionals Seek Excel Formats
While official documents are often published as PDFs, professionals frequently use the Kerala PWD Data Book in Excel for several practical reasons:
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
Kerala PWD Data Book is available in digital formats, including Excel, to streamline civil and electrical engineering estimations. Kerala State Electricity Board Ltd Key Resources for Excel Data Books
If you are looking for the latest Kerala Public Works Department (PWD) data and estimation tools in Excel: Civil Works Data Book (Excel Linked)
: The Kerala State Electricity Board (KSEB) and PWD provide data prepared in Excel linked format , allowing for soft-copy preparation of project estimates. Google Drive Repositories : Community-shared Kerala PWD Data Books in Excel
are frequently hosted on platforms like Google Drive for quick access. Estimation Software : Local developers often create specialized Excel-based software
tailored for Kerala PWD calculations, including tax regimes and latest Schedule of Rates (SOR). Kerala State Electricity Board Ltd Core Data Components
A "Feature" or standard data entry in these books typically includes: Use Rate of Equipment
: Columns for cost of fuel, equipment capacity, and charges as per prevailing SOR. Electrical Infrastructure
: Information on power distribution networks, safety guidelines, and maintenance schedules. Standard Rates : Inclusion of cost indexing, centage charges of 13.78% GST of 18% in current rate calculations. Prefeitura de Aracaju How to Create a Data-Linked Feature in Excel
To build a custom estimation tool using the PWD Data Book logic: Reference the Manual : Align your inputs with the Kerala PWD Manual standards for roads and buildings. Link the SOR : Create a master sheet for the current Schedule of Rates (SOR)
so your main estimate sheet updates automatically when rates change. Include Standard Formulas
: Ensure your Excel "feature" accounts for mandatory additions like the 13.78% centage charges. Irrigation Department Excel template for a building estimate or a road work calculation? 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. kerala+pwd+data+book+in+excel+format+new
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
Kerala PWD Data Book (Analysis of Rates) is a foundational document used for preparing detailed estimates for public works in Kerala. While the official Public Works Department (PWD) often releases these documents in PDF format, integrated Excel-linked versions are standard for modern engineering estimation. old.kseb.in Key Components of the Kerala PWD Data Book
The data book provides the standard breakdown for various construction activities, including: Labour Components
: Lists specific categories of workers (skilled, semi-skilled, and unskilled) and their daily output norms. Material Quantities
: Defines the exact quantity of materials (cement, sand, steel, etc.) required for a unit volume or area of work. Equipment Use Rates
: Includes charges for machinery, fuel consumption, and operational capacity. Overheads & Profit (OH & CP)
: Standardized percentages added to the basic cost to cover administrative costs and contractor profits. old.kseb.in Accessing Excel Formats
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
: Detailed analysis sheets and editable Excel formats for the 2024-25 period are often shared on platforms like or professional engineering communities. Government of Kerala Important Guidelines for Use
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
In the bustling world of infrastructure and civil engineering, the "Data Book" is not just a register; it is the bible. For engineers, contractors, and quantity surveyors operating under the Kerala Public Works Department (PWD), this document is the final arbiter of cost, the standard of quality, and the blueprint for estimation.
For years, the industry ran on paper and rigid PDFs. But the search query "Kerala PWD Data Book in Excel format new" signals a massive shift in how Kerala builds its future. It represents a transition from static reference to dynamic calculation. Let’s crack open the spine of this digital volume and see what makes the "new" Excel format so sought after.
⚠️ 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.
Introduction
The Public Works Department (PWD) of Kerala is responsible for the construction, maintenance, and management of various infrastructure projects in the state, including roads, bridges, buildings, and other public works. To facilitate efficient planning, monitoring, and evaluation of these projects, the PWD has developed a data book that provides a comprehensive overview of various parameters related to these projects. This report provides an overview of the Kerala PWD Data Book in Excel format.
Kerala PWD Data Book
The Kerala PWD Data Book is a comprehensive database that contains information on various aspects of PWD projects, including:
Excel Format
The Kerala PWD Data Book is maintained in Excel format, which provides an easily accessible and user-friendly interface for data analysis and reporting. The data book consists of multiple worksheets, each containing specific information related to PWD projects.
Benefits
The Kerala PWD Data Book in Excel format provides several benefits, including:
Features
The Kerala PWD Data Book in Excel format has several features, including:
Conclusion
The Kerala PWD Data Book in Excel format is a valuable tool for monitoring, evaluating, and managing PWD projects in Kerala. The data book provides a comprehensive overview of various parameters related to PWD projects, enabling informed decision making and policy formulation. The features and benefits of the data book make it an essential tool for PWD officials, policymakers, and stakeholders.
Here is a sample Excel sheet:
PWD Project Details
| Project ID | Project Name | Location | Type of Project | Estimated Cost | Completion Status | | --- | --- | --- | --- | --- | --- | | P001 | Road Construction | Thiruvananthapuram | Road | 100 lakhs | Ongoing | | P002 | Bridge Construction | Ernakulam | Bridge | 500 lakhs | Completed | | P003 | Building Construction | Kozhikode | Building | 200 lakhs | Ongoing |
PWD Physical Progress
| Project ID | Milestones Achieved | Works Completed | Pending Works | | --- | --- | --- | --- | | P001 | 2/5 | 30% | 70% | | P002 | 5/5 | 100% | 0% | | P003 | 1/3 | 20% | 80% |
PWD Financial Progress
| Project ID | Expenditure Incurred | Funds Allocated | Funds Released | | --- | --- | --- | --- | | P001 | 30 lakhs | 100 lakhs | 50 lakhs | | P002 | 500 lakhs | 500 lakhs | 500 lakhs | | P003 | 40 lakhs | 200 lakhs | 100 lakhs |
Please let me know if you want any modifications or changes.
Here is an dummy data for kerala pwd data book
| District | PWD Division | Project Name | Project Type | Start Date | End Date | Budget | Expenditure | Progress | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Thiruvananthapuram | TVM | Road Upgradation | Road | 01/01/2020 | 31/12/2020 | 100.00 | 50.00 | 50% | | Ernakulam | EKM | Bridge Construction | Bridge | 01/02/2020 | 31/01/2021 | 500.00 | 200.00 | 40% | | Kozhikode | KZD | Building Construction | Building | 01/03/2020 | 28/02/2021 | 200.00 | 100.00 | 50% | | Palakkad | PLK | Road Construction | Road | 01/04/2020 | 31/03/2021 | 150.00 | 75.00 | 50% | | Thrissur | TRS | Water Supply Scheme | Water Supply | 01/05/2020 | 30/04/2021 | 300.00 | 150.00 | 50% |
While the official Kerala PWD Data Book is traditionally published as a PDF, most engineers and contractors use unofficial Excel-converted versions or specialized software to automate estimation.
If you are looking for the latest data for the 2024-2025 period, here are the most helpful resources and features to manage this data effectively: 1. Official PWD Schedule of Rates (SoR)
The official department typically releases updates in PDF format, which serves as the "Source of Truth."
Latest Documents: You can find the latest PWD Schedule of Rates 2024-25 and Revised PWD Manual 2021 on the Official Kerala PWD Website.
Alternative Industry Source: The Kerala State Electricity Board (KSEB) provides a Data Book for Civil Works explicitly in an Excel-linked format to facilitate easy estimate preparation. 2. Specialized Estimation Software The latest Kerala Public Works Department (PWD) estimates
Since manually maintaining Excel sheets can lead to errors with new rate revisions, many professionals in Kerala use PRICE (Project Realisation and Information, Costing and Estimation) software.
Feature: This is the official software used by the Kerala Government for preparing estimates.
Benefit: It automatically updates to the current DSoR (Delhi Schedule of Rates) adapted for Kerala, removing the need for manual data entry. 3. Creating Your Own Excel Feature
If you prefer a custom Excel workbook, you can build a "Helpful Feature" using these steps:
Data Conversion: Use tools like the Adobe PDF to Excel Converter to import tables from the official 2024 SoR PDF into Excel.
Dynamic Linking: Set up a "Master Rates" sheet. Link your estimation sheets to this master sheet using VLOOKUP or XLOOKUP so that when next year's rates come out, you only have to update the master list once.
Regional Adjustments: Ensure your sheet includes a toggle for Hilly Areas (15% increase) or difficult terrain adjustments as specified in the PWD guidelines. 4. Direct Excel Downloads (Unofficial)
Several community-driven Google Drive links and third-party sites offer pre-converted Excel versions, though these should always be verified against the official PDF:
Kerala PWD Data Book in Excel (Google Docs): Often maintained by professional groups.
Scribd Resources: Frequently hosts user-uploaded Excel templates and converted rate lists for recent years. Kerala Pwd Data Book In Excel Format - Google Docs 🌎 Kerala Pwd Data Book In Excel Format - Google Drive. Google Docs PWD Rates 2023-24 | PDF - Scribd
Kerala PWD Data Book in Excel Format: A Comprehensive Guide
The Kerala Public Works Department (PWD) is a vital organization responsible for the construction, maintenance, and management of various infrastructure projects in the state of Kerala, India. The department plays a crucial role in ensuring the development and upkeep of roads, bridges, buildings, and other public infrastructure. To facilitate efficient data management and analysis, the Kerala PWD has introduced a data book that provides a comprehensive collection of data on various aspects of the department's activities.
In this article, we will discuss the Kerala PWD data book in Excel format, its features, and benefits, as well as provide a step-by-step guide on how to access and utilize the data book.
What is the Kerala PWD Data Book?
The Kerala PWD data book is a comprehensive document that provides a wide range of data on the department's activities, including project details, financial information, and performance metrics. The data book is designed to provide stakeholders, including government officials, contractors, and researchers, with easy access to accurate and reliable data on the department's operations.
Features of the Kerala PWD Data Book
The Kerala PWD data book in Excel format offers several features that make it a valuable resource for stakeholders. Some of the key features include:
Benefits of the Kerala PWD Data Book
The Kerala PWD data book in Excel format offers several benefits to stakeholders, including:
How to Access the Kerala PWD Data Book
The Kerala PWD data book in Excel format is available on the official website of the Kerala Public Works Department. To access the data book, follow these steps:
Using the Kerala PWD Data Book
Once you have downloaded the Kerala PWD data book in Excel format, you can use it to analyze and manipulate the data. Here are some tips on how to use the data book:
New Features in the Latest Version of the Kerala PWD Data Book
The latest version of the Kerala PWD data book in Excel format includes several new features and updates, including:
Conclusion
The Kerala PWD data book in Excel format is a valuable resource for stakeholders, including government officials, contractors, and researchers. The data book provides a comprehensive collection of data on various aspects of the department's activities, which can inform decisions, improve data management, and enhance transparency. By following the steps outlined in this article, you can access and utilize the Kerala PWD data book to gain insights and trends that can help drive improvements in the department's operations.
The most recent official data for the Kerala Public Works Department (PWD) is based on the Schedule of Rates (SoR) 2024, which was issued via G.O.(Ms)No.43/2024/PWD on August 30, 2024. While the PWD primarily uses the PRICE (Project Information and Cost Estimation) software to generate estimates and dynamic data books, users often seek Excel versions for offline analysis. Official Resources and Downloads
Latest Government Order (2024): Access the official notification for the 2024 Schedule of Rates from the Government of Kerala.
PWD E-Knowledge Portal: The E-Knowledge section of the Kerala PWD website contains updated codes, manuals, and current schedules of rates.
PRICE Software Integration: Most Kerala PWD data is now synced with the CPWD Delhi Schedule of Rates (DSR) 2018 (updated with 2021 cost indices) or specialized MORTH specifications for roads and bridges. Alternative Formats (Excel and Linked Data)
Since the department primarily provides PDF documents, engineers often use specialized utilities or third-party conversions for Excel: KSEB Data Book for Civil Works
The Kerala PWD Data Book is a structured collection of public works information maintained by the Kerala Public Works Department (PWD). Typical contents include:
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 Public Works Department (PWD) Data Book is a foundational document used for estimating construction and maintenance costs in the state. While the official manuals are typically published as PDFs, current engineering workflows often require this data in Excel format for dynamic rate analysis and estimation. Key Features of the PWD Data Book
The Data Book contains standardized "data" (specifications and resource requirements) for various work items. Standardized Rates
: 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
(typically around 13.78%) plus GST to reflect contemporary market prices. Revised Editions Kerala PWD Manual
and Data Books are periodically updated to include new construction technologies and administrative reforms. Kerala State Electricity Board Ltd Accessing and Using Excel Formats
Most engineers and contractors use Excel versions of these books to automate calculations: Linked Calculations
: Modern Excel versions of the Data Book are often "linked," meaning that changing a single base rate (like the price of cement) automatically updates all related work items. Source Locations
: Official Excel sheets are sometimes provided through internal departmental portals like the e-knowledge portal
, while community-maintained versions are frequently found on Google Drive or shared among professional circles. Compatibility
: If you only have access to a PDF, you can convert it using standard PDF-to-Excel tools, though manual verification is required to ensure formatting remains intact. Kerala State Electricity Board Ltd Critical Instructions for Estimates According to departmental guidelines (like those found in KSEB's Civil Data Book ), when using these data: Equipment Use Rates
: Ensure the cost of fuel and capacity are updated as per the latest Schedule of Rates (SOR). Steel Formwork : Many newer datasets assume the use of steel formwork for economy and availability.
: 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
Data Book for Civil Works - Kerala State Electricity Board Limited
The latest Kerala PWD Data Book serves as the primary technical reference for preparing engineering estimates for public works in Kerala, covering roads, bridges, and buildings. While the official core document is often distributed as a PDF via the Kerala PWD e-knowledge portal, Excel-formatted versions are highly sought after by engineers for direct integration into estimation software like PRICE. Key Components of the Data Book
Standardized Item Codes: Provides a systematic coding for civil and electrical works, essential for generating a Bill of Quantities (BoQ). ⚠️ The full Kerala PWD Data Book (~500
Labor & Material Coefficients: Detailed breakdown of labor hours and material quantities required for specific units of work (e.g., 10m³ of excavation).
Machinery Hire Rates: Updated hourly usage rates for equipment like power rollers, including fuel and operator costs.
Linked Excel Format: Modern versions are often prepared as excel linked files, allowing for automatic calculations once the basic Schedule of Rates (SoR) for the current year (e.g., 2024-25) is entered. Recent Updates (2024-2025)
Data Book for Civil Works - Kerala State Electricity Board Limited
The Kerala PWD Data Book is an essential technical compendium used by engineers and contractors to standardize material consumption, labor output, and equipment hire charges across state-funded projects. With the digital shift in the Kerala Public Works Department (PWD), obtaining this data in Excel format has become a priority for professionals seeking to streamline rate analysis and estimation. Overview of the Kerala PWD Data Book
The Data Book serves as the foundation for the Schedule of Rates (SoR), providing the "data" required to build unit rates for various construction tasks.
Genesis: Traditionally a physical manual, the digital version—specifically in Excel—automates complex calculations like labor constants and material requirements.
Key Contents: Includes standard schedules of rates (SSR), equipment fuel and hire charges, and profit margins (typically 10% for contractors).
Latest Updates: 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
While official PDF documents are hosted on the KERALA PWD E-Knowledge portal, Excel-linked versions are often distributed as "soft copies" alongside the official releases for estimation purposes.
Official Portal: Check the Kerala PWD Downloads section for the latest "E-Knowledge" resources, which may include downloadable calculators or structured data.
KSEB Resources: The Kerala State Electricity Board (KSEB) often hosts civil works data books in Excel linked format that align with PWD standards.
Third-Party Platforms: Engineering communities frequently share Excel-converted files of the Kerala PWD Data Book on platforms like Scribd for rate analysis. Critical Technical Components
When using the Excel data book, users must verify the following columns and formulas: Kerala Public Works Department Manual
For professionals and contractors working with the Kerala Public Works Department (PWD), maintaining accurate estimation data is essential for modern civil engineering projects. The department primarily uses the PRICE software to manage project cost estimates, but many engineers still rely on the PWD Data Book in Excel for offline calculations and detailed breakdowns. Kerala PWD Data Book Overview PWD Data Book
provides a comprehensive list of standard data for various civil works, including roads, bridges, and buildings. While the official manual is frequently updated (most recently the Revised Edition 2021), the Excel version is preferred for its "linked format," which allows users to update market rates for labor and materials to automatically recalculate item costs. Key Data Categories in the Excel Format A standard Kerala PWD Data Book in Excel typically includes the following sheets:
Basic Rates: A master list of labor wages (unskilled, skilled, specialized) and material costs (cement, steel, aggregate).
Standard Data: Calculations for standard tasks like earthwork, masonry, concrete work, and flooring based on the Kerala Public Works Account Code.
Estimation Sheet: Pre-formatted cells to input quantities that pull from the standard data and basic rates.
Roads & Bridges: Specific data for highway construction, culverts, and bridge spans. Accessing the "New" Data Book (2024-2026)
The department is currently transitioning toward digital-first processes. You can find the latest official documents and templates through these resources:
Official PWD Manuals: The Kerala PWD e-Knowledge Portal hosts the most recent manuals and measurement book guidelines.
Digital Tools: The PRICE Software is now the mandatory tool for submitting official estimates.
Community Resources: For unofficial Excel templates frequently used by contractors, sources like Google Drive archives often host the latest spreadsheets shared within the engineering community. Typical Excel Layout Structure
If you are building or updating your own workbook, the following structure is standard: Description of Work Material Qty Machinery Qty B.1 Brickwork in CM 1:6 0.72 (Mason) 500 (Bricks) C.1 PCC 1:4:8 for Foundation 0.20 (Mazdoor) 0.90 (Aggregate) 0.1 (Mixer)
Important Note: Ensure you are using the most recent Delhi Schedule of Rates (DSR) or the State Schedule of Rates (SOR) as mandated by the latest Kerala Government Orders to remain compliant with current pricing standards. Kerala Public Works Department Manual
The search for the Kerala PWD Data Book in Excel format (New) is more than a request for a file; it is a demand for efficiency. It represents the modernization of the Kerala infrastructure sector, where the clang of steel and the dust of construction are now orchestrated by the silent, precise logic of a spreadsheet. For any engineer working today, mastering this digital Data Book is just as important as mastering the concrete it calculates.
Kerala PWD Data Book in Excel Format: A Comprehensive Guide
The Kerala Public Works Department (PWD) is a vital organization responsible for the construction, maintenance, and management of infrastructure projects in the state of Kerala, India. To facilitate efficient data management and analysis, a data book in Excel format can be a valuable resource. In this article, we will explore the concept of a Kerala PWD data book in Excel format and provide a comprehensive guide on how to create and utilize one.
What is a Kerala PWD Data Book?
A Kerala PWD data book is a comprehensive collection of data related to various infrastructure projects undertaken by the Kerala PWD. The data book typically includes information on projects such as roads, bridges, buildings, and other infrastructure developments. The data book serves as a centralized repository of information, enabling easy access, analysis, and decision-making.
Benefits of a Kerala PWD Data Book in Excel Format
Using an Excel format for the Kerala PWD data book offers several benefits, including:
Creating a Kerala PWD Data Book in Excel Format
To create a Kerala PWD data book in Excel format, follow these steps:
Sample Kerala PWD Data Book Template
Here is a sample Kerala PWD data book template in Excel format:
| Project Name | Location | Type of Infrastructure | Cost (₹) | Completion Status | | --- | --- | --- | --- | --- | | Road Construction | Thiruvananthapuram | Road | 10,00,000 | Completed | | Bridge Construction | Kochi | Bridge | 50,00,000 | Under Progress | | Building Construction | Kozhikode | Building | 20,00,000 | Completed |
Utilizing the Kerala PWD Data Book
The Kerala PWD data book in Excel format can be utilized in various ways, including:
Conclusion
A Kerala PWD data book in Excel format is a valuable resource for managing and analyzing infrastructure project data. By creating a comprehensive data book, stakeholders can make informed decisions, monitor project progress, and evaluate performance. We hope this article has provided a useful guide on how to create and utilize a Kerala PWD data book in Excel format.
While the official Kerala Public Works Department (PWD) provides many documents in PDF format, specific Excel versions PWD Data Book are primarily accessible through the PRICE software or unofficial community links. Official Access via PRICE Software The Kerala PWD uses a dedicated software called
(Project Rate Information and Costing Estimation) for preparing estimates. Availability
: Data within the PRICE system is often "linked" and can be exported to Excel for estimate preparation. User Manuals : You can find instructions on using this system in the PRICE 3.0 User Manual PRICE Software User Guide old.kseb.in Community & Unofficial Excel Formats
Third-party links frequently shared in engineering communities provide converted Excel versions of the Data Book for easier editing: Kerala PWD Data Book (Excel) : Found on shared drives like Google Drive link 1 Google Drive link 2 Alternative Source Google Drive version is also available through community sharing. Google Drive Official Reference Documents (PDF)
If you need to verify the data against official sources, the Kerala PWD website lists the following latest manuals and codes: PWD Manual Revised Edition 2021 Kerala PWD Quality Control Manual Kerala Public Works Account Code (Fifth Edition) KERALA PWD
For the most accurate and up-to-date data, it is recommended to use the PRICE software
directly if you are a registered contractor or official employee. specific chapter
of the data book (e.g., civil works or roads) to use in a particular estimate?
Data Book for Civil Works - Kerala State Electricity Board Limited
It sounds like you're looking for a ready-made Kerala PWD Data Book (likely containing Road/Bridge inventories, project details, or specifications) in Excel format, specifically a newer/updated version.
I can't directly provide an Excel file download here, but I can help you create a template structure based on the typical contents of the Kerala Public Works Department Data Book. You can then populate it with official data from PWD Kerala reports, annual administrative reports, or the Morphosis portal.
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).
A significant portion of these searches leads to third-party tools developed by enterprising engineers. The TECH-NIQ software, for instance, is a famous offline/offline tool that exports Kerala PWD data into Excel. The "New" formats found online are often custom-built templates that sit on top of official data, offering: