Anstruk Fix.xlsx

1
No. Member Length (m) Area (m2) Length/Are a (1/m) S' μL4 μL2 (S'.μL4).(L/AE ) (S'.μL2).(L/AE) (μL2.μL2).(L/AE) (μL4.μL4).(L/AE ) (μL4.μL2).(L/AE) S = S' + μL4.R1 + μL2.R2 (ton) 1 U0U1 6 0.004 1500 -17.32 0.17 0.40 -4499.74 -10495.92 244.82 45.00 104.96 -1.39 2 U1U2 6 0.004 1500 -46.19 0.52 1.21 -36000.49 -83973.42 2203.42 404.98 944.63 1.59 3 U2U3 6 0.004 1500 -57.74 0.89 0.89 -76669.19 -76669.19 1175.63 1175.63 1175.63 -8.80 4 U3U4 6 0.004 1500 -46.19 1.21 0.52 -83964.33 -35996.59 404.98 2203.42 944.63 1.75 5 U4U5 6 0.004 1500 -17.32 0.40 0.17 -10495.92 -4499.74 45.00 244.82 104.96 -1.34 6 U5L5 6 0.004 1500 34.64 -0.81 -0.35 -41983.68 -17998.94 179.99 979.30 419.84 2.68 7 L4L5 6 0.004 1500 36.64 -0.81 -0.35 -44407.68 -19038.14 179.99 979.30 419.84 4.68 8 L3L4 6 0.004 1500 57.57 -1.21 -0.86 -104280.91 -74339.55 1111.46 2187.08 1559.12 0.37 9 L2L3 6 0.004 1500 57.57 -0.86 -1.21 -74339.55 -104280.91 2187.08 1111.46 1559.12 0.45 10 L1L2 6 0.004 1500 34.64 -0.35 -0.81 -17998.94 -41983.68 979.30 179.99 419.84 2.79 11 U0L1 6 0.004 1500 34.64 -0.35 -0.81 -17998.94 -41983.68 979.30 179.99 419.84 2.79 12 U1L1 6 0.002 3000 -34.64 0.35 0.81 -35997.89 -83967.36 1958.59 359.98 839.67 -2.79 13 U1L2 6 0.002 3000 23.10 -0.35 -0.81 -24005.52 -55994.40 1958.59 359.98 839.67 -8.75 14 U2L2 6 0.002 3000 -23.10 0.35 -0.35 -24005.52 24026.31 360.60 359.98 -360.29 -23.03 15 U2L3 6 0.002 3000 0.00 -0.35 0.35 0.00 0.00 360.60 360.00 -360.30 -0.07 16 U3L3 6 0.002 3000 0.00 0.35 -0.35 0.00 0.00 360.60 360.00 -360.30 0.07 17 U3L4 6 0.002 3000 -23.10 -0.35 0.35 24006.22 -24005.52 359.98 360.00 -359.99 -23.18 18 U4L4 6 0.002 3000 23.10 -0.81 -0.35 -55994.40 -24005.52 359.98 1958.59 839.67 -8.86 19 U4L5 6 0.002 3000 -34.64 0.81 0.35 -83967.36 -35997.89 359.98 1958.59 839.67 -2.68 -712603.8334 -711204.1406 15769.8966 15768.08859 9990.225237 Δcp Δdp δjj δhh δhj = δjh A + B X = 0 B-1 -712603.83 15769.897 9990.2252 R1 712604 -711204.14 9990.2252 15768.089 R2 711204 R1 = 27.754 R2 = 27.52 Va = 2.2464 Vb = 2.2464 59.766 2.246357473 -2.102096355

description

anstruk fix

Transcript of Anstruk Fix.xlsx

  • No. Member Length(m) Area (m2)Length/Are

    a (1/m) S' L4 L2(S'.L4).(L/AE

    ) (S'.L2).(L/AE) (L2.L2).(L/AE)(L4.L4).(L/AE

    ) (L4.L2).(L/AE)S = S' + L4.R1 +

    L2.R2 (ton)1 U0U1 6 0.004 1500 -17.32 0.17 0.40 -4499.74 -10495.92 244.82 45.00 104.96 -1.392 U1U2 6 0.004 1500 -46.19 0.52 1.21 -36000.49 -83973.42 2203.42 404.98 944.63 1.593 U2U3 6 0.004 1500 -57.74 0.89 0.89 -76669.19 -76669.19 1175.63 1175.63 1175.63 -8.804 U3U4 6 0.004 1500 -46.19 1.21 0.52 -83964.33 -35996.59 404.98 2203.42 944.63 1.755 U4U5 6 0.004 1500 -17.32 0.40 0.17 -10495.92 -4499.74 45.00 244.82 104.96 -1.346 U5L5 6 0.004 1500 34.64 -0.81 -0.35 -41983.68 -17998.94 179.99 979.30 419.84 2.687 L4L5 6 0.004 1500 36.64 -0.81 -0.35 -44407.68 -19038.14 179.99 979.30 419.84 4.688 L3L4 6 0.004 1500 57.57 -1.21 -0.86 -104280.91 -74339.55 1111.46 2187.08 1559.12 0.379 L2L3 6 0.004 1500 57.57 -0.86 -1.21 -74339.55 -104280.91 2187.08 1111.46 1559.12 0.4510 L1L2 6 0.004 1500 34.64 -0.35 -0.81 -17998.94 -41983.68 979.30 179.99 419.84 2.7911 U0L1 6 0.004 1500 34.64 -0.35 -0.81 -17998.94 -41983.68 979.30 179.99 419.84 2.7912 U1L1 6 0.002 3000 -34.64 0.35 0.81 -35997.89 -83967.36 1958.59 359.98 839.67 -2.7913 U1L2 6 0.002 3000 23.10 -0.35 -0.81 -24005.52 -55994.40 1958.59 359.98 839.67 -8.7514 U2L2 6 0.002 3000 -23.10 0.35 -0.35 -24005.52 24026.31 360.60 359.98 -360.29 -23.0315 U2L3 6 0.002 3000 0.00 -0.35 0.35 0.00 0.00 360.60 360.00 -360.30 -0.0716 U3L3 6 0.002 3000 0.00 0.35 -0.35 0.00 0.00 360.60 360.00 -360.30 0.0717 U3L4 6 0.002 3000 -23.10 -0.35 0.35 24006.22 -24005.52 359.98 360.00 -359.99 -23.1818 U4L4 6 0.002 3000 23.10 -0.81 -0.35 -55994.40 -24005.52 359.98 1958.59 839.67 -8.8619 U4L5 6 0.002 3000 -34.64 0.81 0.35 -83967.36 -35997.89 359.98 1958.59 839.67 -2.68

    -712603.8334 -711204.1406 15769.8966 15768.08859 9990.225237cp dp jj hh hj = jh

    A + B X = 0 B-1-712603.83 15769.897 9990.2252 R1 712604-711204.14 9990.2252 15768.089 R2 711204

    R1 = 27.754R2 = 27.52Va = 2.2464Vb = 2.2464

    59.766 2.246357473-2.102096355