Download xlsx - Pca

Transcript

EJEMPLO CLASEaotazanee/aoi0.0311.04768695TPD(dia)1350nee/dia21.04799442.8i3CAMIONES76869531.04831420.512CAMIONESEJES TADEMEJES TRIPLE41.04864677.33248AUTOS675AOBUSESC-2C-3C-5C-6AOTPD(vias)/diaTPD(carril)-diaBUSESC-2C-3,C-5,C-6C-651.04899264.4257792BUSES1351135216108541081130548548.577.6116.438.861.04935235.002810368CAMIONES5402139.05222.48111.2455.62111.242499.5549.95579.928119.89239.96471.04972644.4029227833143.2215229.1544114.577257.2886114.57723514.536551.4536582.32584123.4887641.1629281.041011550.179039694147.518145236.029032118.01451659.007258118.0145164529.97259552.997259584.7956152127.193422842.397807691.041052012.186201285151.94368935243.10990296121.5549514860.77747574121.554951485545.8717728554.58717728587.339483656131.00922548443.669741828101.041094092.673649336156.5020000305250.4032000488125.201600024462.6008000122125.20160002446562.247926035556.224792603689.9596681657134.939502248544.9798340828111.041137856.380595317161.1970600314257.9152960503128.957648025164.4788240126128.95764802517579.115363816657.911536381792.6584582107138.98768731646.3292291053121.041183370.635819128166.0329718324265.6527549318132.826377465966.4131887329132.82637746598596.488824731159.648882473195.438211957143.157317935547.7191059785131.041230705.461251889171.0139609873273.6223375797136.811168789968.4055843949136.81116878999614.38348947361.438348947398.3013583157147.452037473549.1506791578141.041279933.6797019610176.1443798169281.8310077071140.915503853670.4577519268140.915503853610632.814994157263.2814994157101.2503990651151.875598597750.6251995326151.041331131.0268900411181.4287112115290.2859379383145.142968969272.5714844846145.142968969211651.799443981965.1799443982104.2879110371156.431866555752.1439555186pongo todo15392031.69914112186.8715725478298.9945160765149.497258038274.7486290191149.497258038212671.353427301467.1353427301107.4165483682161.124822552353.70827418417696015.84957048de diseo13192.4777197242307.9643515588153.982175779476.9910878897153.982175779413691.494030120469.149403012110.6390448193165.958567228955.319522409614198.252051316317.2032821055158.601641052879.3008205264158.601641052814712.23885102471.2238851024113.9582161638170.937324245856.979108081915204.1996128554326.7193805687163.359690284481.6798451422163.359690284415733.606016554773.3606016555117.3769626488176.065443973158.688481324416210.3256012411336.5209619858168.260480992984.1302404964168.260480992916755.614197051475.5614197051120.8982715282181.347407292360.449135764117216.6353692783346.6165908453173.308295422786.6541477113173.308295422717778.282622962977.8282622963124.5252196741186.787829511162.26260983718223.1344303567357.0150885707178.507544285389.2537721427178.507544285318801.631101651880.1631101652128.2609762643192.391464396464.130488132119229.8284632674367.7255412278183.862770613991.931385307183.862770613919825.680034701482.5680034701132.1088055522198.163208328366.054402776120236.7233171654378.7573074647189.378653732394.6893268662189.378653732320850.450435742485.0450435742136.0720697188204.108104578268.0360348594Total vehiculos-dia1303.21316271562085.14106034493127.71159051731042.5705301724total vehiculo via dia3627.50055601245804.00088961982902.00044480991451.00022240492902.0004448099Total vehiculos-ao475672.804391177761076.4870258831141614.73053882380538.243512941total vehiculo carril dia1813.75027800622902.00044480991451.0002224049725.50011120251451.0002224049total vehiculo carril ao662018.8514722561059230.16235561529615.081177805264807.540588902529615.081177805ejes simplesN0 repeticiones esperadasejes tandemN0 repeticiones esperadasejes tripleN0 repeticiones esperadas12-13 ton114161.47305388220-22 ton171242.20958082420-22 ton57080.736526941211-12 ton114161.47305388218-20 ton171242.20958082418-20 ton57080.736526941210-11 ton228322.94610776516-18 ton342484.41916164716-18 ton114161.4730538829-10 ton304430.59481035314-16 ton114161.47305388214-16 ton38053.8243512941

EJES SENCILLOEJES TNDEMEJES TRIPLECARGACARGA*F.SN0 repeticiones esperadasFATIGAEROSIONCARGACARGA*F.SN0 repeticiones esperadasFATIGAEROSIONCARGACARGA*F.SN0 repeticiones esperadasFATIGAEROSIONN0 repeticiones admisible% de consumo por fatigaN0 repeticiones admisible% de dao por erosionN0 repeticiones admisible% de consumo por fatigaN0 repeticiones admisible% de dao por erosionN0 repeticiones admisible% de fatigaN0 repeticiones admisible% de daoF.S1.112.513.75114161.4730538821.50E+067.68.00E+061.432123.1171242.20958082411.512.65114161.473053882INF01.50E+070.761920.9171242.20958082410.511.55228322.946107765INF03.50E+070.651718.7342484.4191616479.510.45304430.594810353INF05.50E+070.551516.5114161.473053882

SUMA(%)8E+003.39

Hoja2CAMIONES%DECIMALESPESOR Y K HALLAMOS ESFUERZO EQUIVALENTEC-2 PEQ00TPD VIA2000C-2 GRA400.4SENCILLOTABLA 7-23JOYATPD CARRIL1000C-3200.2-EQUIVALENTE =1TABLA-EQUIVALENTE =2001.378INTERES I5C-400FS =1.1C-5400.4RELACION DE ESFUERZOSHALLARK SR-SB=51.55Mpa/m190.0PCIC-600FATIGAEROSIONMROTURA4.5MpaSUMA1001FACTOR DE FATICA=0.2220.306FACTOR DE EROSION =2.6Espeso250mmFATIGAEROSIONTANDEMTRIDEMEJE SENCILLOCARGA PROMEDIOCARGA*FSCARGA KN% CARGANo ESPERADASNo. Admisible% CONSUMONo. Admisible% CONSUMOAOSBUSESC-2 GRANDEC-3,C-4,C-5,C-6C-612--13 ton1314.314310482,762.93INFINITOERROR:#VALUE!7,000,000.006.90COMPOSICION1.00.00400.001,000.000.0011--12 ton1213.213210482,762.93INFINITOERROR:#VALUE!12,000,000.004.02TIPO VE.% VE.CANT. DE VE.2.00.00420.001,050.000.0010--11 ton1112.112120965,525.86INFINITOERROR:#VALUE!25,000,000.003.86BUSES003.00.00441.001,102.500.009--10 ton101111020965,525.86INFINITOERROR:#VALUE!40,000,000.002.41CAMIONES10010004.00.00463.051,157.630.008-9 TON99.99910482,762.93INFINITOERROR:#VALUE!AUTOS005.00.00486.201,215.510.0088.888301448288.78970651INFINITOERROR:#VALUE!TOTAL10006.00.00510.511,276.280.0000GRAFICA17.207.00.00536.041,340.100.00EJES8.00.00562.841,407.100.00VEH.SENCILLOTANDEMTRIDEM9.00.00590.981,477.460.00C-2 PEQUEO10010.00.00620.531,551.330.00C-2 GRANDE10011.00.00651.561,628.890.00TANDEMTABLA 7-24JOYAC-311012.00.00684.141,710.340.00-EQUIVALENTE =1.28TABLA-EQUIVALENTE =1831.26087C-402013.00.00718.341,795.860.0050.53C-512014.00.00754.261,885.650.00RELACION DE ESFUERZOSC-611115.00.00791.971,979.930.00FATIGAEROSION16.00.00831.572,078.930.00FACTOR DE FATICA=0.2840.280FACTOR DE EROSION =2.7817.00.00873.152,182.870.0018.00.00916.812,292.020.00FATIGAEROSION19.00.00962.652,406.620.00EJE TANDEMCARGA PROMEDIOCARGA*FSCARGA KIPS% CARGANo ESPERADASNo. Admisible% CONSUMONo. Admisible% CONSUMO20.00.001,010.782,526.950.00TOTAL VEH. DIA CARRIL0.0013,226.3833,065.950.0024--26 ton2325.3253101,206,907.32INFINITOERROR:#VALUE!7,000,000.0017.24TOTAL VEH. AO CARRIL0.004,827,629.3012,069,073.250.0022--24 ton2123.1231101,206,907.32INFINITOERROR:#VALUE!15,000,000.008.05TANDEMTRIDEM20--22 ton1920.9209202,413,814.65INFINITOERROR:#VALUE!30,000,000.008.05BUSESC-2 GRANDEC-3,C-4,C-5,C-6C-618--20 ton1718.7187202,413,814.65INFINITOERROR:#VALUE!16-18 TON1516.5165101,206,907.32INFINITOERROR:#VALUE!GRAFICA33.33

Hoja3CAMIONES%ESPESOR Y K HALLAMOS ESFUERZO EQUIVALENTEC-2 PEQ0%TPD VIA2000C-2 GRA40%SENCILLOTABLA 7-23JOYATPD CARRIL1000C-320%-EQUIVALENTE =TABLA-EQUIVALENTE =0INTERES I5%C-40%FS =1.1C-540%RELACION DE ESFUERZOSHALLARK SR-SB=51.55Mpa/m190.0PCIC-60%FATIGAEROSIONMROTURA4.5MpaSUMA100%FACTOR DE FATICA=FACTOR DE EROSION =Espesor250mmFATIGAEROSIONTANDEMTRIDEMEJE SENCILLOCARGA PROMEDIOCARGA*FSCARGA Kn% CARGANo ESPERADASNo. Admisible% CONSUMONo. Admisible% CONSUMOAOSBUSESC-2 GRANDEC-3,C-4,C-5,C-6C-61314.314310482,762.93COMPOSICION1.00.00400.001,000.000.0012--13 ton1213.213210TIPO VE.% VEHICULOCANT. DE VE.2.00.00420.001,050.000.0011--12 ton1112.112120BUSES0%03.00.00441.001,102.500.0010--11 ton101111020CAMIONES100%10004.00.00463.051,157.630.009--10 ton99.99910AUTOS0%05.00.00486.201,215.510.008-9 TON88.88830TOTAL10006.00.00510.511,276.280.00GRAFICA7.00.00536.041,340.100.00EJES8.00.00562.841,407.100.00VEH.SENCILLOTANDEMTRIDEM9.00.00590.981,477.460.00C-2 PEQUEO10010.00.00620.531,551.330.00C-2 GRANDE10011.00.00651.561,628.890.00TANDEMTABLA 7-24JOYAC-311012.00.00684.141,710.340.00-EQUIVALENTE =TABLA-EQUIVALENTE =C-402013.00.00718.341,795.860.00C-512014.00.00754.261,885.650.00RELACION DE ESFUERZOSC-611115.00.00791.971,979.930.00FATIGAEROSION16.00.00831.572,078.930.00FACTOR DE FATICA=FACTOR DE EROSION =2.7817.00.00873.152,182.870.0018.00.00916.812,292.020.00FATIGAEROSION19.00.00962.652,406.620.00EJE TANDEMCARGA PROMEDIOCARGA*FSCARGA KIPS% CARGANo ESPERADASNo. Admisible% CONSUMONo. Admisible% CONSUMO20.00.001,010.782,526.950.00TOTAL VEH. DIA CARRIL0.0013,226.3833,065.950.0024--26 tonTOTAL VEH. AO CARRIL0.004,827,629.3012,069,073.250.0022--24 tonTANDEMTRIDEM20--22 tonBUSESC-2 GRANDEC-3,C-4,C-5,C-6C-618--20 ton16-18 TONGRAFICA