metodo de cross para porticos de 2 pisos

11
JUNTA 1 2 3 4 5 6 ELEMENTO 1-6 2-7 3-8 4-9 5-10 6-1 6-7 6-11 FD 0 0 0 0 0 0.3 0.24 0.46 FEM 0 0 0 0 0 0 -10.17 0 DISTRIB. 0 0 0 0 0 3.051 2.4408 4.6782 TR 1.5255 -0.2076 0 0.2076 -1.5255 0 -0.37628 1.4847 DISTRIB. 0 0 0 0 0 -0.33253 -0.26602 -0.50988 TR -0.16626 -0.09073 0 0.09073 0.16626 0 -0.16445 -0.39224 DISTRIB. 0 0 0 0 0 0.167006 0.133605 0.256076 TR 0.083503 0.039836 0 -0.0398 -0.0835 0 0.072203 0.116994 DISTRIB. 0 0 0 0 0 -0.05676 -0.04541 -0.08703 TR -0.02838 -0.01579 0 0.01579 0.02838 0 -0.02861 -0.0483 DISTRIB. 0 0 0 0 0 0.023073 0.018458 0.035378 TR 0.011536 0.00517 0 -0.0052 -0.0115 0 0.009372 0.015931 DISTRIB. 0 0 0 0 0 -0.00759 -0.00607 -0.01164 SUMATORIA 1.425896 -0.26911 0 0.26911 -1.4259 2.844202 -8.3824 5.538202 carga muerta

Upload: alexis-morales-pinto

Post on 30-Sep-2015

340 views

Category:

Documents


8 download

DESCRIPTION

tabla excel para metodo de cross para porticos de varios vanos

TRANSCRIPT

Hoja1JUNTA123456789101112131415ELEMENTO1-62-73-84-95-106-16-76-117-27-67-87-128-38-78-98-139-49-89-109-1410-510-910-1511-611-1212-712-1112-1313-813-1213-1414-914-1314-1515-1015-14FD000000.30.240.460.160.290.30.250.160.30.30.240.160.30.290.250.30.240.460.350.650.30.340.360.30.350.350.30.360.340.350.65FEM000000-10.17009.573-6.978006.978-6.978006.978-9.5730010.1700-8.48408.484-7.90907.909-7.90907.909-8.48408.484DISTRIB.000003.0512.44084.6782-0.4152-0.75255-0.7785-0.6487500000.41520.77850.752550.64875-3.051-2.4408-4.67822.96945.5146-0.1725-0.1955-0.2070000.17250.2070.1955-2.9694-5.5146TR1.5255-0.207600.2076-1.52550-0.3762751.484701.22040-0.086250-0.389250.38925000-1.22040.0862500.376275-1.48472.3391-0.09775-0.3243752.757300-0.10350.10350.3243750-2.7573-2.33910.09775DISTRIB.00000-0.3325275-0.266022-0.5098755-0.181464-0.3289035-0.340245-0.283537500000.1814640.3402450.32890350.28353750.33252750.2660220.5098755-0.7844725-1.4568775-0.7298775-0.8271945-0.8758530000.72987750.8758530.82719450.78447251.4568775TR-0.16626375-0.09073200.0907320.166263750-0.16445175-0.392236250-0.1330110-0.364938750-0.17012250.17012250000.1330110.3649387500.164451750.39223625-0.25493775-0.41359725-0.14176875-0.7284387500-0.43792650.43792650.1417687500.728438750.254937750.41359725DISTRIB.000000.16700640.133605120.256076480.079671960.14440542750.1493849250.12448743750000-0.07967196-0.149384925-0.1444054275-0.1244874375-0.1670064-0.13360512-0.256076480.233987250.434547750.261062250.295870550.3132747000-0.26106225-0.3132747-0.29587055-0.23398725-0.43454775TR0.08350320.039835980-0.03983598-0.083503200.07220271380.11699362500.0668025600.13053112500.0746924625-0.0746924625000-0.06680256-0.1305311250-0.0722027138-0.1169936250.128038240.1479352750.06224371880.217273875000.15663735-0.15663735-0.06224371880-0.217273875-0.12803824-0.147935275DISTRIB.00000-0.0567589016-0.0454071213-0.0870303158-0.0315733896-0.0572267686-0.0592001055-0.049333421200000.03157338960.05920010550.05722676860.04933342120.05675890160.04540712130.0870303158-0.0965907302-0.1793827848-0.0838552781-0.0950359819-0.10062633380000.08385527810.10062633380.09503598190.09659073020.1793827848TR-0.0283794508-0.015786694800.01578669480.02837945080-0.0286133843-0.04829536510-0.02270356060-0.04192763910-0.02960005280.02960005280000.02270356060.041927639100.02861338430.0482953651-0.0435151579-0.0475179909-0.0246667106-0.089691392400-0.05031316690.05031316690.024666710600.08969139240.04351515790.0475179909DISTRIB.000000.02307262480.01845809990.03537802470.0103409920.01874304790.01938935990.01615779990000-0.010340992-0.0193893599-0.0187430479-0.0161577999-0.0230726248-0.0184580999-0.03537802470.03186160210.05917154680.03430743090.0388817550.0411689171000-0.0343074309-0.0411689171-0.038881755-0.0318616021-0.0591715468TR0.01153631240.0051704960-0.005170496-0.011536312400.0093715240.01593080100.009229049900.017153715400.00969468-0.00969468000-0.0092290499-0.01715371540-0.009371524-0.0159308010.01768901240.01944087750.00807890.0295857734000.0205844585-0.0205844585-0.00807890-0.0295857734-0.0176890124-0.0194408775DISTRIB.00000-0.0075906975-0.006072558-0.0116390695-0.0042212425-0.007651002-0.0079148296-0.006595691300000.00422124250.00791482960.0076510020.00659569130.00759069750.0060725580.0116390695-0.0129954615-0.0241344284-0.011299402-0.0128059889-0.01355928240000.0112994020.01355928240.01280598890.01299546150.0241344284

SUMATORIA1.4258963116-0.269112218800.2691122188-1.42589631162.8442019257-8.38240435615.5382024303-0.54244568019.7305342541-7.9950856502-1.193002923806.4734145897-6.473414589700.54244568017.9950856502-9.73053425411.1930029238-2.84420192578.3824043561-5.53820243034.5275645048-4.5275645048-1.12265034119.8742453402-8.751594999107.4944821417-7.49448214171.12265034118.7515949991-9.8742453402-4.52756450484.5275645048

carga muerta

Hoja2JUNTA123456789101112131415ELEMENTO1-62-73-84-95-106-16-76-117-27-67-87-128-38-78-98-139-49-89-109-1410-510-910-1511-611-1212-712-1112-1313-813-1213-1414-914-1314-1515-1015-14FD000000.30.240.460.160.290.30.250.160.30.30.240.160.30.290.250.30.240.460.350.650.30.340.360.30.350.350.30.360.340.350.65FEM000000-3.45003.45-3.09003.09-3.09003.09-3.45003.4500-1.3801.38-1.2901.29-1.2901.29-1.3801.38DISTRIB.000001.0350.8281.587-0.0576-0.1044-0.108-0.0900000.05760.1080.10440.09-1.035-0.828-1.5870.4830.897-0.027-0.0306-0.03240000.0270.03240.0306-0.483-0.897TR0.5175-0.028800.0288-0.51750-0.05220.241500.4140-0.01350-0.0540.054000-0.4140.013500.0522-0.24150.7935-0.0153-0.0450.448500-0.01620.01620.0450-0.4485-0.79350.0153DISTRIB.00000-0.05679-0.045432-0.087078-0.06408-0.116145-0.12015-0.10012500000.064080.120150.1161450.1001250.056790.0454320.087078-0.27237-0.50583-0.12105-0.13719-0.145260000.121050.145260.137190.272370.50583TR-0.028395-0.0320400.032040.0283950-0.0580725-0.1361850-0.0227160-0.0605250-0.0600750.0600750000.0227160.06052500.05807250.136185-0.043539-0.068595-0.0500625-0.25291500-0.072630.072630.050062500.2529150.0435390.068595DISTRIB.000000.058277250.04662180.089358450.013318560.024139890.02497230.020810250000-0.01331856-0.0249723-0.02413989-0.02081025-0.05827725-0.0466218-0.089358450.03924690.07288710.090893250.103012350.1090719000-0.09089325-0.1090719-0.10301235-0.0392469-0.0728871TR0.0291386250.006659280-0.00665928-0.02913862500.0120699450.0196234500.023310900.04544662500.01248615-0.01248615000-0.0233109-0.0454466250-0.012069945-0.019623450.0446792250.0515061750.0104051250.03644355000.05453595-0.05453595-0.0104051250-0.03644355-0.044679225-0.051506175DISTRIB.00000-0.0095080185-0.0076064148-0.0145789617-0.011001204-0.0199396822-0.0206272575-0.017189381200000.0110012040.02062725750.01993968220.01718938120.00950801850.00760641480.0145789617-0.03366489-0.06252051-0.0140546025-0.0159285495-0.0168655230000.01405460250.0168655230.01592854950.033664890.06252051TR-0.0047540092-0.00550060200.0055006020.00475400920-0.0099698411-0.0168324450-0.00380320740-0.00702730120-0.01031362880.01031362880000.00380320740.007027301200.00996984110.016832445-0.0072894808-0.0079642748-0.0085946906-0.03126025500-0.00843276150.00843276150.008594690600.0312602550.00728948080.0079642748DISTRIB.000000.00804068580.00643254870.01232905160.00173288140.00314084750.00324915260.00270762720000-0.0017328814-0.0032491526-0.0031408475-0.0027076272-0.0080406858-0.0064325487-0.01232905160.00533881450.00991494110.01195648370.01355068150.0143477804000-0.0119564837-0.0143477804-0.0135506815-0.0053388145-0.0099149411TR0.00402034290.00086644070-0.0008664407-0.004020342900.00157042380.002669407200.003216274300.005978241800.0016245763-0.0016245763000-0.0032162743-0.00597824180-0.0015704238-0.00266940720.00616452580.00677534080.00135381360.0049574706000.0071738902-0.0071738902-0.00135381360-0.0049574706-0.0061645258-0.0067753408DISTRIB.00000-0.0012719493-0.0010175594-0.0019503223-0.0014711226-0.0026664097-0.0027583549-0.00229862900000.00147112260.00275835490.00266640970.0022986290.00127194930.00101755940.0019503223-0.0045289533-0.0084109133-0.0018933852-0.0021458366-0.00227206230000.00189338520.00227206230.00214583660.00452895330.0084109133

SUMATORIA0.5175099587-0.058814881300.0588148813-0.51750995871.033747968-2.72960359791.6958556299-0.11910088523.6481376125-3.3133141598-0.215722567502.9797220975-2.979722097500.11910088523.3133141598-3.64813761250.2157225675-1.0337479682.7296035979-1.69585562991.0105371411-1.0105371411-0.15304650611.516424411-1.363377904901.2544470787-1.25444707870.15304650611.3633779049-1.516424411-1.01053714111.0105371411carga vivaaa

Hoja3