PLANILHA DE DIMENSIONAMENTO DA REDE COLETORA DE ESGOTO

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

Plan1
	TRECHO 	COMPRIMENTO
(m) 	INFILTRAÇÃO
 (L/s.m)	VAZÃO TRECHO
(L/s)	VAZÃO MONTANTE 
(L/s)	 VAZÃO JUSANTE 
(L/s)	VAZÃO DE PROJETO 
(L/s)	COTA 
MONTANTE 
	COTA
 JUSANTE
	DECLIVID. 
TERRENO
 (m/m)	DECLIVIDADE
MINIMA COLETOR 
(m/m)	DECLIVIDADE 
DE PROJETO
(m/m)	COTA COLETOR 
MONTANTE	COTA COLETOR
 JUSANTE	PROFUND. 
COLETOR MONTANTE	PROFUND.
 COLETOR JUSANTE 	Qp/√Ip	DIÂMETRO
D (m)	LÂMINA 
LIQUIDA 
(y/d)	Vf/√Ip	BETA
(B)	RAIO 
HIDRAULICO
(RH=BXD)	PRESSÃO 
CRITICA
(Pa)	VELOCID. 
CRITICA 
(m/s)	VELOCID. 
FINAL
(m/s)	TESTE
VELOCID.	TESTE 
TENSÃO 
CRITICA
(NBR 9649)
	0.0005	0.00833
	1.1	80	0.0400	0.667	0.000	0.707	1.500	5.025	4.025	0.0125	0.0045	0.0125	4.025	3.025	1.00	1.00	0.0134	0.100	0.350	5.54	0.194	0.0194	2.425	2.62	0.62	OK	OK
	1.2	80	0.0400	0.667	0.667	1.373	1.500	4.025	3.025	0.0125	0.0045	0.0125	3.025	2.025	1.00	1.00	0.0134	0.100	0.350	5.54	0.194	0.0194	2.425	2.62	0.62	OK	OK
	1.3	80	0.0400	0.667	1.333	2.040	2.040	3.025	2.025	0.0125	0.0039	0.0125	2.025	1.025	1.00	1.00	0.0182	0.100	0.425	6.11	0.234	0.0234	2.925	2.87	0.68	OK	OK
	1.4	70	0.0350	0.583	2.000	2.618	2.618	2.025	2.020	0.0001	0.0035	0.0035	1.025	0.780	1.00	1.24	0.0443	0.150	0.375	7.53	0.215	0.0323	1.128	3.37	0.45	OK	OK
	1.5	70	0.0350	0.583	6.333	6.952	6.952	2.020	2.015	0.0001	0.0022	0.0022	0.780	0.625	1.24	1.39	0.1478	0.200	0.500	10.44	0.250	0.0500	1.105	4.20	0.49	OK	OK
	1.6	70	0.0350	0.583	10.667	11.285	11.285	2.015	2.010	0.0001	0.0018	0.0018	0.625	0.502	1.39	1.51	0.2689	0.250	0.500	12.11	0.250	0.0625	1.100	4.70	0.51	OK	OK
	1.7	60	0.0300	15.000	15.000	15.030	15.030	2.010	2.005	0.0001	0.0015	0.0015	0.502	0.410	1.51	1.60	0.3831	0.300	0.450	13.05	0.234	0.0702	1.080	4.98	0.51	OK	OK
	1.8	60	0.0300	15.000	15.000	15.060	15.060	2.005	2.003	0.0000	0.0015	0.0015	0.410	0.318	1.60	1.69	0.3841	0.300	0.450	13.05	0.234	0.0702	1.079	4.98	0.51	OK	OK
	2.1	70	0.0350	0.583	0.000	0.618	1.500	5.025	5.020	0.0001	0.0045	0.0045	4.025	3.707	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	2.2	80	0.0400	0.667	0.583	1.290	1.500	5.020	4.020	0.0125	0.0045	0.0125	3.707	2.707	1.31	1.31	0.0134	0.100	0.350	5.54	0.194	0.0194	2.425	2.62	0.62	OK	OK
	2.3	80	0.0400	0.667	1.833	2.540	2.540	4.020	3.020	0.0125	0.0035	0.0125	2.707	1.707	1.31	1.31	0.0227	0.100	0.500	6.58	0.250	0.0250	3.125	2.97	0.74	OK	OK
	2.4	80	0.0400	0.667	3.083	3.790	3.790	3.020	2.020	0.0125	0.0029	0.0125	1.707	0.707	1.31	1.31	0.0339	0.150	0.350	7.26	0.194	0.0291	3.638	3.21	0.81	OK	OK
	3.1	70	0.0350	0.583	0.000	0.618	1.500	4.025	4.020	0.0001	0.0045	0.0045	3.025	2.707	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	4.1	70	0.0350	0.583	0.000	0.618	1.500	3.025	3.020	0.0001	0.0045	0.0045	2.025	1.707	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	5.1	70	0.0350	0.583	0.000	0.618	1.500	5.020	5.015	0.0001	0.0045	0.0045	4.020	3.702	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	5.2	80	0.0400	0.667	0.583	1.290	1.500	5.015	4.015	0.0125	0.0045	0.0125	3.702	2.702	1.31	1.31	0.0134	0.100	0.350	5.54	0.194	0.0194	2.425	2.62	0.62	OK	OK
	5.3	80	0.0400	0.667	1.833	2.540	2.540	4.015	3.015	0.0125	0.0035	0.0125	2.702	1.702	1.31	1.31	0.0227	0.150	0.300	6.69	0.171	0.0257	3.206	3.01	0.75	OK	OK
	5.4	80	0.0400	0.667	3.083	3.790	3.790	3.015	2.015	0.0125	0.0029	0.0125	1.702	0.702	1.31	1.31	0.0339	0.150	0.375	7.53	0.215	0.0323	4.031	3.37	0.84	OK	OK
	6.1	70	0.0350	0.583	0.000	0.618	1.500	4.020	4.015	0.0001	0.0045	0.0045	3.020	2.702	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	7.1	70	0.0350	0.583	0.000	0.618	1.500	3.020	3.015	0.0001	0.0045	0.0045	2.020	1.702	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	8.1	70	0.0350	0.583	0.000	0.618	1.500	5.015	5.010	0.0001	0.0045	0.0045	4.015	3.697	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	8.2	80	0.0400	0.667	0.583	1.290	1.500	5.010	4.010	0.0125	0.0045	0.0125	3.697	2.697	1.31	1.31	0.0134	0.100	0.450	6.29	0.234	0.0234	2.925	2.87	0.70	OK	OK
	8.3	80	0.0400	0.667	1.833	2.540	2.540	4.010	3.010	0.0125	0.0035	0.0125	2.697	1.697	1.31	1.31	0.0227	0.150	0.325	6.98	0.194	0.0291	3.638	3.21	0.78	OK	OK
	8.4	80	0.0400	0.667	3.083	3.790	3.790	3.010	2.010	0.0125	0.0029	0.0125	1.697	0.697	1.31	1.31	0.0339	0.150	0.400	7.26	0.215	0.0323	4.031	3.37	0.81	OK	OK
	9.1	70	0.0350	0.583	0.000	0.618	1.500	4.015	4.010	0.0001	0.0045	0.0045	3.015	2.697	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	10.1	70	0.0350	0.583	0.000	0.618	1.500	3.015	3.010	0.0001	0.0045	0.0045	2.015	1.697	1.00	1.31	0.0222	0.100	0.475	6.43	0.250	0.0250	1.136	2.97	0.43	OK	OK
	1800
Plan1 (2)
	População inicial (hab)	861	Txis (l/s.m)	0.00115
	População final (hab)	1173	Txif (l/s.m)	0.00182
	TRECHO 	COMP.
(m) 	VAZÃO A JUSANTE INICIAL Qi (l/s)	VAZÃO A JUSANTE FINAL Qf (l/s)	VAZÃO DE PROJETO (l/s)	COTA 
MONT. 
	COTA
 JUS.
	DECLIVID. 
TERRENO
 (m/m)	DECLIVID.
MINIMA COLETOR 
(m/m)	DECLIVID. 
DE PROJETO
(m/m)	COTA COLETOR 
MONT.	COTA COLETOR JUSANTE	PROFUND. 
COLETOR MONT.	PROFUND.
 COLETOR JUSANTE 	DIÂMET.
D (m)	DIÂMET. DE PROJETO
D (m)	VAZÃO A SEÇÃO PLENA Qp (l/s)	Qi/Qp	Qf/Qp	VELOCID. A SEÇÃO PLENA Vp (m/s)	RAIO 
HIDRAUL.
INICIAL Rhi	RAIO 
HIDRAUL.
Final Rhf	TENSÃO TRATIVA (Pa)	VELOCID. 
CRITICA 
(m/s)	VELOCID. 
FINAL
(m/s)	TESTE
VELOCID.	TESTE 
TENSÃO 
CRITICA
(NBR 9649)
	1	1 - 1	100.00	0.115	0.182	1.500	341.00	340.00	0.0100	0.0045	0.0100	339.95	337.95	1.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	2	1 - 2	100.00	0.230	0.364	1.500	340.00	339.00	0.0100	0.0045	0.0100	337.95	337.74	2.05	1.26	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	3	1 - 3	46.38	0.284	0.448	1.500	339.00	339.00	0.0000	0.0045	0.0045	337.74	336.95	1.26	2.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.01646	0.01646	0.7480	2.41	0.34	OK	RECALCULAR
	4	1 - 4	71.58	0.366	0.579	1.500	339.00	338.00	0.0140	0.0045	0.0140	336.95	334.95	2.05	3.05	0.061	0.150	18.001	0.08333	0.08333	1.019	0.01809	0.01809	2.5272	2.53	0.63	OK	OK
	5	2 - 1	100.00	0.115	0.182	1.500	340.00	339.00	0.0100	0.0045	0.0100	338.95	336.95	1.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.57	OK	OK
	6	2 -2	100.00	0.230	0.364	1.500	339.00	338.00	0.0100	0.0045	0.0100	336.95	336.50	2.05	1.50	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.50	OK	OK
	7	2 - 3	100.00	0.346	0.546	1.500	338.00	338.00	0.0000	0.0045	0.0045	336.50	334.95	1.50	3.05	0.076	0.150	10.216	0.14682	0.14682	0.578	0.01889	0.01889	0.8498	2.58	0.33	OK	RECALCULAR
	8	2 - 4	62.58	0.784	1.239	1.500	338.00	336.00	0.0320	0.0045	0.0320	334.95	333.95	3.05	2.05	0.052	0.150	27.226	0.05509	0.05509	1.541	0.01728	0.01728	5.5225	2.47	0.89	OK	OK
	9	3 - 1	100.00	0.115	0.182	1.500	339.00	338.00	0.0100	0.0045	0.0100	337.95	335.95	1.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	10	3 - 2	100.00	0.230	0.364	1.500	338.00	337.00	0.0100	0.0045	0.0100	335.95	334.95	2.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.02274	0.02274	2.2740	2.83	0.62	OK	OK
	11	3 - 3	100.00	0.346	0.546	1.500	337.00	336.00	0.0100	0.0045	0.0100	334.95	334.92	2.05	1.08	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	12	3 - 4	7.55	0.354	0.560	1.500	336.00	336.00	0.0000	0.0045	0.0045	334.92	333.95	1.08	2.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.02274	0.02274	1.0337	2.83	0.42	OK	OK
	13	3 - 5	61.30	1.209	1.910	1.910	336.00	335.00	0.0163	0.0041	0.0163	333.95	332.95	2.05	2.05	0.065	0.150	19.452	0.09819	0.09819	1.101	0.01728	0.01728	2.8189	2.47	0.66	OK	OK
	14	4 - 1	100.00	0.115	0.182	1.500	338.00	337.00	0.0100	0.0045	0.0100	336.95	334.95	1.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.50	OK	OK
	15	4 - 2	100.00	0.230	0.364	1.500	337.00	336.00	0.0100	0.0045	0.0100	334.95	333.95	2.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58
0.55	OK	OK
	16	4 - 3	100.00	0.346	0.546	1.500	336.00	335.00	0.0100	0.0045	0.0100	333.95	333.92	2.05	1.08	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	17	4 - 4	7.63	0.354	0.560	1.500	335.00	335.00	0.0000	0.0045	0.0045	333.92	332.95	1.08	2.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.02274	0.02274	1.0337	2.83	0.42	OK	OK
	18	4 - 5	62.16	1.634	2.583	2.583	335.00	334.00	0.0161	0.0035	0.0161	332.95	329.95	2.05	4.05	0.073	0.150	19.317	0.13371	0.13371	1.093	0.01968	0.01968	3.1660	2.64	0.71	OK	OK
	19	5 - 1	100.00	0.115	0.182	1.500	336.00	336.00	0.0000	0.0045	0.0045	334.95	333.95	1.05	2.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.02274	0.02274	1.0337	2.83	0.42	OK	OK
	20	5 - 2	100.00	0.230	0.364	1.500	336.00	335.00	0.0100	0.0045	0.0100	333.95	332.95	2.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	21	5 - 3	100.00	0.346	0.546	1.500	335.00	334.00	0.0100	0.0045	0.0100	332.95	329.95	2.05	4.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.01889	0.01889	1.8885	2.58	0.55	OK	OK
	22	5 - 4	66.57	2.057	3.250	3.250	334.00	331.00	0.0451	0.0032	0.0451	329.95	330.97	4.05	0.03	0.066	0.150	32.330	0.10053	0.10053	1.830	0.01889	0.01889	8.5106	2.58	1.16	OK	OK
	23	6 - 1	78.29	0.090	0.142	1.500	341.00	340.00	0.0128	0.0045	0.0128	339.95	338.74	1.05	1.26	0.062	0.150	17.212	0.08715	0.08715	0.974	0.01809	0.01809	2.3106	2.53	0.60	OK	OK
	24	6 - 2	45.42	0.142	0.225	1.500	340.00	340.00	0.0000	0.0045	0.0045	338.74	336.95	1.26	3.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.02434	0.02274	1.1066	2.83	0.42	OK	OK
	25	6 - 3	100.00	0.258	0.407	1.500	340.00	338.00	0.0200	0.0045	0.0200	336.95	333.95	3.05	4.05	0.057	0.150	21.538	0.06964	0.06964	1.219	0.14790	0.14790	29.5800	7.23	0.66	OK	OK
	26	6 - 4	100.00	0.373	0.589	1.500	338.00	335.00	0.0300	0.0045	0.0300	333.95	333.88	4.05	1.12	0.053	0.150	26.378	0.05686	0.05686	1.493	0.16455	0.10602	49.3650	6.12	0.86	OK	OK
	27	6 - 5	16.11	0.391	0.618	1.500	335.00	335.00	0.0000	0.0045	0.0045	333.88	332.95	1.12	2.05	0.075	0.150	10.268	0.14608	0.14608	0.581	0.22740	0.22740	10.3369	8.96	0.42	OK	OK
	28	6 - 6 	100.00	0.507	0.800	1.500	335.00	334.00	0.0100	0.0045	0.0100	332.95	331.95	2.05	2.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.18885	0.18885	18.8850	8.17	0.55	OK	OK
	29	6 - 7	100.00	0.689	0.982	1.500	334.00	333.00	0.0100	0.0045	0.0100	331.95	329.95	2.05	3.05	0.065	0.150	15.230	0.09849	0.09849	0.862	0.18885	0.18885	18.8850	8.17	0.55	OK	OK
	30	6 - 8	100.00	0.804	1.164	1.500	333.00	331.00	0.0200	0.0045	0.0200	329.95	329.92	3.05	1.08	0.057	0.150	21.538	0.06964	0.06964	1.219	0.18885	0.18885	37.7700	8.17	0.77	OK	OK
	31	6 - 9	11.09	2.873	4.435	4.435	331.00	331.00	0.0000	0.0027	0.0027	329.92	330.97	1.08	0.03	0.125	0.150	7.959	0.55720	0.55720	0.450	0.03496	0.03496	0.9549	3.51	0.43	OK	RECALCULAR
	2274.08
Plan2
Plan3