We use cookies to make your experience better. To comply with the new e-Privacy directive, we need to ask for your consent to set the cookies. Learn more.
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
A professional-grade PWD estimation workbook should be divided into clean, organized tabs to ensure smooth data flow and scannability:
Ensure all quantities (kg, m³, m²) match the official PWD specification book to avoid disputes. Conclusion kerala+pwd+data+book+in+excel+format+new
Utilizes VLOOKUP , XLOOKUP , or INDEX/MATCH functions to bridge the structural data entries directly with the active pricing index. Core Components of an Excel Rate Analysis Entry
Plain Cement Concrete (PCC), Reinforced Cement Concrete (RCC), mix designs. Brick & Stone Masonry Conclusion Utilizes VLOOKUP , XLOOKUP , or INDEX/MATCH
Instead of manually multiplying material constants by current market prices, Excel formulas ( =SUM , =PRODUCT , VLOOKUP ) automate the entire process. If the price of cement changes, updating one cell recalculates your entire project estimate instantly. 2. Seamless Integration with DSR and PRICE Software
: 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 If the price of cement changes, updating one
: Frequently hosts user-uploaded Excel templates and converted rate lists for recent years. Kerala Pwd Data Book In Excel Format - Google Docs 🌎 Kerala Pwd Data Book In Excel Format - Google Drive. Google Docs PWD Rates 2023-24 | PDF - Scribd