Kerala+pwd+data+book+in+excel+format+new Jun 2026

The file may be “Read-only”. Save a copy and enable editing. Check if the district name is typed exactly as per the dropdown list (e.g., “Kollam” vs “Quilon”).

Government statutory provisions require adding fixed percentages (often ranging from 10% to 15%) to cover site supervision, administrative running costs, water/electricity charges, and contractor profit margins. Excel sheets automate this by adding a trailing multiplier to the subtotal row.

Do you need this template specifically for or roads and highways (MoRTH data) ?

A comprehensive Data Book in Excel format would contain several interconnected datasets. Here's a glimpse into the kind of tables you could find: kerala+pwd+data+book+in+excel+format+new

Remember to build dedicated percentage rows at the bottom of your analysis summaries for Contractor's Profit (CP), Overhead Charges (OH), and applicable GST or construction worker welfare cesses.

Dedicate the very first tab of your workbook to a "Master Rate List." Link all subsequent estimation tabs to this dashboard using formulas. When the government updates the local daily wages or material costs, update this single tab to refresh the entire workbook.

This transition empowers professionals working across the Kerala Public Works Department , the Local Self Government Department (LSGD), and the Kerala Water Authority (KWA) to compute project costs instantly. Instead of manually cross-referencing values, a user can alter a single material rate to update the entire calculation across multiple linked worksheets. Core Structure of the Excel Data Book The file may be “Read-only”

: Formulaic sheets tracking steel tonnage, binding wire wastage, and fabrication labor.

are frequently hosted on platforms like Google Drive for quick access. Estimation Software : Local developers often create specialized Excel-based software

The is responsible for the design, construction, and maintenance of public assets, including roads, bridges, and government buildings. For engineers, contractors, and consultants working on these projects, the Data Book is an indispensable reference tool, providing standardized data for estimating, costing, and analysis. A comprehensive Data Book in Excel format would

: For specific regional rates, you can find the PWD SoR - Kerala Forest Department listings, which are updated periodically.

[Kerala PWD Data Book Workbook] │ ├── Tab 1: Master Rate Index (Dynamic Prices for Cement, Steel, Labor, etc.) ├── Tab 2: Building Works (Excavation, Concrete, Masonry, Plastering) ├── Tab 3: Road and Highway Works (Sub-base, Bituminous Macadam, Asphalt) ├── Tab 4: Water Supply and Sanitary Installations └── Tab 5: Automated BOQ Calculator (User Input Interface) Typical Sheet Breakdown

Data for various grades of concrete (M15, M20, M25, etc.), including proportioning, mixing, laying, and curing.

If you can tell me you are preparing an estimate for (e.g., Road work, Building maintenance, Electrical work), I can help you locate the most relevant data. Share public link

Here is a sample Kerala PWD data book template in Excel format: