: It typically covers chapters such as Excavation, Brickwork, RCC Works, and Site Development.
Use formulas to multiply the Master Constants by the Live Market Rates.
: Many files are available through the Kerala PWD e-Knowledge Portal or specialized repositories like KSEB's Civil Works section . kerala+pwd+data+book+in+excel+format+new
An Excel data book automates time-consuming calculations for rate analysis, material constants, labor coefficients, and machinery costs. This comprehensive guide covers what the new format offers, how it operates, and how to use it to secure Kerala PWD tenders . 🛠 What is the Kerala PWD Data Book in Excel?
Traditionally, the data book was a 200+ page PDF or a printed hard copy. The offers transformative advantages: : It typically covers chapters such as Excavation,
The best way to use the spreadsheet is to keep a locked "master copy" and use a working copy for your specific project. In the working copy, update the table to reflect the current market prices. The formulas will cascade through the rest of the sheets and update the comprehensive item rates automatically. 3. Factor in Location and Terrain Modifiers
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 . An Excel data book automates time-consuming calculations for
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?
Navigate to the primary configuration sheet. Input your localized labor coefficients, basic material quotes, and specific material carriage values based on your project's distance from local supply hubs. 2. Configure Equipment Use Rates
: Defines the exact quantity of materials (cement, sand, steel, etc.) required for a unit volume or area of work. Equipment Use Rates