PLANILHA DE CÁLCULO - REDE COLETORA DE ESGOTOS
DADOS GERAIS:
POPULAÇÃO INICIAL:Pi = 1390 habPOPULAÇÃO FINAL:Pf = 1801 habCONSUMO DE ÁGUA PER CAPITA:q = 150 l/hab.diaCOEFICIENTE DE RETORNO:C = 0.8COEFICIENTE DE MÁXIMA VAZÃO DIÁRIA:
1.2COEFICIENTE DE MÁXIMA VAZÃO HORÁRIA:
1.5TAXA DE CONTRIBUIÇÃO DE INFILTRAÇÃO:Tinf = 0.1 l/s.kmTinf = 0.0001 l/s.mEXTENSÃO DA REDE COLETORA:L = 1862 m
CÁLCULOS:
VAZÃO DOMÉSTICA INICIAL: VAZÃO DE INFILTRAÇÃO VAZÃO TOTAL INICIAL
Qdi =86400 Qinf = Tinf x L Qti = Qdi + Qinf
Qdi = 2.90 l/s Qinf = 0.19 Qti = 3.08
VAZÃO DOMÉSTICA FINAL VAZÃO DE INFILTRAÇÃO VAZÃO TOTAL FINAL
Qdf =86400 Qinf = Tinf x L Qtf = Qdf + Qinf
Qdf = 4.50 l/s Qinf = 0.19 Qtf = 4.69
K1 =
K2 =
CxK2xPixq
CxK1xK2xPfxq
document.xls 04/17/2023 Página 2/4
ANEXO 2.2 - CÁLCULO DA REDE COLETORA ATRAVÉS DO EXCELSISTEMA DE ESGOTAMENTO SANITÁRIO DE ALCÂNTARA 2
MESTRADO EM SANEAMENTO AMBIENTAL - DISCIPLINA: HIDRÁULICA E HIDROLOGIA APLICADOS AO SANEAMENTOEQUIPE: GUSTAVO WEYNE, NEYLIANE SOUZA E SORAIA SOUZA TAVARES
PV
V/√I
Vi (m/s)
Rh/D Rh (m)
MONT INICIAL INICIAL INICIAL INICIAL INICIAL MONTANTE MONTANTE MONTANTE INICIALVf (m/s)
JUS FINAL FINAL FINAL FINAL FINAL JUSANTE JUSANTE JUSANTE FINAL
8-124
611.66 0.10 0.10 1.50 37.0
0.0410 1501.20 35.8 0.0074 0.15 4.45 0.90 0.093 0.014
5.7 OK 2.22 OK OK25 2.52 0.15 0.15 1.50 34.5 1.20 33.3 0.0074 0.15 4.45 0.90 0.093 0.014
8-225
431.66 0.07 0.10 0.17 1.50 34.5
0.0045 1501.20 33.3 0.0222 0.26 6.14 0.41 0.150 0.023
1.0 OK 2.82 OK OK12 2.52 0.11 0.15 0.26 1.50 35.0 1.90 33.1 0.0222 0.26 6.14 0.41 0.150 0.023
7-12
671.66 0.11 0.11 1.50 42.4
0.1119 1501.20 41.2 0.0045 0.12 3.82 1.28 0.076 0.011
12.8 OK 2.01 OK OK23 2.52 0.17 0.17 1.50 34.9 1.20 33.7 0.0045 0.12 3.82 1.28 0.076 0.011
7-223
321.66 0.05 0.11 0.16 1.50 34.9
0.0062 1501.20 33.7 0.0190 0.24 5.87 0.46 0.142 0.021
1.3 OK 2.74 OK OK5 2.52 0.08 0.17 0.25 1.50 34.7 1.20 33.5 0.0190 0.24 5.87 0.46 0.142 0.021
6-118
671.66 0.11 0.11 1.50 35.8
0.0701 1501.20 34.6 0.0057 0.13 4.1 1.09 0.082 0.012
8.6 OK 2.08 OK OK8 2.52 0.17 0.17 1.50 31.1 1.20 29.9 0.0057 0.13 4.1 1.09 0.082 0.012
5-120
501.66 0.08 0.08 1.50 34.0
0.0045 1501.20 32.8 0.0222 0.26 6.14 0.41 0.150 0.023
1.0 OK 2.82 OK OK21 2.52 0.13 0.13 1.50 33.8 1.23 32.6 0.0222 0.26 6.14 0.41 0.150 0.023
5-221
461.66 0.08 0.08 0.16 1.50 33.8
0.0040 1501.23 32.6 0.0222 0.26 6.14 0.41 0.150 0.023
1.0 OK 2.82 OK OK22 2.52 0.12 0.13 0.24 1.50 34.2 1.81 32.4 0.0222 0.26 6.14 0.41 0.150 0.023
5-322
641.66 0.11 0.16 0.26 1.50 34.2
0.0374 1501.81 32.4 0.0069 0.14 4.35 0.94 0.087 0.013
6.1 OK 2.15 OK OK7 2.52 0.16 0.24 0.40 1.50 31.2 1.20 30.0 0.0069 0.14 4.35 0.94 0.087 0.013
4-118
871.66 0.14 0.14 1.50 35.8
0.0368 1501.20 34.6 0.0078 0.15 4.51 0.86 0.093 0.014
5.1 OK 2.22 OK OK19 2.52 0.22 0.22 1.50 32.6 1.20 31.4 0.0078 0.15 4.51 0.86 0.093 0.014
4-219
671.66 0.11 0.14 0.25 1.50 32.6
0.0836 1501.20 31.4 0.0052 0.13 4 1.16 0.087 0.013
10.9 OK 2.15 OK OK9 2.52 0.17 0.22 0.39 1.50 27.0 1.20 25.8 0.0052 0.13 4 1.16 0.087 0.013
3-116
761.66 0.13 0.13 1.50 37.5
0.0461 1501.20 36.3 0.0070 0.15 4.37 0.94 0.093 0.014
6.4 OK 2.22 OK OK17 2.52 0.19 0.19 1.50 34.0 1.20 32.8 0.0070 0.15 4.37 0.94 0.093 0.014
3-217
941.66 0.16 0.13 0.28 1.50 34.0
0.0681 1501.20 32.8 0.0057 0.13 4.1 1.07 0.082 0.012
8.4 OK 2.08 OK OK15 2.52 0.24 0.19 0.43 1.50 27.6 1.20 26.4 0.0057 0.13 4.1 1.07 0.082 0.012
2-11
401.66 0.07 0.07 1.50 44.5
0.1125 1501.20 43.3 0.0045 0.12 3.82 1.28 0.076 0.011
12.8 OK 2.01 OK OK10 2.52 0.10 0.10 1.50 40.0 1.20 38.8 0.0045 0.12 3.82 1.28 0.076 0.011
2-210
491.66 0.08 0.07 0.15 1.50 40.0
0.0714 1501.20 38.8 0.0056 0.13 4.08 1.09 0.082 0.012
8.8 OK 2.08 OK OK11 2.52 0.12 0.10 0.22 1.50 36.5 1.20 35.3 0.0056 0.13 4.08 1.09 0.082 0.012
2-311
991.66 0.16 0.15 0.31 1.50 36.5
0.0152 1501.20 35.3 0.0122 0.19 5.15 0.63 0.120 0.018
2.7 OK 2.52 OK OK12 2.52 0.25 0.22 0.47 1.50 35.0 1.20 33.8 0.0122 0.19 5.15 0.63 0.120 0.018
2-412
521.66 0.09 0.48 0.57 1.50 35.0
0.1597 1501.90 33.1 0.0038 0.11 3.62 1.51 0.070 0.011
18.2 OK 1.92 OK OK13 2.52 0.13 0.74 0.87 1.50 26.0 1.20 24.8 0.0038 0.11 3.62 1.51 0.070 0.011
2-513
431.66 0.07 0.57 0.64 1.50 26.0
0.0512 1501.20 24.8 0.0066 0.14 4.27 0.97 0.090 0.014
6.9 OK 2.18 OK OK14 2.52 0.11 0.87 0.97 1.50 23.8 1.20 22.6 0.0066 0.14 4.27 0.97 0.090 0.014
2-614
681.66 0.11 0.64 0.75 1.50 23.8
0.0045 1501.20 22.6 0.0222 0.26 6.14 0.41 0.150 0.023
1.0 OK 2.82 OK OK
TRECHO Nº
EXT. (m)
TAXA DE CONTR LINEAR (l/s.km)
CONTR DO
TRECHO (l/s)
VAZÃO A MONTANTE
(l/s)
VAZÃO A JUSANTE
(l/s)
VAZÃO A JUSANTE ADOTADA
(l/s)
COTA DO TERRENO
(m) DECL. (m/m)
DIÂM. ADOT. (mm)
PROF DO COLETOR
(m)
COTA DO COLETOR
(m) Q/√I
LÂMINA LÍQUIDA
(Y/D) si (Pa)
si > 1,0Pa
Vc (m/s)
Vf < 5,0
Vf < Vc
document.xls 04/17/2023 Página 3/4
ANEXO 2.2 - CÁLCULO DA REDE COLETORA ATRAVÉS DO EXCELSISTEMA DE ESGOTAMENTO SANITÁRIO DE ALCÂNTARA 2
MESTRADO EM SANEAMENTO AMBIENTAL - DISCIPLINA: HIDRÁULICA E HIDROLOGIA APLICADOS AO SANEAMENTOEQUIPE: GUSTAVO WEYNE, NEYLIANE SOUZA E SORAIA SOUZA TAVARES
PV
V/√I
Vi (m/s)
Rh/D Rh (m)
MONT INICIAL INICIAL INICIAL INICIAL INICIAL MONTANTE MONTANTE MONTANTE INICIALVf (m/s)
JUS FINAL FINAL FINAL FINAL FINAL JUSANTE JUSANTE JUSANTE FINAL
TRECHO Nº
EXT. (m)
TAXA DE CONTR LINEAR (l/s.km)
CONTR DO
TRECHO (l/s)
VAZÃO A MONTANTE
(l/s)
VAZÃO A JUSANTE
(l/s)
VAZÃO A JUSANTE ADOTADA
(l/s)
COTA DO TERRENO
(m) DECL. (m/m)
DIÂM. ADOT. (mm)
PROF DO COLETOR
(m)
COTA DO COLETOR
(m) Q/√I
LÂMINA LÍQUIDA
(Y/D) si (Pa)
si > 1,0Pa
Vc (m/s)
Vf < 5,0
Vf < Vc
2-6 15 68 2.52 0.17 0.97 1.15 1.50 27.6 0.0045 150 5.31 22.3 0.0222 0.26 6.14 0.41 0.150 0.023 1.0 OK 2.82 OK OK
document.xls 04/17/2023 Página 4/4
ANEXO 2.2 - CÁLCULO DA REDE COLETORA ATRAVÉS DO EXCELSISTEMA DE ESGOTAMENTO SANITÁRIO DE ALCÂNTARA 2
MESTRADO EM SANEAMENTO AMBIENTAL - DISCIPLINA: HIDRÁULICA E HIDROLOGIA APLICADOS AO SANEAMENTOEQUIPE: GUSTAVO WEYNE, NEYLIANE SOUZA E SORAIA SOUZA TAVARES
PV
V/√I
Vi (m/s)
Rh/D Rh (m)
MONT INICIAL INICIAL INICIAL INICIAL INICIAL MONTANTE MONTANTE MONTANTE INICIALVf (m/s)
JUS FINAL FINAL FINAL FINAL FINAL JUSANTE JUSANTE JUSANTE FINAL
TRECHO Nº
EXT. (m)
TAXA DE CONTR LINEAR (l/s.km)
CONTR DO
TRECHO (l/s)
VAZÃO A MONTANTE
(l/s)
VAZÃO A JUSANTE
(l/s)
VAZÃO A JUSANTE ADOTADA
(l/s)
COTA DO TERRENO
(m) DECL. (m/m)
DIÂM. ADOT. (mm)
PROF DO COLETOR
(m)
COTA DO COLETOR
(m) Q/√I
LÂMINA LÍQUIDA
(Y/D) si (Pa)
si > 1,0Pa
Vc (m/s)
Vf < 5,0
Vf < Vc
2-715
771.66 0.13 1.03 1.16 1.50 27.6
0.0064 1505.31 22.3 0.0188 0.24 5.85 1.43 0.140 0.021
1.3 OK 2.82 OK OK26 2.52 0.19 1.57 1.77 1.77 23.0 1.20 21.8 0.0221 0.26 6.13 1.50 0.150 0.023
1-11
701.66 0.12 0.12 1.50 44.5
0.0300 1501.20 43.3 0.0087 0.16 4.65 0.81 0.099 0.015
4.5 OK 2.29 OK OK2 2.52 0.18 0.18 1.50 42.4 1.20 41.2 0.0087 0.16 4.65 0.81 0.099 0.015
1-22
661.66 0.11 0.12 0.23 1.50 42.4
0.0318 1501.20 41.2 0.0084 0.16 4.61 0.82 0.099 0.015
4.7 OK 2.29 OK OK3 2.52 0.17 0.18 0.34 1.50 40.3 1.20 39.1 0.0084 0.16 4.61 0.82 0.099 0.015
1-33
851.66 0.14 0.23 0.37 1.50 40.3
0.0624 1501.20 39.1 0.0060 0.13 4.16 1.04 0.082 0.012
7.7 OK 2.08 OK OK4 2.52 0.21 0.34 0.56 1.50 35.0 1.20 33.8 0.0060 0.13 4.16 1.04 0.082 0.012
1-44
301.66 0.05 0.37 0.42 1.50 35.0
0.0100 1501.20 33.8 0.0150 0.21 5.48 0.55 0.130 0.020
1.9 OK 2.62 OK OK5 2.52 0.08 0.56 0.63 1.50 34.7 1.20 33.5 0.0150 0.21 5.48 0.55 0.130 0.020
1-55
591.66 0.10 0.58 0.68 1.50 34.7
0.0288 1501.20 33.5 0.0088 0.16 4.67 0.79 0.099 0.015
4.3 OK 2.29 OK OK6 2.52 0.15 0.88 1.03 1.50 33.0 1.20 31.8 0.0088 0.16 4.67 0.79 0.099 0.015
1-66
471.66 0.08 0.68 0.75 1.50 33.0
0.0383 1501.20 31.8 0.0077 0.15 4.5 0.88 0.093 0.014
5.3 OK 2.22 OK OK7 2.52 0.12 1.03 1.15 1.50 31.2 1.20 30.0 0.0077 0.15 4.5 0.88 0.093 0.014
1-77
601.66 0.10 1.02 1.12 1.50 31.2
0.0045 1501.20 30.0 0.0222 0.26 6.14 0.41 0.150 0.023
1.0 OK 2.90 OK OK8 2.52 0.15 1.55 1.70 1.70 31.1 1.37 29.7 0.0252 0.275 6.37 0.43 0.159 0.024
1-88
891.66 0.15 1.23 1.38 1.50 31.1
0.0441 1501.37 29.7 0.0071 0.15 4.39 0.94 0.093 0.014
6.4 OK 2.30 OK OK9 2.52 0.22 1.87 2.10 2.10 27.0 1.20 25.8 0.0100 0.17 4.86 1.04 0.100 0.015
1-99
581.66 0.10 1.63 1.73 1.73 27.0
0.0690 1501.20 25.8 0.0066 0.14 4.27 1.12 0.090 0.014
9.3 OK 2.30 OK OK26 2.52 0.15 2.48 2.63 2.63 23.0 1.20 21.8 0.0100 0.17 4.86 1.28 0.100 0.015
1-1026
561.66 0.09 2.89 2.98 2.98 23.0
0.0179 1501.20 21.8 0.0223 0.26 6.15 0.82 0.150 0.023
4.0 OK 3.09 OK OK27 2.52 0.14 4.40 4.54 4.54 22.0 1.20 20.8 0.0340 0.32 6.93 0.93 0.180 0.027
1-1127
601.66 0.10 2.98 3.08 3.08 22.0
0.0083 1501.20 20.8 0.0338 0.32 6.92 0.63 0.180 0.027
2.3 OK 3.37 OK OKFIM 2.52 0.15 4.54 4.69 4.69 21.5 1.20 20.3 0.0514 0.40 7.77 0.71 0.215 0.032
Recommended