análisis est.xlsx

Upload: emmanuel-zarate-carreno

Post on 05-Jul-2018

212 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/16/2019 análisis Est.xlsx

    1/6

    Barra No. n1 n2

    AB   -8000 -0.6 0

    AF   0 -0.8 0

    BC  -5333.33 -0.8 0

    BF   6666.66 1 0

    CF   -8000 -0.6 -0.6

    DF   6666.66 0 1

    DC   -5333.33 0 -0.8

    EF   0 0 -0.8

    ED   -8000 0 -0.6

    AC   0 1 0

    EC   0 0 1

    REACCIONES

    RAx   0 0 0

    RAy   8000 0 0

    REy   8000 0 0

    MATRIZ

    AC EC

    1728 108   AC

    108 1728  EC

    RESP.

    AC 4313.723094

    EC 4313.723094

    X Y Z

    1 3 2

    2 2 13 1 3

    X 12

     Y -2

    Z 3

  • 8/16/2019 análisis Est.xlsx

    2/6

    L A No*n1*L No n2 L n1 n1 L n1 n2 L

    300 1440000 0 108 0

    400 0 0 256 0

    400 1706665.6 0 256 0

    500 3333330 0 500 0

    300 1440000 1440000 108 108

    500 0 3333330 0 0

    400 0 1706665.6 0 0

    400 0 0 0 0

    300 0 1440000 0 0

    500 0 0 500 0

    500 0 0 0 0

    0 0 0 0

    0 0 0 0

    0 0 0 0

    7919995.6 7919995.6 1728 108

    =

    7919995.6   INVERSA 0.00 0.00

    7919995.6  0.00 0.00

    =

    12   -0.41666667 0.5833333333 0.0833333333

    23   0.25 0.25 -0.2543 0.33333333 -0.6666666667 0.3333333333

  • 8/16/2019 análisis Est.xlsx

    3/6

    n2 n2 L n1 A n2 E N= No!n1A!n2E

    0 -2588.23386 0 -10588.2338562092

    0 -3450.97847 0 -3450.9784749455

    0 -3450.97847 0 -8784.3084749455

    0 4313.72309 0 10980.3830936819

    108 -2588.23386 -2588.23386 -13176.4677124183

    500 0 4313.72309 10980.3830936819

    256 0 -3450.97847 -8784.3084749455

    256 0 -3450.97847 -3450.9784749455

    108 0 -2588.23386 -10588.2338562092

    0 4313.72309 0 4313.7230936819

    500 0 4313.72309 4313.7230936819

    0 0 0

    0 0 0 0

    0 0 0 8000

    0 0 0 8000

    1728

  • 8/16/2019 análisis Est.xlsx

    4/6

    Barra No. n1 n2

    AB   2250 -0.6 0

    AF   0 -0.8 0

    BC   -5333.33 -0.8 0

    BF   6666.66 1 0

    CF   -8000 -0.6 -0.6

    DF   6666.66 0 1

    DC   -5333.33 0 -0.8

    EF   0 0 -0.8

    ED   -8000 0 -0.6

    AC   0 1 0

    EC   0 0 1

    REACCIONES

    RAx   6000 0 0

    RAy   2250 0 0

    REy   2250 0 0

    MATRIZ

    AC EC

    1728 108   AC

    108 1728   ECRESP.

    AC 4313.723094

    EC 4313.723094

  • 8/16/2019 análisis Est.xlsx

    5/6

    L A No*n1*L No n2 L n1 n1 L n1 n2 L

    300 1440000 0 108 0

    400 0 0 256 0

    400 1706665.6 0 256 0

    500 3333330 0 500 0

    300 1440000 1440000 108 108

    500 0 3333330 0 0

    400 0 1706665.6 0 0

    400 0 0 0 0

    300 0 1440000 0 0

    500 0 0 500 0

    500 0 0 0 0

    0 0 0 0

    0 0 0 0

    0 0 0 0

    7919995.6 7919995.6 1728 108

    =

    7919995.6   INVERSA 0.00 0.00

    7919995.6   0.00 0.00

  • 8/16/2019 análisis Est.xlsx

    6/6

    n2 n2 L n1 A n2 E N= No!n1A!n2E

    0 -2588.23386 0 -338.2338562092

    0 -3450.97847 0 -3450.9784749455

    0 -3450.97847 0 -8784.3084749455

    0 4313.72309 0 10980.3830936819

    108 -2588.23386 -2588.23386 -13176.4677124183

    500 0 4313.72309 10980.3830936819

    256 0 -3450.97847 -8784.3084749455

    256 0 -3450.97847 -3450.9784749455

    108 0 -2588.23386 -10588.2338562092

    0 4313.72309 0 4313.7230936819

    500 0 4313.72309 4313.7230936819

    0 0 0

    0 0 0 6000

    0 0 0 2250

    0 0 0 2250

    1728