Metodo Directo Para Encontrar Tirantes Programado En Excel

|n= |0.016 |b= |12 |Sf= |0.04 |Q= |106.30 |L= |200 | |  | | |Coordenada |Y1 |A1 |P1 |Rh1 |V1 |S1 |V1^2/(2*g) |Ee1 |Sf∆X |Ee1-(S1/2)∆x+Sf∆x |Y2 |A2 |P2 |Rh2 |V2 |S2 |V2^2/(2*g) |Ee2 |Ee2+(S2/2)∆x |  || | | | | | | | | | | | | | | | | | | | | | |0.000 |2.000 |24.00 |16.00 |1.50 |4.43 |0.0029248 |1.000 |3.00 |0.80 |3.771 |1.900 |22.80 |15.80 |1.44 |4.662 |0.0034125 |1.108 |3.008 |3.042 |0.729 | | |  |  |  |  |  |  |  |  |  |  |1.310 |15.72 |14.62 |1.08 |6.762 |0.0106266 |2.331 |3.641 |3.747 |0.024 | |  |  |  |  |  |  |  |  |  |  |  |1.302 |15.62 |14.60 |1.07 |6.806 |0.0108403 |2.361 |3.662|3.771 |0.000 | |20.000 |1.302 |15.62 |14.60 |1.07 |6.81 |0.0108403 |2.361 |3.66 |0.80 |4.354 |1.150 |13.80 |14.30 |0.97 |7.703 |0.0159279 |3.024 |4.174 |4.333 |0.020 | |  |  |  |  |  |  |  |  |  |  | |1.146 |13.75 |14.29 |0.96 |7.732 |0.0161151 |3.047 |4.193 |4.354 |0.000 | |40.000 |1.146 |13.75 |14.29 |0.96 |7.73 |0.0161151 |3.047 |4.19 |0.80 |4.831 |1.070 |12.84 |14.14 |0.91 |8.279 |0.0199536|3.493 |4.563 |4.763 |0.069 | |  |  |  |  |  |  |  |  |  |  |  |1.059 |12.71 |14.12 |0.90 |8.365 |0.0206101 |3.566 |4.625 |4.831 |0.000 | |60.000 |1.059 |12.71 |14.12 |0.90 |8.36 |0.0206101 |3.566 |4.63|0.80 |5.219 |1.010 |12.12 |14.02 |0.86 |8.771 |0.0239127 |3.921 |4.931 |5.170 |0.049 | |  |  |  |  |  |  |  |  |  |  |  |1.003 |12.04 |14.01 |0.86 |8.828 |0.0244035 |3.972 |4.975 |5.219 |0.000 ||80.000 |1.003 |12.04 |14.01 |0.86 |8.83 |0.0244035 |3.972 |4.98 |0.80 |5.531 |0.970 |11.64 |13.94 |0.84 |9.132 |0.0271527 |4.251 |5.221 |5.492 |0.039 | |  |  |  |  |  |  |  |  |  |  |  |0.966 |11.59|13.93 |0.83 |9.175 |0.0275531 |4.290 |5.256 |5.531 |0.000 | |100.000 |0.966 |11.59 |13.93 |0.83 |9.17 |0.0275531 |4.290 |5.26 |0.80 |5.780 |0.940 |11.28 |13.88 |0.81 |9.424 |0.0299775 |4.526 |5.466|5.766 |0.014 | |  |  |  |  |  |  |  |  |  |  |  |0.938 |11.26 |13.88 |0.81 |9.439 |0.0301298 |4.541 |5.479 |5.781 |0.000 | |120.000 |0.938 |11.26 |13.88 |0.81 |9.44 |0.0301298 |4.541 |5.48 |0.80 |5.978...