Building Estimation sheet by Parag Pal.xlsx

	A	B	C	D	E	F
1		BUILDING QUANTITY ESTIMATION & RATE ANALYSIS By Parag Pal Visit: www.civilnotess.com

2	Input data	As per Indian Standards (IS Codes)
3	Earthwork
4	Sub Structure	PROJECT DETAILS
5	Super Strucuture	Project Name:	Sample Project
6	Masonary	Location:	City Name
7	Plaster	Date:	2024-01-01
8	Painting	Engineer Name:	Engineer Name
9	Doors and Window
10	Rate Analysis format
11	Standard Rates
12	Cost Abstract Form	BUILDING DIMENSIONS
13		Description	Symbol	Value	Unit	Remarks
14		Total Plinth Area	A_plinth	150	sq.m
15		Building Length	L	5	m
16		Building Width	B	10	m
17		Ground Floor Height	H_gf	4	m	Floor to floor
18		First Floor Height	H_ff	3	m	Floor to floor
19		Number of Floors	N_floors	2
20		Parapet Height	H_parapet	1	m
21
22
23		FOUNDATION PARAMETERS
24		Number of Footings	N_footings	12	nos
25		Footing Length (avg)	L_ftg	2	m
26		Footing Width (avg)	B_ftg	2	m
27		Footing Depth	D_ftg	0	m
28		PCC Thickness	T_pcc	0	m	Plain cement concrete
29		Plinth Beam Depth	D_pb	0	m
30		Plinth Beam Width	B_pb	0	m
31		Total Plinth Beam Length	L_pb_total	50	m
32		Excavation Depth	D_exc	2	m	Below NGL
33		Sand Filling Thickness	T_sand	0	m
34
35
36
37		STRUCTURAL PARAMETERS
38		Number of Columns	N_col	12	nos
39		Column Size	Col_size	230x300	mm	e.g. 230x300
40		Column Height (per floor)	H_col	3	m
41		Total Beam Length	L_beam_total	80	m	All beams
42		Beam Depth (avg)	D_beam	0	m
43		Beam Width (avg)	B_beam	0	m
44		Slab Area (per floor)	A_slab	140	sq.m
45		Slab Thickness	T_slab	0	m
46		Lintel Depth	D_lintel	0	m
47		Lintel Width	B_lintel	0	m
48		Total Lintel Length	L_lintel	30	m
49
50		MASONRY & FINISHING
51		External Wall Length	L_wall_ext	50	m
52		Internal Wall Length	L_wall_int	80	m
53		Wall Height (avg)	H_wall	3	m
54		External Wall Thickness	T_wall_ext	0	m	230mm or 115mm
55		Internal Wall Thickness	T_wall_int	0	m	115mm or 100mm
56		Plaster Thickness (internal)	T_plaster_int	0	m	12mm or 15mm
57		Plaster Thickness (external)	T_plaster_ext	0	m	15mm or 20mm
58		Floor Finish Area	A_floor	140	sq.m
59		Flooring Thickness	T_floor	0	m
60		Ceiling Area	A_ceiling	140	sq.m
61		Roof Slab Area	A_roof	145	sq.m
62
63
64		DOORS & WINDOWS
65		Number of Doors (main)	N_door_main	2	nos
66		Main Door Size	Door_main	1.2x2.1	m	e.g. 1.2x2.1
67		Number of Doors (internal)	N_door_int	8	nos
68		Internal Door Size	Door_int	0.9x2.1	m	e.g. 0.9x2.1
69		Number of Windows	N_window	12	nos
70		Window Size (avg)	Window_size	1.2x1.5	m	e.g. 1.2x1.5
71		Ventilator Count	N_vent	6	nos
72		Ventilator Size	Vent_size	0.6x0.6	m	e.g. 0.6x0.6
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100