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

Could you tell me a bit more about your upcoming project? I can provide you with: Strategies to calculate your local Guidance on preparing Non-Scheduled Items (NSI) Templates for tracking materials vs. PWD consumption norms

The PWD Data Book, often referred to along with the , contains the theoretical analysis of rates for various construction items. It breaks down the cost into: Material cost (Cement, steel, aggregate, etc.) Labor cost (Skilled, unskilled, technicians) Machinery/Equipment hire charges Overheads and Contractor’s Profit (OH & CP)

The primary source for the updated Data Book and Schedule of Rates is the official Kerala PWD website .

| Project ID | Milestones Achieved | Works Completed | Pending Works | | --- | --- | --- | --- | | P001 | 2/5 | 30% | 70% | | P002 | 5/5 | 100% | 0% | | P003 | 1/3 | 20% | 80% |

Here is a sample Excel sheet:

Estimators and contractors can typically download the latest Schedule of Rates (SOR) and Data Books from the official website. Additionally, regional engineering associations, engineering forums, and professional groups frequently share the unlocked, user-friendly Excel conversions to aid professionals in the field.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

When downloading an Excel file from a third-party engineering platform, always cross-verify a few random item codes and constants against the official Kerala PWD PDF to guarantee that the mathematical data has not been corrupted during conversion.

Excavation, embankment, backfilling, and soil stabilization. Mortar & Concrete kerala+pwd+data+book+in+excel+format+new

: The digital Data Book is often designed as an Excel-linked format where modifying one base rate (e.g., cement price) updates all related work estimates automatically.

: Covers clearing site, profiling, and earth excavation in all types of soils and rocks.

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

Kerala PWD Data Book in Excel Format: The Ultimate Guide to Modern Construction Estimation Could you tell me a bit more about your upcoming project

Create a separate, simple lookup table containing current material costs (per bag, ton, or cubic meter) and daily labor wages. Update only this sheet when market prices fluctuate.

Which specific (e.g., building masonry, road asphalt layers, or plumbing) do you need to format first?

Details of hourly or daily rental charges for machinery like mixers, vibrators, excavators, and dumpers. 5. Analysis Tabs (The Core Formula) These tabs calculate the cost per unit.