Noelia 12

Embed Size (px)

DESCRIPTION

CALCULO EN XLS

Citation preview

Entre Piso 1 Metrado de cargas del 1er entre piso(Concreto Ton/m3) =2.4h (m) =3Walig (ton/m2) =0.4Wacab (ton/m2) =0.1Wtabq (ton/m2) =0.15Wmur. LP (ton/m) =0.5Wmur. Fach. (ton/m) =0.25s/c (ton/m2) =0.25b (m)h (m)Long (m)m (Ton)XYm*Xm*YVP1010.40.752618.7213.514.5252.72271.44VP1020.40.752618.7213.511252.72205.92VP1030.40.752618.7213.57252.72131.04VP1040.40.752215.8411.53182.1647.52VP1050.40.752618.7213.50252.720.00VS1010.40.522.510.8007.250.0078.30VS1020.40.622.512.96107.25129.6093.96VS1030.40.622.512.96167.25207.3693.96VS1040.40.5522.511.88237.25273.2486.13VS1050.40.522.510.80277.25291.6078.30Total =150.122094.841086.57b (m)t (m)Long (m)m (Ton)XYm*Xm*YCol. Cent.0.60.4531.9410319.445.830.60.4531.9410719.4413.610.60.4531.94101119.4421.380.60.4531.9416331.105.830.60.4531.9416731.1013.610.60.4531.94161131.1021.380.60.4531.9423344.715.830.60.4531.9423744.7113.610.60.4531.94231144.7121.38Col.Perim.0.60.431.73030.005.180.60.431.73070.0012.100.60.431.730110.0019.010.60.431.7310017.280.000.60.431.731014.517.2825.060.60.431.7316027.650.000.60.431.731614.527.6525.060.60.431.7323039.740.000.60.431.732314.539.7425.060.60.431.7327746.6612.100.60.431.73271146.6619.01Col. Esq.0.60.431.73000.000.000.60.431.73014.50.0025.060.60.431.7327046.660.000.60.431.732714.546.6625.06Total =43.42641.74315.14Ancho (m)Largo (m)W (Ton/m2)m (Ton)XYm*Xm*YAligerado13.926.60.4147.9013.57.251996.601072.25Acabados14.5270.139.1513.77.55536.36295.58Tabiqueria14.5270.1558.7313.77.55804.53443.37S/C14.5270.2548.9413.77.55670.44369.48Total =294.714007.932180.68Largo (m)W (Ton/m)m (Ton)XYm*Xm*YMuro LP------270.513.5013.50182.250.00Muro LP------270.513.5013.514.5182.25195.75Muro Fach.------14.50.253.6307.250.0026.28Muro Fach.------14.50.253.63277.2597.8826.28Total =34.25462.38248.31Peso Total del 1er Entre PisoP (Ton) =522.49m =53.2614169215XYC.M =13.797.33Calculo del Im del Entre Pisom (Ton)a (m)b (m)IzXYr (m)ImVP10118.72260.41054.809613.514.57.172018.37VP10218.72260.41054.809613.5113.681308.34VP10318.72260.41054.809613.570.441058.48VP10415.84220.4639.091211.534.901019.59VP10518.72260.41054.809613.507.342062.66VS10110.8022.50.4455.76907.2513.792510.57VS10212.9622.50.4546.9228107.253.79733.48VS10312.9622.50.4546.9228167.252.21610.12VS10411.8822.50.4501.3459237.259.211508.43VS10510.8022.50.4455.769277.2513.212339.57Total =15169.61m (Ton)a (m)b (m)IzXYr (m)ImC11.940.450.60.0911251035.7664.541.940.450.60.0911251073.8128.281.940.450.60.09112510115.2854.221.940.450.60.0911251634.8646.031.940.450.60.0911251672.239.771.940.450.60.09112516114.2835.721.940.450.60.09112523310.17201.351.940.450.60.0911252379.21165.091.940.450.60.09112523119.91191.04C21.730.40.60.074880314.46361.251.730.40.60.074880713.80329.021.730.40.60.0748801114.27352.091.730.40.60.074881008.25117.821.730.40.60.074881014.58.11113.731.730.40.60.074881607.66101.371.730.40.60.074881614.57.5097.291.730.40.60.0748823011.77239.431.730.40.60.074882314.511.67235.341.730.40.60.0748827713.21301.661.730.40.60.07488271113.71324.73C31.730.40.60.074880015.62421.721.730.40.60.07488014.515.54417.631.730.40.60.0748827015.11394.351.730.40.60.074882714.515.03390.27Total =4993.73ma (m)b (m)IzXYr (m)ImAligerado147.9013.926.611101.689993333313.57.250.3011115.39Acabados39.1514.5273064.30312513.77.550.243066.51Tabiqueria58.7314.5274596.454687513.77.550.244599.77S/C48.9414.5273830.3789062513.77.550.243833.14Total =22614.81m (Ton)a (m)b (m)IzXYr (m)ImMuro LP13.50270.15820.150312513.507.341546.96Muro LP13.50270.15820.150312513.514.57.171515.03Muro Fach.3.630.1514.563.519817708307.2513.79753.21Muro Fach.3.630.1514.563.5198177083277.2513.21695.81Total =4511.01Im del Entre Piso:Im =4820.51

Entre Piso 2Metrado de cargas del 2do entre piso(Concreto Ton/m3) =2.4h (m) =2.6Walig (ton/m2) =0.4Wacab (ton/m2) =0.1Wtabq (ton/m2) =0.15Wmur. LP (ton/m) =0.5Wmur. Fach. (ton/m) =0.25s/c (ton/m2) =0.25b (m)h (m)Long (m)m (Ton)XYm*Xm*YVP1010.40.752618.7213.514.5252.72271.44VP1020.40.752618.7213.511252.72205.92VP1030.40.752618.7213.57252.72131.04VP1040.40.752215.8411.53182.1647.52VP1050.40.752618.7213.50252.720.00VS1010.40.522.510.8007.250.0078.30VS1020.40.622.512.96107.25129.6093.96VS1030.40.622.512.96167.25207.3693.96VS1040.40.5522.511.88237.25273.2486.13VS1050.40.522.510.80277.25291.6078.30Total =150.122094.841086.57b (m)t (m)Long (m)m (Ton)XYm*Xm*YCol. Cent.0.60.452.61.6810316.855.050.60.452.61.6810716.8511.790.60.452.61.68101116.8518.530.60.452.61.6816326.965.050.60.452.61.6816726.9611.790.60.452.61.68161126.9618.530.60.452.61.6823338.755.050.60.452.61.6823738.7511.790.60.452.61.68231138.7518.53Col.Perim.0.60.42.61.50030.004.490.60.42.61.50070.0010.480.60.42.61.500110.0016.470.60.42.61.5010014.980.000.60.42.61.501014.514.9821.720.60.42.61.5016023.960.000.60.42.61.501614.523.9621.720.60.42.61.5023034.440.000.60.42.61.502314.534.4421.720.60.42.61.5027740.4410.480.60.42.61.50271140.4416.47Col. Esq.0.60.42.61.50000.000.000.60.42.61.50014.50.0021.720.60.42.61.5027040.440.000.60.42.61.502714.540.4421.72Total =37.63556.17273.12Ancho (m)Largo (m)W (Ton/m2)m (Ton)XYm*Xm*YAligerado13.926.60.4147.9013.57.251996.601072.25Acabados14.5270.139.1513.77.55536.36295.58Tabiqueria14.5270.1558.7313.77.55804.53443.37S/C14.5270.2548.9413.77.55670.44369.48Total =294.714007.932180.68Largo (m)W (Ton/m)m (Ton)XYm*Xm*YMuro LP------270.513.5013.50182.250.00Muro LP------270.513.5013.514.5182.25195.75Muro Fach.------14.50.253.6307.250.0026.28Muro Fach.------14.50.253.63277.2597.8826.28Total =34.25462.38248.31Peso Total del 1er Entre PisoP (Ton) =516.71m =52.6713251784XYC.M =13.787.33Calculo del Im del Entre Pisom (Ton)a (m)b (m)IzXYr (m)ImVP10118.72260.41054.809613.514.57.172018.03VP10218.72260.41054.809613.5113.681308.11VP10318.72260.41054.809613.570.441058.37VP10415.84220.4639.091211.534.901018.90VP10518.72260.41054.809613.507.342062.76VS10110.8022.50.4455.76907.2513.782507.28VS10212.9622.50.4546.9228107.253.78732.40VS10312.9622.50.4546.9228167.252.22610.76VS10411.8822.50.4501.3459237.259.221510.86VS10510.8022.50.4455.769277.2513.222342.73Total =15170.19m (Ton)a (m)b (m)IzXYr (m)ImC11.680.450.60.0789751035.7555.801.680.450.60.0789751073.8024.371.680.450.60.07897510115.2746.841.680.450.60.0789751634.8739.991.680.450.60.0789751672.248.551.680.450.60.07897516114.2931.031.680.450.60.07897523310.19174.861.680.450.60.0789752379.22143.421.680.450.60.07897523119.92165.90C21.500.40.60.0648960314.45312.641.500.40.60.0648960713.79284.701.500.40.60.06489601114.26304.681.500.40.60.0648961008.25102.001.500.40.60.0648961014.58.1098.431.500.40.60.0648961607.6687.951.500.40.60.0648961614.57.5084.371.500.40.60.06489623011.78207.831.500.40.60.0648962314.511.68204.251.500.40.60.06489627713.22261.881.500.40.60.064896271113.72281.86C31.500.40.60.0648960015.61365.051.500.40.60.064896014.515.53361.471.500.40.60.06489627015.12342.231.500.40.60.0648962714.515.04338.65Total =4328.73m (Ton)a (m)b (m)IzXYr (m)ImAligerado147.9013.926.611101.689993333313.57.250.2911114.47Acabados39.1514.5273064.30312513.77.550.233066.42Tabiqueria58.7314.5274596.454687513.77.550.234599.63S/C48.9414.5273830.3789062513.77.550.233833.03Total =22613.55m (Ton)a (m)b (m)IzXYr (m)ImMuro LP13.50270.15820.150312513.507.341547.04Muro LP13.50270.15820.150312513.514.57.171514.78Muro Fach.3.630.1514.563.519817708307.2513.78752.10Muro Fach.3.630.1514.563.5198177083277.2513.22696.87Total =4510.80Im del Entre Piso:Im =4752.63estos mismos datos se cumplen con el Entre Piso 2,3y4

Entre Piso 5Metrado de cargas del 5to entre piso(Concreto Ton/m3) =2.4h (m) =1.3Walig (ton/m2) =0.4Wacab (ton/m2) =0.1Wtabq (ton/m2) =0.05Wmur. LP (ton/m) =0.2Wmur. Fach. (ton/m) =0.2s/c (ton/m2) =0.125b (m)h (m)Long (m)m (Ton)XYm*Xm*YVP1010.40.752618.7213.514.5252.72271.44VP1020.40.752618.7213.511252.72205.92VP1030.40.752618.7213.57252.72131.04VP1040.40.752215.8411.53182.1647.52VP1050.40.752618.7213.50252.720.00VS1010.40.522.510.8007.250.0078.30VS1020.40.622.512.96107.25129.6093.96VS1030.40.622.512.96167.25207.3693.96VS1040.40.5522.511.88237.25273.2486.13VS1050.40.522.510.80277.25291.6078.30Total =150.122094.841086.57b (m)t (m)Long (m)m (Ton)XYm*Xm*YCol. Cent.0.60.451.30.841038.422.530.60.451.30.841078.425.900.60.451.30.8410118.429.270.60.451.30.8416313.482.530.60.451.30.8416713.485.900.60.451.30.84161113.489.270.60.451.30.8423319.382.530.60.451.30.8423719.385.900.60.451.30.84231119.389.27Col.Perim.0.60.41.30.75030.002.250.60.41.30.75070.005.240.60.41.30.750110.008.240.60.41.30.751007.490.000.60.41.30.751014.57.4910.860.60.41.30.7516011.980.000.60.41.30.751614.511.9810.860.60.41.30.7523017.220.000.60.41.30.752314.517.2210.860.60.41.30.7527720.225.240.60.41.30.75271120.228.24Col. Esq.0.60.41.30.75000.000.000.60.41.30.75014.50.0010.860.60.41.30.7527020.220.000.60.41.30.752714.520.2210.86Total =18.81278.09136.56Ancho (m)Largo (m)W (Ton/m2)m (Ton)XYm*Xm*YAligerado13.926.60.4147.9013.57.151996.601057.46Acabados14.5270.139.1513.77.45536.36291.67Tabiqueria14.5270.0519.5813.77.45268.18145.83S/C14.5270.12524.4713.77.45335.22182.29Total =231.093136.351677.25Largo (m)W (Ton/m)m (Ton)XYm*Xm*YMuro LP------270.25.4013.5072.900.00Muro LP------270.25.4013.514.572.9078.30Muro Fach.------14.50.22.9007.250.0021.03Muro Fach.------14.50.22.90277.2578.3021.03Total =16.60224.10120.35Peso Total del 1er Entre PisoP (Ton) =416.62m =42.4692507645XYC.M =13.767.25Calculo del Im del Entre Pisom (Ton)a (m)b (m)IzXYr (m)ImVP10118.72260.41054.809613.514.57.252039.92VP10218.72260.41054.809613.5113.761319.27VP10318.72260.41054.809613.570.361057.26VP10415.84220.4639.091211.534.811006.28VP10518.72260.41054.809613.507.262040.20VS10110.8022.50.4455.76907.2513.762501.07VS10212.9622.50.4546.9228107.253.76730.30VS10312.9622.50.4546.9228167.252.24611.86VS10411.8822.50.4501.3459237.259.241515.30VS10510.8022.50.4455.769277.2513.242348.54Total =15170.01m (Ton)a (m)b (m)IzXYr (m)ImC10.840.450.60.03948751035.6827.180.840.450.60.03948751073.7712.010.840.450.60.039487510115.3123.800.840.450.60.03948751634.8019.480.840.450.60.03948751672.254.310.840.450.60.039487516114.3716.100.840.450.60.039487523310.1787.160.840.450.60.03948752379.2471.990.840.450.60.039487523119.9783.78C20.750.40.60.0324480314.40155.370.750.40.60.0324480713.76141.890.750.40.60.03244801114.26152.370.750.40.60.0324481008.1749.990.750.40.60.0324481014.58.1749.980.750.40.60.0324481607.5943.150.750.40.60.0324481614.57.5943.140.750.40.60.03244823011.74103.310.750.40.60.0324482314.511.74103.300.750.40.60.03244827713.24131.310.750.40.60.032448271113.76141.79C30.750.40.60.0324480015.55181.200.750.40.60.032448014.515.55181.190.750.40.60.03244827015.09170.630.750.40.60.0324482714.515.09170.62Total =2165.05m (Ton)a (m)b (m)IzXYr (m)ImAligerado147.9013.926.611101.689993333313.57.150.2811113.30Acabados39.1514.5273064.30312513.77.450.213066.01Tabiqueria19.5814.5271532.151562513.77.450.211533.00S/C24.4714.5271915.18945312513.77.450.211916.26Total =17628.57m (Ton)a (m)b (m)IzXYr (m)ImMuro LP5.40270.15328.06012513.507.26612.31Muro LP5.40270.15328.06012513.514.57.25612.23Muro Fach.2.900.1514.550.815854166707.2513.76600.02Muro Fach.2.900.1514.550.8158541667277.2513.24559.06Total =2383.61Im del Entre Piso:Im =3807.06

ResumenEntre pisoCoord. XCoord. YmasaIm113.797.3353.264820.51213.787.3352.674752.63313.787.3352.674752.63413.787.3352.674752.63513.767.2542.473807.06

Hallando T y SLA LIBERTAD: ZONA 3Z =0.4Tp =0.4U =1R =8S =1Sa=ZUSCgC=2.5*Tp < 2.5RTTCSa0.12.51.226250.22.51.226250.32.51.226250.42.51.226250.520.9810.61.670.8191350.71.430.7014150.81.250.6131250.91.110.544455110.4905