Important Warning: Do not download from random file-sharing sites (e.g., DocStoc, scribd, or unknown blogspot links). These often contain outdated (pre-2020) or manipulated rates that can void a tender.

For experienced users, the new Excel data book can be integrated with VBA macros to:

Let’s say you are a contractor bidding for a road re-tarring project in Thrissur. Here’s how to use the new Excel data book:

Step 1 – Open the Master File
Enable macros (if the file contains analysis buttons). Many new versions have a “Dashboard” sheet.

Step 2 – Select District
Use the dropdown filter in the “Material” sheet to choose Thrissur. The sheet automatically updates sand, aggregate, and bitumen prices.

Step 3 – Build Your Bill of Quantities (BOQ)
Create a new worksheet named “My Estimate”. Use VLOOKUP to fetch rates from the data book:

=VLOOKUP(A2, 'Main_Items'!A:D, 4, FALSE)

Where A2 contains the item code (e.g., PWDP405 – Granular Sub-base).

Step 4 – Apply Lead & Lift
If the quarry is 15km away, the lead sheet automatically adds ₹X per km. The new Excel format has a pre-programmed Lead Calculator – simply enter distance.

Step 5 – Generate Print-Ready Abstract
Use pivot tables to group items (Earthwork, Pavement, Drainage, etc.) and add 5% contingencies.

The PWD Data Book, officially known as the Schedule of Rates (SoR), is a comprehensive document listing:

The “new” version typically refers to the latest annual or biennial revision, incorporating inflation, new technology (like geo-synthetics or recycled materials), and updated GST slabs.

To make the Excel sheet functional (not just a typing board), use these formulas:

1. Abstract Sheet (Auto-fill Item Details) *Assuming you type

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

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

Q1: Is the Excel data book legally valid for tender quoting?
Yes, if downloaded from the official PWD site. However, the signed hard copy of the SoR overrides any formula error. Always cross-check 10% of rates manually.

Q2: How often is the “new” version released?
Usually during April-May (start of financial year). Mid-year corrigenda are released as separate Excel files for download.

Q3: Can I get the data book in Malayalam Excel format?
The item descriptions are often in English, but the latest new versions include a bilingual header (Malayalam/English) for field engineers.

Q4: I am a student. Can I use this for academic projects?
Absolutely. Many civil engineering colleges in Kerala – from CET Thiruvananthapuram to NIT Calicut – use the official Excel data book for estimation labs. However, watermark it as “Academic Use Only”.

The Kerala Public Works Department (PWD) is the backbone of the state’s infrastructure, overseeing thousands of kilometers of roads, bridges, and government buildings. For decades, engineers and contractors relied on bulky printed “Data Books” (Schedules of Rates – SoR) to estimate project costs. However, in a significant digital leap, the department has moved towards structured digital datasets. The demand for the Kerala PWD Data Book in Excel format new has skyrocketed among civil engineers, quantity surveyors, and government tender analysts.

But what exactly is this new Excel data book? Why is it a game-changer? And most importantly, how can you obtain and utilize the latest version effectively? This article answers all these questions.