3
SECCION H H^3 X L-X Y 1 1.25 1.953125 0.5 8.5 530.335 2 0.75 0.421875 1.5 7.5 1405.005 3 0.5 0.125 2.5 6.5 2031.675 4 0.5 0.125 3.5 5.5 2410.345 5 0.5 0.125 4.5 4.5 2541.015 6 1.2 1.728 5.5 3.5 2416.185 7 1.2 1.728 6.5 2.5 2035.855 8 1.2 1.728 7.5 1.5 1407.525 9 1.2 1.728 8.5 0.5 531.195 UL 3.17686091 VL 4.84887082 U 2139.58661 V 2199.6912

Excell Metodo Grafico

Embed Size (px)

DESCRIPTION

método grafico

Citation preview

Page 1: Excell Metodo Grafico

CUADRO DE EXCEL

SECCION H H^3 X L-X Y X/H^31 1.25 1.953125 0.5 8.5 530.335 0.2562 0.75 0.421875 1.5 7.5 1405.005 3.555555555563 0.5 0.125 2.5 6.5 2031.675 204 0.5 0.125 3.5 5.5 2410.345 285 0.5 0.125 4.5 4.5 2541.015 366 1.2 1.728 5.5 3.5 2416.185 3.182870370377 1.2 1.728 6.5 2.5 2035.855 3.761574074078 1.2 1.728 7.5 1.5 1407.525 4.340277777789 1.2 1.728 8.5 0.5 531.195 4.91898148148

104.015259259

UL 3.17686091VL 4.84887082U 2139.58661V 2199.6912

Page 2: Excell Metodo Grafico

CUADRO DE EXCEL

(L-X)/H^3 X*(L-X)/H^3 Y/H^3 X*Y/H^34.352 2.176 271.53152 135.76576

17.77777777778 26.6666666666667 3330.3822222222 4995.57333333352 130 16253.4 40633.544 154 19282.76 67489.6636 162 20328.12 91476.54

2.025462962963 11.1400462962963 1398.2552083333 7690.4036458331.446759259259 9.40393518518519 1178.1568287037 7658.0193865740.868055555556 6.51041666666667 814.53993055556 6109.0494791670.289351851852 2.45949074074074 307.40451388889 2612.938368056158.7594074074 504.356555555556 63164.550223704 228801.449973