Building Estimation Step by Step In Excel Sheet

Dear friend, we work building quantity calculation in manual in a paper, So now going we area in how to Calculate in Excel use a long wall and short wall method.

Because of this method, very easy all methods like Centre Line Method & Crossing Method. And mostly Billing Engineer and Quantity Surveyor use this method.

In this article, we calculate step by calculation as below.

Table of Contents

Following Quantities are calculated to Estimate

1. Excavation

2. Footing P.C.C.

3. Footing R.C.C.

4. Column up to Plinth Level R.C.C.

5. Backfilling

6. Plinth Beam R.C.C.

7. Grae Slab R.C.C.

8. Column Up to Slab Level R.C.C.

9. Brick Masonry

10. In Side Plaster

11. Out Side Plaster

12. Celling Plaster

13. Slab R.C.C.

14. In Side Paint

15. Out Side Pint

Building Estimate Format in Excel – Download link

Also, read: How to Find House Construction Cost

How to Find Excavation as Per Drawing

Footing excavation work needs sum drawing like Footing location Drawing and Section Drawing. All drawing as per below, please see

Section A-A

Footing Location

In this plan, 11 footings as per drawing.

Length = 0.6m + 1.0m + 0.6m = 2.20m

Here 0.6 m is working space in footing for both sides.

And,1.0 m = footing size

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
1	Earthwork in Excavation in Foundation:
	Footing (1m x 1m)	11	2.200	2.200	1.580	84.12	Cu.m.
	Depth From GL = 0.6 + 1 + 0.6
	0.6 =Extra For working space
		Total Qty=				84.12	Cu.m.

Also, read: What Is Slab Beam / Hidden Beam / Concealed Beam | Advantage and Disadvantage

How to Find Footing P.C.C. as Per Drawing

In this plan, 11 footings as per drawing.

Length = 0.15m + 1.0m + 0.15m = 1.30m

Here 0.15 m = P.C.C. working space in footing, for both side

And,1.0 m = footing size

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
2	Footing P.C.C.
	Footing (1m x 1m)	11	1.300	1.300	0.075	1.39	Cu.m.
	Thickness = 0.075
	D = 0.150 + 1.0 + 0.150
		Total Qty=				1.39	Cu.m.

How to Find Footing R.C.C. as Per Drawing

In this plan, 11 footings as per drawing.

Length = 1.0m = 1.0m

Here Height = 0.450 m

And, 1.0 m = footing size

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
3	Footing R.C.C.
	Base(1m x 1m)	11	1.000	1.000	0.450	4.95	Cu.m.
	Thickness = 0.450
		Total Qty=				4.95	Cu.m.

Also, read: Difference Between CPM and PERT/PERT Vs CPM | What Is CPM & PERT

How to Find Column up to Plinth Level R.C.C. as Per Drawing

In this plan, 11 footings as per drawing.

Length = 0.230 m, Breadth = 0.230 m

Here Height = 1.05 m

Section A-A

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
4	Column up to Plinth Level R.C.C.
	Column	11	0.230	0.230	1.050	0.61	Cu.m.
		Total Qty=				0.61	Cu.m.

How to Find Backfilling as Per Drawing

Footing backfilling qty for 11 Qty

Length & Breadth = 2.2 m, Height Footing Bottom to ground level = 1.580 mm

Backfilling = Excavation – Footing P.C.C – Column R.C.C

Plinth Beam Backfilling

Height of backfilling = 0.600 m

Total plinth beam backfilling = Total Area – Plinth beam

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
5	BackFilling
5.a	Backfilling In Footing
	Excavation Area	11	2.200	2.200	1.580	84.12	Cu.m.
	Deduction
	Footing P.C.C.	-11	1.300	1.300	0.075	-1.39	Cu.m.
	Footing R.C.C.	-11	1.000	1.000	0.450	-4.95	Cu.m.
	Footing Column	-11	0.230	0.230	1.050	-0.61	Cu.m.
		5.a Total Qty=				77.16	Cu.m.
5.b	Plinth Beam Backfilling
	Plinth area out to out	1	10.240	7.690	0.600	47.25	Cu.m.
	Deduction
	L-1	-3	10.240	0.230	0.600	-4.24	Cu.m.
	L-2	-4	3.000	0.230	0.600	-1.66	Cu.m.
	L-3	-3	4.000	0.230	0.600	-1.66	Cu.m.
	L-4	-1	1.500	0.230	0.600	-0.21	Cu.m.
	L-5	-1	2.315	0.230	0.600	-0.32	Cu.m.
		5.b Total Qty=				39.17	Cu.m.
		5.a + 5.b Total Qty=				116.33	Cu.m.

Also, read, Rate Analysis of Brick Masonry

How to Find Plinth Beam R.C.C. as Per Drawing

Lintel Beam

As per lintel beam drawing, L-1 = 3 nos., L-2 = 4 nos., L-3 = 3 nos., L- 4 = 1 nos, L-5 = 1 nos of qty and length

and beam size = 0.230 m x 0.600 m

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
6	Plinth Beam R.C.C.
	Beam (230 mm x 600 mm)
	L-1	3	10.240	0.230	0.600	4.24	Cu.m.
	L-2	4	3.000	0.230	0.600	1.66	Cu.m.
	L-3	3	4.000	0.230	0.600	1.66	Cu.m.
	L-4	1	1.500	0.230	0.600	0.21	Cu.m.
	L-5	1	2.315	0.230	0.600	0.32	Cu.m.
		Total Qty=				0.32	Cu.m.

How to Find Grae Slab RCC as Per Drawing

Grae Slab RCC = ( Total Length x Total Breadth x Thickness ) – Column

Grae Slab RCC = ( 10.240 x 7.690 x 0.100 ) – ( 11 x 0.230 x 0.230 x 0.100)

Grae Slab RCC = ( 7.87 ) – (0.06)

Grae Slab RCC = 7.82 Cu.m.

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
7	Grae Slab R.C.C.
	Plinth area out to out	1	10.240	7.690	0.100	7.87	Cu.m.
	Deduction
	Column	-11	0.230	0.230	0.100	-0.06	Cu.m.
		Total Qty=				7.82	Cu.m.

How to Find Grae Slab RCC as Per Drawing

Column Length & Breadth= 0.230 m

Height = Ground Slab – Ground Floor – Slab Beam

Height = 3 – 0 – 0.350 = 2.650 m

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
8	Column Up to Slab Level R.C.C.
	Column	11	0.230	0.230	2.650	1.54	Cu.m.
		Total Qty=				1.54	Cu.m.

Also, read: What Is Floating Slab| Floating Slab Construction | How to Build a Floating Slab | Advantages & Disadvantages Floating Slabs

How to Find Brick Masonry as Per Drawing

Plan

Elevation

Section

Brick masonry calculation uses a Long wall and Short wall method

All length as per drawing and height = 3.00 m – 0.35 m = 2.65 m.

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
9	Brick Masonry
	230 mm thick wall Brick Masonry
	Long Wall	3	10.240	0.230	2.650	18.72	Cu.m.
	Shot wall-1	3	3.000	0.230	2.650	5.49	Cu.m.
	Shot wall-1	1	3.000	0.230	1.200	0.83	Cu.m.
	Shot Wall-2	3	4.000	0.230	2.650	7.31	Cu.m.
	Deduction
	Column	-11	0.230	0.230	2.650	-1.54	Cu.m.
	Window W	-2	2.000	0.230	1.200	-1.10	Cu.m.
	Window W1	-2	1.500	0.230	1.200	-0.83	Cu.m.
	Window W2	-3	1.200	0.230	1.200	-0.99	Cu.m.
	Window W3	-1	1.200	0.230	1.500	-0.41	Cu.m.
	Door o	-2	1.200	0.230	2.100	-1.16	Cu.m.
	Door D	-1	1.200	0.230	2.100	-0.58	Cu.m.
	Door D1	-1	1.000	0.230	2.100	-0.48	Cu.m.
	Door MS	-1	2.000	0.230	1.200	-0.55	Cu.m.
	Vent	-1	0.900	0.230	0.600	-0.12	Cu.m.
	Vent V1	-1	0.600	0.230	0.600	-0.08	Cu.m.
		Total Qty 230 mm Thick Wall=				24.49	Cu.m.
	115 mm thick wall Brick Masonry
	Bath Room	1	1.500	0.115	2.650	0.46	Cu.m.
	Passage wall	1	2.315	0.115	2.650	0.71	Cu.m.
	Deduction
	Door D2	-2	0.750	0.115	2.100	-0.36	Cu.m.
	Parapet Wall
	Long Wall	2	10.240	0.115	1.000	2.36	Cu.m.
	Shot Wall	2	7.460	0.115	1.000	1.72	Cu.m.
		Total Qty 115 mm Thick Wall=				4.87	Cu.m.

How to Find In Side Plaster as Per Drawing

Sum Note Point for deduction

1. 0.5 sq.m. below section is a full deduction

2. 0.5 sq.m. to 3.0 sq.m. between half deduction in area

3. 3.0 sq.m above full deduction but add side pattas

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
10	In Side Plaster
	Bed Room
	Long Wall	2	4.000		3.000	24.00	Sq.m.
	Shot wall	2		3.000	3.000	18.00	Sq.m.
	Deduction
	Door D1	-0.5	1.000		2.100	-1.05	Sq.m.
	Window W2	-0.5	1.200		1.000	-0.60	Sq.m.
	Window W3	-0.5	1.200		1.200	-0.72	Sq.m.
	Kitchen + Dining
	Long Wall	2	4.000		3.000	24.00	Sq.m.
	Shot wall	2		4.000	3.000	24.00	Sq.m.
	Deduction
	Door O	-0.5	1.200		2.100	-1.26	Sq.m.
	Window W2	-1	1.200		1.000	-1.20	Sq.m.
	Verandah
	Long Wall	2	3.000		3.000	18.00	Sq.m.
	Shot wall	1		3.000	3.000	9.00	Sq.m.
	Shot wall	1		3.000	1.200	3.60	Sq.m.
	Deduction
	Door MS	-0.5	1.200		1.200	-0.72	Sq.m.
	Door D	-0.5	1.200		2.100	-1.26	Sq.m.
	Window W	-0.5	2.000		1.200	-1.20	Sq.m.
	DRG. Room
	Long Wall	2	5.550		3.000	33.30	Sq.m.
	Shot wall	2		4.000	3.000	24.00	Sq.m.
	Deduction
	Door O	-1	1.200		2.100	-2.52	Sq.m.
	Door D	-0.5	1.200		1.200	-0.72	Sq.m.
	Window W	-0.5	2.000		1.200	-1.20	Sq.m.
	Window W1	-1	1.500		1.200	-1.80	Sq.m.
	Bath Room
	Long Wall	2	1.500		3.000	9.00	Sq.m.
	Shot wall	2		1.200	3.000	7.20	Sq.m.
	Deduction
	Door D2	-0.5	0.750		2.100	-0.79	Sq.m.
	Vent V1	-0.5	0.900		0.600	-0.27	Sq.m.
	W.C.
	Long Wall	2	1.500		3.000	9.00	Sq.m.
	Shot wall	2		1.000	3.000	6.00	Sq.m.
	Deduction
	Door D2	-0.5	0.750		2.100	-0.79	Sq.m.
	Vent	-0.5	0.600		0.600	-0.18	Sq.m.
	Passage
	Long Wall	2	2.320		3.000	13.92	Sq.m.
	Shot wall	2		1.390	3.000	8.34	Sq.m.
	Deduction
	Door D2	-1	0.750		2.100	-1.58	Sq.m.
	Door D1	-1	1.000		2.100	-2.10	Sq.m.
	Door O	-1	1.200		2.100	-2.52	Sq.m.

		Total Qty In Side Plaster=				208.89	Sq.m.

How to Find Out Side Plaster as Per Drawing

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
11	Out Side Plaster
	Front Side	1	4.450		4.775	21.25	Sq.m.
		1	3.230		2.180	7.04	Sq.m.
	Lintel W	1	2.000	1.300		2.60	Sq.m.
	Deduction
	Door MS	-0.5	1.200		1.200	-0.72	Sq.m.
	Window W	-0.5	2.000		1.200	-1.20	Sq.m.
	Back Side	1	7.690		4.775	36.72	Sq.m.
	Lintel W 2	2	1.200	1.300		3.12	Sq.m.
	Deduction
	Window W 2	-1	1.200		1.000	-1.20	Sq.m.
	Right Side	1	10.240		4.775	48.90	Sq.m.
	Deduction
	Window W	-0.5	2.000		1.200	-1.20	Sq.m.
	Window W 3	-0.5	1.200		1.200	-0.72	Sq.m.
	Vent	-0.5	0.600		0.600	-0.18	Sq.m.
	Vent V1	-0.5	0.900		0.600	-0.27	Sq.m.
	Left Side	1	10.240		4.775	48.90	Sq.m.
	Deduction
	Window W 1	-1	1.500		1.200	-1.80	Sq.m.
	Window W 2	-0.5	1.200		1.000	-0.60	Sq.m.
	Parapet Wall
	Long Wall	2	10.010		1.115	22.32	Sq.m.
	Shot Wall	2		7.460	1.000	14.92	Sq.m.
		Total Out Side Plastet Qty =				197.87	Sq.m.

How to Find Celling Plaster as Per Drawing

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
12	Celling Plaster
	Bed Room	1	4.000	3.000		12.00	Sq.m.
	Kitchen + Dining	1	4.000	4.000		16.00	Sq.m.
	Verandah	1	3.000	3.000		9.00	Sq.m.
	DRG. Room	1	5.550	4.000		22.20	Sq.m.
	Bath Room	1	1.500	1.200		1.80	Sq.m.
	W.C	1	1.500	1.000		1.50	Sq.m.
	Passage	1	2.320	1.390		3.22	Sq.m.
		Total Out Side Plastet Qty =				65.72	Sq.m.

How to Find In Out Side Plaster as Per Drawing

Slab Beam

Section

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
13	Slab RCC
	Slab Area	1	10.240	7.690	0.100	7.87	Cu.m.
	S-1	3	10.240	0.230	0.350	2.47	Cu.m.
	S-2	4	3.000	0.230	0.350	0.97	Cu.m.
	S-3	3	4.000	0.230	0.350	0.97	Cu.m.
	S-4	1	1.500	0.230	0.350	0.12	Cu.m.
	S-5	1	2.315	0.230	0.350	0.19	Cu.m.
		Total RCC Slab Qty=				12.59	Cu.m.

How to Find In Side Paint as Per Drawing

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
14	In Side Paint
	Bed Room
	Long Wall	2	4.000		3.000	24.00	Sq.m.
	Shot wall	2		3.000	3.000	18.00	Sq.m.
	Bed Room Ceiling	1	4.000	3.000		12.00	Sq.m.
	Deduction
	Door D1	-1	1.000		2.100	-2.10	Sq.m.
	Window W2	-1	1.200		1.000	-1.20	Sq.m.
	Window W3	-1	1.200		1.200	-1.44	Sq.m.
	Kitchen + Dining
	Long Wall	2	4.000		3.000	24.00	Sq.m.
	Shot wall	2		4.000	3.000	24.00	Sq.m.
	Kitchen + Dining Celling	1	4.000	4.000		16.00	Sq.m.
	Deduction
	Door O	-1	1.200		2.100	-2.52	Sq.m.
	Window W2	-2	1.200		1.000	-2.40	Sq.m.
	Verandah
	Long Wall	2	3.000		3.000	18.00	Sq.m.
	Shot wall	1		3.000	3.000	9.00	Sq.m.
	Shot wall	1		3.000	1.200	3.60	Sq.m.
	Verandah Celling	1	3.000	3.000		9.00	Sq.m.
	Deduction
	Door MS	-1	1.200		1.200	-1.44	Sq.m.
	Door D	-1	1.200		2.100	-2.52	Sq.m.
	Window W	-1	2.000		1.200	-2.40	Sq.m.
	DRG. Room
	Long Wall	2	5.550		3.000	33.30	Sq.m.
	Shot wall	2		4.000	3.000	24.00	Sq.m.
	DRG. Room Ceiling	1	5.550	4.000		22.20	Sq.m.
	Deduction
	Door O	-2	1.200		2.100	-5.04	Sq.m.
	Door D	-1	1.200		1.200	-1.44	Sq.m.
	Window W	-1	2.000		1.200	-2.40	Sq.m.
	Window W1	-2	1.500		1.200	-3.60	Sq.m.
	Bath Room
	Long Wall	2	1.500		3.000	9.00	Sq.m.
	Shot wall	2		1.200	3.000	7.20	Sq.m.
	Bath Room Ceiling	1	1.500	1.200		1.80	Sq.m.
	Deduction
	Door D2	-1	0.750		2.100	-1.58	Sq.m.
	Vent V1	-1	0.900		0.600	-0.54	Sq.m.
	W.C.
	Long Wall	2	1.500		3.000	9.00	Sq.m.
	Shot wall	2		1.000	3.000	6.00	Sq.m.
	W.C Celling	1	1.500	1.000		1.50	Sq.m.
	Deduction
	Door D2	-1	0.750		2.100	-1.58	Sq.m.
	Vent	-1	0.600		0.600	-0.36	Sq.m.
	Passage
	Long Wall	2	2.320		3.000	13.92	Sq.m.
	Shot wall	2		1.390	3.000	8.34	Sq.m.
	Passage Celling	1	2.320	1.390		3.22	Sq.m.
	Deduction
	Door D2	-2	0.750		2.100	-3.15	Sq.m.
	Door D1	-2	1.000		2.100	-4.20	Sq.m.
	Door O	-2	1.200		2.100	-5.04	Sq.m.
		Total Qty In Side Plaster=				252.14	Sq.m.

How to Find Out Side Plaster as Per Drawing

QUANTITY SHEET
Sr. No.	Item Description	No.	Length (m)	Widht/ Breadth (m)	Height/ Depth (m)	Quantity	Unit
15	Out Side Plaster
	Front Side	1	4.450		4.775	21.25	Sq.m.
		1	3.230		2.180	7.04	Sq.m.
	Lintel W	1	2.000	1.300		2.60	Sq.m.
	Deduction
	Door MS	-1	1.200		1.200	-1.44	Sq.m.
	Window W	-1	2.000		1.200	-2.40	Sq.m.
	Back Side	1	7.690		4.775	36.72	Sq.m.
	Lintel W 2	2	1.200	1.300		3.12	Sq.m.
	Deduction
	Window W 2	-1	1.200		1.000	-1.20	Sq.m.
	Right Side	1	10.240		4.775	48.90	Sq.m.
	Deduction
	Window W	-1	2.000		1.200	-2.40	Sq.m.
	Window W 3	-1	1.200		1.200	-1.44	Sq.m.
	Vent	-1	0.600		0.600	-0.36	Sq.m.
	Vent V1	-1	0.900		0.600	-0.54	Sq.m.
	Left Side	1	10.240		4.775	48.90	Sq.m.
	Deduction
	Window W 1	-2	1.500		1.200	-3.60	Sq.m.
	Window W 2	-1	1.200		1.000	-1.20	Sq.m.
	Parapet Wall
	Long Wall	2	10.010		1.115	22.32	Sq.m.
	Shot Wall	2		7.460	1.000	14.92	Sq.m.
		Total Out Side Plastet Qty =				191.18	Sq.m.

Like this post? Share it with your friends!

Suggested Read –