Once you download the file, follow these three steps to customize it for your house plan:
Standard units (e.g., for concrete, Sqm for tiles, Kg for steel). D Quantity Calculated values based on architectural drawings. E Rate Unit price including materials and labor. F Amount Formula-driven: =D2*E2 . Advanced Reporting Tips for Excel: boq format for residential building in excel free download
The Excel file includes SUM formulas, so your "Total Amount" updates automatically. Once you download the file, follow these three
The template has a dedicated cell for "Wastage & Contingency." Always add this. If your total material cost is ₹20 Lakhs, add ₹1-2 Lakhs for price hikes and breakage. F Amount Formula-driven: =D2*E2
Once you download the free BOQ format for residential building, follow these steps to customize it for your project:
: Detailed explanation of the work (e.g., "Excavation for foundation in hard murum"). : Unit of measurement, such as for concrete, for plaster, or for steel. : The exact amount of work or material needed. : The cost per single unit of the item. : The total cost for that item, calculated as : Notes on specific conditions or assumptions. Typical Residential Work Categories