Excel Para Analisis.... c3
25
DESARROLLO DE PROBLEMA E= 10107286.82 A= 0.2 BARRA ANGULO L 1 1-2 90.00 3.000 2 2-3 19.65 7.433 3 3-4 19.65 7.433 4 4-5 -19.65 7.433 5 5-6 -19.65 7.433 6 6-7 -90.00 3.000 7 7-8 167.91 7.159 8 8-6 12.09 7.159 9 8-5 90.00 4.000 10 8-9 167.91 7.159 11 9-5 19.65 7.433 12 9-4 90.00 5.000 13 9-3 160.35 7.433 14 9-10 -167.91 7.159 15 10-3 90.00 4.000 16 10-2 167.91 7.159 17 10-1 -167.91 7.159 DATOS DE MATRIZ DE RIGID 200KN 7m 7m E = 10107286.82 KN A= 0.2 m ²
description
anali
Transcript of Excel Para Analisis.... c3
Hoja1
DESARROLLO DE PROBLEMA
E=10107286.82A=0.2MATRIZ DE DESPLAMIENTO
BARRAANGULOLEA/LEA/L cosEA/L senEA/L cos*senU1U2V2U3V3U4V4U5V5U6V6U8V8U9V9U10V1011-290.003.000673819.120.00673819.120.00U1269978.94-0.00-0.000.000.000.000.000.000.000.000.000.000.000.000.00-269978.94-57829.19U122-319.657.433271957.13241204.2530752.8886126.22U2-0.00511183.1928297.04-241204.25-86126.220.000.000.000.000.000.000.000.000.000.00-269978.9457829.19U233-419.657.433271957.13241204.2530752.8886126.22V2-0.0028297.04716958.95-86126.22-30752.880.000.000.000.000.000.000.000.000.000.0057829.19-12386.95V244-5-19.657.433271957.13241204.2530752.88-86126.22U30.00-241204.25-86126.22482408.500.00-241204.25-86126.220.000.000.000.000.000.00-241204.2586126.22-0.00-0.00U355-6-19.657.433271957.13241204.2530752.88-86126.22V30.00-86126.22-30752.880.00566870.11-86126.22-30752.880.000.000.000.000.000.0086126.22-30752.88-0.00-505364.34V366-7-90.003.000673819.120.00673819.12-0.00U40.000.000.00-241204.25-86126.22482408.500.00-241204.2586126.220.000.000.000.00-0.00-0.000.000.00U477-8167.917.159282365.88269978.9412386.95-57829.19V40.000.000.00-86126.22-30752.880.00465797.2486126.22-30752.880.000.000.000.00-0.00-404291.470.000.00V488-612.097.159282365.88269978.9412386.9557829.19U50.000.000.000.000.00-241204.2586126.22723612.74-86126.22-241204.2586126.22-0.00-0.00-241204.25-86126.220.000.00U598-590.004.000505364.340.00505364.340.00V50.000.000.000.000.0086126.22-30752.88-86126.22597622.9986126.22-30752.88-0.00-505364.34-86126.22-30752.880.000.00V5108-9167.917.159282365.88269978.9412386.95-57829.19U60.000.000.000.000.000.000.00-241204.2586126.22511183.19-28297.04-269978.94-57829.190.000.000.000.00U6119-519.657.433271957.13241204.2530752.8886126.22V60.000.000.000.000.000.000.0086126.22-30752.88-28297.04716958.95-57829.19-12386.950.000.000.000.00V6129-490.005.000404291.470.00404291.470.00U80.000.000.000.000.000.000.00-0.00-0.00-269978.94-57829.19809936.81-57829.19-269978.9457829.190.000.00U8139-3160.357.433271957.13241204.2530752.88-86126.22V80.000.000.000.000.000.000.00-0.00-505364.34-57829.19-12386.95-57829.19542525.1857829.19-12386.950.000.00V8149-10-167.917.159282365.88269978.9412386.9557829.19U90.000.000.00-241204.2586126.22-0.00-0.00-241204.25-86126.220.000.00-269978.9457829.191022366.370.00-269978.94-57829.19U91510-390.004.000505364.340.00505364.340.00V90.000.000.0086126.22-30752.88-0.00-404291.47-86126.22-30752.880.000.0057829.19-12386.950.00490571.13-57829.19-12386.95V91610-2167.917.159282365.88269978.9412386.95-57829.19U10-269978.94-269978.9457829.19-0.00-0.000.000.000.000.000.000.000.000.00-269978.94-57829.19809936.8157829.19U101710-1-167.917.159282365.88269978.9412386.9557829.19V10-57829.1957829.19-12386.95-0.00-505364.340.000.000.000.000.000.000.000.00-57829.19-12386.9557829.19542525.18V10
MATRIZ INVERSADATOS DE MATRIZ DE RIGIDEZMATRIZ DE FUERZADEZPLAZAMIENTOS
U1U2V2U3V3U4V4U5V5U6V6U8V8U9V9U10V10U10.000003-0.000002-0.000001-0.000004-0.000003-0.000004-0.000002-0.000002-0.000000-0.0000020.000000-0.000001-0.000000-0.000002-0.000001-0.000000-0.000003U10.00U10.00072U1V1U2V2U2-0.0000020.000000-0.000001-0.000002-0.000006-0.000003-0.000005-0.000002-0.000002-0.000001-0.000000-0.000001-0.000002-0.000001-0.000005-0.000001-0.000006U20.00U20.002110.000.00-0.00-0.00U1V2-0.000001-0.0000010.000001-0.0000000.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.000000-0.0000010.000000V20.00V2-0.000041K 1-20.00673819.12-0.00-673819.12V1U3-0.000004-0.000002-0.000000-0.000001-0.000009-0.000002-0.000007-0.000002-0.000005-0.000001-0.000000-0.000000-0.000004-0.000001-0.000008-0.000002-0.000008U30.00U30.00309-0.00-0.000.000.00U2V3-0.000003-0.0000060.000000-0.0000090.000012-0.0000050.000006-0.0000050.000001-0.0000040.000000-0.0000040.000001-0.0000060.000006-0.0000060.000011V30.00V3-0.00330-0.00-673819.120.00673819.12V2U4-0.000004-0.000003-0.000000-0.000002-0.0000050.000001-0.000006-0.000001-0.000005-0.000001-0.000000-0.000001-0.000005-0.000002-0.000006-0.000003-0.000005U40.00U40.00216V4-0.000002-0.000005-0.000000-0.0000070.000006-0.0000060.000014-0.0000040.000008-0.0000040.000001-0.0000030.000008-0.0000040.000013-0.0000030.000006V4X0.00=V4-0.00362U5-0.000002-0.000002-0.000000-0.000002-0.000005-0.000001-0.0000040.000001-0.0000010.000001-0.0000000.000000-0.000001-0.000000-0.000003-0.000002-0.000005U50.00U50.00144U2V2U3V3V5-0.000000-0.000002-0.000000-0.0000050.000001-0.0000050.000008-0.0000010.000016-0.0000010.000001-0.0000000.000015-0.0000010.000009-0.0000010.000002V5-60.00V5-0.00268241204.2586126.22-241204.25-86126.22U2U6-0.000002-0.000001-0.000000-0.000001-0.000004-0.000001-0.0000040.000001-0.0000010.0000030.0000000.000001-0.0000010.000000-0.000004-0.000001-0.000004U60.00U60.001462K 2-386126.2230752.88-86126.22-30752.88V2V60.000000-0.000000-0.000000-0.0000000.000000-0.0000000.000001-0.0000000.0000010.0000000.0000010.0000000.0000010.0000000.0000010.0000000.000000V60.00V6-0.00018-241204.25-86126.22241204.2586126.22U3U8-0.000001-0.000001-0.000000-0.000000-0.000004-0.000001-0.0000030.000000-0.0000000.0000010.0000000.000002-0.0000000.000000-0.000003-0.000000-0.000004U80.00U80.00117-86126.22-30752.8886126.2230752.88V3V8-0.000000-0.000002-0.000000-0.0000040.000001-0.0000050.000008-0.0000010.000015-0.0000010.000001-0.0000000.000016-0.0000010.000008-0.0000010.000002V80.00V8-0.00250U9-0.000002-0.000001-0.000000-0.000001-0.000006-0.000002-0.000004-0.000000-0.0000010.0000000.0000000.000000-0.0000010.000001-0.000004-0.000001-0.000006U90.00U90.00176V9-0.000001-0.000005-0.000000-0.0000080.000006-0.0000060.000013-0.0000030.000009-0.0000040.000001-0.0000030.000008-0.0000040.000015-0.0000030.000006V9-150.00V9-0.00407U3V3U4V4U10-0.000000-0.000001-0.000001-0.000002-0.000006-0.000003-0.000003-0.000002-0.000001-0.0000010.000000-0.000000-0.000001-0.000001-0.0000030.000001-0.000005U100.00U100.00151241204.2586126.22-241204.25-86126.22U3V10-0.000003-0.0000060.000000-0.0000080.000011-0.0000050.000006-0.0000050.000002-0.0000040.000000-0.0000040.000002-0.0000060.000006-0.0000050.000013V10-200.00V10-0.003653K 3-486126.2230752.88-86126.22-30752.88V3-241204.25-86126.22241204.2586126.22U4-86126.22-30752.8886126.2230752.88V4
FUERZA AXIALFUERZASU4V4U5V5241204.25-86126.22-241204.2586126.22U40.00138970314K 4-5-86126.2230752.8886126.22-30752.88V4F1-20.001.00X-0.0000383096=-0.000038COMPARACION ANALITICO - SAP2000-241204.2586126.22241204.25-86126.22U586126.22-30752.88-86126.2230752.88V5
U5V5U6V60.0009760032241204.25-86126.22-241204.2586126.22U5F2-30.940.34X-0.0032580437=-0.000176ORDENANDO LOS DEPLAZAMIENTOS5K 5-6-86126.2230752.8886126.22-30752.88V5TABLE: Joint Displacements-241204.2586126.22241204.25-86126.22U6X=U1Y=U3JointOutputCaseCaseTypeU1U2U3R1R2R386126.22-30752.88-86126.2230752.88V6NODOSXYTextTextTextmmmRadiansRadiansRadians10.000720.000001DEADLinStatic-0.00820.00000.0000000-0.000934467420.00211-0.000042DEADLinStatic-0.00510.0000-0.0004000U6V6U7V7DESPLAZAMIENTOSF3-40.940.34X-0.0003283482=-0.00099030.00309-0.003304DEADLinStatic-0.00310.0000-0.01100000.00-0.00-0.000.00U60.0007U140.00216-0.003626DEADLinStatic-0.00420.0000-0.01230006K 6-7-0.00673819.120.00-673819.12V60.0000V150.00144-0.002688DEADLinStatic-0.00480.0000-0.0094000-0.000.000.00-0.00U70.0021U260.00146-0.000189DEADLinStatic0.00000.00000.00000000.00-673819.12-0.00673819.12V7-0.0000V270.000000.0000010DEADLinStatic-0.00280.0000-0.00030000.0031U3-0.000713282380.00117-0.0025011DEADLinStatic-0.00390.0000-0.0130000-0.0033V3F4-50.94-0.34X0.0009477969=-0.00099090.00176-0.0040713DEADLinStatic-0.00590.0000-0.0111000U7V7U8V80.0022U4100.00151-0.0036514DEADLinStatic-0.00200.0000-0.0091000269978.94-57829.19-269978.9457829.19U7-0.0036V47K 7-8-57829.1912386.9557829.19-12386.95V70.0014U5-269978.9457829.19269978.94-57829.19U8-0.0027V557829.19-12386.95-57829.1912386.95V80.0015U60.0000168525-0.0002V6F5-60.94-0.34X0.0024979548=-0.0008240.0000U7U8V8U6V60.0000V7269978.9457829.19-269978.94-57829.19U80.0012U88K 8-657829.1912386.95-57829.19-12386.95V8-0.0025V8-269978.94-57829.19269978.9457829.19U60.0018U9-0.0014592003-57829.19-12386.9557829.1912386.95V6-0.0041V9F6-70.00-1.00X0.0001789498=-0.0001790.0015U10-0.0037V10U8V8U5V50.000.00-0.00-0.00U89K 8-50.00505364.34-0.00-505364.34V80.0011741147-0.00-0.000.000.00U5F7-8-0.980.21X-0.0024979765=-0.001671-0.00-505364.340.00505364.34V5
U8V8U9V9269978.94-57829.19-269978.9457829.19U8-0.000285085610K 8-9-57829.1912386.9557829.19-12386.95V8F8-60.980.21X-0.0023190267=-0.000764-269978.9457829.19269978.94-57829.19U957829.19-12386.95-57829.1912386.95V9
U9V9U5V5-0.000241204.2586126.22-241204.25-86126.22U9F8-50.001.00X0.000=0.00017911K 9-586126.2230752.88-86126.22-30752.88V9-241204.25-86126.22241204.2586126.22U5-86126.22-30752.8886126.2230752.88V5
0.0005900361U9V9U4V4F8-9-0.980.21X-0.0015748166=-0.0009070.000.00-0.00-0.00U912K 9-40.00404291.47-0.00-404291.47V9-0.00-0.000.000.00U4-0.00-404291.470.00404291.47V40.000F9-50.940.34X-0.001=-0.000166U9V9U3V3241204.25-86126.22-241204.2586126.22U913K 9-3-86126.2230752.8886126.22-30752.88V9-241204.2586126.22241204.25-86126.22U386126.22-30752.88-86126.2230752.88V3-0.000F9-40.001.00X-0.000=-0.000448
U9V9U10V10269978.9457829.19-269978.94-57829.19U914K 9-1057829.1912386.95-57829.19-12386.95V9-269978.94-57829.19269978.9457829.19U10-0.0013259468-57829.19-12386.9557829.1912386.95V10F9-3-0.940.34X-0.0007764398=0.000988
U10V10U3V30.000.00-0.00-0.00U1015K 10-30.00505364.34-0.00-505364.34V10-0.0002571192-0.00-0.000.000.00U3F9-10-0.98-0.21X0.0004189906=0.000164-0.00-505364.340.00505364.34V3
U10V10U2V2269978.94-57829.19-269978.9457829.19U10-0.001583065916K 10-2-57829.1912386.9557829.19-12386.95V10F10-30.001.00X-0.0003574491=-0.000357-269978.9457829.19269978.94-57829.19U257829.19-12386.95-57829.1912386.95V2
U10V10U1V1-0.0006070627269978.9457829.19-269978.94-57829.19U10F10-2-0.980.21X-0.0036154928=-0.00016417K 10-157829.1912386.95-57829.19-12386.95V10-269978.94-57829.19269978.9457829.19U1-57829.19-12386.9557829.1912386.95V1
0.0007826404F10-1-0.98-0.21X-0.0036538024=-0.000000
Hoja2
Hoja3
