Project Management Articles

BOQ Format for Residential Building in Excel (Free Download)

Creating a well-structured BOQ in Excel for a residential building is essential for accurate project costing and management. Below is a guide for crafting an effective and professional BOQ format:

BOQ Structure

Header Section
The header should include essential project details:
- Project Name: “Residential Building Project”
- BOQ Reference Number
- Client Name
- Consultant/Contractor Details
- Date of Preparation
Column Headings
The following columns should be included in the BOQ Excel format:
- S.No.: Serial Number for tracking items
- Description of Work: Detailed description of each item
- Unit: Measurement unit (e.g., Sq. ft., Cu. m., Nos.)
- Quantity: Total quantity required
- Rate ($): Rate per unit
- Amount ($): Total cost (Quantity × Rate)
Main Categories of Work
Divide the BOQ into logical sections, such as:
- Preliminary Work
- Earthwork
- Concrete Work
- Masonry Work
- Flooring
- Plumbing
- Electrical Work
- Finishing

Sample BOQ Format in Excel

S.No.	Description of Work	Unit	Quantity	Rate ($)	Amount ($)
1	Site Clearance	Sq. m.	200	20	4,000
2	Excavation for Foundation	Cu. m.	50	150	7,500
3	PCC below Foundation	Cu. m.	10	4,000	40,000
4	RCC for Foundation	Cu. m.	8	6,500	52,000
5	Brick Masonry (230 mm thick)	Cu. m.	15	4,200	63,000
6	Plastering (Internal, 12 mm thick)	Sq. m.	100	180	18,000
Total					184,500

Features to Enhance the BOQ Excel File

Formulas: Use Excel formulas to automate calculations:
- Amount = Quantity × Rate
- Add a total amount field with =SUM(Amount Column).
Formatting:
- Apply borders for neatness.
- Use bold text for headings and totals.
- Apply conditional formatting to highlight high-cost items.
Dropdowns: Use dropdown menus for standardized unit entries (Sq. m., Cu. m., Nos.).
Notes Section: Add a section at the end for any remarks or terms & conditions.