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

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

Phase 3: Key Components to Include

If you are building this from scratch or updating an old file, ensure you include these specific Kerala PWD sections:

1. Earthwork (Lead & Lift Calculations) Kerala PWD calculates earthwork based on initial lift and lead.

Initial Lift: Usually free up to a certain distance (often 1.5m or 3m).
Lead: Transport cost per km.
Excel Tip: Create a calculator sheet where you input "Distance in km" and it auto-applies the Lead charge based on Data Book items.

2. Cost Indexation (The "New" Factor) Kerala PWD rates are frequently updated via Cost Index (CI) or Price Index (PI).

Instead of hardcoding the new rate, keep the Base Rate in one column and a "Cost Index %" column.
This allows you to update the entire book instantly by changing one percentage value when a new GO is released.

3. Abstract Sheet Format This is the sheet you print for estimates.

Structure: It should pull data from the Master Sheet using VLOOKUP or XLOOKUP.
Columns: Item No | Description | Unit | Quantity | Rate | Amount.

How to obtain the data

Kerala PWD official website and e-procurement/tenders portal often publish reports and tender documents; look for “Data Book”, “Annual Report”, “Project Dashboard”, or RTI disclosures.
State open data portals (Kerala Open Data) may host machine-readable datasets.
RTI (Right to Information) request to Kerala PWD can be used to obtain specific structured datasets if not publicly available.
Contact PWD’s IT/records section or the Public Relations Office for bulk data exports.

Sheet 4: PWD Circle-wise Contact & Data

| Circle | Division | Subdivision | Executive Engineer Name | Contact Email | Data Book Last Updated | |--------|----------|-------------|------------------------|---------------|------------------------| | Trivandrum | TVM Road | Attingal | Sri. M. Nair | ee.tvm@pwd.kerala.gov.in | Jan 2024 |

Basic analysis ideas once data is in Excel

Pivot tables: expenditure by district, project type, year.
Timeline Gantt charts for project durations.
Conditional formatting to flag delayed projects or overspent budgets.
Mapping: export to GeoJSON or use Excel’s 3D Maps for spatial visualization.
KPIs: percent on-time, average cost overrun, projects per contractor.

Phase 2: Structural Draft (Column Headers)

Below is the recommended column structure for the SoR Master Data sheet. This structure aligns with the Kerala PWD Standard Data Book format.

What is the Kerala PWD Data Book?

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

Standard Item Descriptions (e.g., Earthwork excavation, concrete works, steel reinforcement).
Unit Costs (Current market rates for materials, labor, and machinery).
Lead and Lift Charges (Transportation and handling costs).
Analysis of Rates (Detailed break-up of how a final rate is derived).

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.

Phase 4: Draft Excel Formulas

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

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

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

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) The Ultimate Guide to the New Kerala PWD

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

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:

Project Details: This section provides information on project-wise details such as project name, location, type of project, estimated cost, and completion status.
Physical Progress: This section provides data on physical progress of projects, including milestones achieved, works completed, and pending works.
Financial Progress: This section provides data on financial progress of projects, including expenditure incurred, funds allocated, and funds released.
Resource Allocation: This section provides data on resource allocation for PWD projects, including manpower, machinery, and materials.
Quality Control: This section provides data on quality control measures adopted by PWD, including test results, inspection reports, and quality assurance measures.

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:

Improved Data Management: The data book provides a centralized repository of information on PWD projects, enabling easy access and retrieval of data.
Enhanced Transparency: The data book provides a transparent and accountable system for monitoring and evaluating PWD projects.
Better Decision Making: The data book provides valuable insights and trends on PWD projects, enabling informed decision making and policy formulation.
Increased Efficiency: The data book streamlines data collection, analysis, and reporting, reducing administrative burden and improving efficiency.

Features

The Kerala PWD Data Book in Excel format has several features, including:

Dynamic Dashboards: The data book has dynamic dashboards that provide real-time updates on PWD projects.
Data Validation: The data book has data validation features that ensure accuracy and consistency of data.
Automated Reports: The data book generates automated reports on PWD projects, including project-wise reports, divisional reports, and consolidated reports.
Data Analytics: The data book provides data analytics tools for analyzing trends, patterns, and performance of PWD projects.

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% |

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:

Easy data management: Excel provides a user-friendly interface for data entry, editing, and management.
Data analysis: Excel's built-in formulas and functions enable easy data analysis and calculation.
Data visualization: Excel's chart and graph features facilitate data visualization, making it easier to understand complex data.
Accessibility: Excel files can be easily shared and accessed by multiple stakeholders.

Creating a Kerala PWD Data Book in Excel Format

To create a Kerala PWD data book in Excel format, follow these steps:

Identify the data requirements: Determine the type of data to be collected, such as project name, location, type of infrastructure, cost, and completion status.
Design the data book template: Create an Excel template with columns and rows to accommodate the data requirements.
Collect and enter data: Gather data from various sources, such as project reports, and enter it into the Excel template.
Format the data: Apply formatting to make the data easy to read and understand.

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:

Project monitoring and evaluation: Use the data book to track project progress, identify delays, and take corrective action.
Data analysis and reporting: Analyze data to generate reports on project performance, cost, and completion status.
Decision-making: Use data from the data book to inform decision-making on future infrastructure projects.

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.