cálculo de flujo variado.xlsx
TRANSCRIPT
Q 400 cfs yc 2.15 ftb 20 ft yn 3.36 ftz 2 alfa 1
So 0.0016 gravedad 32.2 sfsn 0.025
Y T A R R^2/3 K Z5.00 40.00 150.00 3.54 2.323 20769.4 290.54.80 39.20 142.08 3.43 2.273 19245.9 270.54.60 38.40 134.32 3.31 2.221 17782.7 251.24.40 37.60 126.72 3.19 2.169 16379.2 232.64.20 36.80 119.28 3.08 2.115 15034.8 214.74.00 36.00 112.00 2.96 2.060 13749.0 197.53.80 35.20 104.88 2.84 2.003 12521.2 181.03.70 34.80 101.38 2.77 1.974 11928.9 173.03.60 34.40 97.92 2.71 1.945 11350.9 165.23.55 34.20 96.21 2.68 1.930 11067.2 161.43.50 34.00 94.50 2.65 1.915 10787.1 157.53.47 33.88 93.48 2.63 1.906 10620.8 155.33.44 33.76 92.47 2.61 1.897 10455.7 153.03.42 33.68 91.79 2.60 1.891 10346.4 151.53.40 33.60 91.12 2.59 1.885 10237.6 150.13.36 33.44 89.78 2.56 1.873 10021.7 147.1
3.30 3.50 3.70 3.90 4.10 4.30 4.50 4.70 4.90 5.100.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
Y vs dx/dy
Y
dx/d
y
3.30 3.50 3.70 3.90 4.10 4.30 4.50 4.70 4.90 5.100.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
Y vs dx/dy
Y
dx/d
y
Zc 70.5 3.4 y 5Kn 10000
L 2393.89L Ven T Chow 2401 %dL 0.2959
dx/dy dA x765.70 0797.99 156.37 156.37842.08 164.01 320.38904.92 174.70 495.08
1000.08 190.50 685.581158.02 215.81 901.391464.10 262.21 1163.601753.67 160.89 1324.492283.65 201.87 1526.352754.99 125.97 1652.323554.95 157.75 1810.074372.48 118.91 1928.985774.53 152.21 2081.187439.58 132.14 2213.32
10617.42 180.57 2393.89111193.16
3.30 3.50 3.70 3.90 4.10 4.30 4.50 4.70 4.90 5.100.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
Y vs dx/dy
Y
dx/d
y
3.3503.31003.31503.32003.30.00
1.00
2.00
3.00
4.00
5.00
6.00
X vs Y
X
Y
3.30 3.50 3.70 3.90 4.10 4.30 4.50 4.70 4.90 5.100.00
2000.00
4000.00
6000.00
8000.00
10000.00
12000.00
Y vs dx/dy
Y
dx/d
y
3.3503.31003.31503.32003.30.00
1.00
2.00
3.00
4.00
5.00
6.00
X vs Y
X
Y
3.3503.31003.31503.32003.30.00
1.00
2.00
3.00
4.00
5.00
6.00
X vs Y
X
Y
3.3503.31003.31503.32003.30.00
1.00
2.00
3.00
4.00
5.00
6.00
X vs Y
X
Y
Q 400 cfs yc 2.15 ft 3.4b 20 ft yn 3.36 ftz 2 alfa 1
So 0.0016 gravedad 32.2 sfsn 0.025
Y A R R^4/3 V V^2/2g E5.00 150.00 3.54 5.40 2.667 0.1104 5.11044.80 142.08 3.43 5.17 2.815 0.1231 4.92314.60 134.32 3.31 4.93 2.978 0.1377 4.73774.40 126.72 3.19 4.70 3.157 0.1547 4.55474.20 119.28 3.08 4.47 3.353 0.1746 4.37464.00 112.00 2.96 4.24 3.571 0.1981 4.19813.80 104.88 2.84 4.01 3.814 0.2259 4.02593.70 101.38 2.77 3.90 3.946 0.2417 3.94173.60 97.92 2.71 3.78 4.085 0.2591 3.85913.55 96.21 2.68 3.73 4.158 0.2684 3.81843.50 94.50 2.65 3.67 4.233 0.2782 3.77823.47 93.48 2.63 3.63 4.279 0.2843 3.75433.44 92.47 2.61 3.60 4.326 0.2906 3.73063.42 91.79 2.60 3.58 4.358 0.2949 3.71493.40 91.12 2.59 3.55 4.390 0.2992 3.6992
y 5 L 2367.32L Ven T Chow 2375 %dL 0.3234
dE Sf Sf prom So-Sf dx x0.000371
0.1873 0.000432 0.000401 0.001199 156.31 156.310.1854 0.000506 0.000469 0.001131 163.90 320.210.1830 0.000596 0.000551 0.001049 174.47 494.680.1801 0.000708 0.000652 0.000948 190.00 684.680.1766 0.000846 0.000777 0.000823 214.57 899.260.1722 0.001021 0.000934 0.000666 258.36 1157.620.0841 0.001124 0.001073 0.000527 159.50 1317.120.0826 0.001242 0.001183 0.000417 198.20 1515.320.0407 0.001306 0.001274 0.000326 124.83 1640.150.0402 0.001375 0.001341 0.000259 155.14 1795.290.0239 0.001418 0.001397 0.000203 117.64 1912.940.0237 0.001464 0.001441 0.000159 149.28 2062.220.0157 0.001495 0.001479 0.000121 130.07 2192.290.0156 0.001527 0.001511 0.000089 175.03 2367.32
Q 400 cfs yc 2.15 ftb 20 ft yn 3.36 ftz 2 alfa 1
So 0.0016 gravedad 32.2 sfsn 0.025
Y prom 4.2 M 3.43 Ay/b 2.1 N 3.65 B
J 2.99
y u v F(u,N) F(v,J) L5 1.488 1.624 0.148 0.213 L Ven T Chow
3.4 1.012 1.015 1.025 1.293Dif 0.476 -0.877 -1.080
Zc 70.5 3.4 y 5Kn 10000
21000.1772
0.197
2439.7212394.904 %dL -1.8713
Q 7.132 m3/s yc 2.15 ft 3.4D 1.8 m yn 3.36 ftz 2 alfa 1
So 0.02 gravedad 9.81 sfsn 0.012
Y/D A/D^2 R/D Y A R R^4/3 V0.74 0.6231 0.3006 1.33 2.02 0.54 0.44 3.5330.7 0.5872 0.2962 1.26 1.90 0.53 0.43 3.749
0.65 0.5404 0.2881 1.17 1.75 0.52 0.42 4.0730.6 0.492 0.2776 1.08 1.59 0.50 0.40 4.474
0.55 0.4426 0.2649 0.99 1.43 0.48 0.37 4.9730.5 0.3927 0.25 0.90 1.27 0.45 0.34 5.605
0.49 0.3827 0.2467 0.88 1.24 0.44 0.34 5.7520.48 0.3727 0.2434 0.86 1.21 0.44 0.33 5.9060.46 0.3527 0.2366 0.83 1.14 0.43 0.32 6.241
0 20 40 60 80 100 120 140 1600.00
0.20
0.40
0.60
0.80
1.00
1.20
1.40
X vs Y
X
Y
y 5 L 139.05L Ven T Chow 2375 %dL 94.1455
V^2/2g E dE Sf Sf prom So-Sf dx x0.6997 2.0317 0.0040760.7879 2.0479 0.0162 0.004681 0.004378 0.015622 1.04 1.040.9302 2.1002 0.0524 0.005735 0.005208 0.014792 3.54 4.581.1223 2.2023 0.1020 0.007270 0.006502 0.013498 7.56 12.131.3868 2.3768 0.1745 0.009562 0.008416 0.011584 15.06 27.201.7616 2.6616 0.2848 0.013121 0.011341 0.008659 32.89 60.091.8549 2.7369 0.0753 0.014062 0.013591 0.006409 11.74 71.841.9557 2.8197 0.0829 0.015096 0.014579 0.005421 15.29 87.122.1838 3.0118 0.1921 0.017505 0.016300 0.003700 51.92 139.05
0 20 40 60 80 100 120 140 1600.00
0.20
0.40
0.60
0.80
1.00
1.20
1.40
X vs Y
X
Y