Planilla de Excel Para Calculo Hidraulico
17
TABLA 1 Calculo de caudal [ Flujo uniforme Nº Y (cm) x (cm) t1 t2 t3 t4 t5 1 2.2 100 1.05 1.02 1.1 1.1 1.1 2 2.1 100 0.9 0.97 0.89 1 1.08 3 1.6 100 1.01 1.2 1.1 1.08 1.1 4 0.9 100 1.51 1.5 1.4 1.56 1.52 5 0.4 100 2.3 2.4 2.5 2.34 2.3 TABLA 2 Calculo de caudal [ Energia Especifica] Nº t1 t2 t3 t4 t5 tprom 1 17.4 17.49 17.54 17.75 17.44 17.524 0.00092 2 24.33 24.26 24.37 24.15 24.5 24.322 0.00066 3 46.46 46.27 46.1 46.25 46.43 46.302 0.00035 4 22 21.46 21.78 22 21.92 21.832 0.00074 5 30.97 30.95 31.02 30.9 30.93 30.954 0.00052 Q (m`3/s)
-
Upload
jaime-guerra -
Category
Documents
-
view
323 -
download
16
Transcript of Planilla de Excel Para Calculo Hidraulico
TABLA 1 Calculo de caudal [ Flujo uniforme]
Nº x (cm) t1 t2 t3 t4 t5 tprom
1 2.2 100 1.05 1.02 1.1 1.1 1.1 1.074 2.50E-042 2.1 100 0.9 0.97 0.89 1 1.08 0.968 2.80E-043 1.6 100 1.01 1.2 1.1 1.08 1.1 1.098 2.40E-044 0.9 100 1.51 1.5 1.4 1.56 1.52 1.498 1.80E-045 0.4 100 2.3 2.4 2.5 2.34 2.3 2.368 1.10E-04
TABLA 2 Calculo de caudal [ Energia Especifica]
Nº t1 t2 t3 t4 t5 tprom
1 17.4 17.49 17.54 17.75 17.44 17.524 0.00092 9202 24.33 24.26 24.37 24.15 24.5 24.322 0.00066 6603 46.46 46.27 46.1 46.25 46.43 46.302 0.00035 3504 22 21.46 21.78 22 21.92 21.832 0.00074 740
5 30.97 30.95 31.02 30.9 30.93 30.954 0.00052 520
Y (cm)
Q (m`3/s)
Q (m`3/s)
x1= 62 [cm]Nº TIEMPO [S]
x2= 20 [cm] 1 35.4 0.00046p= 5.2 2.6 2 36 0.00045
16.12 8.06 3 35.87 0.000451000 4 35.82 0.00045
5 36 0.00045
CAUDAL [m3/S]
w(H2O)δ(H2O)
1,- GRAFICO V VRS Yb= 7.4
Q [m3/s] 0.00025 0.00028 0.00024 0.00018
y[m] 0.02200 0.02100 0.01600 0.00900
v [m/s] 0.00154 0.00180 0.00203 0.00270
2,- RADIO HIDRAULICO
y (m) R (m) v (m/s)
0.022 0.02187 0.001540.021 0.02088 0.001800.016 0.01593 0.002030.009 0.00898 0.00270
0.004 0.00400 0.00372
0 0.005 0.01 0.015 0.02 0.0250.00000
0.00050
0.00100
0.00150
0.00200
0.00250
0.00300
0.00350
0.00400
y [m]
v [m
/s]
1,- GRAFICO V VRS Y
0.00011 0.022 0.00154
0.00400 0.021 0.00180
0.00372 0.016 0.0020279.00E-03 2.70E-034.00E-03 3.72E-03
2,- RADIO HIDRAULICO
0 0.005 0.01 0.015 0.02 0.0250.00000
0.00050
0.00100
0.00150
0.00200
0.00250
0.00300
0.00350
0.00400
y [m]
v [m
/s]
7.4Nº
980 1 920 2.5072 660 2.0093 350 1.3164 740 2.1695 520 1.741
profundidad hidraulica
Nº
1 2.507 18.552 2.5072 2.009 14.867 2.0093 1.316 9.738 1.3164 2.169 16.051 2.1695 1.741 12.883 1.741
3.761723.014561.975033.253492.57217
Q (cm3/s
)
Yc (cm)
Yc (cm)
A (cm^2
)
D (cm)
AGUAS ARRIBAcaudal0 920
b= 7.4n Fr OBS.
g= 980 1 5.9 43.66 6.127 0.277 Régimen sub- critico2 5.6 41.44 5.851 0.300 Régimen sub- critico3 5.3 39.22 5.581 0.325 Régimen sub- critico4 4.7 34.78 5.057 0.390 Régimen sub- critico5 4.3 31.82 4.727 0.445 Régimen sub- critico6 3.7 27.38 4.276 0.558 Régimen sub- critico
caudal0 660
b= 7.4n Fr OBS
g= 980 1 5.6 41.44 5.729 0.215 Régimen sub- critico2 5.2 38.48 5.350 0.240 Régimen sub- critico3 4.9 36.26 5.069 0.263 Régimen sub- critico4 4.4 32.56 4.610 0.309 Régimen sub- critico5 4 29.6 4.254 0.356 Régimen sub- critico6 3.5 25.9 3.831 0.435 Régimen sub- critico7 2.9 21.46 3.383 0.577 Régimen sub- critico
caudal0 350
b= 7.4n Fr OBS
g= 980 1 4.6 34.04 4.654 0.153 Régimen sub- critico2 4.2 31.08 4.265 0.176 Régimen sub- critico3 3.9 28.86 3.975 0.196 Régimen sub- critico4 3.4 25.16 3.499 0.241 Régimen sub- critico5 3 22.2 3.127 0.291 Régimen sub- critico6 2.7 19.98 2.857 0.341 Régimen sub- critico7 2.2 16.28 2.436 0.463 Régimen sub- critico
caudal0 740
b= 7.4n Fr OBS
g= 980 1 5.9 43.66 6.047 0.223 Régimen sub- critico2 5.5 40.7 5.669 0.248 Régimen sub- critico3 5.1 37.74 5.296 0.277 Régimen sub- critico4 4.8 35.52 5.021 0.304 Régimen sub- critico5 4.3 31.82 4.576 0.358 Régimen sub- critico6 3.8 28.12 4.153 0.431 Régimen sub- critico
7 3.2 23.68 3.698 0.558 Régimen sub- critico
caudal0 520
y (cm)
A (cm^
2)
E (cm)
y (cm)
A (cm^
2)
E (cm)
y (cm)
A (cm^
2)
E (cm)
y (cm)
A (cm^
2)
E (cm)
b= 7.4n Fr OBS
g= 980 1 5.3 39.22 5.390 0.184 Régimen sub- critico2 5 37 5.101 0.201 Régimen sub- critico3 4.7 34.78 4.814 0.220 Régimen sub- critico4 4.2 31.08 4.343 0.261 Régimen sub- critico5 3.8 28.12 3.974 0.303 Régimen sub- critico
6 3.6 26.64 3.794 0.329 Régimen sub- critico
7 3 22.2 3.280 0.432 Régimen sub- critico
y (cm)
A (cm^
2)
E (cm)
AGUAS ARRIBA
n y (cm) E (cm) Fr OBS.
1 1.3 9.62 5.966 2.679 Régimen Súper- critico2 1.5 11.1 5.005 2.162 Régimen Súper- critico3 1.5 11.1 5.005 2.162 Régimen Súper- critico4 1.5 11.1 5.005 2.162 Régimen Súper- critico5 1.5 11.1 5.005 2.162 Régimen Súper- critico6 1.5 11.1 5.005 2.162 Régimen Súper- critico
Régimen Súper- critico
n y (cm) E (cm) Fr OBS
1 1 7.4 5.059 2.849 Régimen Súper- critico2 1.1 8.14 4.454 2.470 Régimen Súper- critico3 1.1 8.14 4.454 2.470 Régimen Súper- critico4 1.25 9.25 3.847 2.039 Régimen Súper- critico5 1.1 8.14 4.454 2.470 Régimen Súper- critico6 1.3 9.62 3.701 1.922 Régimen Súper- critico7 1.2 8.88 4.018 2.167 Régimen Súper- critico
n y (cm) E (cm) Fr OBS
1 0.8 5.92 2.583 2.111 Régimen Súper- critico2 0.9 6.66 2.309 1.770 Régimen Súper- critico3 0.7 5.18 3.029 2.580 Régimen Súper- critico4 0.9 6.66 2.309 1.770 Régimen Súper- critico5 0.9 6.66 2.309 1.770 Régimen Súper- critico6 0.8 5.92 2.583 2.111 Régimen Súper- critico7 0.9 6.66 2.309 1.770 Régimen Súper- critico
n y (cm) E (cm) Fr OBS
1 1.1 8.14 5.317 2.769 Régimen Súper- critico2 1.2 8.88 5.892 2.430 Régimen Súper- critico3 1.2 8.88 9.429 2.430 Régimen Súper- critico4 1.3 9.62 8.312 2.155 Régimen Súper- critico5 1.3 9.62 8.312 2.155 Régimen Súper- critico6 1.3 9.62 8.312 2.155 Régimen Súper- critico
A (cm^2
)
A (cm^2
)
A (cm^2
)
A (cm^2
)
n y (cm) E (cm) Fr OBS
1 0.9 6.66 4.010 2.629 Régimen Súper- critico2 1 7.4 3.519 2.245 Régimen Súper- critico3 0.8 5.92 4.736 3.137 Régimen Súper- critico4 1 7.4 3.519 2.245 Régimen Súper- critico5 1 7.4 3.519 2.245 Régimen Súper- critico
6 1 7.4 3.519 2.245 Régimen Súper- critico
A (cm^2
)
Nº EE (cm) Yc (cm)1 6.13 6.132 5.85 5.853 5.58 5.584 5.06 5.065 4.73 4.736 4.28 4.28
Yc 3.76 2.517 5.97 1.38 5.00 1.59 5.00 1.5
10 5.00 1.511 5.00 1.512 5.00 1.5
Nº EE (cm) Yc (cm)1 5.73 5.62 5.35 5.23 5.07 4.94 4.61 4.45 4.25 46 3.83 3.57 3.38 2.9
Yc 3.01 2.0098 7.40 19 8.14 1.1
10 8.14 1.111 9.25 1.2512 8.14 1.113 9.62 1.314 8.88 1.2
Nº EE (cm) Yc (cm)1 4.65 4.62 4.26 4.23 3.98 3.94 3.50 3.45 3.13 36 2.86 2.77 2.44 2.2
Yc 1.98 1.3168 2.58 0.89 2.31 0.9
10 3.03 0.711 2.31 0.912 2.31 0.913 2.58 0.814 2.31 0.9
3.50 4.00 4.50 5.00 5.50 6.00 6.500.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
ENERGIA ESPESIFICA (cm)
Y (c
m)
2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.000
1
2
3
4
5
6
ENERGIA ESPESIFICA (cm)
Y (c
m)
1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.000
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
ENERGIA ESPESIFICA (cm)
Y (c
m)
Nº EE (cm) Yc (cm)1 6.05 5.92 5.67 5.53 5.30 5.14 5.02 4.85 4.58 4.36 4.15 3.87 3.70 3.2
Yc 3.25 2.1698 5.32 1.19 5.89 1.2
10 9.43 1.211 8.31 1.312 8.31 1.313 8.31 1.3
Nº EE (cm) Yi(cm)1 5.39 5.32 5.10 53 4.81 4.74 4.34 4.25 3.97 3.86 3.79 3.67 3.28 3
Yc 2.57 1.7418 4.01 0.99 3.52 1
10 4.74 0.811 3.52 112 3.52 113 3.52 1
2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.000
1
2
3
4
5
6
7
ENERGIA ESPECIFICA (cm)
Y (c
m)
2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.000
1
2
3
4
5
6
ENENERGIA ESPECIFICA (cm)
Y (c
m)
3.50 4.00 4.50 5.00 5.50 6.00 6.500.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
ENERGIA ESPESIFICA (cm)
Y (c
m)
2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.000
1
2
3
4
5
6
ENERGIA ESPESIFICA (cm)
Y (c
m)
1.50 2.00 2.50 3.00 3.50 4.00 4.50 5.000
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
ENERGIA ESPESIFICA (cm)
Y (c
m)
2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.000
1
2
3
4
5
6
7
ENERGIA ESPECIFICA (cm)
Y (c
m)
2.00 2.50 3.00 3.50 4.00 4.50 5.00 5.50 6.000
1
2
3
4
5
6
ENENERGIA ESPECIFICA (cm)
Y (c
m)
