Eng. M.Sc.

J
Amortecimento
Método P
Esta planilha foi desenvolvida baseado no livro "Drenagem
Urbana e controle de enchentes" 2a Edição, e nas aulas do
Prof. Walter Collischonn e possui caráter apenas didático, Contato: contato@eng
cabendo ao usuário a responsabilidade do uso.
ng. M.Sc. José Costa
ortecimento de Cheias
Método Puls

ontato: [email protected]
1 CARACTERÍSTICAS DO VERTEDOR DE CRISTA

DADOS VALORES UNIDADES

L: m 𝑄=𝐶×𝐿×(𝐻−𝐻_𝑠 )^(3/2)
Hs: m
C: 1.8 adm

2 CARACTERÍSTICAS DO DESCARREGADOR DE FUNDO

DADOS VALORES UNIDADES

Quantidade Unidades
D: m
C: adm 𝑄=𝐶×𝐴×√(2×𝑔×(𝐻−𝐻_𝑒 ) )
Cota eixo: m
R: 0m
R^2: 0m
A: 0 m²

3 HIDROGRAMA AFLUENTE
Tempo (H) Vazão I (m³/s)
0 0.0
0.1 2.3
0.2 3.5
0.3 4.8
0.4 7.9
0.5 10.4
0.6 11.9
0.7 12.6
0.8 12.7
0.9 12.0
1 10.9
1.1 9.4
1.2 8.0
1.3 7.0
1.4 6.3
1.5 5.9
1.6 5.5
1.7 5.1
1.8 4.8
1.9 4.3
2 3.8
2.1 3.2
2.2 2.3
2.3 1.6
2.4 1.0
2.5 0.6
2.6 0.3
2.7 0.1
2.8 0.0
2.9 0.0
4 DEFINIR INTERVALO DE TEMPO
Intervalo de tempo
∆𝑡≤𝑡_𝑝/5

DADOS VALORES UNIDADES

tp: 0.8 H
tp/5: 0.16 H
∆ 𝑡: 0.1 H
∆ 𝑡: 360 s
Verificação: OK

5 COTA x VOLUME
Na tabela abaixo devemos inserir as cotas x volume do nosso reservatório
Volume (1000
Cota (m) Volume (m³) Q Vertedor Q Descarregador Q Total 2×𝑆/∆𝑡+𝑄 (m³/s)
m³)
134 0 0 0 0.0 0.0
135 0 0 0 0.0 0.0
136 0 0 0 0.0 0.0
137 0 0 0 0.0 0.0
138 0 0 0 0.0 0.0
139 0 0 0 0.0 0.0
140 0 0 0 0.0 0.0

2×𝑆/∆𝑡+𝑄
𝑄=𝐶×𝐿×(𝐻−𝐻_𝑠 )^(3/2)

𝑄=𝐶×𝐴×√(2×𝑔×(𝐻−𝐻_𝑒 ) )
 Cota x Q Total Cota x Q Total x Q Desc.
1.0 1.0
0.9 0.9
0.8 0.8
0.7 0.7
0.6 0.6
0.5 0.5
0.4 0.4
0.3 0.3
0.2 0.2
0.1 0.1
0.0 0.0
133 134 135 136 137 138 139 140 141 133 134 135 136 137 138 139 140 141

Cota x 2×𝑆/∆ 𝑡+𝑄 Q Total x 2×𝑆/∆ 𝑡+𝑄

1.0 1.0
0.9 0.9
0.8 0.8
0.7 0.7
0.6 0.6
0.5 0.5
0.4 0.4
0.3 0.3
0.2 0.2
0.1 0.1
0.0 0.0
133 134 135 136 137 138 139 140 141 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0

Cota x Volume(m³)
12

10

0
133 134 135 136 137 138 139 140 141
 𝑥=2𝑆/∆𝑡+𝑄
((2×𝑆_2)/∆𝑡+𝑄_2 )=(𝐼_1+𝐼_2 )+((2×𝑆_1)/∆𝑡)−𝑄_1

Vazão afluente com 1 𝑄=𝑄_𝑎𝑏𝑎𝑖𝑥𝑜+(𝑄_𝑎𝑐𝑖𝑚𝑎−𝑄_𝑎𝑏𝑎𝑖𝑥𝑜 )×((𝑥−𝑥_𝑖𝑛𝑓 ))/((𝑥_𝑠𝑢𝑝−𝑥_𝑖𝑛𝑓 ) )

Volume no passo
Vazão do hidrograma afluente passo de tempo Vazão efluente no tempo 1 Volume no tempo 2
de tempo 1 (𝐼_1+𝐼_2 )+((2×𝑆_1)/∆𝑡)−𝑄_1 ((2×𝑆_2)/∆𝑡+𝑄_2 )
avançado

Comandos para interpolação linear

Tempo (H) Vazão I (m³/s) Vazão I (t+∆𝑡) S1 (t) Q1 (m³/s) (𝐼1+𝐼2 )+((2×𝑆1)/∆𝑡)−𝑄1 ((2×𝑆2)/∆𝑡+𝑄2 ) Pos. Tabela Abaixo Acima Qabaixo Qacima Q2 (2×𝑆1)/∆𝑡 S2

10:00:00 AM 0 2.3 0 2.3 0.0 0.0 7 0.0 Err:502 0.0 Err:502 Err:502 Err:502 Err:502
10:06:00 AM 2.3 3.5 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:12:00 AM 3.5 4.845923786107 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:18:00 AM 4.8 7.947528733782 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:24:00 AM 7.9 10.37083867783 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:30:00 AM 10.4 11.92402791888 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:36:00 AM 11.9 12.63791983029 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:42:00 AM 12.6 12.66464429956 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:48:00 AM 12.7 12.02588942034 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
10:54:00 AM 12.0 10.88579456763 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:00:00 AM 10.9 9.377938037189 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:06:00 AM 9.4 8.016896122497 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:12:00 AM 8.0 7.014741052379 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:18:00 AM 7.0 6.333581523704 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:24:00 AM 6.3 5.887054386426 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:30:00 AM 5.9 5.489171090544 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:36:00 AM 5.5 5.097721555157 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:42:00 AM 5.1 4.823270394285 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:48:00 AM 4.8 4.334162941812 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
11:54:00 AM 4.3 3.785957292875 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:00:00 PM 3.8 3.179665640525 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:06:00 PM 3.2 2.308122044376 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:12:00 PM 2.3 1.58682709386 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:18:00 PM 1.6 1.017698474681 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:24:00 PM 1.0 0.601745843599 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:30:00 PM 0.6 0.315564532739 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:36:00 PM 0.3 0.106735107929 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:42:00 PM 0.1 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:48:00 PM 0.0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
12:54:00 PM 0.0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:00:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:06:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:12:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:18:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:24:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:30:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:36:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:42:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:48:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
01:54:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:00:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:06:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:12:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:18:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:24:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:30:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:36:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:42:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:48:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
02:54:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:00:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:06:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:12:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:18:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:24:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
03:30:00 PM 0 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502
 0
2
4
6
8
10
12
14
10:00
10:06
10:12
10:18
10:24
10:30
10:36
10:42
10:48
10:54
11:00
11:06
11:12
11:18
11:24
11:30
11:36
11:42
11:48
11:54
12:00
12:06
12:12
12:18
12:24
12:30
12:36
12:42
12:48
12:54
13:00
13:06
13:12
13:18
13:24
13:30
13:36
13:42
13:48
13:54
14:00
14:06
14:12
14:18
14:24
14:30
14:36
14:42
14:48
14:54
15:00
15:06
Entrada

15:12
15:18
15:24
15:30
15:36
15:42
15:48
15:54
Saída (EXCEL)

16:00
16:06