01. Vertedero - Tuberia.xlsx

Diseño de un vertedero lateral de excedencia por el metodo de inc Datos de ingreso 0.85 m Umbral del vertedero. 1m Delta L 2m Ancho de solera 1.05 m tirante normal 1 talud. 0.015 Coeficiente de rugosidad 0.001 Pendiente

a= ∆L= B= y= z= n= S=

Q= 5.03688311 m3/s

�=𝟎.𝟒𝟑𝟒+𝟎.𝟐𝟏(𝒉/(𝒉+𝒂))^𝟐 ∆�=�𝒉√𝟐𝒈𝒉 ∆�

Caudal

𝑬𝒄.𝟐

1

2

3

4

5

6

7

8

y

Q

h

m Ec. 1

∆Q Ec. 2

Q ∆Q

T

1.05 1.03706525 1.0238234 1.01035563 0.99674739 0.98308816 0.96947115

5.03688311 5.21184453 5.3698285 5.51108781 5.63603513 5.74523599 5.83939951

0.2 0.18706525 0.1738234 0.16035563 0.14674739 0.13308816 0.11947115

𝒉√𝟐𝒈𝒉

0.44161905 0.44083272 0.44005321 0.4392898 0.43855187 0.43784869 0.43718915

0.17496142 0.15798397 0.14125931 0.12494732 0.10920086 0.09416352 0.07996748

0.88126022 0.82338787 0.75853826 0.68859567 0.61545989 0.54099163 0.46696209

4.1 4.07413051 4.04764681 4.02071127 3.99349479 3.96617631 3.9389423

0.39618178 0.35837623 0.32100506 0.28443029 0.24900329 0.21505949 0.18291278

𝑬𝒄. 1

excedencia por el metodo de incrementos diferenciales.

(𝒉+𝒂))^𝟐

�)/𝑨−𝒈𝑨^𝟐 ) 𝑬𝒄.(�∙∆�)/((�^𝟐 1

9

10

11

Q2T

A

104.017785 110.666925 116.714131 122.1174 126.852931 130.914503 134.312365

3.2025 3.14963485 3.09586117 3.04152978 2.98700015 2.93263864 2.8788166

𝑬𝒄. 𝟑

12

〖� ^𝟐 � 〗∕� gA2 32.4801827 35.1364301 37.7000532 40.1499932 42.4683375 44.6405163 46.6554087

100.611421 97.3171591 94.0225364 90.7513623 87.5264867 84.3696237 81.3012091

13

14

15

16

Q2T/A-gA2

(7)/(13) Ec. 3

y+∆h

Lacum.

-68.131239 -62.180729 -56.322483 -50.601369 -45.058149 -39.729107 -34.6458

-0.0129347 -0.0132418 -0.0134678 -0.0136082 -0.0136592 -0.013617 -0.0134782

1.03706525 1.0238234 1.01035563 0.99674739 0.98308816 0.96947115 0.95599297

0 1 2 3 4 5 6

Ejercicio de tuberia de riego

D [plg] 6 8 10

D[m]

Q[m3/s]

L [m]

C

0.1524 0.2032 0.254

0.073 0.112 0.157

174 123 350

150 150 150 ∑

ε=

1.5E-06 m

υ=

1.03E-06 m2/s

D [plg] 6 8 10

D[m] 0.1524 0.2032 0.254

Q[m3/s] 0.073 0.112 0.157

Hf 12.9494 𝒉_𝒇=𝟏𝟎.𝟔𝟒𝟖𝑪^(−𝟏.𝟖𝟓𝟐) �^(𝟏.𝟖𝟓𝟐) 𝑫^(𝟒.𝟖𝟕𝟏) � 4.9809 8.93462 26.8649

Datos de tabla L [m]

V [m/s]

Re

174 4.00187 592121 123 3.45367 681345 350 3.09843 764080

ε/D 9.843E-06 7.382E-06 5.906E-06

f 0.01292 8.7971 8.7971 0.01258 8.915965 8.91596 0.01231 9.011814 9.01181 26.72488 26.7249

hf [m] 12.0424 4.62921 8.30224 24.9738

km 3.5 3.3 4.2

∑hm 2.8569 2.00621 2.05511 6.91822 31.8921