FlowFrictionPower

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	Timestamp

2
3		Only Change cells with a blue background.
4		Givens:	run	400	ft
5			Ht	50	ft
6			e	0.8
7			K	5310	(galft)/(minkW)
8
9			Lengths of pipe per fitting (ft)							Total length of pipe (ft)
10	Qty	Component	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"
11	2	90	3.8	4	5.7	6.9	7.9	12	18	7.6	8	11.4	13.8	15.8	24	36
12	4	45	1.8	2.1	2.6	3.1	4	5.1	8	7.2	8.4	10.4	12.4	16	20.4	32
13	5	Gate Valve	0.8	1	1.5	2	3	4	7	4	5	7.5	10	15	20	35
14	5	T - Run	2.3	2.7	4.3	5.1	6.2	8.3	12.5	11.5	13.5	21.5	25.5	31	41.5	62.5
15	0	T - Branch	7	8	12	15	16	22	32.7	0	0	0	0	0	0	0
16	20	Adapter	2.8	3.5	4.5	5.5	6.5	9	14	56	70	90	110	130	180	280
17	0									0	0	0	0	0	0	0
18	400	feet of pipe	1	1	1	1	1	1	1	400	400	400	400	400	400	400
19		Total								486.3	504.9	540.8	571.7	607.8	685.9	845.5
20
21			Friction loss per 100' of plastic pipe (ft)							Total friction loss (ft)							Head Available (Ha in Ft)							Power (P in kW)
22		Flow Rate	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"
23		5	0.4	0.2						1.95	1.01	-	-	-	-	-	48.05	48.99	-	-	-	-	-	0.036	0.037	-	-	-	-	-
24		10	1.6	0.7	0.2	0.1				7.78	3.53	1.08	0.57	-	-	-	42.22	46.47	48.92	49.43	-	-	-	0.064	0.070	0.074	0.074	-	-	-
25		20	5.6	2.6	0.8	0.3	0.1			27.23	13.13	4.33	1.72	0.61	-	-	22.77	36.87	45.67	48.28	49.39	-	-	0.069	0.111	0.138	0.145	0.149	-	-
26		30	11.8	5.6	1.7	0.7	0.2			57.38	28.27	9.19	4.00	1.22	-	-	-	21.73	40.81	46.00	48.78	-	-	-	0.098	0.184	0.208	0.220	-	-
27		40	20.1	9.5	2.8	1.2	0.4	0.1		97.75	47.97	15.14	6.86	2.43	0.69	-	-	2.03	34.86	43.14	47.57	49.31	-	-	0.012	0.210	0.260	0.287	0.297	-
28		50		14.4	4.3	1.8	0.6	0.2		-	72.71	23.25	10.29	3.65	1.37	-	-	-	26.75	39.71	46.35	48.63	-	-	-	0.201	0.299	0.349	0.366	-
29		60		20.1	6	2.5	0.9	0.2		-	101.48	32.45	14.29	5.47	1.37	-	-	-	17.55	35.71	44.53	48.63	-	-	-	0.159	0.323	0.403	0.440	-
30		70			7.9	3.3	1.2	0.3		-	-	42.72	18.87	7.29	2.06	-	-	-	7.28	31.13	42.71	47.94	-	-	-	0.077	0.328	0.450	0.506	-
31		80			10.2	4.3	1.5	0.4		-	-	55.16	24.58	9.12	2.74	-	-	-	-	25.42	40.88	47.26	-	-	-	-	0.306	0.493	0.570	-
32		90			12.6	5.3	1.9	0.5		-	-	68.14	30.30	11.55	3.43	-	-	-	-	19.70	38.45	46.57	-	-	-	-	0.267	0.521	0.631	-
33		100				6.5	2.3	0.6	0.1	-	-	-	37.16	13.98	4.12	0.85	-	-	-	12.84	36.02	45.88	49.15	-	-	-	0.193	0.543	0.691	0.741
34		125				9.8	3.4	0.9	0.1	-	-	-	56.03	20.67	6.17	0.85	-	-	-	-	29.33	43.83	49.15	-	-	-	-	0.552	0.825	0.926
35		150					4.8	1.3	0.2	-	-	-	-	29.17	8.92	1.69	-	-	-	-	20.83	41.08	48.31	-	-	-	-	0.471	0.928	1.092
36										-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
37
38			Pipe Diameter (inches)																									281%	127%	107%
39		GPM	1-1/4"	1-1/2"	2"	2-1/2"	3"	4"	6"
40	Flow Rate (GPM)	5 GPM	36	37	#N/A	#N/A	#N/A	#N/A	#N/A
41		10 GPM	64	70	74	74	#N/A	#N/A	#N/A
42		20 GPM	69	111	138	145	149	#N/A	#N/A
43		30 GPM	#N/A	98	184	208	220	#N/A	#N/A
44		40 GPM	#N/A	12	210	260	287	297	#N/A
45		50 GPM	#N/A	#N/A	201	299	349	366	#N/A
46		60 GPM	#N/A	#N/A	159	323	403	440	#N/A
47		70 GPM	#N/A	#N/A	77	328	450	506	#N/A
48		80 GPM	#N/A	#N/A	#N/A	306	493	570	#N/A
49		90 GPM	#N/A	#N/A	#N/A	267	521	631	#N/A
50		100 GPM	#N/A	#N/A	#N/A	193	543	691	741
51		125 GPM	#N/A	#N/A	#N/A	#N/A	552	825	926
52		150 GPM	#N/A	#N/A	#N/A	#N/A	471	928	1092
53
54	See http://www.retscreen.net/ to actually do it!
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73