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

The Kerala Public Works Department (PWD) is a vital organization responsible for the construction, maintenance, and management of infrastructure projects in the state of Kerala, India. To facilitate efficient data management and analysis, a data book in Excel format can be a valuable resource. In this article, we will explore the concept of a Kerala PWD data book in Excel format and provide a comprehensive guide on how to create and utilize one.

| Column | Header Name | Description / Formula Logic | | :--- | :--- | :--- | | | Sl. No. | Serial Number of the item. | | B | Item Code | Unique PWD Code (e.g., PM 1.1.1 for Pre-mixed gravel). | | C | Category | E.g., Earthwork, Concrete, Steel, Wood, Roads. | | D | Description of Item | Full specification of the work item. | | E | Unit | Measurement unit (cu.m, sq.m, Kg, Each, etc.). | | F | Basic Rate (₹) | The raw rate found in the Data Book. | | G | Cost Index % | The percentage increase/decrease based on current GO (Government Order). | | H | Indexed Rate | =F + (F * G/100) or specific PWD indexation formula. | | I | Quantity | Input field (Used when linking to Abstract). | | J | Amount | =H * I | kerala+pwd+data+book+in+excel+format+new

provides a comprehensive list of standard data for various civil works, including roads, bridges, and buildings. While the official manual is frequently updated (most recently the Revised Edition 2021 ), the Excel version is preferred for its "linked format," which allows users to update market rates for labor and materials to automatically recalculate item costs. A standard Kerala PWD Data Book in Excel typically includes the following sheets: The Kerala Public Works Department (PWD) is a