How to estimate building in excel with centerline method

In this construction video tutorial, you will learn to make complete estimation of a 3 rooms building with centerline method in excel.

The building plan includes the following items :-

One hall with size 6800 x 4000
One bed room with size 3500 x 3500
One kitchen with size 3000 x 3500
The size of the door is given by 1000 x 2000
The size of the window is given by 1200 x 1500

Details of centerline method: Center line method is very simple and the calculation can be done rapidly. Under this method, sum total length of centre lines of all walls, long and short should be determined. This method is ideal for the walls of similar cross sections. In this method, the total centre line is multiplied with breadth and depth of related item to provide the total quantity of each item.

Under this method, the length will remain equivalent for excavation in foundation, for concrete in foundation, for all footings and for super structure (with little variation where there exist cross walls or number of junctions).

It needs special attention and consideration at the junctions, intersecting points of partition or cross walls, etc. For rectangular, circular polygonal (hexagonal, octagonal etc) building without any inter or cross walls, this method is quite easy. For each junction half breadth of the relevant items or footings is should be deducted from the total centre length.

The following methods are generally applied for estimating the buildings :-

Also Read: Importance of center line method in estimation

Concrete work in foundation (center line and separate wall method)
Brickwork in footing (center line and separate wall method)

Brickwork in walls (center line and separate wall method)
Two rooms building
Concrete work in foundation (center line and separate wall method)

To learn how the calculation is done in excel, go through the following video tutorial.

Video Source: Engr WASEEM RAJA