portico en exel

10
"Año de la Diversificación Productiva y del Fortalecimiento de la Educación" Alumno: José Illarick Balarezo Salgado Profesor: Ing. Masistas Curso: Análisis Estructural 2 2015

Upload: illarick-balarezo-salgado

Post on 07-Oct-2015

221 views

Category:

Documents


0 download

DESCRIPTION

desarrollo de un pórtico con matrices exel

TRANSCRIPT

Caratula

"Ao de la Diversificacin Productiva y del Fortalecimiento de la Educacin"

Alumno:Jos Illarick Balarezo SalgadoProfesor:Ing. MasistasCurso:Anlisis Estructural 2

2015

TRABAJO

COLUMNAVIGAH=0.3mH=0.6mB=0.6mB=0.3m

FUERZATNKg2525000

DATOS:

COLUMNASVIGASACEROSC1C2C3V1V2Ac 1Ac 2AREA (m2)0.1800.1800.180AREA (m2)0.1800.180AREA (m2)2.000E-042.000E-04E (kg/m2)2173706511.9282173706511.932173706511.9E (kg/m2)2173706511.932173706511.928E (kg/m2)21,000,000,000.0021000000000.000I (m4)0.001350.001350.00135I (m4)0.00540.0054L (m)7.0715.831H (m)5.0003.0003.000L (m)5.0006.000

MATRICES

COLUMNA (C1)VIGA (V1)

121213K1=2.82E+057.04E+051K2=1.13E+062.82E+06-1.13E+062.82E+0617.04E+052.35E+0622.82E+069.39E+06-2.82E+064.70E+062-1.13E+06-2.82E+061.13E+06-2.82E+0612.82E+064.70E+06-2.82E+069.39E+063COLUMNA (C2)

134VIGA (V2)K3=1.30E+061.96E+061.96E+0611.96E+063.91E+061.96E+06313151.96E+061.96E+063.91E+064K4=6.52E+051.96E+06-6.52E+051.96E+0611.96E+067.83E+06-1.96E+063.91E+063-6.52E+05-1.96E+066.52E+05-1.96E+061COLUMNA (C3)1.96E+063.91E+06-1.96E+067.83E+065

156K5=1.30E+061.96E+061.96E+0611.96E+063.91E+061.96E+0651.96E+061.96E+063.91E+066

ACERO (Ac-1)ACERO (Ac-1)

ANGULO=0.7853981633974483ANGULO=2.677858671334899711l=0.707K6=5.940E+050.5001l=-0.894K7=7.203E+050.8001m=0.707m=0.447

11K6=2.970E+051K7=5.762E+051

MATRIZ TOTALINVERSA MATRIZ

1234561234563.76E+067.04E+051.96E+061.96E+061.96E+061.96E+0610.0000005992-0.0000000311-0.0000000121-0.0000002935-0.0000000501-0.00000027461Kt=7.04E+051.17E+074.70E+060002-0.00000003110.0000000963-0.00000002310.00000002710.00000001120.000000009921.96E+064.70E+062.11E+071.96E+063.91E+0603-0.0000000121-0.00000002310.0000000596-0.0000000237-0.00000002060.000000016331.96E+0601.96E+063.91E+06004-0.00000029350.0000000271-0.00000002370.00000041420.00000003530.000000129141.96E+0603.91E+0601.17E+071.96E+065-0.00000005010.0000000112-0.00000002060.00000003530.000000105-0.000000027551.96E+060001.96E+063.91E+066-0.00000027460.00000000990.00000001630.0000001291-0.00000002750.00000040666

FUERZAS

250001Ft=0203040506

DESPLAZAMIENTOU=K-1*F

1.50E-021m-7.78E-042radU=-3.03E-043rad-7.34E-034rad-1.25E-035rad-6.86E-036rad

3,00 m25 Tn5,00 m5,00 m6,00 mC1C2C3V1V2Ac 1Ac 2