excel sismica
DESCRIPTION
pTRANSCRIPT
PREDIMENCIONAMIENTO
Dimensiones de plantaRESUMEN DE CARGAS Predimensionamiento de ColumnasPredimensionamiento de zapatas
Carga muerta
L16mcolumnaszapatas - 1CMCVTOTALL26mPISO 46.5761.047.616L36mCOLUMNA LARGO (m)ANCHO (m) . TRIBUTARIA (M2)pisoh(m)b(m)d(m)gtotalPISO 36.5762.088.6564.003.300.400.502.401.58PISO 26.5762.088.656C - 166363.003.300.400.502.401.58PISO 17.0562.089.136Predimensionamiento de losa aligeradaC -263182.003.300.400.502.401.5834.065C - 33391.004.300.400.502.402.06zapatas - 2CMCVTOTALTRAMOLONG.(m)COEFICIENTEESPESORESPESO A TOMARvigasPISO 410.5833.6014.183L - 16250.240.25PISO 310.5837.2017.783L - 26250.240.25VIGASL(m)H(m)b(m)gtotalPISO 210.5837.2017.783L - 36250.240.251.005.550.500.302.402.00PISO 111.0637.2018.263COLUMNA PC (kgf/cm) . TRIBUTARIA (M2)N DE PISOSP. SERVICIO (kgf)2.008.650.500.302.403.1168.0133.0011.100.500.302.404.00C - 11000364144000C -2100018472000zapatas - 3CMCVTOTALPredimensionamiento de vigasC - 310009436000PISO 416.9521.9518.902losa aligeradaPISO 316.9523.9020.852PISO 216.9523.9020.852para columnas centralesLOSAL(M)A(M)P.USUBTOTALPISO 117.4323.9021.332TRAMOLONG.(m)COEFICIENTEPERALTEANCHOL-1(c. esqina)2.952.900.352.9981.936L - 16120.50.3L-2(c. excentrica)5.702.950.355.89L - 26120.50.3L-3(c. central)5.705.700.3511.37DIMENSIONES DE LAS ZAPATAS REALES Y ASUMIDASL - 36120.50.3para columnas excentricas y esquinadaszapatasAzDimensiones realeszapatasDimensiones asumidasAasunidaCarga vivaBLBLZ - 31.701.311.31Z - 31.401.401.96Z - 23.401.841.94Z - 21.901.903.61LOSA 1LT(M) nlargoAT(M) anchoPUTOTALZ - 14.102.022.02Z - 12.102.104.41COLUMNA AREA DE LA COLUMNA (cm2)B x d (m2)APROXIM.PISO-43.253.200.101.04PISO-33.253.200.202.08C - 11523.839 x 3940 x 40PISO-23.253.200.202.08C -2979.631 x 3135 x 35PISO-13.253.200.202.08C - 3489.823 x 2325 x 25LOSA 2LT(M)AT(M)PUTOTALPISO-46.006.000.103.60para ayuda del calculo consideramos la columna de 40 x 50 cm2PISO-36.006.000.207.20PISO-26.006.000.207.20PISO-16.006.000.207.20LOSA 3LT(M)AT(M)PUTOTALPISO-46.003.250.101.95PISO-36.003.250.203.90PISO-26.003.250.203.90PISO-16.003.250.203.90
METRADO DE CARGAS
PISO 4C.M. LOSA ALIGERADA90.355.65.75101.43COLUMNAS162.40.40.53.325.344VIGAS T.122.40.30.55.624.192VIGAS L.122.40.30.55.523.760174.726C.V.TECHO0.118.418.534.04Ppiso208.766
PISO 3 Y 2C.M. LOSA ALIGERADA90.355.65.75101.43COLUMNAS162.40.40.53.325.344VIGAS T.122.40.30.55.624.192VIGAS L.122.40.30.55.523.760174.726C.V.HOTEL0.218.418.568.08Ppiso 2 = 3242.806
PISO 1C.M. LOSA ALIGERADA90.355.65.75101.43COLUMNAS162.40.40.54.333.024VIGAS T.122.40.30.55.624.192VIGAS L.122.40.30.55.523.760182.406C.V.HOTEL0.218.418.568.08Ppiso 1250.486
RESUMEN DE CARGAS POR PISO
C.M.C.V.P (ton)P (sismo)
4TO PISO174.72634.04208.766183.236
3ER PISO174.72668.08242.806191.746
2DO PISO 174.72668.08242.806191.746
1ER PISO182.40668.08250.486199.426
944.864766.154
UBICACION DEL CENTRO DE MASA
COLUMNAXi (m)Yi (m)Ai (m2)Xi x AiYi x Xi1000.2002600.21.2031200.22.4041800.23.605060.201.26660.21.21.271260.22.41.281860.23.61.290120.202.4106120.21.22.41112120.22.42.41218120.23.62.4130180.203.6146180.21.23.61512180.22.43.61618180.23.63.63.228.828.8
EXCENTRICIDAD
ex0.05Lxey0.05Ly
Lx18.5Ly18.4
ex0.925ey0.920
ANALISIS NORMA 2006
PERIODO FUNDAMENTAL COEFICIENTE DE AMPLIFICACION SISMICAFUERZA CORTANTE EN LA BASEC0.125CUMPLEhn (m) = 13.20CT = 35T = 0.38Tp (s) =0.60Z =0.4RU =10.310.125T = HnC = 2.5 xTpC =2.50CTTS =1P (Tn) =766.17EXCENTRICIDAD ACCIDENTALT = 0.377C =3.98R =8ex (m) =0.925ey (m) =0.92
C =2.50V (Tn) =95.77
PISOP (Tn)H (m)P x H (Tnxm)CUARTO PISO183.2413.202418.72TERCER PISO191.759.901898.29SEGUNDO PISO 191.756.601265.52PRIMER PISO 199.433.30658.10TOTAL =6240.63
F4 (Tn) =37.12F3 (Tn) =29.13 F2 (Tn) =19.42F1 (Tn) =10.10
CONTROL DE DESPLAZAMIENTO LATERCONCRETOg0.007PISODESPLAZAMIENTOH (m)CUMPLE43.333.323.313.3PISODESPLAZAMIENTOH (m)CONTROLCUMPLE43.333.323.313.3
Hoja2
ANALISIS NORMA 2014
PERIODO FUNDAMENTAL COEFICIENTE DE AMPLIFICACION SISMICAFUERZA CORTANTE EN LA BASEC0.125CUMPLEhn (m) = 13.20CT = 35PERFIL DEL SUELO =S2Z =0.45RTp (s) =0.60Tl (s) =2.00U =10.310.125T = HnC =2.50CTS =1.05P (Tn) =766.17EXCENTRICIDAD ACCIDENTALT = 0.377R =8ex (m) =0.925ey (m) =0.92
V (Tn) =113.13C =2.50
k =1
P (Tn)H (m)H^k (m)P x H^k (Tnxm)CUARTO PISO183.2413.2013.202418.72TERCER PISO191.759.909.901898.29SEGUNDO PISO 191.756.606.601265.52PRIMER PISO 199.433.303.30658.10TOTAL =6240.63
4 =0.39F4 (Tn) =43.85 3 =0.30F3 (Tn) =34.412 =0.20F2 (Tn) =22.941 =0.11F1 (Tn) =11.93TOTAL =1.00