Kerala+pwd+data+book+in+excel+format+new Page

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. kerala+pwd+data+book+in+excel+format+new

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: For professionals and contractors working with the Kerala

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 Tabular data is easy to sort, filter, and analyze

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

Problem 3: I found a discrepancy between Excel and PDF data book

Solution: Always trust the official PDF notification as the source of truth. The Excel version is a derived tool. Notify the PWD Data Centre at datacell@pwd.kerala.gov.in.

The Ultimate Guide to the New Kerala PWD Data Book in Excel Format: Streamlining Public Works Data Management

Why Excel format is useful

Sheet 2: Major Bridges (>30m)

| Bridge Name | District | River/Crossing | Length (m) | Year Built | Condition (Good/Fair/Poor) | |-------------|----------|----------------|------------|------------|----------------| | Kallumoodu Bridge | Kollam | Ithikkara River | 180 | 2018 | Good | | (Add 50+ entries) | | | | | |

Common Problems and Troubleshooting

5. Lead Statement

Cookie Preferences

Cookies help us to better understand user behavior including for security and fraud prevention purposes, tell us which parts of our websites people have visited, and facilitate and measure the effectiveness of advertisements and web searches.

Cookie Policy