RCC building Quantity Estimation Excel Sheet by Parag Pal.xlsx

	A	B	C	D	F	G	H	I	J	K	L	M
1	Abstract of Quantities for RCC building By Parag Pal

2
3	Sr.No.	Item Description	Unit	Quantity
4	1	Earthwork Excavation	cu.m.	33.75	Earthwork Excavation Quantity
5	2	PCC (1:4:8) for Foundations	cu.m.	2.03	Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
6	3	RCC - Foundations (Footings, Plinth Beams)	cu.m.	9.42	Excavation for isolated footings	10.00	1.50	1.50	1.50	33.75	cu.m.
7	4	RCC - Columns	cu.m.	3.94
8	5	RCC - Beams (Floor & Roof)	cu.m.	8.46					Total Excavation	33.75	cu.m.
9	6	RCC - Slabs (GF, FF, Roof, Staircase)	cu.m.	32.50
10	7	Brickwork (Net)	cu.m.	44.72	Plain Cement Concrete (PCC) Quantity
11	8	Plaster Work (Net Area)	sq.m.	1076.80	Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
12	9	Formwork (Shuttering)	sq.m.	460.00	PCC for isolated footings (1:4:8)	9.00	1.50	1.50	0.10	2.03	cu.m.
13
14									Total PCC	2.03	cu.m.
15
16
17					RCC Quantity - Foundations
18					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
19					RCC for isolated footings (M20)	9.00	1.20	1.20	0.40	5.18	cu.m.
20					RCC for Plinth Beams (M20)	1.00	46.00	0.23	0.40	4.23	cu.m.
21
22									Total RCC Foundations	9.42	cu.m.
23
24					RCC Quantity - Columns
25					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
26					RCC for Ground Floor Columns (M20)	9.00	0.23	0.30	3.48	2.16	cu.m.
27					RCC for First Floor Columns (M20)	9.00	0.23	0.30	2.88	1.79	cu.m.
28
29									Total RCC Columns	3.94	cu.m.
30
31					RCC Quantity - Beams (Floor & Roof)
32					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
33					RCC for GF Floor Beams (M20)	1.00	46.00	0.23	0.40	4.23	cu.m.
34					RCC for FF/Roof Beams (M20)	1.00	46.00	0.23	0.40	4.23	cu.m.
35
36									Total RCC Beams	8.46	cu.m.
37
38
39					RCC Quantity - Slabs
40					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
41					RCC for GF Slab (M20)	1.00	80.00	1.00	0.13	10.00	cu.m.
42					RCC for FF Slab (M20)	1.00	80.00	1.00	0.13	10.00	cu.m.
43					RCC for Roof Slab (M20)	1.00	80.00	1.00	0.13	10.00	cu.m.
44					RCC for Staircase (M20) - Lump Sum	2.50	0	0	0	2.50	cu.m.
45
46									Total RCC Slabs	32.50	cu.m.
47
48
49					Brickwork Quantity
50					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
51					GF External Walls (230mm)	1.00	36.00	0.23	2.60	21.53	cu.m.
52					GF Internal Walls (115mm)	1.00	30.00	0.12	2.60	8.97	cu.m.
53					FF External Walls (230mm)	1.00	36.00	0.23	2.60	21.53	cu.m.
54					FF Internal Walls (115mm)	1.00	30.00	0.12	2.60	8.97	cu.m.
55					Parapet Wall (115mm)	1.00	36.00	0.12	0.90	3.73	cu.m.
56					Deductions for Openings:
57					Doors Deduction (230mm walls)	-8.00	0.48	1.00	1.00	-8.00	cu.m.
58					Windows Deduction (230mm walls)	-12.00	0.41	1.00	1.00	-12.00	cu.m.
59
60									Net Brickwork	44.72	cu.m.
61
62
63					Plaster Quantity (Area)
64					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
65					Internal Wall Plaster (12mm)	499.20	1.00	1.00	1.00	499.20	sq.m.
66					External Wall Plaster (20mm)	475.20	1.00	1.00	1.00	475.20	sq.m.
67					Ceiling Plaster (6mm)	160.00	1.00	1.00	1.00	160.00	sq.m.
68					Deductions for Openings (single face):
69					Doors Deduction	-25.20	1.00	1.00	1.00	-25.20	sq.m.
70					Windows Deduction	-32.40	1.00	1.00	1.00	-32.40	sq.m.
71
72									Net Plaster Area	1076.80	sq.m.
73
74
75					Formwork Quantity (Area)
76					Item Description	Nos.	Length (m)	Breadth (m)	Height/Depth (m)	Quantity	Unit	Remarks
77					Formwork - Footings (sides)	17.28	1.00	1.00	1.00	17.28	sq.m.
78					Formwork - Columns (GF+FF)	60.58	1.00	1.00	1.00	60.58	sq.m.
79					Formwork - Beams (All)	142.14	1.00	1.00	1.00	142.14	sq.m.
80					Formwork - Slabs (Soffit)	240.00	1.00	1.00	1.00	240.00	sq.m.
81
82									Total Formwork Area	460.00	sq.m.
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100