Rede Malhada

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Planilha1
	Planilha de Cálculo de Rede Malhada
	Anel	Trecho 	Extensão (m)	Vazão Q0 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h0 (m)	1,85x h0/Q0 (m)	ΔQ0	Vazão corrigida Q1 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h1 (m)	1,85x h1/Q1 (m)	ΔQ1	Vazão corrigida Q2 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h2 (m)	1,85x h2/Q2 (m)	ΔQ2	Vazão corrigida Q3 (l/s)
	ANEL I	AB	550	31.00	250	0.0029	1.6161	0.0964	-3.4049	27.60	200.00	0.0070	3.8632	0.2590	-1.6443	25.95	200.00	0.0063	3.4482	0.2458	-0.8543	25.10
	BC	275	14.00	150	0.0081	2.2344	0.2953	-3.4049	10.60	150.00	0.0049	1.3344	0.2330	-1.6443	8.95	150.00	0.0036	0.9767	0.2019	-0.8543	8.10
	CD	525	11.40	150	0.0056	2.9170	0.4734	-3.4049	8.00	150.00	0.0029	1.5132	0.3501	-1.6443	6.35	150.00	0.0019	0.9883	0.2879	-0.8543	5.50
	DE	250	8.80	150	0.0034	0.8605	0.1809	-3.4049	5.40	150.00	0.0014	0.3481	0.1193	-1.6443	3.75	100.00	0.0051	1.2798	0.6312	-0.8543	2.90
	EF	250	6.20	150	0.0018	0.4502	0.1343	-3.4049	2.80	100.00	0.0030	0.7428	0.4916	-1.6443	1.15	75.00	0.0023	0.5839	0.9386	-0.8543	0.30
	FG	75	0.00	50	0.0000	0.0000	-3.4049	-3.40	100.00	0.0043	-0.3210	0.1744	-1.6443	-5.05	150.00	0.0012	-0.0924	0.0338	-0.8543	-5.90
	GH	445	-14.60	200	0.0022	-0.9626	0.1220	-3.4049	-18.00	200.00	0.0032	-1.4187	0.1458	-1.6443	-19.65	200.00	0.0037	-1.6676	0.1570	-0.8543	-20.50
	HA	670	-17.20	200	0.0029	-1.9627	0.2111	-3.4049	-20.60	200.00	0.0041	-2.7414	0.2461	-1.6443	-22.25	200.00	0.0047	-3.1598	0.2627	-0.8543	-23.10
	Rugosidade da tubulação (C)	100	Σ =	5.1529	1.5134	Σ =	3.3205	2.0194	Σ =	2.3571	2.7590
	Anel	Diâmetro (mm)	Perda de carga unitária (m/km)	h3 (m)	1,85x h3/Q3 (m)	ΔQ3	Vazão corrigida Q4 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h4 (m)	1,85x h4/Q4 (m)	ΔQ4	Vazão corrigida Q4 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h5 (m)	1,85x h5/Q5 (m)	ΔQ5	Vazão corrigida Q5 (l/s)	Diâmetro (mm)
	ANEL I	200	0.0059	3.2411	0.2389	-0.1658	24.93	200.00	0.0058	3.2016	0.238	-0.0333	24.90	200	0.0058	3.1937	0.2373	-0.0016	24.90	200.00
	150	0.0030	0.8113	0.1854	-0.1658	7.93	150.00	0.0028	0.7808	0.182	-0.0333	7.90	150	0.0028	0.7748	0.1815	-0.0016	7.90	150.00
	150	0.0014	0.7565	0.2546	-0.1658	5.33	150.00	0.0014	0.7148	0.248	-0.0333	5.30	150	0.0013	0.7066	0.2468	-0.0016	5.30	150.00
	100	0.0032	0.7933	0.5067	-0.1658	2.73	100.00	0.0028	0.7114	0.482	-0.0333	2.70	100	0.0028	0.6954	0.4769	-0.0016	2.70	100.00
	50	0.0014	0.3421	2.1348	-0.1658	0.13	50.00	0.0003	0.0751	1.064	-0.0333	0.10	50	0.0002	0.0436	0.8284	-0.0016	0.10	50.00
	150	0.0016	-0.1233	0.0387	-0.1658	-6.07	150.00	0.0017	-0.1298	0.040	-0.0333	-6.10	150	0.0017	-0.1312	0.0398	-0.0016	-6.10	150.00
	200	0.0041	-1.8042	0.1628	-0.1658	-20.67	200.00	0.0041	-1.8313	0.164	-0.0333	-20.70	200	0.0041	-1.8368	0.1641	-0.0016	-20.70	200.00
	200	0.0051	-3.3879	0.2713	-0.1658	-23.27	200.00	0.0051	-3.4330	0.273	-0.0333	-23.30	200	0.0051	-3.4421	0.2733	-0.0016	-23.30	200.00
	Σ =	0.6289	3.7932	Σ =	0.0897	2.6901	Σ =	0.0040	2.4480
	Anel	Trecho 	Extensão (m)	Vazão Q0 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h0 (m)	1,85x h0/Q0 (m)	ΔQ0	Vazão corrigida Q1 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h1 (m)	1,85x h1/Q1 (m)	ΔQ1	Vazão corrigida Q2 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h2 (m)	1,85x h2/Q2 (m)	ΔQ2	Vazão corrigida Q3 (l/s)
	ANEL II	FI	345	6.20	150	0.0018	0.6212	0.1854	1.7490	7.95	150	0.0029	0.9838	0.229	0.7254	8.67	150	0.0034	1.1563	0.2466	0.4579	9.13
	IJ	345	3.10	100	0.0036	1.2414	0.7408	1.7490	4.85	150	0.0011	0.3943	0.150	0.7254	5.57	150	0.0015	0.5103	0.1693	0.4579	6.03
	JK	260	0.00	50	0.0000	0.0000	-	1.7490	1.75	75	0.0051	1.3172	1.393	0.7254	2.47	100	0.0024	0.6165	0.4610	0.4579	2.93
	KL	560	-3.10	100	0.0036	-2.0150	1.2025	1.7490	-1.35	75	0.0031	-1.7595	2.409	0.7254	-0.63	50	0.0054	-3.0505	9.0214	0.4579	-0.17
	LM	380	-6.10	150	0.0017	-0.6640	0.2014	1.7490	-4.35	100	0.0067	-2.5600	1.088	0.7254	-3.63	100	0.0048	-1.8268	0.9322	0.4579	-3.17
	MN	390	-9.20	150	0.0037	-1.4574	0.2931	1.7490	-7.45	150	0.0025	-0.9866	0.245	0.7254	-6.73	150	0.0021	-0.8163	0.2245	0.4579	-6.27
	NG	500	-12.20	150	0.0063	-3.1495	0.4776	1.7490	-10.45	150	0.0047	-2.3654	0.419	0.7254	-9.73	150	0.0041	-2.0707	0.3939	0.4579	-9.27
	FG	75	0.00	50	0.0000	0.0000	-	1.7490	1.75	75	0.0051	0.3800	0.402	0.7254	2.47	100	0.0024	0.1779	0.1330	0.4579	2.93
	Rugosidade da tubulação (C)	100	Σ =	-5.4232	3.1007	Σ =	-4.5963	6.336	Σ =	-5.3034	11.5818
	Anel	Diâmetro (mm)	Perda de carga unitária (m/km)	h3 (m)	1,85x h3/Q3 (m)	ΔQ3	Vazão corrigida Q4 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h4 (m)	1,85x h4/Q4 (m)	ΔQ4	Vazão corrigida Q4 (l/s)	Diâmetro (mm)	Perda de carga unitária (m/km)	h5 (m)	1,85x h5/Q5 (m)	ΔQ5	Vazão corrigida Q5 (l/s)	Diâmetro (mm)
	ANEL II	150	0.0037	1.2717	0.258	0.2460	9.38	150	0.0039	1.3358	0.264	0.0965	9.47	150	0.0039	0.0069	0.001	-0.4207	9.05	150
	150	0.0017	0.5905	0.181	0.2460	6.28	150	0.0018	0.6358	0.187	0.0965	6.37	150	0.0019	0.0033	0.001	-0.4207	5.95	150
	100	0.0032	0.8441	0.533	0.2460	3.18	100	0.0038	0.9797	0.570	0.0965	3.27	100	0.0040	0.0070	0.004	-0.4207	2.85	100
	50	0.0005	-0.2670	2.946	0.2460	0.08	50	0.0001	0.0653	1.542	0.0965	0.17	50	0.0005	0.0009	0.010	-0.4207	-0.25	50
	100	0.0037	-1.4230	0.831	0.2460	-2.92	100	0.0032	-1.2254	0.776	0.0965	-2.83	100	0.0030	-0.0053	0.003	-0.4207	-3.25	100
	150	0.0018	-0.7165	0.211	0.2460	-6.02	150	0.0017	-0.6653	0.204	0.0965	-5.93	150	0.0017	-0.0029	0.001	-0.4207	-6.35	150
	150	0.0038	-1.8939	0.378	0.2460	-9.02	150	0.0036	-1.8020	0.370	0.0965	-8.93	150	0.0035	-0.0062	0.001	-0.4207	-9.35	150
	100	0.0032	0.2435	0.154	0.2460	3.18	100	0.0038	0.2826	0.164	0.0965	3.27	100	0.0040	0.0070	0.004	-0.4207	2.85	100
	Σ =	-1.3506	5.4913	Σ =	-0.3935	4.0776	Σ =	0.0107	0.0254