Pump Sizing Calculation 1.xlsx

	B	C	D	E	F	G	J	K	L	M	N	O	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU
1
2		PUMP SIZING CALCULATION
3	MEPengineersclub.com							Tag No.		P-101				Suction Calculations				Outlet Calculations					Head Equation (2nd Order Curve Fitting)
4	MEP Engineers Club Spreadsheets							Description		Feed Pump													-0.001995719443	-0.1006603792	149.9347963
5								Date		05-March-2023				Selected ID		9		Selected ID		6			0.000008902103279	0.001984773194	0.08344841026
6	User Input		1.000					By		Qasim Ibrar				Selected Schedule		7		Selected Schedule		7			0.9999952288	0.1051910702	#N/A	ty
7														Pipe ID Selected		7.981	inch	Pipe ID Selected		3.068	inch
8																7.981	inch			3.068	inch		Efficiency Equation (2nd Order Curve Fitting)
9														Area		0.3474	ft2	Area		0.0513	ft2		-0.001745813345	0.4234484427	20.13677892
10	Flowrate			120.0	US gpm									Velocity		0.770	ft/s	Velocity		5.208	ft/s		0.00001563344017	0.003485562006	0.1465480334
11	Density			62.40	lb/ft3									Re		47530		Re		123643			0.999552324	0.1847314337	#N/A
12	Viscosity			1.00	cP									e/D		0.0002255356472		e/D		0.0005867014342
13	Vapor Pressure			15.0	psia									A		1.30E+20		A		3.43E+20			System Curve (2nd Order Curve Fitting)
14														B		0.02		B		0.00			0.0007770540709	0.009953142834	100.7951954
15	Differential DP			49.30	psi									f		0.0245		f		0.0217			0.000001700219828	0.0003169886491	0.01231220806
16	Differential Head			113.9	ft									DP1		0.015	psi/100ft	DP		1.548	psi/100ft		0.9999948564	0.02062673775	#N/A
17	Hydraulic power			3.45	bhp									Pressure		22.14	psi	Pressure		71.44
18	NPSH available			16.5	ft																		Solution of System & Head Curve						Efficiency	45.74	%
19																							-0.002772773514	-0.1106135221	49.13960097
20	Suction Condition						Discharge Condition							Curve Fitting					Maximum Flow		180
21	Pressure		P1	25.0	psia		Pressure		P2	50.0	psia								Division		20		Determinant		0.5572472875	TRUE	0.7464899782			X	Y
22	Static Head		h1	5.0	ft		Static Head		h2	25.0	ft			Flow	Head	Efficiency			Increment		9		Roots		-154.5570702	114.66				114.664	0
23	Equipment DP			5.0	psi		Equipment DP			5.0	psi		1	0.0	150.0	20.0							Selected Flow		114.664	GPM	Head	112.15	ft	114.664	112.15
24	Misc DP			0.0	psi		Misc DP			0.0	psi		2	20.0	147.0	28.0				Suction Pipe
25													3	50.0	140.0	37.0			Flow	Velocity	Reynold	A	B	f	DP1	Elb, 90LR	Elb, 45LR	Tees, Thru	Tees, Bran	Ball	Butterfly	Gate	Globe	Check	Plug	Pipe	Sum K	DP	Suct P	Diff P	System Curve	Pump Head	Efficiency %
26	Piping						Piping						4	80.0	129.0	43.0			GPM	ft/s						1	1	1	1	0	0	1	0	0	0	1							%
27	Length		L1	120.0	ft		Length		L2	300.0	ft		5	100.0	120.0	45.0		1	0.0	0.000	0	0.00E+00	0.00E+00	0.0000	0.000	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	22.16	43.66	100.9	149.9	20.14
28	Pipe Diameter			8	inch		Pipe Diameter			3	inch		6	150.0	90.0	44.0		2	9.0	0.058	3565	1.62E+18	2.28E+16	0.0423	0.000	0.45	0.31	0.60	1.12	0.31	0.51	0.20	4.92	2.11	0.56	0.54	3.23	0.00	22.16	43.70	101.0	148.9	23.81
29	Sch/ Thick			40			Sch/ Thick			40			7	180.0	67.0	40.0		3	18.0	0.115	7129	8.47E+18	3.48E+11	0.0344	0.000	0.34	0.24	0.58	1.01	0.24	0.39	0.15	4.71	1.90	0.42	0.52	2.85	0.00	22.16	43.81	101.2	147.5	27.19
30	Pipe ID		ID1	7.981	inch		Pipe ID		ID2	3.068	inch		8	200.0	50.0	35.0		4	27.0	0.173	10694	2.05E+19	5.29E+08	0.0308	0.001	0.30	0.22	0.58	0.98	0.22	0.36	0.14	4.64	1.83	0.37	0.51	2.72	0.00	22.16	43.99	101.6	145.8	30.30
31													9	200.0	50.0	35.0		5	36.0	0.231	14259	3.70E+19	5.30E+06	0.0287	0.002	0.28	0.20	0.57	0.96	0.20	0.34	0.13	4.61	1.79	0.35	0.51	2.66	0.00	22.16	44.21	102.1	143.7	33.12
32	Roughness			0.0018	inch		Roughness			0.0018	inch		10	200.0	50.0	35.0		6	45.0	0.289	17824	5.73E+19	1.49E+05	0.0271	0.002	0.27	0.20	0.57	0.95	0.20	0.33	0.13	4.59	1.77	0.34	0.51	2.62	0.00	22.16	44.50	102.8	141.4	35.66
33																		7	54.0	0.346	21388	8.09E+19	8.08E+03	0.0260	0.003	0.26	0.19	0.57	0.94	0.19	0.32	0.13	4.57	1.76	0.33	0.51	2.60	0.00	22.16	44.84	103.6	138.7	37.91
34	Fittings			No.	K	DP	Fittings			No.	K	DP						8	63.0	0.404	24953	1.07E+20	6.86E+02	0.0251	0.004	0.26	0.19	0.57	0.93	0.19	0.31	0.12	4.56	1.75	0.32	0.51	2.58	0.00	22.16	45.24	104.5	135.7	39.88
35	Elbows, 90LR			1	0.24	0.00	Elbows, 90LR			1	0.27	0.05						9	72.0	0.462	28518	1.36E+20	8.09E+01	0.0243	0.005	0.25	0.19	0.57	0.93	0.19	0.31	0.12	4.55	1.74	0.32	0.51	2.56	0.00	22.15	45.69	105.5	132.3	41.57
36	Elbows, 45LR			1	0.18	0.00	Elbows, 45LR			1	0.20	0.04						10	81.0	0.519	32083	1.67E+20	1.23E+01	0.0237	0.006	0.25	0.18	0.57	0.93	0.18	0.31	0.12	4.55	1.73	0.31	0.50	2.55	0.00	22.15	46.19	106.7	128.7	42.98
37	Tees, Thru			1	0.57	0.00	Tees, Thru			1	0.66	0.12						11	90.0	0.577	35647	2.00E+20	2.28E+00	0.0232	0.008	0.25	0.18	0.57	0.92	0.18	0.30	0.12	4.54	1.73	0.31	0.50	2.55	0.01	22.15	46.75	108.0	124.7	44.11
38	Tees, Branch			1	0.92	0.00	Tees, Branch			1	1.07	0.19						12	99.0	0.635	39212	2.34E+20	4.96E-01	0.0227	0.009	0.25	0.18	0.57	0.92	0.18	0.30	0.12	4.54	1.73	0.31	0.50	2.54	0.01	22.15	47.36	109.4	120.4	44.95
39	Ball Valves				0.18		Ball Valves				0.20							13	108.0	0.693	42777	2.70E+20	1.23E-01	0.0223	0.011	0.24	0.18	0.57	0.92	0.18	0.30	0.12	4.54	1.72	0.30	0.50	2.53	0.01	22.14	48.03	110.9	115.8	45.51
40	Butterfly Valves				0.30		Butterfly Valves				0.34							14	117.0	0.750	46342	3.07E+20	3.42E-02	0.0220	0.013	0.24	0.18	0.57	0.92	0.18	0.30	0.12	4.53	1.72	0.30	0.50	2.53	0.01	22.14	48.75	112.6	110.8	45.78
41	Gate Valves			1	0.12	0.00	Gate Valves			1	0.14	0.02						15	126.0	0.808	49906	3.45E+20	1.05E-02	0.0217	0.014	0.24	0.18	0.57	0.92	0.18	0.30	0.12	4.53	1.72	0.30	0.50	2.52	0.01	22.14	49.53	114.4	105.6	45.77
42	Globe Valves				4.53		Globe Valves				5.32							16	135.0	0.866	53471	3.84E+20	3.47E-03	0.0214	0.016	0.24	0.18	0.57	0.92	0.18	0.30	0.12	4.53	1.72	0.30	0.50	2.52	0.01	22.13	50.35	116.3	100.0	45.48
43	Check Valves				1.72		Check Valves			1	2.00	0.37						17	144.0	0.924	57036	4.24E+20	1.24E-03	0.0211	0.018	0.24	0.18	0.57	0.91	0.18	0.30	0.12	4.53	1.71	0.30	0.50	2.52	0.01	22.13	51.24	118.4	94.1	44.91
44	Plug Valves				0.30		Plug Valves				0.34							18	153.0	0.981	60601	4.64E+20	4.68E-04	0.0209	0.020	0.24	0.18	0.57	0.91	0.18	0.29	0.12	4.53	1.71	0.30	0.50	2.51	0.02	22.12	52.17	120.5	87.8	44.06
45	Pipe Entrance			1	0.50	0.00	Pipe Exit			1	1.00	0.18						19	162.0	1.039	64165	5.05E+20	1.88E-04	0.0207	0.023	0.24	0.18	0.56	0.91	0.18	0.29	0.12	4.52	1.71	0.30	0.50	2.51	0.02	22.12	53.16	122.8	81.3	42.92
46						0.01						0.97						20	171.0	1.097	67730	5.47E+20	7.90E-05	0.0205	0.025	0.24	0.18	0.56	0.91	0.18	0.29	0.12	4.52	1.71	0.30	0.50	2.51	0.02	22.11	54.20	125.2	74.4	41.50
47	Velocity			0.77	ft/s		Velocity			5.21	ft/s							21	180.0	1.154	71295	5.89E+20	3.48E-05	0.0203	0.027	0.24	0.18	0.56	0.91	0.18	0.29	0.12	4.52	1.71	0.30	0.50	2.51	0.02	22.11	55.30	127.7	67.2	39.79
48	Reynold's No.			47530			Reynold's No.			123643
49	Pipe DP			0.01	psi/100ft		Pipe DP			1.55	psi/100ft									Discharge Conditions
50	Suction Pressure			22.14	psia		Discharge Pressure			71.44	psia								Flow	Velocity	Reynold	A	B	f	DP1	Elb, 90LR	Elb, 45LR	Tees, Thru	Tees, Bran	Ball	Butterfly	Gate	Globe	Check	Plug	Pipe	Sum K	DP	Disch P
51																			GPM	ft/s						1	1	1	1	0	0	1	0	1	0	1
52																		1	0	0.000	0	0.00E+00	0.00E+00	0.0000	0.000	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1.00	1.00	0.00	65.82
53		Pump Manufacturer's Curve					Maximum Flow			180	US gpm							2	9	0.391	9273	1.31E+19	5.18E+09	0.0326	0.013	0.35	0.25	0.68	1.15	0.25	0.42	0.16	5.47	2.15	0.44	1.00	5.75	0.01	65.87
54							Flow value till which System and Head Curve											3	18	0.781	18546	4.87E+19	7.90E+04	0.0277	0.044	0.31	0.23	0.67	1.10	0.23	0.37	0.15	5.38	2.07	0.39	1.00	5.53	0.02	65.98
55		Flow	Head	Efficiency			are calculated											4	27	1.172	27820	9.53E+19	1.20E+02	0.0254	0.092	0.29	0.22	0.67	1.09	0.22	0.36	0.14	5.36	2.04	0.37	1.00	5.45	0.05	66.15
56		gpm	ft	%														5	36	1.562	37093	1.47E+20	1.21E+00	0.0241	0.155	0.29	0.21	0.67	1.08	0.21	0.35	0.14	5.34	2.03	0.36	1.00	5.42	0.09	66.38
57		0.0	150.0	20.0			Operating Conditions											6	45	1.953	46366	2.00E+20	3.40E-02	0.0232	0.233	0.28	0.21	0.67	1.08	0.21	0.35	0.14	5.34	2.02	0.35	1.00	5.40	0.14	66.66
58		20.0	147.0	28.0			Flowrate			114.7	US gpm							7	54	2.344	55639	2.52E+20	1.84E-03	0.0225	0.326	0.28	0.21	0.67	1.08	0.21	0.35	0.14	5.33	2.02	0.35	1.00	5.38	0.20	67.00
59		50.0	140.0	37.0			Head			112.2	ft							8	63	2.734	64913	3.04E+20	1.56E-04	0.0220	0.433	0.28	0.21	0.67	1.07	0.21	0.34	0.14	5.33	2.01	0.35	1.00	5.37	0.27	67.39
60		80.0	129.0	43.0			Efficiency			45.74	%							9	72	3.125	74186	3.54E+20	1.84E-05	0.0216	0.555	0.28	0.21	0.66	1.07	0.21	0.34	0.14	5.32	2.01	0.34	1.00	5.36	0.35	67.84
61		100.0	120.0	45.0			Hydraulic Power			3.25	bhp							10	81	3.515	83459	4.01E+20	2.80E-06	0.0213	0.692	0.27	0.20	0.66	1.07	0.20	0.34	0.14	5.32	2.01	0.34	1.00	5.36	0.45	68.34
62		150.0	90.0	44.0			Rated Power			7.10	bhp							11	90	3.906	92732	4.47E+20	5.18E-07	0.0210	0.842	0.27	0.20	0.66	1.07	0.20	0.34	0.14	5.32	2.01	0.34	1.00	5.35	0.55	68.90
63		180.0	67.0	40.0														12	99	4.296	102005	4.91E+20	1.13E-07	0.0207	1.007	0.27	0.20	0.66	1.07	0.20	0.34	0.14	5.32	2.00	0.34	1.00	5.35	0.66	69.51
64		200.0	50.0	35.0														13	108	4.687	111279	5.32E+20	2.80E-08	0.0205	1.187	0.27	0.20	0.66	1.07	0.20	0.34	0.14	5.32	2.00	0.34	1.00	5.35	0.79	70.17
65																		14	117	5.078	120552	5.72E+20	7.79E-09	0.0203	1.380	0.27	0.20	0.66	1.07	0.20	0.34	0.14	5.32	2.00	0.34	1.00	5.34	0.93	70.89
66																		15	126	5.468	129825	6.10E+20	2.38E-09	0.0202	1.588	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.32	2.00	0.34	1.00	5.34	1.07	71.66
67																		16	135	5.859	139098	6.46E+20	7.89E-10	0.0200	1.810	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.34	1.23	72.49
68																		17	144	6.249	148372	6.80E+20	2.81E-10	0.0199	2.046	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.34	1.40	73.36
69																		18	153	6.640	157645	7.13E+20	1.06E-10	0.0198	2.296	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.34	1.58	74.29
70																		19	162	7.031	166918	7.44E+20	4.27E-11	0.0197	2.561	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.33	1.77	75.28
71																		20	171	7.421	176191	7.74E+20	1.80E-11	0.0196	2.839	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.33	1.98	76.32
72																		21	180	7.812	185465	8.02E+20	7.90E-12	0.0195	3.132	0.27	0.20	0.66	1.07	0.20	0.34	0.13	5.31	2.00	0.34	1.00	5.33	2.19	77.41
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