Construction Planning and Scheduling Project

quantity.xlsx

Home >Engineering homework help >Civil Engineering homework help >Construction Planning and Scheduling Project

division 1

		quantity estimation of medical clinic
			division 2
sr no	Item	No	Length	Breadth	Height/depth	sq m	quantity
			foot	foot	foot
1	Subsurface investigation	1	44	0.9	0.75		29.7
2	site cleaning	1	44	0.9	0		39.6
3	excavation work	1	44	0.9	5		198
4	landscaping (romoval of unwanted plants)	1	41	58			2378
5	labour living space preparation	3	20	45	12		32400

Sheet1

		quantity calculation medical clinic
			Division 2 concrete
		quantity	sq m	Height	Breadth	length	No	Item	Sr no
		6998.4		3.6	3.6	540	1	excavation for foundation	1
length of long wall								L=c.l-width/2
								300-3.60/2=540
								B=0.150+90+0.15=1.1=3.60'
								H=0.20+0.30+0.3+0.3=1.1=3.60'
								B.B.C or P.C.C (1:4:8)	2
		848.49375		0.65	2.95	442.5	1	L=c.l-width/2
								300-2.95/2= 442.5
		564.7152		0.98	1.96	294	1	brick work in foundation	3
								1st step 1.96'
								L=c.l-width/2
								300-1.96/2= 294
		395.3712		0.98	1.64	246	1	2nd step( 1.64)
								L=c.l-width/2
								300-1.64/2= 246
							1	3rd step(0.40)
								L=c.l-width/2
		217.1325		0.85	1.31	195	1	300-1.31/2= 195
								Earth filling upto plinth	4
		1403.6		0.55	58	44	1	hospital area (44'*58')
								this area include every single room of hospital
								0.55 height is upto the plinth level
								D.P.C(DAMP PROOF COARSE) AT PLINTH LEVEL	5
								5CM=0.16'
								L=c.l-width/2*NO. OF JUNCTIONS
	m^2	255.45			1.31	195	1	300-1.31/2= 195*10

Sheet2

		quantity calculation medical clinic
			Division 3 masonary
quantity	sq m	Height	Breadth	length	No	Item	Sr no
14291.45856		9.84	0.984	1476	1	BRICK MASONARY IN SUPER STRUCTURE	1
						L=c.l-width/2
						300-9.84/2= 1476
						DEDUCTION OF DOOR AND WINDOWS	2
19.27656		6.53	0.984	3	1	D1(3'*6'8")
247.968		9	0.984	4	7	D2(4'*9')
478.224		9	0.984	6	9	D3(6'*9')
354.24		9	0.984	8	5	D4(8'*9')
123		5	0.984	5	5	w1(5'*5')
337.512		7	0.984	7	7	W2(7'*7')
88.56		5	0.984	6	3	W3(6'*5')
76.752		2	0.984	3	13	v1(3'*2')
1725.52
						Lintel quantity deduction	3
0.48708		0.15	0.984	3.3	1	D1(3'*6'8")
4.44276		0.15	0.984	4.3	7	D2(4'*9')
8.36892		0.15	0.984	6.3	9	D3(6'*9')
6.1254		0.15	0.984	8.3	5	D4(8'*9')
3.9114		0.15	0.984	5.3	5	w1(5'*5')
7.54236		0.15	0.984	7.3	7	W2(7'*7')
2.78964		0.15	0.984	6.3	3	W3(6'*5')
33.6675
						Brick work in super strucutre	4
						12532.3325
						This is the brick work after the deduction of lintel, doors & windows
6683.4		0.3	158	141	1	R.C.C SLAB	5
						L=141
						B=158
						H=0.3'
190.1088		1.4	0.984	138	1	BRICK work in parapet wall	6
						L=138' horizontal wall
216.2832		1.4	0.984	157	1	L=157' vertical wall
						plastering work [room wize]	7
						Waiting room ( 14'*15')	a
						horizontal wall
						vertical wall
						Doctor office(25'*15')	b
						horizontal wall
						vertical wall
						Operation theator(15'*15')	c
						horizontal wall
						vertical wall
						utility base(10'*10')	d
						horizontal wall
						vertical wall
						playroom(15'*12')	e
						horizontal wall
						vertical wall
						restroom(16'*19')	f
						horizontal wall
						vertical wall
						washroom(	g
						horizontal wall
						vertical wall
						break room	h
						horizontal wall
						vertical wall
						Examination room	i
						horizontal wall
						vertical wall
						Halls	j
						horizontal wall
						vertical wall
						reception office	k
						horizontal wall
						vertical wall
						admin office	l
						horizontal wall
						vertical wall
						x-ray laboratary	m
						horizontal wall
						vertical wall
						processing room	n
						horizontal wall
						vertical wall
						nurses office	o
						horizontal wall
						vertical wall

Sheet3

	quantity calculation
	division 4 paint
quantity	sq.m	height	breadth	length	No	item	sr no
						priamry coat of plaster of paris on the walls	1
						Waiting room ( 14'*15')	a
1.4		0.1		14	1	horizontal wall
1.5		0.1		15	1	vertical wall
						Doctor office(25'*15')	b
2.5		0.1		25	1	horizontal wall
1.5		0.1		15	1	vertical wall
						Operation theator(15'*15')	c
1.5		0.1		15	1	horizontal wall
1.5		0.1		15	1	vertical wall
						utility base(10'*10')	d
1		0.1		10	1	horizontal wall
1		0.1		10	1	vertical wall
						playroom(15'*12')	e
1.5		0.1		15	1	horizontal wall
1.2		0.1		12	1	vertical wall
						restroom(16'*19')	f
1.6		0.1		16	1	horizontal wall
1.9		0.1		19	1	vertical wall
						washroom(	g
0.8		0.1		8	1	horizontal wall
0.9		0.1		9	1	vertical wall
						break room	h
1.5		0.1		15	1	horizontal wall
1.9		0.1		19	1	vertical wall
						Examination room	i
4		0.1		40	1	horizontal wall
3.2		0.1		32	1	vertical wall
						Halls	j
1.2		0.1		12	1	horizontal wall
1		0.1		10	1	vertical wall
						reception office	k
1.5		0.1		15	1	horizontal wall
1.5		0.1		15	1	vertical wall
						admin office	l
1.6		0.1		16	1	horizontal wall
1.9		0.1		19	1	vertical wall
						x-ray laboratary	m
1.2		0.1		12	1	horizontal wall
1.3		0.1		13	1	vertical wall
						processing room	n
1.2		0.1		12	1	horizontal wall
1.2		0.1		12	1	vertical wall
		0.1				nurses office	o
1.4		0.1		14	1	horizontal wall
1.5		0.1		15	1	vertical wall
						coat of latex paint	2
1.4		0.1		14	1	Waiting room ( 14'*15')	a
1.5		0.1		15	1	horizontal wall
						vertical wall
2.5		0.1		25	1	Doctor office(25'*15')	b
1.5		0.1		15	1	horizontal wall
						vertical wall
1.5		0.1		15	1	Operation theator(15'*15')	c
1.5		0.1		15	1	horizontal wall
						vertical wall
1		0.1		10	1	utility base(10'*10')	d
1		0.1		10	1	horizontal wall
						vertical wall
1.5		0.1		15	1	playroom(15'*12')	e
1.2		0.1		12	1	horizontal wall
						vertical wall
1.6		0.1		16	1	restroom(16'*19')	f
1.9		0.1		19	1	horizontal wall
						vertical wall
0.8		0.1		8	1	washroom(	g
0.9		0.1		9	1	horizontal wall
						vertical wall
1.5		0.1		15	1	break room	h
1.9		0.1		19	1	horizontal wall
						vertical wall
4		0.1		40	1	Examination room	i
3.2		0.1		32	1	horizontal wall
						vertical wall
1.2		0.1		12	1	Halls	j
1		0.1		10	1	horizontal wall
						vertical wall
1.5		0.1		15	1	reception office	k
1.5		0.1		15	1	horizontal wall
						vertical wall
1.6		0.1		16	1	admin office	l
1.9		0.1		19	1	horizontal wall
						vertical wall
1.2		0.1		12	1	x-ray laboratary	m
1.3		0.1		13	1	horizontal wall
						vertical wall
1.2		0.1		12	1	processing room	n
1.2		0.1		12	1	horizontal wall
		0.1				vertical wall
1.4		0.1		14	1	nurses office	o
1.5		0.1		15	1	horizontal wall
0						vertical wall
0						final coat of sherwins william paint	3
0						Waiting room ( 14'*15')	a
1.4		0.1		14	1	horizontal wall
1.5		0.1		15	1	vertical wall
						Doctor office(25'*15')	b
2.5		0.1		25	1	horizontal wall
1.5		0.1		15	1	vertical wall
						Operation theator(15'*15')	c
1.5		0.1		15	1	horizontal wall
1.5		0.1		15	1	vertical wall
						utility base(10'*10')	d
1		0.1		10	1	horizontal wall
1		0.1		10	1	vertical wall
						playroom(15'*12')	e
1.5		0.1		15	1	horizontal wall
1.2		0.1		12	1	vertical wall
						restroom(16'*19')	f
1.6		0.1		16	1	horizontal wall
1.9		0.1		19	1	vertical wall
						washroom(	g
0.8		0.1		8	1	horizontal wall
0.9		0.1		9	1	vertical wall
						break room	h
1.5		0.1		15	1	horizontal wall
1.9		0.1		19	1	vertical wall
						Examination room	i
4		0.1		40	1	horizontal wall
3.2		0.1		32	1	vertical wall
						Halls	j
1.2		0.1		12	1	horizontal wall
1		0.1		10	1	vertical wall
						reception office	k
1.5		0.1		15	1	horizontal wall
1.5		0.1		15	1	vertical wall
						admin office	l
1.6		0.1		16	1	horizontal wall
1.9		0.1		19	1	vertical wall
						x-ray laboratary	m
1.2		0.1		12	1	horizontal wall
1.3		0.1		13	1	vertical wall
						processing room	n
1.2		0.1		12	1	horizontal wall
1.2		0.1		12	1	vertical wall
		0.1				nurses office	o
1.4		0.1		14	1	horizontal wall
1.5		0.1		15	1	vertical wall
						Painting the doors	4
						applying the potene to the doors for fineness
		20.1	6.7	3	1	D1(3'*6'8")
		252	9	4	7	D2(4'*9')
		486	9	6	9	D3(6'*9')
		360	9	8	5	D4(8'*9')
		125	5	5	5	w1(5'*5')
		343	7	7	7	W2(7'*7')
		90	5	6	3	W3(6'*5')
		78	2	3	13	v1(3'*2')
						Applying paint to the doors and windows	5
		20.1	6.7	3	1	D1(3'*6'8")
		252	9	4	7	D2(4'*9')
		486	9	6	9	D3(6'*9')
		360	9	8	5	D4(8'*9')
		125	5	5	5	w1(5'*5')
		343	7	7	7	W2(7'*7')
		90	5	6	3	W3(6'*5')
		78	2	3	13	v1(3'*2')
						Applying polish to the doors	6
		20.1	6.7	3	1	D1(3'*6'8")
		252	9	4	7	D2(4'*9')
		486	9	6	9	D3(6'*9')
		360	9	8	5	D4(8'*9')
		125	5	5	5	w1(5'*5')
		343	7	7	7	W2(7'*7')
		90	5	6	3	W3(6'*5')
		78	2	3	13	v1(3'*2')

Sheet4

quantity calculation
division 5 door window ceiling
quantity	sq.m	height	breadth	length	no	item	sr no
						Doors of inside buildings	1
20.1			6.7	3	1	D1(3'*6'8")
252			9	4	7	D2(4'*9')
486			9	6	9	D3(6'*9')
360			9	8	5	D4(8'*9')
125			5	5	5	w1(5'*5')
343			7	7	7	W2(7'*7')
90			5	6	3	W3(6'*5')
78			2	3	13	v1(3'*2')
22278			158	141	1	sill plate on all concrete surface	2
						L=141'
						B=158'
						wooden ceiling in everyroom	4
375			15	25	1	Waiting room ( 14'*15')
225			15	15	1	Doctor office(25'*15')
100			10	10	1	Operation theator(15'*15')
180			12	15	1	utility base(10'*10')
304			19	16	1	playroom(15'*12')
504			9	8	7	restroom(16'*19')
500			25	20	1	washroom(
285			19	15	1	break room
1280			32	40	1	Examination room
120			10	12	1	Halls
225			15	15	1	reception office
304			19	16	1	admin office
156			13	12	1	x-ray laboratary
144			12	12	1	processing room
210			15	14	1	nurses office

Sheet5

	quantity calculation
	division 6 wood work
quantity	sq.m	height	breadth	length	no	item	sr no
1350		2	5	9	15	wooden block of plywood in rooms	1
						applying plastic ply to doors to avoid moisture	2
3.9		6.5	0.2	3	1	D1(3'*6'8")
50.4		9	0.2	4	7	D2(4'*9')
97.2		9	0.2	6	9	D3(6'*9')
72		9	0.2	8	5	D4(8'*9')
						Rough carpentary	3
						sill plates all around the walls of room
375			15	25	1	Waiting room ( 14'*15')
225			15	15	1	Doctor office(25'*15')
100			10	10	1	Operation theator(15'*15')
180			12	15	1	utility base(10'*10')
304			19	16	1	playroom(15'*12')
504			9	8	7	restroom(16'*19')
500			25	20	1	washroom(
285			19	15	1	break room
1280			32	40	1	Examination room
120			10	12	1	Halls
225			15	15	1	reception office
304			19	16	1	admin office
156			13	12	1	x-ray laboratary
144			12	12	1	processing room
210			15	14	1	nurses office

Sheet6

quantity calculation
division 7 electronic work
quantity calculation	sq.m	height	breadth	length	no	item	sr no
						underground wiring in rooms	1
375			15	25	1	Waiting room ( 14'*15')
225			15	15	1	Doctor office(25'*15')
100			10	10	1	Operation theator(15'*15')
180			12	15	1	utility base(10'*10')
304			19	16	1	playroom(15'*12')
504			9	8	7	restroom(16'*19')
500			25	20	1	washroom(
285			19	15	1	break room
1280			32	40	1	Examination room
120			10	12	1	Halls
225			15	15	1	reception office
304			19	16	1	admin office
156			13	12	1	x-ray laboratary
144			12	12	1	processing room
210			15	14	1	nurses office
						electric bulbs and boards in each room	2
375			15	25	1	Waiting room ( 14'*15')
225			15	15	1	Doctor office(25'*15')
100			10	10	1	Operation theator(15'*15')
180			12	15	1	utility base(10'*10')
304			19	16	1	playroom(15'*12')
504			9	8	7	restroom(16'*19')
500			25	20	1	washroom(
285			19	15	1	break room
1280			32	40	1	Examination room
120			10	12	1	Halls
225			15	15	1	reception office
304			19	16	1	admin office
156			13	12	1	x-ray laboratary
144			12	12	1	processing room
210			15	14	1	nurses office
						elecctric fans in each rooms	3
375			15	25	1	Waiting room ( 14'*15')
225			15	15	1	Doctor office(25'*15')
100			10	10	1	Operation theator(15'*15')
180			12	15	1	utility base(10'*10')
304			19	16	1	playroom(15'*12')
504			9	8	7	restroom(16'*19')
500			25	20	1	washroom(
285			19	15	1	break room
1280			32	40	1	Examination room
120			10	12	1	Halls
225			15	15	1	reception office
304			19	16	1	admin office
156			13	12	1	x-ray laboratary
144			12	12	1	processing room
210			15	14	1	nurses office

Sheet7

quantity calculation
division 8 furnishing works
		quantity	sq.m	height	breadth	length	no	Item	sr no
								tiles	1
		210			15	14	1	Waiting room ( 14'*15')
		375			15	25	1	Doctor office(25'*15')
		225			15	15	1	Operation theator(15'*15')
		100			10	10	1	utility base(10'*10')
		180			12	15	1	playroom(15'*12')
		304			19	16	1	restroom(16'*19')
		504			9	8	7	washroom(
		500			25	20	1	break room
		285			19	15	1	Examination room
		1280			32	40	1	Halls
		120			10	12	1	reception office
		225			15	15	1	admin office
		304			19	16	1	x-ray laboratary
		156			13	12	1	processing room
		144			12	12	1	nurses office
	5122	210			15	14	1
								polishing of tiles	2
		375			15	25	1	Waiting room ( 14'*15')
		225			15	15	1	Doctor office(25'*15')
		100			10	10	1	Operation theator(15'*15')
		180			12	15	1	utility base(10'*10')
		304			19	16	1	playroom(15'*12')
		504			9	8	7	restroom(16'*19')
		500			25	20	1	washroom(
		285			19	15	1	break room
		1280			32	40	1	Examination room
		120			10	12	1	Halls
		225			15	15	1	reception office
		304			19	16	1	admin office
		156			13	12	1	x-ray laboratary
		144			12	12	1	processing room
	5122	210			15	14	1	nurses office
								placement of carpet in rooms	3
		375			15	25	1	Waiting room ( 14'*15')
		225			15	15	1	Doctor office(25'*15')
		100			10	10	1	Operation theator(15'*15')
		180			12	15	1	utility base(10'*10')
		304			19	16	1	playroom(15'*12')
		504			9	8	7	restroom(16'*19')
		500			25	20	1	washroom(
		285			19	15	1	break room
		1280			32	40	1	Examination room
		120			10	12	1	Halls
		225			15	15	1	reception office
		304			19	16	1	admin office
		156			13	12	1	x-ray laboratary
	4702	144			12	12	1	processing room
		210			15	14	1	nurses office
								wall paintings	5
								one wall in each room
		375			15	25	1	Waiting room ( 14'*15')
		225			15	15	1	Doctor office(25'*15')
		100			10	10	1	Operation theator(15'*15')
		180			12	15	1	playroom(15'*12')
		304			19	16	1	restroom(16'*19')
		504			9	8	7	break room
		500			25	20	1	Examination room
		120			10	12	1	Halls
		225			15	15	1	reception office
		304			19	16	1	admin office
		156			13	12	1	x-ray laboratary
		144			12	12	1	processing room
		210			15	14	1	nurses office
								curtains on windows	6
		125			5	5	5	w1(5'*5')
		343			7	7	7	W2(7'*7')
		90			5	6	3	W3(6'*5')