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.
The Kerala PWD Data Book is a foundational document specifying the exact quantities of materials, labor hours, and machinery run-time required to complete a single unit of a construction item (e.g., one cubic meter of concrete or one square meter of plastering).
: 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
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
The data book functions alongside the standard . While the SoR contains volatile market prices for materials and labor, the Data Book contains fixed engineering coefficients. For example, if a specific grade of concrete requires a set amount of cement, that physical quantity is detailed in the Data Book. The current monetary cost of that cement is pulled directly from the current year's SoR. Why Use the Excel Linked Format? kerala+pwd+data+book+in+excel+format+new
Projects: ProjectID, ProjectName, Type, District, Taluk, Panchayat, Latitude, Longitude, StartDate, ExpectedEndDate, Status, ContractorID, SanctionAmount, ExpenditureToDate
Base labor daily wages, unit material costs, basic plant hire costs. Ground & Site Preparation
This comprehensive guide will cover what the Data Book is, why the Excel format is revolutionary, what you’ll find inside, and where you can get the latest version.
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 Dedicate the very first tab of your workbook
In this final sheet, you import the quantities measured from your architectural blueprints. Excel multiplies your project's specific quantities by the automated rates calculated in Tab 2, delivering your final, comprehensive project cost. Adapting to Modern Standards: PRICE Software Integration
The release of the 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%.
: Standardized percentages added to the basic cost to cover administrative costs and contractor profits. old.kseb.in Accessing Excel Formats
| 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 | Official Access via PRICE Software The Kerala PWD
The transition to dynamic Excel workbooks solves several limitations found in traditional paper or PDF documentation. Automatic Dynamic Linking
are frequently hosted on platforms like Google Drive for quick access. Estimation Software : Local developers often create specialized Excel-based software
: Lists specific categories of workers (skilled, semi-skilled, and unskilled) and their daily output norms. Material Quantities