hojas_de_calculo(1).xls
Transcript of hojas_de_calculo(1).xls
-
5/21/2018 hojas_de_calculo(1).xls
1/67
11.5 METRADO DE CARGAS
Peso de la Losa Aligerada = 280 kg/m2. (e=0.17m)
Peso de Albailera = 1,800 kg/m3.Peso de Acabados = 100 kg/m2.
Peso del Concreto Armado = 2,400 kg/m3.
Sobrecargas (s/c) 1, 2, 3 nivel = 200 kg/m2. (vivienda)
Sobrecargas (s/c) 4 nivel = 150 kg/m2. (vivienda)
11.6 ANALISIS Y DISEO DE MUROS11.6.1 DENOMINACION Y LONGITUDES DE MURO EN CADA DIRECCION
t=0.13m t=0.23m t=0.13m t=0.23m1X 4.15 1Y 8.35
2X 2.60 2Y 3.90
3X 3.60 3Y 3.45
4X 3.60 4Y 3.90
5X 2.20 5Y 2.05
6X 7.35 6Y 3.10
7X 5.75 7Y 1.75
8X 4.00 8Y 8.35
9X 4.15 9Y 1.7510X 2.60 10Y 3.10
11X 3.60 11Y 2.05
12X 3.60 12Y 3.90
13X 2.20 13Y 3.45
14X 5.75 14Y 3.90
15Y 8.35
16Y 2.90
17Y 2.90
Totales 27.25 27.90 23.90 43.25
11.6.2 VERIFICACION DE LA DENSIDAD DE MUROS
Area en planta de la edificacin por piso Ap = 257.67 m2.
Nmero de pisos N = 4 pisos
Eje X:
Muro Direccin X Muro Direccin Y
AmAp
-
5/21/2018 hojas_de_calculo(1).xls
2/67
Area de Muros Am = 9.96 m2.
Am / Ap = 0.0387
N / 140 = 0.0286
Am / Ap > N/140 = 0.74
Eje Y:Area de Muros Am = 13.05 m2.
Am / Ap = 0.0507
N / 140 = 0.0286
Am / Ap > N/140 = 0.56
Parmetros ValoresZ 0.40
U 1.00
S 1.20
Lt / Ap Z.U.S.N / 56
Area de corte de todos los muros Lt = 23.014 m2.
Lt / Ap = 0.0893 adimZ.U.S.N / 56 = 0.0343 adim
Lt / Ap Z.U.S.N / 56 0.38
Descripcin
Zona 3 (Piura)
Edificacin para vivienda (categora C)
Suelos flexibles o con estratos de gran espesor S3
-
5/21/2018 hojas_de_calculo(1).xls
3/67
> N140
-
5/21/2018 hojas_de_calculo(1).xls
4/67
VerArt.5
Art.10
Art.6
-
5/21/2018 hojas_de_calculo(1).xls
5/67
11.6.3 ANALISIS POR CARGA VERTICAL
a) Metrado de cargas y clculo de los esfuerzos actuantes
Peso de Albailera = 1,800 kg/m3.
Nmero de pisos = 4 pisosPeso de la Losa Aligerada = 280 kg/m2. (e=0.17m)
Peso de Acabados = 100 kg/m2.
Peso del Concreto Armado = 2,400 kg/m3.
Altura del muro = 2.40 m.Sobrecargas (s/c) 1, 2, 3 nivel = 200 kg/m2. (vivienda)
Sobrecargas (s/c) 4 nivel = 150 kg/m2. (vivienda)
DIRECCION "Y" - PRIMER PISO
Muro Espesor
(m)
Area
tributaria
(m2)
Peso propio
muros
(kg)
Peso
aligerado
e = 0.17
(kg)
Peso
acabados de
aligerado
(kg)
1Y 0.23 1.900 3,974.40 2,128.00 760.00
2Y 0.23 3.600 3,974.40 4,032.00 1,440.00
3Y 0.23 3.600 3,974.40 4,032.00 1,440.00
4Y 0.13 3.650 2,246.40 4,088.00 1,460.00
5Y 0.13 3.650 2,246.40 4,088.00 1,460.00
6Y 0.13 0.000 2,246.40 0.00 0.00
7Y 0.23 1.825 3,974.40 2,044.00 730.00
8Y 0.23 3.650 3,974.40 4,088.00 1,460.00
9Y 0.23 1.825 3,974.40 2,044.00 730.00
10Y 0.13 0.000 2,246.40 0.00 0.00
11Y 0.13 3.650 2,246.40 4,088.00 1,460.00
12Y 0.13 3.650 2,246.40 4,088.00 1,460.00
13Y 0.23 3.600 3,974.40 4,032.00 1,440.00
14Y 0.23 3.600 3,974.40 4,032.00 1,440.00
15Y 0.23 1.900 3,974.40 2,128.00 760.0016Y 0.13 0.000 2,246.40 0.00 0.00
17Y 0.13 0.000 2,246.40 0.00 0.00
DIRECCION "X" - PRIMER PISO
-
5/21/2018 hojas_de_calculo(1).xls
6/67
Muro Espesor
(m)
Area
tributaria
(m2)
Peso propio
muros
(kg)
Peso
aligerado
e = 0.17
(kg)
Peso
acabados de
aligerado
(kg)
1X 0.23 0.000 3,974.40 0.00 0.002X 0.23 0.000 3,974.40 0.00 0.00
3X 0.23 0.000 3,974.40 0.00 0.00
4X 0.23 0.000 3,974.40 0.00 0.00
5X 0.13 2.125 2,246.40 2,380.00 850.00
6X 0.13 2.125 2,246.40 2,380.00 850.00
7X 0.13 2.125 2,246.40 2,380.00 850.00
8X 0.13 0.600 2,246.40 672.00 240.00
9X 0.23 0.000 3,974.40 0.00 0.00
10X 0.23 0.000 3,974.40 0.00 0.00
11X 0.23 0.000 3,974.40 0.00 0.00
12X 0.23 0.000 3,974.40 0.00 0.00
13X 0.13 2.125 2,246.40 2,380.00 850.00
14X 0.13 2.125 2,246.40 2,380.00 850.00
b) Clculo del Esfuerzo Admisible (Fa)
Esfuerzo resistente a la compresin del muro de ladril f'm = 60
Altura del muro de ladrillo h = 2.40
Para t = 0.13 m. t = 0.13Esfuerzo Admisible Fa = 8.66
Para t = 0.23 m. t = 0.23Esfuerzo Admisible Fa = 10.93
Fa = 0.20 f'm ( 1 - (
-
5/21/2018 hojas_de_calculo(1).xls
7/67
Peso
parapeto
(kg)
Total carga
muerta "Pd"
(kg)
Total carga
viva "Pl"
(kg)
Esfuerzo
act. por
carga
muerta fd
k /cm2
Esfuerzo
act. por
carga viva fl
(kg/cm2)
Esfuerzo
act. total
fa (kg/cm2)
210.60 7,073.00 1,425.00 3.08 0.62 3.69 0.34
0.00 9,446.40 2,700.00 4.11 1.17 5.28 0.48
0.00 9,446.40 2,700.00 4.11 1.17 5.28 0.48
0.00 7,794.40 2,737.50 6.00 2.11 8.10 0.94
0.00 7,794.40 2,737.50 6.00 2.11 8.10 0.94
0.00 2,246.40 0.00 1.73 0.00 1.73 0.20
0.00 6,748.40 1,368.75 2.93 0.60 3.53 0.32
0.00 9,522.40 2,737.50 4.14 1.19 5.33 0.49
0.00 6,748.40 1,368.75 2.93 0.60 3.53 0.32
0.00 2,246.40 0.00 1.73 0.00 1.73 0.20
0.00 7,794.40 2,737.50 6.00 2.11 8.10 0.94
0.00 7,794.40 2,737.50 6.00 2.11 8.10 0.94
0.00 9,446.40 2,700.00 4.11 1.17 5.28 0.48
0.00 9,446.40 2,700.00 4.11 1.17 5.28 0.48
210.60 7,073.00 1,425.00 3.08 0.62 3.69 0.34210.60 2,457.00 0.00 1.89 0.00 1.89 0.22
210.60 2,457.00 0.00 1.89 0.00 1.89 0.22
-
5/21/2018 hojas_de_calculo(1).xls
8/67
Peso
parapeto
(kg)
Total carga
muerta "Pd"
(kg)
Total carga
viva "Pl"
(kg)
Es uerzo
act. por
carga
muerta fd
k /cm2
Esfuerzo
act. por
carga viva fl
(kg/cm2)
Esfuerzo
act. total
fa (kg/cm2)
210.60 4,185.00 0.00 1.82 0.00 1.82 0.170.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 5,476.40 1,593.75 4.21 1.23 5.44 0.63
210.60 5,687.00 1,593.75 4.37 1.23 5.60 0.65
210.60 5,687.00 1,593.75 4.37 1.23 5.60 0.65
210.60 3,369.00 450.00 2.59 0.35 2.94 0.34
210.60 4,185.00 0.00 1.82 0.00 1.82 0.17
0.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 3,974.40 0.00 1.73 0.00 1.73 0.16
0.00 5,476.40 1,593.75 4.21 1.23 5.44 0.63
210.60 5,687.00 1,593.75 4.37 1.23 5.60 0.65
Kg/cm2.
m.
m.
Kg/cm2.
m.
Kg/cm2.
h / 35 t )
-
5/21/2018 hojas_de_calculo(1).xls
9/67
11.6.4 CALCULO DEL PESO TOTAL DEL EDIFICIO (P)
Peso de Albailera = 1,800 kg/m3.
Longitud de muros portantes en direccin "X"Para t = 0.13 m., son: 27.25 m.
Para t = 0.23 m., son: 27.90 m.
Longitud de muros portantes en direccin "Y"Para t = 0.13 m., son: 23.90 m.
Para t = 0.23 m., son: 43.25 m.
Altura del muro hm = 2.40 m.
Espesor efectivo del muro e_t1 = 0.13 m.
Espesor efectivo del muro e_t2 = 0.23 m.Longitud de muros no portantes 2.90 m.
Longitud de alfizares 20.55 m.
Altura de alfizar ha = 0.90 m.
Nmero de pisos = 4 pisosPeso de la Losa Aligerada = 280 kg/m2. (e=0.17m)
Peso de Acabados = 100 kg/m2.
Area techada 257.67 m2.Sobrecargas (s/c) 1, 2, 3 nivel = 200 kg/m2. (vivienda)
Sobrecargas (s/c) 4 nivel = 150 kg/m2. (vivienda)
Longitud del parapeto Lp = 76.70 m.
Altura del parapeto hp = 0.90 m.
Piso
Peso de
muros
portantes
(1)
Peso de
muros no
portantes
(2)
Peso de
alfizares
(3)
Peso de losa
aligerada
(4)
Peso de
acabados
(5)
1 99,420.480 1,628.640 4,327.830 72,147.600 25,767.000
2 99,420.480 1,628.640 4,327.830 72,147.600 25,767.0003 99,420.480 1,628.640 4,327.830 72,147.600 25,767.000
4 99,420.480 1,628.640 4,327.830 72,147.600 25,767.000
397,681.920 6,514.560 17,311.320 ####### 103,068.000
-
5/21/2018 hojas_de_calculo(1).xls
10/67
Peso de
parapeto
(6)
ota
carga muerta
"D"
(7)
=(1)+(2)++(6
Total
carga
viva "L"
(8)
Peso
total
P=D+L
(9)
=(7)+(8)
0.000 203,291.550 12,883.500 216,175.050
0.000 203,291.550 12,883.500 216,175.0500.000 203,291.550 12,883.500 216,175.050
16,153.020 219,444.570 9,662.625 229,107.195
16,153.020 829,319.220 48,313.125 877,632.345
-
5/21/2018 hojas_de_calculo(1).xls
11/67
11.6.5 CALCULO DE LA FUERZA CORTANTE EN LA BASE DEL EDIFICIO (V)
V = ZUCS P / R V = K P
C = 2.5 ( Tp / T ) C < = 2.5
T = hn / Ct C / R > = 0.125
Parmetros ValoresZ 0.40
U 1.00
S 1.20
R 6.00
Tp 0.90hn 10.28
Ct 60.00
T 0.17
C_calc 13.13
C_asum 2.50
C/R_calc 0.42
C/R_asum 0.42
K 0.20
P 877,632.35
V 175,526.47
11.6.6 DISTRIBUCION DE LA FUERZA CORTANTE EN ALTURA
PISO Pi hi Pi.hiPi.hiPi.hi
Fi
4 229,107.20 10.28 2,355,221.96 0.414 72,671.80
3 216,175.05 7.71 1,666,709.64 0.293 51,427.33
2 216,175.05 5.14 1,111,139.76 0.195 34,284.89
1 216,175.05 2.57 555,569.88 0.098 17,142.44
877,632.35 5,688,641.24 175,526.47
DescripcinZona 3 (Piura)
Edificacin para vivienda (categora C)
Suelos flexibles o con estratos de gran espesor S3
Estructura de albailera armada o confinada
Factor segn el periodo de vibracin de suelo
Peso total de la edificacin en kg
Fuerza cortante en la base de la estructura en kg
Factor C / R calculado
Factor C / R asumido
Altura total de la edificacin en metros
Coeficiente para estimar el periodo fundamental
Periodo fundamental de la estructura
Coeficiente de amplificacin ssmica
Coeficiente de amplificacin ssmica
Coeficiente de proporcionalidad
-
5/21/2018 hojas_de_calculo(1).xls
12/67
VerArt.5 0.40
Art.10 1.00
Art.6 1.40
Art.12 3.00
Art.6 0.9010.28
Art.17 60.00
Art.17 0.17
Art.7 13.13
Art.7 2.50
Art.17 0.83
Art.17 0.13
0.07
0.00
Art.17 0.00
Vi
72,671.80
124,099.13
158,384.02
175,526.47
-
5/21/2018 hojas_de_calculo(1).xls
13/67
11.6.7 DISTRIBUCION DE LA FUERZA CORTANTE DE NIVEL EN CADA MUROPiso 01 Datos geomtricos Piso 02 Datos geo
Muro h t l x y Muro h1X 2.40 0.23 4.15 3.675 12.325 1X 2.40
2X 2.40 0.23 2.60 1.300 8.675 2X 2.403X 2.40 0.23 3.60 6.550 8.675 3X 2.40
4X 2.40 0.23 3.60 6.550 7.175 4X 2.40
5X 2.40 0.13 2.20 2.700 4.175 5X 2.40
6X 2.40 0.13 7.35 10.875 4.175 6X 2.40
7X 2.40 0.13 5.75 4.475 0.075 7X 2.40
8X 2.40 0.13 4.00 10.850 0.075 8X 2.40
9X 2.40 0.23 4.15 18.075 12.325 9X 2.40
10X 2.40 0.23 2.60 20.450 8.675 10X 2.40
11X 2.40 0.23 3.60 15.200 8.675 11X 2.40
12X 2.40 0.23 3.60 15.200 7.175 12X 2.4013X 2.40 0.13 2.20 19.050 4.175 13X 2.40
14X 2.40 0.13 5.75 17.275 0.075 14X 2.40
1Y 2.40 8.35 0.23 0.125 8.275 1Y 2.40
2Y 2.40 3.90 0.23 3.675 10.500 2Y 2.40
3Y 2.40 3.45 0.23 3.675 5.825 3Y 2.40
4Y 2.40 3.90 0.13 7.275 10.500 4Y 2.40
5Y 2.40 2.05 0.13 7.275 5.125 5Y 2.40
6Y 2.40 3.10 0.13 7.275 1.550 6Y 2.40
7Y 2.40 1.75 0.23 8.225 7.925 7Y 2.40
8Y 2.40 8.35 0.23 10.875 8.275 8Y 2.40
9Y 2.40 1.75 0.23 13.525 7.925 9Y 2.4010Y 2.40 3.10 0.13 14.475 1.550 10Y 2.40
11Y 2.40 2.05 0.13 14.475 5.125 11Y 2.40
12Y 2.40 3.90 0.13 14.475 10.500 12Y 2.40
13Y 2.40 3.45 0.23 18.075 5.825 13Y 2.40
14Y 2.40 3.90 0.23 18.075 10.500 14Y 2.40
15Y 2.40 8.35 0.23 21.625 8.275 15Y 2.40
16Y 2.40 2.90 0.13 9.550 2.800 16Y 2.40
17Y 2.40 2.90 0.13 12.200 2.800 17Y 2.40
-
5/21/2018 hojas_de_calculo(1).xls
14/67
mtricos Piso 03 Datos geomtricos
t l x y Muro h t l x0.23 4.15 3.675 12.325 1X 2.40 0.23 4.15 3.675
0.23 2.60 1.300 8.675 2X 2.40 0.23 2.60 1.3000.23 3.60 6.550 8.675 3X 2.40 0.23 3.60 6.550
0.23 3.60 6.550 7.175 4X 2.40 0.23 3.60 6.550
0.13 2.20 2.700 4.175 5X 2.40 0.13 2.20 2.700
0.13 7.35 10.875 4.175 6X 2.40 0.13 7.35 10.875
0.13 5.75 4.475 0.075 7X 2.40 0.13 5.75 4.475
0.13 4.00 10.850 0.075 8X 2.40 0.13 4.00 10.850
0.23 4.15 18.075 12.325 9X 2.40 0.23 4.15 18.075
0.23 2.60 20.450 8.675 10X 2.40 0.23 2.60 20.450
0.23 3.60 15.200 8.675 11X 2.40 0.23 3.60 15.200
0.23 3.60 15.200 7.175 12X 2.40 0.23 3.60 15.2000.13 2.20 19.050 4.175 13X 2.40 0.13 2.20 19.050
0.13 5.75 17.275 0.075 14X 2.40 0.13 5.75 17.275
8.35 0.23 0.125 8.275 1Y 2.40 8.35 0.23 0.125
3.90 0.23 3.675 10.500 2Y 2.40 3.90 0.23 3.675
3.45 0.23 3.675 5.825 3Y 2.40 3.45 0.23 3.675
3.90 0.13 7.275 10.500 4Y 2.40 3.90 0.13 7.275
2.05 0.13 7.275 5.125 5Y 2.40 2.05 0.13 7.275
3.10 0.13 7.275 1.550 6Y 2.40 3.10 0.13 7.275
1.75 0.23 8.225 7.925 7Y 2.40 1.75 0.23 8.225
8.35 0.23 10.875 8.275 8Y 2.40 8.35 0.23 10.875
1.75 0.23 13.525 7.925 9Y 2.40 1.75 0.23 13.5253.10 0.13 14.475 1.550 10Y 2.40 3.10 0.13 14.475
2.05 0.13 14.475 5.125 11Y 2.40 2.05 0.13 14.475
3.90 0.13 14.475 10.500 12Y 2.40 3.90 0.13 14.475
3.45 0.23 18.075 5.825 13Y 2.40 3.45 0.23 18.075
3.90 0.23 18.075 10.500 14Y 2.40 3.90 0.23 18.075
8.35 0.23 21.625 8.275 15Y 2.40 8.35 0.23 21.625
2.90 0.13 9.550 2.800 16Y 2.40 2.90 0.13 9.550
2.90 0.13 12.200 2.800 17Y 2.40 2.90 0.13 12.200
-
5/21/2018 hojas_de_calculo(1).xls
15/67
Piso 04 Datos geomtricos
y Muro h t l x y12.325 1X 2.40 0.23 4.15 3.675 12.325
8.675 2X 2.40 0.23 2.60 1.300 8.6758.675 3X 2.40 0.23 3.60 6.550 8.675
7.175 4X 2.40 0.23 3.60 6.550 7.175
4.175 5X 2.40 0.13 2.20 2.700 4.175
4.175 6X 2.40 0.13 7.35 10.875 4.175
0.075 7X 2.40 0.13 5.75 4.475 0.075
0.075 8X 2.40 0.13 4.00 10.850 0.075
12.325 9X 2.40 0.23 4.15 18.075 12.325
8.675 10X 2.40 0.23 2.60 20.450 8.675
8.675 11X 2.40 0.23 3.60 15.200 8.675
7.175 12X 2.40 0.23 3.60 15.200 7.1754.175 13X 2.40 0.13 2.20 19.050 4.175
0.075 14X 2.40 0.13 5.75 17.275 0.075
8.275 1Y 2.40 8.35 0.23 0.125 8.275
10.500 2Y 2.40 3.90 0.23 3.675 10.500
5.825 3Y 2.40 3.45 0.23 3.675 5.825
10.500 4Y 2.40 3.90 0.13 7.275 10.500
5.125 5Y 2.40 2.05 0.13 7.275 5.125
1.550 6Y 2.40 3.10 0.13 7.275 1.550
7.925 7Y 2.40 1.75 0.23 8.225 7.925
8.275 8Y 2.40 8.35 0.23 10.875 8.275
7.925 9Y 2.40 1.75 0.23 13.525 7.9251.550 10Y 2.40 3.10 0.13 14.475 1.550
5.125 11Y 2.40 2.05 0.13 14.475 5.125
10.500 12Y 2.40 3.90 0.13 14.475 10.500
5.825 13Y 2.40 3.45 0.23 18.075 5.825
10.500 14Y 2.40 3.90 0.23 18.075 10.500
8.275 15Y 2.40 8.35 0.23 21.625 8.275
2.800 16Y 2.40 2.90 0.13 9.550 2.800
2.800 17Y 2.40 2.90 0.13 12.200 2.800
-
5/21/2018 hojas_de_calculo(1).xls
16/67
11.6.7.2 Clculo de rigideces de muros en la direccin "X":Piso 01 Rigideces de muros en la direccin "X":
Muro
(1)
3 ( h / l )
(2)
4 ( h / l )^3
(3)
(4)
=(2)+(3)
Kx / Em
1X 1.7349 0.7737 2.5086 0.091685
2X 2.7692 3.1461 5.9153 0.038882
3X 2.0000 1.1852 3.1852 0.072209
4X 2.0000 1.1852 3.1852 0.072209
5X 3.2727 5.1931 8.4658 0.015356
6X 0.9796 0.1393 1.1189 0.116190
7X 1.2522 0.2909 1.5430 0.084249
8X 1.8000 0.8640 2.6640 0.048799
9X 1.7349 0.7737 2.5086 0.091685
10X 2.7692 3.1461 5.9153 0.03888211X 2.0000 1.1852 3.1852 0.072209
12X 2.0000 1.1852 3.1852 0.072209
13X 3.2727 5.1931 8.4658 0.015356
14X 1.2522 0.2909 1.5430 0.084249
1Y 31.3043 4,544.7522 4576.0565 0.001825
2Y 31.3043 4,544.7522 4576.0565 0.000852
3Y 31.3043 4,544.7522 4576.0565 0.000754
4Y 55.3846 25,168.8666 25224.2513 0.000155
5Y 55.3846 25,168.8666 25224.2513 0.000081
6Y 55.3846 25,168.8666 25224.2513 0.000123
7Y 31.3043 4,544.7522 4576.0565 0.000382
8Y 31.3043 4,544.7522 4576.0565 0.001825
9Y 31.3043 4,544.7522 4576.0565 0.000382
10Y 55.3846 25,168.8666 25224.2513 0.000123
11Y 55.3846 25,168.8666 25224.2513 0.000081
12Y 55.3846 25,168.8666 25224.2513 0.000155
13Y 31.3043 4,544.7522 4576.0565 0.000754
14Y 31.3043 4,544.7522 4576.0565 0.000852
15Y 31.3043 4,544.7522 4576.0565 0.001825
16Y 55.3846 25,168.8666 25224.2513 0.000115
17Y 55.3846 25,168.8666 25224.2513 0.000115
0.924569
11.6.7.3 Clculo de rigideces de muros en la direccin "Y":Piso 01 Rigideces de muros en la direccin "Y":
-
5/21/2018 hojas_de_calculo(1).xls
17/67
Muro(1)
3 ( h / l )(2)
4 ( h / l )^3(3)
(4)=(2)+(3)
Ky / Em
1X 31.3043 4,544.7522 4576.0565 0.000907
2X 31.3043 4,544.7522 4576.0565 0.000568
3X 31.3043 4,544.7522 4576.0565 0.000787
4X 31.3043 4,544.7522 4576.0565 0.000787
5X 55.3846 25,168.8666 25224.2513 0.000087
6X 55.3846 25,168.8666 25224.2513 0.000291
7X 55.3846 25,168.8666 25224.2513 0.000228
8X 55.3846 25,168.8666 25224.2513 0.000159
9X 31.3043 4,544.7522 4576.0565 0.000907
10X 31.3043 4,544.7522 4576.0565 0.000568
11X 31.3043 4,544.7522 4576.0565 0.000787
12X 31.3043 4,544.7522 4576.0565 0.000787
13X 55.3846 25,168.8666 25224.2513 0.00008714X 55.3846 25,168.8666 25224.2513 0.000228
1Y 0.8623 0.0950 0.9573 0.240270
2Y 1.8462 0.9322 2.7783 0.082783
3Y 2.0870 1.3466 3.4335 0.066986
4Y 1.8462 0.9322 2.7783 0.046791
5Y 3.5122 6.4185 9.9307 0.013091
6Y 2.3226 1.8561 4.1787 0.031110
7Y 4.1143 10.3176 14.4319 0.015937
8Y 0.8623 0.0950 0.9573 0.240270
9Y 4.1143 10.3176 14.4319 0.015937
10Y 2.3226 1.8561 4.1787 0.031110
11Y 3.5122 6.4185 9.9307 0.013091
12Y 1.8462 0.9322 2.7783 0.046791
13Y 2.0870 1.3466 3.4335 0.066986
14Y 1.8462 0.9322 2.7783 0.082783
15Y 0.8623 0.0950 0.9573 0.240270
16Y 2.4828 2.2673 4.7500 0.027368
17Y 2.4828 2.2673 4.7500 0.027368
1.296120
-
5/21/2018 hojas_de_calculo(1).xls
18/67
Piso 02 Rigideces de muros en la direccin "X": Piso 03 Rigideces de
Muro
(1)
3 ( h / l )
(2)
4 ( h / l)^3
(3)
(4)
=(2)+(3)
Kx / EmMuro
(1)
3 ( h / l )
(2)1X 1.7349 0.7737 2.5086 0.091685 1X 1.7349
2X 2.7692 3.1461 5.9153 0.038882 2X 2.7692
3X 2.0000 1.1852 3.1852 0.072209 3X 2.0000
4X 2.0000 1.1852 3.1852 0.072209 4X 2.0000
5X 3.2727 5.1931 8.4658 0.015356 5X 3.2727
6X 0.9796 0.1393 1.1189 0.116190 6X 0.9796
7X 1.2522 0.2909 1.5430 0.084249 7X 1.2522
8X 1.8000 0.8640 2.6640 0.048799 8X 1.8000
9X 1.7349 0.7737 2.5086 0.091685 9X 1.7349
10X 2.7692 3.1461 5.9153 0.038882 10X 2.769211X 2.0000 1.1852 3.1852 0.072209 11X 2.0000
12X 2.0000 1.1852 3.1852 0.072209 12X 2.0000
13X 3.2727 5.1931 8.4658 0.015356 13X 3.2727
14X 1.2522 0.2909 1.5430 0.084249 14X 1.2522
1Y 31.3043 4544.7522 4576.0565 0.001825 1Y 31.3043
2Y 31.3043 4544.7522 4576.0565 0.000852 2Y 31.3043
3Y 31.3043 4544.7522 4576.0565 0.000754 3Y 31.3043
4Y 55.3846 25168.8666 25224.2513 0.000155 4Y 55.3846
5Y 55.3846 25168.8666 25224.2513 0.000081 5Y 55.3846
6Y 55.3846 25168.8666 25224.2513 0.000123 6Y 55.3846
7Y 31.3043 4544.7522 4576.0565 0.000382 7Y 31.3043
8Y 31.3043 4544.7522 4576.0565 0.001825 8Y 31.3043
9Y 31.3043 4544.7522 4576.0565 0.000382 9Y 31.3043
10Y 55.3846 25168.8666 25224.2513 0.000123 10Y 55.3846
11Y 55.3846 25168.8666 25224.2513 0.000081 11Y 55.3846
12Y 55.3846 25168.8666 25224.2513 0.000155 12Y 55.3846
13Y 31.3043 4544.7522 4576.0565 0.000754 13Y 31.3043
14Y 31.3043 4544.7522 4576.0565 0.000852 14Y 31.3043
15Y 31.3043 4544.7522 4576.0565 0.001825 15Y 31.3043
16Y 55.3846 25168.8666 25224.2513 0.000115 16Y 55.3846
17Y 55.3846 25168.8666 25224.2513 0.000115 17Y 55.3846
0.924569
Piso 02 Rigideces de muros en la direccin "Y": Piso 03 Rigideces de
-
5/21/2018 hojas_de_calculo(1).xls
19/67
Muro(1)
3 ( h / l )(2)
4 ( h / l)^3(3)
(4)=(2)+(3)
Ky / EmMuro(1)
3 ( h / l )(2)
1X 31.3043 4544.7522 4576.0565 0.000907 1X 31.3043
2X 31.3043 4544.7522 4576.0565 0.000568 2X 31.3043
3X 31.3043 4544.7522 4576.0565 0.000787 3X 31.3043
4X 31.3043 4544.7522 4576.0565 0.000787 4X 31.3043
5X 55.3846 25168.8666 25224.2513 0.000087 5X 55.3846
6X 55.3846 25168.8666 25224.2513 0.000291 6X 55.3846
7X 55.3846 25168.8666 25224.2513 0.000228 7X 55.3846
8X 55.3846 25168.8666 25224.2513 0.000159 8X 55.3846
9X 31.3043 4544.7522 4576.0565 0.000907 9X 31.3043
10X 31.3043 4544.7522 4576.0565 0.000568 10X 31.3043
11X 31.3043 4544.7522 4576.0565 0.000787 11X 31.3043
12X 31.3043 4544.7522 4576.0565 0.000787 12X 31.3043
13X 55.3846 25168.8666 25224.2513 0.000087 13X 55.384614X 55.3846 25168.8666 25224.2513 0.000228 14X 55.3846
1Y 0.8623 0.0950 0.9573 0.240270 1Y 0.8623
2Y 1.8462 0.9322 2.7783 0.082783 2Y 1.8462
3Y 2.0870 1.3466 3.4335 0.066986 3Y 2.0870
4Y 1.8462 0.9322 2.7783 0.046791 4Y 1.8462
5Y 3.5122 6.4185 9.9307 0.013091 5Y 3.5122
6Y 2.3226 1.8561 4.1787 0.031110 6Y 2.3226
7Y 4.1143 10.3176 14.4319 0.015937 7Y 4.1143
8Y 0.8623 0.0950 0.9573 0.240270 8Y 0.8623
9Y 4.1143 10.3176 14.4319 0.015937 9Y 4.1143
10Y 2.3226 1.8561 4.1787 0.031110 10Y 2.3226
11Y 3.5122 6.4185 9.9307 0.013091 11Y 3.5122
12Y 1.8462 0.9322 2.7783 0.046791 12Y 1.8462
13Y 2.0870 1.3466 3.4335 0.066986 13Y 2.0870
14Y 1.8462 0.9322 2.7783 0.082783 14Y 1.8462
15Y 0.8623 0.0950 0.9573 0.240270 15Y 0.8623
16Y 2.4828 2.2673 4.7500 0.027368 16Y 2.4828
17Y 2.4828 2.2673 4.7500 0.027368 17Y 2.4828
1.296120
-
5/21/2018 hojas_de_calculo(1).xls
20/67
muros en la direccin "X": Piso 04 Rigideces de muros en la direccin "X":
4 ( h / l)^3
(3)
(4)
=(2)+(3)
Kx / EmMuro
(1)
3 ( h / l )
(2)
4 ( h / l)^3
(3)
(4)
=(2)+(3)0.7737 2.5086 0.091685 1X 1.7349 0.7737 2.5086
3.1461 5.9153 0.038882 2X 2.7692 3.1461 5.9153
1.1852 3.1852 0.072209 3X 2.0000 1.1852 3.1852
1.1852 3.1852 0.072209 4X 2.0000 1.1852 3.1852
5.1931 8.4658 0.015356 5X 3.2727 5.1931 8.4658
0.1393 1.1189 0.116190 6X 0.9796 0.1393 1.1189
0.2909 1.5430 0.084249 7X 1.2522 0.2909 1.5430
0.8640 2.6640 0.048799 8X 1.8000 0.8640 2.6640
0.7737 2.5086 0.091685 9X 1.7349 0.7737 2.5086
3.1461 5.9153 0.038882 10X 2.7692 3.1461 5.91531.1852 3.1852 0.072209 11X 2.0000 1.1852 3.1852
1.1852 3.1852 0.072209 12X 2.0000 1.1852 3.1852
5.1931 8.4658 0.015356 13X 3.2727 5.1931 8.4658
0.2909 1.5430 0.084249 14X 1.2522 0.2909 1.5430
4544.7522 4576.0565 0.001825 1Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000852 2Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000754 3Y 31.3043 4544.7522 4576.0565
25168.8666 25224.2513 0.000155 4Y 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000081 5Y 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000123 6Y 55.3846 25168.8666 25224.2513
4544.7522 4576.0565 0.000382 7Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.001825 8Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000382 9Y 31.3043 4544.7522 4576.0565
25168.8666 25224.2513 0.000123 10Y 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000081 11Y 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000155 12Y 55.3846 25168.8666 25224.2513
4544.7522 4576.0565 0.000754 13Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000852 14Y 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.001825 15Y 31.3043 4544.7522 4576.0565
25168.8666 25224.2513 0.000115 16Y 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000115 17Y 55.3846 25168.8666 25224.2513
0.924569
muros en la direccin "Y": Piso 04 Rigideces de muros en la direccin "Y":
-
5/21/2018 hojas_de_calculo(1).xls
21/67
4 ( h / l)^3(3)
Ky / Em Ky / EmMuro(1)
3 ( h / l )(2)
4 ( h / l)^3(3)
(4)=(2)+(3)
4544.7522 4576.0565 0.000907 1X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000568 2X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000787 3X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000787 4X 31.3043 4544.7522 4576.0565
25168.8666 25224.2513 0.000087 5X 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000291 6X 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000228 7X 55.3846 25168.8666 25224.2513
25168.8666 25224.2513 0.000159 8X 55.3846 25168.8666 25224.2513
4544.7522 4576.0565 0.000907 9X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000568 10X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000787 11X 31.3043 4544.7522 4576.0565
4544.7522 4576.0565 0.000787 12X 31.3043 4544.7522 4576.0565
25168.8666 25224.2513 0.000087 13X 55.3846 25168.8666 25224.251325168.8666 25224.2513 0.000228 14X 55.3846 25168.8666 25224.2513
0.0950 0.9573 0.240270 1Y 0.8623 0.0950 0.9573
0.9322 2.7783 0.082783 2Y 1.8462 0.9322 2.7783
1.3466 3.4335 0.066986 3Y 2.0870 1.3466 3.4335
0.9322 2.7783 0.046791 4Y 1.8462 0.9322 2.7783
6.4185 9.9307 0.013091 5Y 3.5122 6.4185 9.9307
1.8561 4.1787 0.031110 6Y 2.3226 1.8561 4.1787
10.3176 14.4319 0.015937 7Y 4.1143 10.3176 14.4319
0.0950 0.9573 0.240270 8Y 0.8623 0.0950 0.9573
10.3176 14.4319 0.015937 9Y 4.1143 10.3176 14.4319
1.8561 4.1787 0.031110 10Y 2.3226 1.8561 4.1787
6.4185 9.9307 0.013091 11Y 3.5122 6.4185 9.9307
0.9322 2.7783 0.046791 12Y 1.8462 0.9322 2.7783
1.3466 3.4335 0.066986 13Y 2.0870 1.3466 3.4335
0.9322 2.7783 0.082783 14Y 1.8462 0.9322 2.7783
0.0950 0.9573 0.240270 15Y 0.8623 0.0950 0.9573
2.2673 4.7500 0.027368 16Y 2.4828 2.2673 4.7500
2.2673 4.7500 0.027368 17Y 2.4828 2.2673 4.7500
1.296120
-
5/21/2018 hojas_de_calculo(1).xls
22/67
Kx / Em
0.091685
0.038882
0.072209
0.072209
0.015356
0.116190
0.084249
0.048799
0.091685
0.0388820.072209
0.072209
0.015356
0.084249
0.001825
0.000852
0.000754
0.000155
0.000081
0.000123
0.000382
0.001825
0.000382
0.000123
0.000081
0.000155
0.000754
0.000852
0.001825
0.000115
0.000115
0.924569
-
5/21/2018 hojas_de_calculo(1).xls
23/67
Ky / Em
0.000907
0.000568
0.000787
0.000787
0.000087
0.000291
0.000228
0.000159
0.000907
0.000568
0.000787
0.000787
0.0000870.000228
0.240270
0.082783
0.066986
0.046791
0.013091
0.031110
0.015937
0.240270
0.015937
0.031110
0.013091
0.046791
0.066986
0.082783
0.240270
0.027368
0.027368
1.296120
-
5/21/2018 hojas_de_calculo(1).xls
24/67
11.6.7.4 Clculo de cortantes de traslacin en la direccin "X":
Piso 01 Piso 02
Vx1 = 175,526.47 kg Vx2 = 158,384.02
MuroV_traslac =
Vxi.Kxi / Kxi% de
AbsorcinMuro
V_traslac =Vxi.Kxi / Kxi
1X 17,406.04 9.92% 1X 15,706.11
2X 7,381.62 4.21% 2X 6,660.71
3X 13,708.71 7.81% 3X 12,369.87
4X 13,708.71 7.81% 4X 12,369.87
5X 2,915.26 1.66% 5X 2,630.55
6X 22,058.37 12.57% 6X 19,904.08
7X 15,994.48 9.11% 7X 14,432.41
8X 9,264.30 5.28% 8X 8,359.52
9X 17,406.04 9.92% 9X 15,706.11
10X 7,381.62 4.21% 10X 6,660.71
11X 13,708.71 7.81% 11X 12,369.87
12X 13,708.71 7.81% 12X 12,369.87
13X 2,915.26 1.66% 13X 2,630.55
14X 15,994.48 9.11% 14X 14,432.41
1Y 346.42 0.20% 1Y 312.58
2Y 161.80 0.09% 2Y 146.00
3Y 143.13 0.08% 3Y 129.15
4Y 29.35 0.02% 4Y 26.495Y 15.43 0.01% 5Y 13.92
6Y 23.33 0.01% 6Y 21.05
7Y 72.60 0.04% 7Y 65.51
8Y 346.42 0.20% 8Y 312.58
9Y 72.60 0.04% 9Y 65.51
10Y 23.33 0.01% 10Y 21.05
11Y 15.43 0.01% 11Y 13.92
12Y 29.35 0.02% 12Y 26.49
13Y 143.13 0.08% 13Y 129.15
14Y 161.80 0.09% 14Y 146.00
15Y 346.42 0.20% 15Y 312.58
16Y 21.83 0.01% 16Y 19.69
17Y 21.83 0.01% 17Y 19.69
100.00%
11.6.7.5 Clculo de cortantes de traslacin en la direccin "Y":
Cortantes de traslacin
en la direccin "X":
Cortantes de tra
en la direccin "X
-
5/21/2018 hojas_de_calculo(1).xls
25/67
Piso 01 Piso 02
Vy1 = 175,526.47 kg Vy2 = 158,384.02
MuroV_traslac =
Vxi.Kxi / Kxi
% de
Absorcin
MuroV_traslac =
Vxi.Kxi / Kxi1X 122.82 0.07% 1X 110.82
2X 76.94 0.04% 2X 69.43
3X 106.54 0.06% 3X 96.13
4X 106.54 0.06% 4X 96.13
5X 11.81 0.01% 5X 10.66
6X 39.46 0.02% 6X 35.61
7X 30.87 0.02% 7X 27.86
8X 21.48 0.01% 8X 19.38
9X 122.82 0.07% 9X 110.82
10X 76.94 0.04% 10X 69.4311X 106.54 0.06% 11X 96.13
12X 106.54 0.06% 12X 96.13
13X 11.81 0.01% 13X 10.66
14X 30.87 0.02% 14X 27.86
1Y 32,538.47 18.54% 1Y 29,360.67
2Y 11,210.91 6.39% 2Y 10,116.02
3Y 9,071.56 5.17% 3Y 8,185.60
4Y 6,336.60 3.61% 4Y 5,717.75
5Y 1,772.81 1.01% 5Y 1,599.67
6Y 4,213.07 2.40% 6Y 3,801.61
7Y 2,158.25 1.23% 7Y 1,947.47
8Y 32,538.47 18.54% 8Y 29,360.67
9Y 2,158.25 1.23% 9Y 1,947.47
10Y 4,213.07 2.40% 10Y 3,801.61
11Y 1,772.81 1.01% 11Y 1,599.67
12Y 6,336.60 3.61% 12Y 5,717.75
13Y 9,071.56 5.17% 13Y 8,185.60
14Y 11,210.91 6.39% 14Y 10,116.02
15Y 32,538.47 18.54% 15Y 29,360.67
16Y 3,706.35 2.11% 16Y 3,344.37
17Y 3,706.35 2.11% 17Y 3,344.37
100.00%
Cortantes de traslacin
en la direccin "Y":
Cortantes de tra
en la direccin "Y
-
5/21/2018 hojas_de_calculo(1).xls
26/67
Piso 03 Piso 04
kg Vx3 = 124,099.13 kg Vx4 = 72,671.80
% deAbsorcin
MuroV_traslac =
Vxi.Kxi / Kxi% de
AbsorcinMuro
V_traslac =Vxi.Kxi / Kxi
9.92% 1X 12,306.26 9.92% 1X 7,206.48
4.21% 2X 5,218.88 4.21% 2X 3,056.15
7.81% 3X 9,692.20 7.81% 3X 5,675.70
7.81% 4X 9,692.20 7.81% 4X 5,675.70
1.66% 5X 2,061.12 1.66% 5X 1,206.98
12.57% 6X 15,595.51 12.57% 6X 9,132.65
9.11% 7X 11,308.27 9.11% 7X 6,622.06
5.28% 8X 6,549.96 5.28% 8X 3,835.62
9.92% 9X 12,306.26 9.92% 9X 7,206.48
4.21% 10X 5,218.88 4.21% 10X 3,056.15
7.81% 11X 9,692.20 7.81% 11X 5,675.70
7.81% 12X 9,692.20 7.81% 12X 5,675.70
1.66% 13X 2,061.12 1.66% 13X 1,206.98
9.11% 14X 11,308.27 9.11% 14X 6,622.06
0.20% 1Y 244.92 0.20% 1Y 143.42
0.09% 2Y 114.39 0.09% 2Y 66.99
0.08% 3Y 101.19 0.08% 3Y 59.26
0.02% 4Y 20.75 0.02% 4Y 12.150.01% 5Y 10.91 0.01% 5Y 6.39
0.01% 6Y 16.50 0.01% 6Y 9.66
0.04% 7Y 51.33 0.04% 7Y 30.06
0.20% 8Y 244.92 0.20% 8Y 143.42
0.04% 9Y 51.33 0.04% 9Y 30.06
0.01% 10Y 16.50 0.01% 10Y 9.66
0.01% 11Y 10.91 0.01% 11Y 6.39
0.02% 12Y 20.75 0.02% 12Y 12.15
0.08% 13Y 101.19 0.08% 13Y 59.26
0.09% 14Y 114.39 0.09% 14Y 66.99
0.20% 15Y 244.92 0.20% 15Y 143.42
0.01% 16Y 15.43 0.01% 16Y 9.04
0.01% 17Y 15.43 0.01% 17Y 9.04
100.00% 100.00%
lacin
":
Cortantes de traslacin
en la direccin "X":
Cortantes de tra
en la direccin "
-
5/21/2018 hojas_de_calculo(1).xls
27/67
Piso 03 Piso 04
kg Vy3 = 124,099.13 kg Vy4 = 72,671.80
% de
Absorcin
MuroV_traslac =
Vxi.Kxi / Kxi
% de
Absorcin
MuroV_traslac =
Vxi.Kxi / Kxi0.07% 1X 86.83 0.07% 1X 50.85
0.04% 2X 54.40 0.04% 2X 31.86
0.06% 3X 75.32 0.06% 3X 44.11
0.06% 4X 75.32 0.06% 4X 44.11
0.01% 5X 8.35 0.01% 5X 4.89
0.02% 6X 27.90 0.02% 6X 16.34
0.02% 7X 21.83 0.02% 7X 12.78
0.01% 8X 15.18 0.01% 8X 8.89
0.07% 9X 86.83 0.07% 9X 50.85
0.04% 10X 54.40 0.04% 10X 31.860.06% 11X 75.32 0.06% 11X 44.11
0.06% 12X 75.32 0.06% 12X 44.11
0.01% 13X 8.35 0.01% 13X 4.89
0.02% 14X 21.83 0.02% 14X 12.78
18.54% 1Y 23,005.06 18.54% 1Y 13,471.64
6.39% 2Y 7,926.23 6.39% 2Y 4,641.56
5.17% 3Y 6,413.69 5.17% 3Y 3,755.82
3.61% 4Y 4,480.05 3.61% 4Y 2,623.49
1.01% 5Y 1,253.40 1.01% 5Y 733.98
2.40% 6Y 2,978.68 2.40% 6Y 1,744.30
1.23% 7Y 1,525.91 1.23% 7Y 893.56
18.54% 8Y 23,005.06 18.54% 8Y 13,471.64
1.23% 9Y 1,525.91 1.23% 9Y 893.56
2.40% 10Y 2,978.68 2.40% 10Y 1,744.30
1.01% 11Y 1,253.40 1.01% 11Y 733.98
3.61% 12Y 4,480.05 3.61% 12Y 2,623.49
5.17% 13Y 6,413.69 5.17% 13Y 3,755.82
6.39% 14Y 7,926.23 6.39% 14Y 4,641.56
18.54% 15Y 23,005.06 18.54% 15Y 13,471.64
2.11% 16Y 2,620.43 2.11% 16Y 1,534.51
2.11% 17Y 2,620.43 2.11% 17Y 1,534.51
100.00% 100.00%
lacin
":
Cortantes de traslacin
en la direccin "Y":
Cortantes de tra
en la direccin "
-
5/21/2018 hojas_de_calculo(1).xls
28/67
kg
% deAbsorcin
9.92%
4.21%
7.81%
7.81%
1.66%
12.57%
9.11%
5.28%
9.92%
4.21%
7.81%
7.81%
1.66%
9.11%
0.20%
0.09%
0.08%
0.02%0.01%
0.01%
0.04%
0.20%
0.04%
0.01%
0.01%
0.02%
0.08%
0.09%
0.20%
0.01%
0.01%
100.00%
slacin
":
-
5/21/2018 hojas_de_calculo(1).xls
29/67
kg
% de
Absorcin0.07%
0.04%
0.06%
0.06%
0.01%
0.02%
0.02%
0.01%
0.07%
0.04%0.06%
0.06%
0.01%
0.02%
18.54%
6.39%
5.17%
3.61%
1.01%
2.40%
1.23%
18.54%
1.23%
2.40%
1.01%
3.61%
5.17%
6.39%
18.54%
2.11%
2.11%
100.00%
slacin
":
-
5/21/2018 hojas_de_calculo(1).xls
30/67
11.6.8 CORRECCION POR TORSION
11.6.8.1 Clculo del centro de rigidezPiso 01 Centro de rigidez
Muro
(1) Kx / Em Ky / Em y.Kx / Em x.Ky / Em1X 0.091685 0.000907 1.130013 0.003333
2X 0.038882 0.000568 0.337301 0.000739
3X 0.072209 0.000787 0.626416 0.005153
4X 0.072209 0.000787 0.518102 0.005153
5X 0.015356 0.000087 0.064111 0.000235
6X 0.116190 0.000291 0.485095 0.003169
7X 0.084249 0.000228 0.006319 0.001020
8X 0.048799 0.000159 0.003660 0.001721
9X 0.091685 0.000907 1.130013 0.016392
10X 0.038882 0.000568 0.337301 0.01161911X 0.072209 0.000787 0.626416 0.011958
12X 0.072209 0.000787 0.518102 0.011958
13X 0.015356 0.000087 0.064111 0.001661
14X 0.084249 0.000228 0.006319 0.003938
1Y 0.001825 0.240270 0.015100 0.030034
2Y 0.000852 0.082783 0.008949 0.304229
3Y 0.000754 0.066986 0.004392 0.246174
4Y 0.000155 0.046791 0.001623 0.340402
5Y 0.000081 0.013091 0.000417 0.095235
6Y 0.000123 0.031110 0.000190 0.226326
7Y 0.000382 0.015937 0.003031 0.131081
8Y 0.001825 0.240270 0.015100 2.612938
9Y 0.000382 0.015937 0.003031 0.215547
10Y 0.000123 0.031110 0.000190 0.450318
11Y 0.000081 0.013091 0.000417 0.189489
12Y 0.000155 0.046791 0.001623 0.677294
13Y 0.000754 0.066986 0.004392 1.210773
14Y 0.000852 0.082783 0.008949 1.496310
15Y 0.001825 0.240270 0.015100 5.195841
16Y 0.000115 0.027368 0.000322 0.261368
17Y 0.000115 0.027368 0.000322 0.333894
0.924569 1.296120 5.936423 14.095302
Xcr = 10.8750 m.
Ycr = 6.4207 m.
-
5/21/2018 hojas_de_calculo(1).xls
31/67
Piso 02 Centro de rigidez Piso 03 Centro de rig
Muro
(1) Kx / Em Ky / Em y.Kx / Em x.Ky / Em
Muro
(1) Kx / Em1X 0.091685 0.000907 1.130013 0.003333 1X 0.091685
2X 0.038882 0.000568 0.337301 0.000739 2X 0.038882
3X 0.072209 0.000787 0.626416 0.005153 3X 0.072209
4X 0.072209 0.000787 0.518102 0.005153 4X 0.072209
5X 0.015356 0.000087 0.064111 0.000235 5X 0.015356
6X 0.116190 0.000291 0.485095 0.003169 6X 0.116190
7X 0.084249 0.000228 0.006319 0.001020 7X 0.084249
8X 0.048799 0.000159 0.003660 0.001721 8X 0.048799
9X 0.091685 0.000907 1.130013 0.016392 9X 0.091685
10X 0.038882 0.000568 0.337301 0.011619 10X 0.03888211X 0.072209 0.000787 0.626416 0.011958 11X 0.072209
12X 0.072209 0.000787 0.518102 0.011958 12X 0.072209
13X 0.015356 0.000087 0.064111 0.001661 13X 0.015356
14X 0.084249 0.000228 0.006319 0.003938 14X 0.084249
1Y 0.001825 0.240270 0.015100 0.030034 1Y 0.001825
2Y 0.000852 0.082783 0.008949 0.304229 2Y 0.000852
3Y 0.000754 0.066986 0.004392 0.246174 3Y 0.000754
4Y 0.000155 0.046791 0.001623 0.340402 4Y 0.000155
5Y 0.000081 0.013091 0.000417 0.095235 5Y 0.000081
6Y 0.000123 0.031110 0.000190 0.226326 6Y 0.000123
7Y 0.000382 0.015937 0.003031 0.131081 7Y 0.000382
8Y 0.001825 0.240270 0.015100 2.612938 8Y 0.001825
9Y 0.000382 0.015937 0.003031 0.215547 9Y 0.000382
10Y 0.000123 0.031110 0.000190 0.450318 10Y 0.000123
11Y 0.000081 0.013091 0.000417 0.189489 11Y 0.000081
12Y 0.000155 0.046791 0.001623 0.677294 12Y 0.000155
13Y 0.000754 0.066986 0.004392 1.210773 13Y 0.000754
14Y 0.000852 0.082783 0.008949 1.496310 14Y 0.000852
15Y 0.001825 0.240270 0.015100 5.195841 15Y 0.001825
16Y 0.000115 0.027368 0.000322 0.261368 16Y 0.000115
17Y 0.000115 0.027368 0.000322 0.333894 17Y 0.000115
0.924569 1.296120 5.936423 14.095302 0.924569
Xcr = 10.8750 m. Xcr = 10.8750
Ycr = 6.4207 m. Ycr = 6.4207
-
5/21/2018 hojas_de_calculo(1).xls
32/67
idez Piso 04 Centro de rigidez
Ky / Em y.Kx / Em x.Ky / Em
Muro
(1) Kx / Em Ky / Em y.Kx / Em0.000907 1.130013 0.003333 1X 0.091685 0.000907 1.130013
0.000568 0.337301 0.000739 2X 0.038882 0.000568 0.337301
0.000787 0.626416 0.005153 3X 0.072209 0.000787 0.626416
0.000787 0.518102 0.005153 4X 0.072209 0.000787 0.518102
0.000087 0.064111 0.000235 5X 0.015356 0.000087 0.064111
0.000291 0.485095 0.003169 6X 0.116190 0.000291 0.485095
0.000228 0.006319 0.001020 7X 0.084249 0.000228 0.006319
0.000159 0.003660 0.001721 8X 0.048799 0.000159 0.003660
0.000907 1.130013 0.016392 9X 0.091685 0.000907 1.130013
0.000568 0.337301 0.011619 10X 0.038882 0.000568 0.3373010.000787 0.626416 0.011958 11X 0.072209 0.000787 0.626416
0.000787 0.518102 0.011958 12X 0.072209 0.000787 0.518102
0.000087 0.064111 0.001661 13X 0.015356 0.000087 0.064111
0.000228 0.006319 0.003938 14X 0.084249 0.000228 0.006319
0.240270 0.015100 0.030034 1Y 0.001825 0.240270 0.015100
0.082783 0.008949 0.304229 2Y 0.000852 0.082783 0.008949
0.066986 0.004392 0.246174 3Y 0.000754 0.066986 0.004392
0.046791 0.001623 0.340402 4Y 0.000155 0.046791 0.001623
0.013091 0.000417 0.095235 5Y 0.000081 0.013091 0.000417
0.031110 0.000190 0.226326 6Y 0.000123 0.031110 0.000190
0.015937 0.003031 0.131081 7Y 0.000382 0.015937 0.003031
0.240270 0.015100 2.612938 8Y 0.001825 0.240270 0.015100
0.015937 0.003031 0.215547 9Y 0.000382 0.015937 0.003031
0.031110 0.000190 0.450318 10Y 0.000123 0.031110 0.000190
0.013091 0.000417 0.189489 11Y 0.000081 0.013091 0.000417
0.046791 0.001623 0.677294 12Y 0.000155 0.046791 0.001623
0.066986 0.004392 1.210773 13Y 0.000754 0.066986 0.004392
0.082783 0.008949 1.496310 14Y 0.000852 0.082783 0.008949
0.240270 0.015100 5.195841 15Y 0.001825 0.240270 0.015100
0.027368 0.000322 0.261368 16Y 0.000115 0.027368 0.000322
0.027368 0.000322 0.333894 17Y 0.000115 0.027368 0.000322
1.296120 5.936423 14.095302 0.924569 1.296120 5.936423
m. Xcr = 10.8750 m.
m. Ycr = 6.4207 m.
-
5/21/2018 hojas_de_calculo(1).xls
33/67
x.Ky / Em0.003333
0.000739
0.005153
0.005153
0.000235
0.003169
0.001020
0.001721
0.016392
0.0116190.011958
0.011958
0.001661
0.003938
0.030034
0.304229
0.246174
0.340402
0.095235
0.226326
0.131081
2.612938
0.215547
0.450318
0.189489
0.677294
1.210773
1.496310
5.195841
0.261368
0.333894
14.095302
-
5/21/2018 hojas_de_calculo(1).xls
34/67
11.6.8.1 Clculo del centro de masaPiso 01 Centro de masa
Muro l h t PE_alb Peso "P" X1X 4.150 2.400 0.23 1,800 4,123.44 3.675
2X 2.600 2.400 0.23 1,800 2,583.36 1.3003X 3.600 2.400 0.23 1,800 3,576.96 6.550
4X 3.600 2.400 0.23 1,800 3,576.96 6.550
5X 2.200 2.400 0.13 1,800 1,235.52 2.700
6X 7.350 2.400 0.13 1,800 4,127.76 10.875
7X 5.750 2.400 0.13 1,800 3,229.20 4.475
8X 4.000 2.400 0.13 1,800 2,246.40 10.850
9X 4.150 2.400 0.23 1,800 4,123.44 18.075
10X 2.600 2.400 0.23 1,800 2,583.36 20.450
11X 3.600 2.400 0.23 1,800 3,576.96 15.200
12X 3.600 2.400 0.23 1,800 3,576.96 15.20013X 2.200 2.400 0.13 1,800 1,235.52 19.050
14X 5.750 2.400 0.13 1,800 3,229.20 17.275
1Y 8.350 2.400 0.23 1,800 8,296.56 0.125
2Y 3.900 2.400 0.23 1,800 3,875.04 3.675
3Y 3.450 2.400 0.23 1,800 3,427.92 3.675
4Y 3.900 2.400 0.13 1,800 2,190.24 7.275
5Y 2.050 2.400 0.13 1,800 1,151.28 7.275
6Y 3.100 2.400 0.13 1,800 1,740.96 7.275
7Y 1.750 2.400 0.23 1,800 1,738.80 8.225
8Y 8.350 2.400 0.23 1,800 8,296.56 10.875
9Y 1.750 2.400 0.23 1,800 1,738.80 13.52510Y 3.100 2.400 0.13 1,800 1,740.96 14.475
11Y 2.050 2.400 0.13 1,800 1,151.28 14.475
12Y 3.900 2.400 0.13 1,800 2,190.24 14.475
13Y 3.450 2.400 0.23 1,800 3,427.92 18.075
14Y 3.900 2.400 0.23 1,800 3,875.04 18.075
15Y 8.350 2.400 0.23 1,800 8,296.56 21.625
16Y 2.900 2.400 0.13 1,800 1,628.64 9.550
17Y 2.900 2.400 0.13 1,800 1,628.64 12.200
99,420.48
Xcm = 10.8744 m.
Ycm = 7.1937 m.
-
5/21/2018 hojas_de_calculo(1).xls
35/67
Piso 02 Centro de masa
Y P.X P.Y Muro l h t12.325 15,153.64 50,821.40 1X 4.150 2.400 0.23
8.675 3,358.37 22,410.65 2X 2.600 2.400 0.238.675 23,429.09 31,030.13 3X 3.600 2.400 0.23
7.175 23,429.09 25,664.69 4X 3.600 2.400 0.23
4.175 3,335.90 5,158.30 5X 2.200 2.400 0.13
4.175 44,889.39 17,233.40 6X 7.350 2.400 0.13
0.075 14,450.67 242.19 7X 5.750 2.400 0.13
0.075 24,373.44 168.48 8X 4.000 2.400 0.13
12.325 74,531.18 50,821.40 9X 4.150 2.400 0.23
8.675 52,829.71 22,410.65 10X 2.600 2.400 0.23
8.675 54,369.79 31,030.13 11X 3.600 2.400 0.23
7.175 54,369.79 25,664.69 12X 3.600 2.400 0.234.175 23,536.66 5,158.30 13X 2.200 2.400 0.13
0.075 55,784.43 242.19 14X 5.750 2.400 0.13
8.275 1,037.07 68,654.03 1Y 8.350 2.400 0.23
10.500 14,240.77 40,687.92 2Y 3.900 2.400 0.23
5.825 12,597.61 19,967.63 3Y 3.450 2.400 0.23
10.500 15,934.00 22,997.52 4Y 3.900 2.400 0.13
5.125 8,375.56 5,900.31 5Y 2.050 2.400 0.13
1.550 12,665.48 2,698.49 6Y 3.100 2.400 0.13
7.925 14,301.63 13,779.99 7Y 1.750 2.400 0.23
8.275 90,225.09 68,654.03 8Y 8.350 2.400 0.23
7.925 23,517.27 13,779.99 9Y 1.750 2.400 0.231.550 25,200.40 2,698.49 10Y 3.100 2.400 0.13
5.125 16,664.78 5,900.31 11Y 2.050 2.400 0.13
10.500 31,703.72 22,997.52 12Y 3.900 2.400 0.13
5.825 61,959.65 19,967.63 13Y 3.450 2.400 0.23
10.500 70,041.35 40,687.92 14Y 3.900 2.400 0.23
8.275 179,413.11 68,654.03 15Y 8.350 2.400 0.23
2.800 15,553.51 4,560.19 16Y 2.900 2.400 0.13
2.800 19,869.41 4,560.19 17Y 2.900 2.400 0.13
###### 715,202.78
Xcm = 10.8744 m.
Ycm = 7.1937 m.
-
5/21/2018 hojas_de_calculo(1).xls
36/67
Piso 03
PE_alb Peso "P" X Y P.X P.Y Muro1,800 4,123.44 3.675 12.325 15,153.64 50,821.40 1X
1,800 2,583.36 1.300 8.675 3,358.37 22,410.65 2X1,800 3,576.96 6.550 8.675 23,429.09 31,030.13 3X
1,800 3,576.96 6.550 7.175 23,429.09 25,664.69 4X
1,800 1,235.52 2.700 4.175 3,335.90 5,158.30 5X
1,800 4,127.76 10.875 4.175 44,889.39 17,233.40 6X
1,800 3,229.20 4.475 0.075 14,450.67 242.19 7X
1,800 2,246.40 10.850 0.075 24,373.44 168.48 8X
1,800 4,123.44 18.075 12.325 74,531.18 50,821.40 9X
1,800 2,583.36 20.450 8.675 52,829.71 22,410.65 10X
1,800 3,576.96 15.200 8.675 54,369.79 31,030.13 11X
1,800 3,576.96 15.200 7.175 54,369.79 25,664.69 12X1,800 1,235.52 19.050 4.175 23,536.66 5,158.30 13X
1,800 3,229.20 17.275 0.075 55,784.43 242.19 14X
1,800 8,296.56 0.125 8.275 1,037.07 68,654.03 1Y
1,800 3,875.04 3.675 10.500 14,240.77 40,687.92 2Y
1,800 3,427.92 3.675 5.825 12,597.61 19,967.63 3Y
1,800 2,190.24 7.275 10.500 15,934.00 22,997.52 4Y
1,800 1,151.28 7.275 5.125 8,375.56 5,900.31 5Y
1,800 1,740.96 7.275 1.550 12,665.48 2,698.49 6Y
1,800 1,738.80 8.225 7.925 14,301.63 13,779.99 7Y
1,800 8,296.56 10.875 8.275 90,225.09 68,654.03 8Y
1,800 1,738.80 13.525 7.925 23,517.27 13,779.99 9Y1,800 1,740.96 14.475 1.550 25,200.40 2,698.49 10Y
1,800 1,151.28 14.475 5.125 16,664.78 5,900.31 11Y
1,800 2,190.24 14.475 10.500 31,703.72 22,997.52 12Y
1,800 3,427.92 18.075 5.825 61,959.65 19,967.63 13Y
1,800 3,875.04 18.075 10.500 70,041.35 40,687.92 14Y
1,800 8,296.56 21.625 8.275 179,413.11 68,654.03 15Y
1,800 1,628.64 9.550 2.800 15,553.51 4,560.19 16Y
1,800 1,628.64 12.200 2.800 19,869.41 4,560.19 17Y
99,420.48 ###### 715,202.78
Xcm =
Ycm =
-
5/21/2018 hojas_de_calculo(1).xls
37/67
Centro de masa
l h t PE_alb Peso "P" X Y P.X4.150 2.400 0.23 1,800 4,123.44 3.675 12.325 15,153.64
2.600 2.400 0.23 1,800 2,583.36 1.300 8.675 3,358.373.600 2.400 0.23 1,800 3,576.96 6.550 8.675 23,429.09
3.600 2.400 0.23 1,800 3,576.96 6.550 7.175 23,429.09
2.200 2.400 0.13 1,800 1,235.52 2.700 4.175 3,335.90
7.350 2.400 0.13 1,800 4,127.76 10.875 4.175 44,889.39
5.750 2.400 0.13 1,800 3,229.20 4.475 0.075 14,450.67
4.000 2.400 0.13 1,800 2,246.40 10.850 0.075 24,373.44
4.150 2.400 0.23 1,800 4,123.44 18.075 12.325 74,531.18
2.600 2.400 0.23 1,800 2,583.36 20.450 8.675 52,829.71
3.600 2.400 0.23 1,800 3,576.96 15.200 8.675 54,369.79
3.600 2.400 0.23 1,800 3,576.96 15.200 7.175 54,369.792.200 2.400 0.13 1,800 1,235.52 19.050 4.175 23,536.66
5.750 2.400 0.13 1,800 3,229.20 17.275 0.075 55,784.43
8.350 2.400 0.23 1,800 8,296.56 0.125 8.275 1,037.07
3.900 2.400 0.23 1,800 3,875.04 3.675 10.500 14,240.77
3.450 2.400 0.23 1,800 3,427.92 3.675 5.825 12,597.61
3.900 2.400 0.13 1,800 2,190.24 7.275 10.500 15,934.00
2.050 2.400 0.13 1,800 1,151.28 7.275 5.125 8,375.56
3.100 2.400 0.13 1,800 1,740.96 7.275 1.550 12,665.48
1.750 2.400 0.23 1,800 1,738.80 8.225 7.925 14,301.63
8.350 2.400 0.23 1,800 8,296.56 10.875 8.275 90,225.09
1.750 2.400 0.23 1,800 1,738.80 13.525 7.925 23,517.273.100 2.400 0.13 1,800 1,740.96 14.475 1.550 25,200.40
2.050 2.400 0.13 1,800 1,151.28 14.475 5.125 16,664.78
3.900 2.400 0.13 1,800 2,190.24 14.475 10.500 31,703.72
3.450 2.400 0.23 1,800 3,427.92 18.075 5.825 61,959.65
3.900 2.400 0.23 1,800 3,875.04 18.075 10.500 70,041.35
8.350 2.400 0.23 1,800 8,296.56 21.625 8.275 179,413.11
2.900 2.400 0.13 1,800 1,628.64 9.550 2.800 15,553.51
2.900 2.400 0.13 1,800 1,628.64 12.200 2.800 19,869.41
99,420.48 ######
10.8744 m.
7.1937 m.
-
5/21/2018 hojas_de_calculo(1).xls
38/67
Piso 04 Centro de masa
P.Y Muro l h t PE_alb Peso "P"50,821.40 1X 4.150 2.400 0.23 1,800 4,123.44
22,410.65 2X 2.600 2.400 0.23 1,800 2,583.3631,030.13 3X 3.600 2.400 0.23 1,800 3,576.96
25,664.69 4X 3.600 2.400 0.23 1,800 3,576.96
5,158.30 5X 2.200 2.400 0.13 1,800 1,235.52
17,233.40 6X 7.350 2.400 0.13 1,800 4,127.76
242.19 7X 5.750 2.400 0.13 1,800 3,229.20
168.48 8X 4.000 2.400 0.13 1,800 2,246.40
50,821.40 9X 4.150 2.400 0.23 1,800 4,123.44
22,410.65 10X 2.600 2.400 0.23 1,800 2,583.36
31,030.13 11X 3.600 2.400 0.23 1,800 3,576.96
25,664.69 12X 3.600 2.400 0.23 1,800 3,576.965,158.30 13X 2.200 2.400 0.13 1,800 1,235.52
242.19 14X 5.750 2.400 0.13 1,800 3,229.20
68,654.03 1Y 8.350 2.400 0.23 1,800 8,296.56
40,687.92 2Y 3.900 2.400 0.23 1,800 3,875.04
19,967.63 3Y 3.450 2.400 0.23 1,800 3,427.92
22,997.52 4Y 3.900 2.400 0.13 1,800 2,190.24
5,900.31 5Y 2.050 2.400 0.13 1,800 1,151.28
2,698.49 6Y 3.100 2.400 0.13 1,800 1,740.96
13,779.99 7Y 1.750 2.400 0.23 1,800 1,738.80
68,654.03 8Y 8.350 2.400 0.23 1,800 8,296.56
13,779.99 9Y 1.750 2.400 0.23 1,800 1,738.802,698.49 10Y 3.100 2.400 0.13 1,800 1,740.96
5,900.31 11Y 2.050 2.400 0.13 1,800 1,151.28
22,997.52 12Y 3.900 2.400 0.13 1,800 2,190.24
19,967.63 13Y 3.450 2.400 0.23 1,800 3,427.92
40,687.92 14Y 3.900 2.400 0.23 1,800 3,875.04
68,654.03 15Y 8.350 2.400 0.23 1,800 8,296.56
4,560.19 16Y 2.900 2.400 0.13 1,800 1,628.64
4,560.19 17Y 2.900 2.400 0.13 1,800 1,628.64
715,202.78 99,420.48
Xcm = 10.8744 m.
Ycm = 7.1937 m.
-
5/21/2018 hojas_de_calculo(1).xls
39/67
X Y P.X P.Y3.675 12.325 15,153.64 50,821.40
1.300 8.675 3,358.37 22,410.656.550 8.675 23,429.09 31,030.13
6.550 7.175 23,429.09 25,664.69
2.700 4.175 3,335.90 5,158.30
10.875 4.175 44,889.39 17,233.40
4.475 0.075 14,450.67 242.19
10.850 0.075 24,373.44 168.48
18.075 12.325 74,531.18 50,821.40
20.450 8.675 52,829.71 22,410.65
15.200 8.675 54,369.79 31,030.13
15.200 7.175 54,369.79 25,664.6919.050 4.175 23,536.66 5,158.30
17.275 0.075 55,784.43 242.19
0.125 8.275 1,037.07 68,654.03
3.675 10.500 14,240.77 40,687.92
3.675 5.825 12,597.61 19,967.63
7.275 10.500 15,934.00 22,997.52
7.275 5.125 8,375.56 5,900.31
7.275 1.550 12,665.48 2,698.49
8.225 7.925 14,301.63 13,779.99
10.875 8.275 90,225.09 68,654.03
13.525 7.925 23,517.27 13,779.9914.475 1.550 25,200.40 2,698.49
14.475 5.125 16,664.78 5,900.31
14.475 10.500 31,703.72 22,997.52
18.075 5.825 61,959.65 19,967.63
18.075 10.500 70,041.35 40,687.92
21.625 8.275 179,413.11 68,654.03
9.550 2.800 15,553.51 4,560.19
12.200 2.800 19,869.41 4,560.19
###### 715,202.78
-
5/21/2018 hojas_de_calculo(1).xls
40/67
11.6.8.3 Clculo del momento polar de Inercia (J)Piso 01 Momento polar de inercia
MuroY
=Yi-YcrY^2 (Kx/Em).Y^2
X=Xi-Xcr
X^2
1X 5.9043 34.8602 3.19615 -7.2000 51.8400
2X 2.2543 5.0817 0.19758 -9.5750 91.6806
3X 2.2543 5.0817 0.36694 -4.3250 18.7056
4X 0.7543 0.5689 0.04108 -4.3250 18.7056
5X -2.2457 5.0434 0.07745 -8.1750 66.8306
6X -2.2457 5.0434 0.58599 0.0000 0.0000
7X -6.3457 40.2685 3.39260 -6.4000 40.9600
8X -6.3457 40.2685 1.96505 -0.0250 0.0006
9X 5.9043 34.8602 3.19615 7.2000 51.8400
10X 2.2543 5.0817 0.19758 9.5750 91.6807
11X 2.2543 5.0817 0.36694 4.3250 18.705712X 0.7543 0.5689 0.04108 4.3250 18.7057
13X -2.2457 5.0434 0.07745 8.1750 66.8307
14X -6.3457 40.2685 3.39260 6.4000 40.9600
1Y 1.8543 3.4383 0.00627 -10.7500 115.5624
2Y 4.0793 16.6403 0.01418 -7.2000 51.8400
3Y -0.5957 0.3549 0.00027 -7.2000 51.8400
4Y 4.0793 16.6403 0.00257 -3.6000 12.9600
5Y -1.2957 1.6790 0.00014 -3.6000 12.9600
6Y -4.8707 23.7242 0.00292 -3.6000 12.9600
7Y 1.5043 2.2628 0.00087 -2.6500 7.0225
8Y 1.8543 3.4383 0.00627 0.0000 0.0000
9Y 1.5043 2.2628 0.00087 2.6500 7.0225
10Y -4.8707 23.7242 0.00292 3.6000 12.9600
11Y -1.2957 1.6790 0.00014 3.6000 12.9600
12Y 4.0793 16.6403 0.00257 3.6000 12.9600
13Y -0.5957 0.3549 0.00027 7.2000 51.8400
14Y 4.0793 16.6403 0.01418 7.2000 51.8400
15Y 1.8543 3.4383 0.00627 10.7500 115.5626
16Y -3.6207 13.1098 0.00151 -1.3250 1.7556
17Y -3.6207 13.1098 0.00151 1.3250 1.7556
-
5/21/2018 hojas_de_calculo(1).xls
41/67
Piso 02 Momento polar de inercia
(Ky/Em).X^2 J MuroY
=Yi-YcrY^2 (Kx/Em).Y^2
X=Xi-Xcr
0.0470 3.2432 1X 5.9043 34.8602 3.19615 -7.2000
0.0521 0.2497 2X 2.2543 5.0817 0.19758 -9.5750
0.0147 0.3817 3X 2.2543 5.0817 0.36694 -4.3250
0.0147 0.0558 4X 0.7543 0.5689 0.04108 -4.3250
0.0058 0.0833 5X -2.2457 5.0434 0.07745 -8.1750
0.0000 0.5860 6X -2.2457 5.0434 0.58599 0.0000
0.0093 3.4019 7X -6.3457 40.2685 3.39260 -6.4000
0.0000 1.9651 8X -6.3457 40.2685 1.96505 -0.0250
0.0470 3.2432 9X 5.9043 34.8602 3.19615 7.2000
0.0521 0.2497 10X 2.2543 5.0817 0.19758 9.5750
0.0147 0.3817 11X 2.2543 5.0817 0.36694 4.32500.0147 0.0558 12X 0.7543 0.5689 0.04108 4.3250
0.0058 0.0833 13X -2.2457 5.0434 0.07745 8.1750
0.0093 3.4019 14X -6.3457 40.2685 3.39260 6.4000
27.7662 27.7725 1Y 1.8543 3.4383 0.00627 -10.7500
4.2915 4.3057 2Y 4.0793 16.6403 0.01418 -7.2000
3.4726 3.4728 3Y -0.5957 0.3549 0.00027 -7.2000
0.6064 0.6090 4Y 4.0793 16.6403 0.00257 -3.6000
0.1697 0.1698 5Y -1.2957 1.6790 0.00014 -3.6000
0.4032 0.4061 6Y -4.8707 23.7242 0.00292 -3.6000
0.1119 0.1128 7Y 1.5043 2.2628 0.00087 -2.6500
0.0000 0.0063 8Y 1.8543 3.4383 0.00627 0.0000
0.1119 0.1128 9Y 1.5043 2.2628 0.00087 2.6500
0.4032 0.4061 10Y -4.8707 23.7242 0.00292 3.6000
0.1697 0.1698 11Y -1.2957 1.6790 0.00014 3.6000
0.6064 0.6090 12Y 4.0793 16.6403 0.00257 3.6000
3.4726 3.4728 13Y -0.5957 0.3549 0.00027 7.2000
4.2915 4.3057 14Y 4.0793 16.6403 0.01418 7.2000
27.7662 27.7725 15Y 1.8543 3.4383 0.00627 10.7500
0.0480 0.0496 16Y -3.6207 13.1098 0.00151 -1.3250
0.0480 0.0496 17Y -3.6207 13.1098 0.00151 1.3250
91.1847
-
5/21/2018 hojas_de_calculo(1).xls
42/67
Piso 03 Momento polar de inercia
X^2 (Ky/Em).X^2 J MuroY
=Yi-YcrY^2 (Kx/Em).Y^2
51.8400 0.0470 3.2432 1X 5.9043 34.8602 3.19615
91.6806 0.0521 0.2497 2X 2.2543 5.0817 0.19758
18.7056 0.0147 0.3817 3X 2.2543 5.0817 0.36694
18.7056 0.0147 0.0558 4X 0.7543 0.5689 0.04108
66.8306 0.0058 0.0833 5X -2.2457 5.0434 0.07745
0.0000 0.0000 0.5860 6X -2.2457 5.0434 0.58599
40.9600 0.0093 3.4019 7X -6.3457 40.2685 3.39260
0.0006 0.0000 1.9651 8X -6.3457 40.2685 1.96505
51.8400 0.0470 3.2432 9X 5.9043 34.8602 3.19615
91.6807 0.0521 0.2497 10X 2.2543 5.0817 0.19758
18.7057 0.0147 0.3817 11X 2.2543 5.0817 0.3669418.7057 0.0147 0.0558 12X 0.7543 0.5689 0.04108
66.8307 0.0058 0.0833 13X -2.2457 5.0434 0.07745
40.9600 0.0093 3.4019 14X -6.3457 40.2685 3.39260
115.5624 27.7662 27.7725 1Y 1.8543 3.4383 0.00627
51.8400 4.2915 4.3057 2Y 4.0793 16.6403 0.01418
51.8400 3.4726 3.4728 3Y -0.5957 0.3549 0.00027
12.9600 0.6064 0.6090 4Y 4.0793 16.6403 0.00257
12.9600 0.1697 0.1698 5Y -1.2957 1.6790 0.00014
12.9600 0.4032 0.4061 6Y -4.8707 23.7242 0.00292
7.0225 0.1119 0.1128 7Y 1.5043 2.2628 0.00087
0.0000 0.0000 0.0063 8Y 1.8543 3.4383 0.00627
7.0225 0.1119 0.1128 9Y 1.5043 2.2628 0.00087
12.9600 0.4032 0.4061 10Y -4.8707 23.7242 0.00292
12.9600 0.1697 0.1698 11Y -1.2957 1.6790 0.00014
12.9600 0.6064 0.6090 12Y 4.0793 16.6403 0.00257
51.8400 3.4726 3.4728 13Y -0.5957 0.3549 0.00027
51.8400 4.2915 4.3057 14Y 4.0793 16.6403 0.01418
115.5626 27.7662 27.7725 15Y 1.8543 3.4383 0.00627
1.7556 0.0480 0.0496 16Y -3.6207 13.1098 0.00151
1.7556 0.0480 0.0496 17Y -3.6207 13.1098 0.00151
91.1847
-
5/21/2018 hojas_de_calculo(1).xls
43/67
Piso 04 Momento polar de inercia
X=Xi-Xcr
X^2 (Ky/Em).X^2 J MuroY
=Yi-YcrY^2
-7.2000 51.8400 0.0470 3.2432 1X 5.9043 34.8602
-9.5750 91.6806 0.0521 0.2497 2X 2.2543 5.0817
-4.3250 18.7056 0.0147 0.3817 3X 2.2543 5.0817
-4.3250 18.7056 0.0147 0.0558 4X 0.7543 0.5689
-8.1750 66.8306 0.0058 0.0833 5X -2.2457 5.0434
0.0000 0.0000 0.0000 0.5860 6X -2.2457 5.0434
-6.4000 40.9600 0.0093 3.4019 7X -6.3457 40.2685
-0.0250 0.0006 0.0000 1.9651 8X -6.3457 40.2685
7.2000 51.8400 0.0470 3.2432 9X 5.9043 34.8602
9.5750 91.6807 0.0521 0.2497 10X 2.2543 5.0817
4.3250 18.7057 0.0147 0.3817 11X 2.2543 5.08174.3250 18.7057 0.0147 0.0558 12X 0.7543 0.5689
8.1750 66.8307 0.0058 0.0833 13X -2.2457 5.0434
6.4000 40.9600 0.0093 3.4019 14X -6.3457 40.2685
-10.7500 115.5624 27.7662 27.7725 1Y 1.8543 3.4383
-7.2000 51.8400 4.2915 4.3057 2Y 4.0793 16.6403
-7.2000 51.8400 3.4726 3.4728 3Y -0.5957 0.3549
-3.6000 12.9600 0.6064 0.6090 4Y 4.0793 16.6403
-3.6000 12.9600 0.1697 0.1698 5Y -1.2957 1.6790
-3.6000 12.9600 0.4032 0.4061 6Y -4.8707 23.7242
-2.6500 7.0225 0.1119 0.1128 7Y 1.5043 2.2628
0.0000 0.0000 0.0000 0.0063 8Y 1.8543 3.4383
2.6500 7.0225 0.1119 0.1128 9Y 1.5043 2.2628
3.6000 12.9600 0.4032 0.4061 10Y -4.8707 23.7242
3.6000 12.9600 0.1697 0.1698 11Y -1.2957 1.6790
3.6000 12.9600 0.6064 0.6090 12Y 4.0793 16.6403
7.2000 51.8400 3.4726 3.4728 13Y -0.5957 0.3549
7.2000 51.8400 4.2915 4.3057 14Y 4.0793 16.6403
10.7500 115.5626 27.7662 27.7725 15Y 1.8543 3.4383
-1.3250 1.7556 0.0480 0.0496 16Y -3.6207 13.1098
1.3250 1.7556 0.0480 0.0496 17Y -3.6207 13.1098
91.1847
-
5/21/2018 hojas_de_calculo(1).xls
44/67
(Kx/Em).Y^2X
=Xi-XcrX^2 (Ky/Em).X^2 J
3.19615 -7.2000 51.8400 0.0470 3.2432
0.19758 -9.5750 91.6806 0.0521 0.2497
0.36694 -4.3250 18.7056 0.0147 0.3817
0.04108 -4.3250 18.7056 0.0147 0.0558
0.07745 -8.1750 66.8306 0.0058 0.0833
0.58599 0.0000 0.0000 0.0000 0.5860
3.39260 -6.4000 40.9600 0.0093 3.4019
1.96505 -0.0250 0.0006 0.0000 1.9651
3.19615 7.2000 51.8400 0.0470 3.2432
0.19758 9.5750 91.6807 0.0521 0.2497
0.36694 4.3250 18.7057 0.0147 0.38170.04108 4.3250 18.7057 0.0147 0.0558
0.07745 8.1750 66.8307 0.0058 0.0833
3.39260 6.4000 40.9600 0.0093 3.4019
0.00627 -10.7500 115.5624 27.7662 27.7725
0.01418 -7.2000 51.8400 4.2915 4.3057
0.00027 -7.2000 51.8400 3.4726 3.4728
0.00257 -3.6000 12.9600 0.6064 0.6090
0.00014 -3.6000 12.9600 0.1697 0.1698
0.00292 -3.6000 12.9600 0.4032 0.4061
0.00087 -2.6500 7.0225 0.1119 0.1128
0.00627 0.0000 0.0000 0.0000 0.0063
0.00087 2.6500 7.0225 0.1119 0.1128
0.00292 3.6000 12.9600 0.4032 0.4061
0.00014 3.6000 12.9600 0.1697 0.1698
0.00257 3.6000 12.9600 0.6064 0.6090
0.00027 7.2000 51.8400 3.4726 3.4728
0.01418 7.2000 51.8400 4.2915 4.3057
0.00627 10.7500 115.5626 27.7662 27.7725
0.00151 -1.3250 1.7556 0.0480 0.0496
0.00151 1.3250 1.7556 0.0480 0.0496
91.1847
-
5/21/2018 hojas_de_calculo(1).xls
45/67
11.6.8.4 Clculo del momento torsor y excentricidades
Piso 01 Piso 02
X Y XV_(1) 175,526.47 175,526.47 V_(1) 158,384.02
F_(1) 17,142.44 17,142.44
F_(2) 34,284.89 34,284.89 F_(2) 34,284.89
F_(3) 51,427.33 51,427.33 F_(3) 51,427.33
F_(4) 72,671.80 72,671.80 F_(4) 72,671.80
Centro masa CM 10.8744 7.1937 Centro masa CM 10.8744
Centro rigidez CR 10.8750 6.4207 Centro rigidez CR 10.8750
Dimensin D 21.75 12.45 Dimensin D 21.75
J 91.1847 91.1847 J 91.1847
Peso Nivel 216,175.05 216,175.05 Peso Nivel 216,175.05C 2.50 2.50 C 2.50
T 0.1713 0.1713 T 0.1713
Mt_1 354,207.26 381,671.46 Mt_1 319,614.31
Mt_2 -82,853.64 -381,868.68 Mt_2 -74,761.91
Excentricidad "e" -0.0006 0.7730 Excentricidad "e" -0.0006
e_accidental 2.175 1.245 e_accidental 2.175
Momento to
excentricida
VaValores
Descripcin
Momento torsor y
excentricidades
Descripcin
-
5/21/2018 hojas_de_calculo(1).xls
46/67
Piso 03 Piso 04
Y X Y158,384.02 V_(1) 124,099.13 124,099.13 V_(1)
34,284.89
51,427.33 F_(3) 51,427.33 51,427.33
72,671.80 F_(4) 72,671.80 72,671.80 F_(4)
7.1937 Centro masa CM 10.8744 7.1937 Centro masa CM
6.4207 Centro rigidez CR 10.8750 6.4207 Centro rigidez CR
12.45 Dimensin D 21.75 12.45 Dimensin D
91.1847 J 91.1847 91.1847 J
216,175.05 Peso Nivel 216,175.05 216,175.05 Peso Nivel2.50 C 2.50 2.50 C
0.1713 T 0.1713 0.1713 T
344,396.27 Mt_1 250,428.41 269,845.90 Mt_1
-344,574.23 Mt_2 -58,578.43 -269,985.34 Mt_2
0.7730 Excentricidad "e" -0.0006 0.7730 Excentricidad "e"
1.245 e_accidental 2.175 1.245 e_accidental
sor y
des
Momento torsor y
excentricidades
lores
Descripcin
Valores
Descripcin
-
5/21/2018 hojas_de_calculo(1).xls
47/67
X Y72,671.80 72,671.80
72,671.80 72,671.80
10.8744 7.1937
10.8750 6.4207
21.75 12.45
91.1847 91.1847
229,107.20 229,107.202.50 2.50
0.1713 0.1713
146,649.56 158,020.34
-34,303.22 -158,101.99
-0.0006 0.7730
2.175 1.245
Valores
Momento torsor y
excentricidades
-
5/21/2018 hojas_de_calculo(1).xls
48/67
11.6.8.5 Clculo de los incrementos de cortantes por torsinPiso 01
V1x V2x
1X 0.091685 0.000907 5.9043 -7.2000 2,102.796 -491.871
2X 0.038882 0.000568 2.2543 -9.5750 340.476 -79.642
3X 0.072209 0.000787 2.2543 -4.3250 632.312 -147.906
4X 0.072209 0.000787 0.7543 -4.3250 211.566 -49.488
5X 0.015356 0.000087 -2.2457 -8.1750 -133.959 31.335
6X 0.116190 0.000291 -2.2457 0.0000 -1,013.599 237.094
7X 0.084249 0.000228 -6.3457 -6.4000 -2,076.753 485.779
8X 0.048799 0.000159 -6.3457 -0.0250 -1,202.894 281.372
9X 0.091685 0.000907 5.9043 7.2000 2,102.796 -491.871
10X 0.038882 0.000568 2.2543 9.5750 340.476 -79.642
11X 0.072209 0.000787 2.2543 4.3250 632.312 -147.90612X 0.072209 0.000787 0.7543 4.3250 211.566 -49.488
13X 0.015356 0.000087 -2.2457 8.1750 -133.959 31.335
14X 0.084249 0.000228 -6.3457 6.4000 -2,076.753 485.779
1Y 0.001825 0.240270 1.8543 -10.7500 13.143 -3.074
2Y 0.000852 0.082783 4.0793 -7.2000 13.505 -3.159
3Y 0.000754 0.066986 -0.5957 -7.2000 -1.745 0.408
4Y 0.000155 0.046791 4.0793 -3.6000 2.450 -0.573
5Y 0.000081 0.013091 -1.2957 -3.6000 -0.409 0.096
6Y 0.000123 0.031110 -4.8707 -3.6000 -2.325 0.544
7Y 0.000382 0.015937 1.5043 -2.6500 2.235 -0.523
8Y 0.001825 0.240270 1.8543 0.0000 13.143 -3.074
9Y 0.000382 0.015937 1.5043 2.6500 2.235 -0.523
10Y 0.000123 0.031110 -4.8707 3.6000 -2.325 0.544
11Y 0.000081 0.013091 -1.2957 3.6000 -0.409 0.096
12Y 0.000155 0.046791 4.0793 3.6000 2.450 -0.573
13Y 0.000754 0.066986 -0.5957 7.2000 -1.745 0.408
14Y 0.000852 0.082783 4.0793 7.2000 13.505 -3.159
15Y 0.001825 0.240270 1.8543 10.7500 13.143 -3.074
16Y 0.000115 0.027368 -3.6207 -1.3250 -1.617 0.378
17Y 0.000115 0.027368 -3.6207 1.3250 -1.617 0.378
0.924569 1.296120
Incrementos de cortantes por torsin ()
Muro Kx / Em Ky / EmY
=Yi-YcrX
=Xi-XcrDIRECCION X
-
5/21/2018 hojas_de_calculo(1).xls
49/67
Piso 02
V1y V2y
-27.331 27.345 1X 0.091685 0.000907 5.9043 -7.2000
-22.771 22.783 2X 0.038882 0.000568 2.2543 -9.5750
-14.242 14.249 3X 0.072209 0.000787 2.2543 -4.3250
-14.242 14.249 4X 0.072209 0.000787 0.7543 -4.3250
-2.984 2.986 5X 0.015356 0.000087 -2.2457 -8.1750
0.000 0.000 6X 0.116190 0.000291 -2.2457 0.0000
-6.107 6.110 7X 0.084249 0.000228 -6.3457 -6.4000
-0.017 0.017 8X 0.048799 0.000159 -6.3457 -0.0250
27.331 -27.345 9X 0.091685 0.000907 5.9043 7.2000
22.771 -22.783 10X 0.038882 0.000568 2.2543 9.5750
14.242 -14.249 11X 0.072209 0.000787 2.2543 4.325014.242 -14.249 12X 0.072209 0.000787 0.7543 4.3250
2.984 -2.986 13X 0.015356 0.000087 -2.2457 8.1750
6.107 -6.110 14X 0.084249 0.000228 -6.3457 6.4000
-10,811.246 10,816.832 1Y 0.001825 0.240270 1.8543 -10.7500
-2,494.843 2,496.133 2Y 0.000852 0.082783 4.0793 -7.2000
-2,018.759 2,019.802 3Y 0.000754 0.066986 -0.5957 -7.2000
-705.064 705.428 4Y 0.000155 0.046791 4.0793 -3.6000
-197.258 197.360 5Y 0.000081 0.013091 -1.2957 -3.6000
-468.782 469.024 6Y 0.000123 0.031110 -4.8707 -3.6000
-176.773 176.865 7Y 0.000382 0.015937 1.5043 -2.6500
0.003 -0.003 8Y 0.001825 0.240270 1.8543 0.0000
176.774 -176.865 9Y 0.000382 0.015937 1.5043 2.6500
468.783 -469.025 10Y 0.000123 0.031110 -4.8707 3.6000
197.258 -197.360 11Y 0.000081 0.013091 -1.2957 3.6000
705.065 -705.430 12Y 0.000155 0.046791 4.0793 3.6000
2,018.760 -2,019.804 13Y 0.000754 0.066986 -0.5957 7.2000
2,494.846 -2,496.135 14Y 0.000852 0.082783 4.0793 7.2000
10,811.252 -10,816.838 15Y 0.001825 0.240270 1.8543 10.7500
-151.786 151.864 16Y 0.000115 0.027368 -3.6207 -1.3250
151.787 -151.865 17Y 0.000115 0.027368 -3.6207 1.3250
0.924569 1.296120
Incrementos de cortantes por torsin ()
Muro Kx / Em Ky / EmY
=Yi-YcrX
=Xi-XcrDIRECCION Y
-
5/21/2018 hojas_de_calculo(1).xls
50/67
Piso 03
V1x V2x V1y V2y
1,897.430 -443.833 -24.662 24.675 1X 0.091685 0.000907
307.224 -71.864 -20.547 20.558 2X 0.038882 0.000568
570.558 -133.461 -12.851 12.858 3X 0.072209 0.000787
190.904 -44.655 -12.851 12.858 4X 0.072209 0.000787
-120.876 28.274 -2.693 2.694 5X 0.015356 0.000087
-914.608 213.939 0.000 0.000 6X 0.116190 0.000291
-1,873.931 438.337 -5.510 5.513 7X 0.084249 0.000228
-1,085.415 253.893 -0.015 0.015 8X 0.048799 0.000159
1,897.430 -443.833 24.662 -24.675 9X 0.091685 0.000907
307.224 -71.864 20.547 -20.558 10X 0.038882 0.000568
570.558 -133.461 12.851 -12.858 11X 0.072209 0.000787190.904 -44.655 12.851 -12.858 12X 0.072209 0.000787
-120.876 28.274 2.693 -2.694 13X 0.015356 0.000087
-1,873.931 438.337 5.510 -5.513 14X 0.084249 0.000228
11.860 -2.774 -9,755.387 9,760.428 1Y 0.001825 0.240270
12.186 -2.850 -2,251.189 2,252.353 2Y 0.000852 0.082783
-1.574 0.368 -1,821.601 1,822.542 3Y 0.000754 0.066986
2.211 -0.517 -636.205 636.534 4Y 0.000155 0.046791
-0.369 0.086 -177.993 178.085 5Y 0.000081 0.013091
-2.098 0.491 -422.999 423.218 6Y 0.000123 0.031110
2.016 -0.472 -159.509 159.592 7Y 0.000382 0.015937
11.860 -2.774 0.003 -0.003 8Y 0.001825 0.240270
2.016 -0.472 159.510 -159.592 9Y 0.000382 0.015937
-2.098 0.491 423.000 -423.218 10Y 0.000123 0.031110
-0.369 0.086 177.993 -178.085 11Y 0.000081 0.013091
2.211 -0.517 636.207 -636.535 12Y 0.000155 0.046791
-1.574 0.368 1,821.602 -1,822.544 13Y 0.000754 0.066986
12.186 -2.850 2,251.191 -2,252.355 14Y 0.000852 0.082783
11.860 -2.774 9,755.392 -9,760.433 15Y 0.001825 0.240270
-1.459 0.341 -136.962 137.033 16Y 0.000115 0.027368
-1.459 0.341 136.963 -137.033 17Y 0.000115 0.027368
0.924569 1.296120
DIRECCION YIncrementos de cortante
Muro Kx / Em Ky / EmDIRECCION X
-
5/21/2018 hojas_de_calculo(1).xls
51/67
Piso 04
V1x V2x V1y V2y
5.9043 -7.2000 1,486.700 -347.758 -19.323 19.333 1X
2.2543 -9.5750 240.720 -56.308 -16.100 16.108 2X
2.2543 -4.3250 447.051 -104.571 -10.069 10.074 3X
0.7543 -4.3250 149.580 -34.989 -10.069 10.074 4X
-2.2457 -8.1750 -94.710 22.154 -2.110 2.111 5X
-2.2457 0.0000 -716.626 167.628 0.000 0.000 6X
-6.3457 -6.4000 -1,468.287 343.451 -4.317 4.320 7X
-6.3457 -0.0250 -850.459 198.933 -0.012 0.012 8X
5.9043 7.2000 1,486.700 -347.758 19.323 -19.333 9X
2.2543 9.5750 240.720 -56.308 16.100 -16.108 10X
2.2543 4.3250 447.051 -104.571 10.069 -10.074 11X0.7543 4.3250 149.580 -34.989 10.069 -10.074 12X
-2.2457 8.1750 -94.710 22.154 2.110 -2.111 13X
-6.3457 6.4000 -1,468.287 343.451 4.317 -4.320 14X
1.8543 -10.7500 9.292 -2.174 -7,643.669 7,647.619 1Y
4.0793 -7.2000 9.548 -2.233 -1,763.882 1,764.793 2Y
-0.5957 -7.2000 -1.234 0.289 -1,427.285 1,428.022 3Y
4.0793 -3.6000 1.732 -0.405 -498.488 498.746 4Y
-1.2957 -3.6000 -0.289 0.068 -139.463 139.536 5Y
-4.8707 -3.6000 -1.644 0.385 -331.434 331.605 6Y
1.5043 -2.6500 1.580 -0.370 -124.981 125.045 7Y
1.8543 0.0000 9.292 -2.174 0.002 -0.002 8Y
1.5043 2.6500 1.580 -0.370 124.981 -125.046 9Y
-4.8707 3.6000 -1.644 0.385 331.434 -331.606 10Y
-1.2957 3.6000 -0.289 0.068 139.464 -139.536 11Y
4.0793 3.6000 1.732 -0.405 498.489 -498.747 12Y
-0.5957 7.2000 -1.234 0.289 1,427.286 -1,428.023 13Y
4.0793 7.2000 9.548 -2.233 1,763.883 -1,764.795 14Y
1.8543 10.7500 9.292 -2.174 7,643.673 -7,647.623 15Y
-3.6207 -1.3250 -1.143 0.267 -107.314 107.370 16Y
-3.6207 1.3250 -1.143 0.267 107.315 -107.370 17Y
s por torsin ()
Y=Yi-Ycr
X=Xi-Xcr
DIRECCION X DIRECCION YMuro
-
5/21/2018 hojas_de_calculo(1).xls
52/67
V1x V2x V1y V2y
0.091685 0 .000907 5.9043 -7.2000 870.603 -203.645 -11.316 11.322
0.038882 0.000568 2.2543 -9.5750 140.964 -32.973 -9.428 9.433
0.072209 0.000787 2.2543 -4.3250 261.791 -61.236 -5.896 5.899
0.072209 0.000787 0.7543 -4.3250 87.593 -20.489 -5.896 5.899
0.015356 0.000087 -2.2457 -8.1750 -55.462 12.973 -1.236 1.236
0.116190 0.000291 -2.2457 0.0000 -419.652 98.162 0.000 0.000
0.084249 0.000228 -6.3457 -6.4000 -859.821 201.123 -2.528 2.530
0.048799 0.000159 -6.3457 -0.0250 -498.024 116.494 -0.007 0.007
0.091685 0.000907 5.9043 7.2000 870.603 -203.645 11.316 -11.322
0.038882 0.000568 2.2543 9.5750 140.964 -32.973 9.428 -9.433
0.072209 0.000787 2.2543 4.3250 261.791 -61.236 5.896 -5.8990.072209 0.000787 0.7543 4.3250 87.593 -20.489 5.896 -5.899
0.015356 0.000087 -2.2457 8.1750 -55.462 12.973 1.236 -1.236
0.084249 0.000228 -6.3457 6.4000 -859.821 201.123 2.528 -2.530
0.001825 0.240270 1.8543 -10.7500 5.442 -1.273 -4,476.092 4,478.405
0.000852 0.082783 4.0793 -7.2000 5.591 -1.308 -1,032.920 1,033.454
0.000754 0.066986 -0.5957 -7.2000 -0.722 0.169 -835.810 836.242
0.000155 0.046791 4.0793 -3.6000 1.014 -0.237 -291.912 292.063
0.000081 0.013091 -1.2957 -3.6000 -0.169 0.040 -81.669 81.711
0.000123 0.031110 -4.8707 -3.6000 -0.963 0.225 -194.086 194.186
0.000382 0.015937 1.5043 -2.6500 0.925 -0.216 -73.188 73.226
0.001825 0.240270 1.8543 0.0000 5.442 -1.273 0.001 -0.001
0.000382 0.015937 1.5043 2.6500 0.925 -0.216 73.188 -73.226
0.000123 0.031110 -4.8707 3.6000 -0.963 0.225 194.086 -194.187
0.000081 0.013091 -1.2957 3.6000 -0.169 0.040 81.669 -81.711
0.000155 0.046791 4.0793 3.6000 1.014 -0.237 291.912 -292.063
0.000754 0.066986 -0.5957 7.2000 -0.722 0.169 835.811 -836.243
0.000852 0 .082783 4.0793 7.2000 5.591 -1.308 1,032.921 -1,033.454
0.001825 0.240270 1.8543 10.7500 5.442 -1.273 4,476.095 -4,478.408
0.000115 0.027368 -3.6207 -1.3250 -0.669 0.157 -62.843 62.875
0.000115 0.027368 -3.6207 1.3250 -0.669 0.157 62.843 -62.875
0.924569 1.296120
Incrementos de cortantes por torsin ()
Kx / Em Ky / EmY
=Yi-YcrX
=Xi-XcrDIRECCION X DIRECCION Y
-
5/21/2018 hojas_de_calculo(1).xls
53/67
11.6.8.6 Clculo de cortantes de diseo en la direccin "X"Piso 01
Vx1 = 175,526.47 kg.
Muro V_tras V1x V2x
Vx
(asumido)
Vx
(diseo)1X 17,406.04 2,102.80 -491.87 2,102.80 19,508.84
2X 7,381.62 340.48 -79.64 340.48 7,722.09
3X 13,708.71 632.31 -147.91 632.31 14,341.02
4X 13,708.71 211.57 -49.49 211.57 13,920.27
5X 2,915.26 -133.96 31.33 31.33 2,946.60
6X 22,058.37 -1,013.60 237.09 237.09 22,295.46
7X 15,994.48 -2,076.75 485.78 485.78 16,480.25
8X 9,264.30 -1,202.89 281.37 281.37 9,545.67
9X 17,406.04 2,102.80 -491.87 2,102.80 19,508.84
10X 7,381.62 340.48 -79.64 340.48 7,722.0911X 13,708.71 632.31 -147.91 632.31 14,341.02
12X 13,708.71 211.57 -49.49 211.57 13,920.27
13X 2,915.26 -133.96 31.33 31.33 2,946.60
14X 15,994.48 -2,076.75 485.78 485.78 16,480.25
1Y 346.42 13.14 -3.07 13.14 359.56
2Y 161.80 13.50 -3.16 13.50 175.30
3Y 143.13 -1.74 0.41 0.41 143.54
4Y 29.35 2.45 -0.57 2.45 31.80
5Y 15.43 -0.41 0.10 0.10 15.52
6Y 23.33 -2.33 0.54 0.54 23.88
7Y 72.60 2.23 -0.52 2.23 74.84
8Y 346.42 13.14 -3.07 13.14 359.56
9Y 72.60 2.23 -0.52 2.23 74.84
10Y 23.33 -2.33 0.54 0.54 23.88
11Y 15.43 -0.41 0.10 0.10 15.52
12Y 29.35 2.45 -0.57 2.45 31.80
13Y 143.13 -1.74 0.41 0.41 143.54
14Y 161.80 13.50 -3.16 13.50 175.30
15Y 346.42 13.14 -3.07 13.14 359.56
16Y 21.83 -1.62 0.38 0.38 22.20
17Y 21.83 -1.62 0.38 0.38 22.20
11.6.8.7 Clculo de cortantes de diseo en la direccin "Y"Piso 01
Vy1 = 175,526.47 kg.
Cortantes de diseo en la direccin "Y"
Cortantes de diseo en la direccin "X"
-
5/21/2018 hojas_de_calculo(1).xls
54/67
Muro V_tras V1y V2y Vy
(asumido)Vy
(diseo)1X 122.82 -27.33 27.35 27.35 150.16
2X 76.94 -22.77 22.78 22.78 99.73
3X 106.54 -14.24 14.25 14.25 120.79
4X 106.54 -14.24 14.25 14.25 120.795X 11.81 -2.98 2.99 2.99 14.80
6X 39.46 0.00 0.00 0.00 39.46
7X 30.87 -6.11 6.11 6.11 36.98
8X 21.48 -0.02 0.02 0.02 21.49
9X 122.82 27.33 -27.35 27.33 150.15
10X 76.94 22.77 -22.78 22.77 99.72
11X 106.54 14.24 -14.25 14.24 120.78
12X 106.54 14.24 -14.25 14.24 120.78
13X 11.81 2.98 -2.99 2.98 14.80
14X 30.87 6.11 -6.11 6.11 36.981Y 32,538.47 -10,811.25 10,816.83 10,816.83 43,355.30
2Y 11,210.91 -2,494.84 2,496.13 2,496.13 13,707.04
3Y 9,071.56 -2,018.76 2,019.80 2,019.80 11,091.36
4Y 6,336.60 -705.06 705.43 705.43 7,042.03
5Y 1,772.81 -197.26 197.36 197.36 1,970.17
6Y 4,213.07 -468.78 469.02 469.02 4,682.09
7Y 2,158.25 -176.77 176.86 176.86 2,335.11
8Y 32,538.47 0.00 0.00 0.00 32,538.48
9Y 2,158.25 176.77 -176.87 176.77 2,335.02
10Y 4,213.07 468.78 -469.02 468.78 4,681.85
11Y 1,772.81 197.26 -197.36 197.26 1,970.0712Y 6,336.60 705.07 -705.43 705.07 7,041.66
13Y 9,071.56 2,018.76 -2,019.80 2,018.76 11,090.32
14Y 11,210.91 2,494.85 -2,496.13 2,494.85 13,705.75
15Y 32,538.47 10,811.25 -10,816.84 10,811.25 43,349.72
16Y 3,706.35 -151.79 151.86 151.86 3,858.21
17Y 3,706.35 151.79 -151.86 151.79 3,858.13
-
5/21/2018 hojas_de_calculo(1).xls
55/67
Piso 02
Vx2 = 158,384.02 kg.
% de
Absorcin Muro V_tras V1x V2x
Vx
(asumido)
Vx
(diseo)11.11% 1X 15,706.11 1,897.43 -443.83 1,897.43 17,603.54
4.40% 2X 6,660.71 307.22 -71.86 307.22 6,967.93
8.17% 3X 12,369.87 570.56 -133.46 570.56 12,940.43
7.93% 4X 12,369.87 190.90 -44.65 190.90 12,560.78
1.68% 5X 2,630.55 -120.88 28.27 28.27 2,658.82
12.70% 6X 19,904.08 -914.61 213.94 213.94 20,118.02
9.39% 7X 14,432.41 -1,873.93 438.34 438.34 14,870.74
5.44% 8X 8,359.52 -1,085.42 253.89 253.89 8,613.41
11.11% 9X 15,706.11 1,897.43 -443.83 1,897.43 17,603.54
4.40% 10X 6,660.71 307.22 -71.86 307.22 6,967.938.17% 11X 12,369.87 570.56 -133.46 570.56 12,940.43
7.93% 12X 12,369.87 190.90 -44.65 190.90 12,560.78
1.68% 13X 2,630.55 -120.88 28.27 28.27 2,658.82
9.39% 14X 14,432.41 -1,873.93 438.34 438.34 14,870.74
0.20% 1Y 312.58 11.86 -2.77 11.86 324.44
0.10% 2Y 146.00 12.19 -2.85 12.19 158.18
0.08% 3Y 129.15 -1.57 0.37 0.37 129.52
0.02% 4Y 26.49 2.21 -0.52 2.21 28.70
0.01% 5Y 13.92 -0.37 0.09 0.09 14.01
0.01% 6Y 21.05 -2.10 0.49 0.49 21.54
0.04% 7Y 65.51 2.02 -0.47 2.02 67.53
0.20% 8Y 312.58 11.86 -2.77 11.86 324.44
0.04% 9Y 65.51 2.02 -0.47 2.02 67.53
0.01% 10Y 21.05 -2.10 0.49 0.49 21.54
0.01% 11Y 13.92 -0.37 0.09 0.09 14.01
0.02% 12Y 26.49 2.21 -0.52 2.21 28.70
0.08% 13Y 129.15 -1.57 0.37 0.37 129.52
0.10% 14Y 146.00 12.19 -2.85 12.19 158.18
0.20% 15Y 312.58 11.86 -2.77 11.86 324.44
0.01% 16Y 19.69 -1.46 0.34 0.34 20.04
0.01% 17Y 19.69 -1.46 0.34 0.34 20.04
104.67%
Piso 02
Vy2 = 158,384.02 kg.
Cortantes de diseo en la direccin "X"
Cortantes de diseo en la direccin "Y"
-
5/21/2018 hojas_de_calculo(1).xls
56/67
% deAbsorcin
Muro V_tras V1y V2y Vy
(asumido)Vy
(diseo)0.09% 1X 110.82 -24.66 24.67 24.67 135.50
0.06% 2X 69.43 -20.55 20.56 20.56 89.99
0.07% 3X 96.13 -12.85 12.86 12.86 108.99
0.07% 4X 96.13 -12.85 12.86 12.86 108.990.01% 5X 10.66 -2.69 2.69 2.69 13.35
0.02% 6X 35.61 0.00 0.00 0.00 35.61
0.02% 7X 27.86 -5.51 5.51 5.51 33.37
0.01% 8X 19.38 -0.01 0.01 0.01 19.39
0.09% 9X 110.82 24.66 -24.67 24.66 135.48
0.06% 10X 69.43 20.55 -20.56 20.55 89.98
0.07% 11X 96.13 12.85 -12.86 12.85 108.98
0.07% 12X 96.13 12.85 -12.86 12.85 108.98
0.01% 13X 10.66 2.69 -2.69 2.69 13.35
0.02% 14X 27.86 5.51 -5.51 5.51 33.3724.70% 1Y 29,360.67 -9,755.39 9,760.43 9,760.43 39,121.09
7.81% 2Y 10,116.02 -2,251.19 2,252.35 2,252.35 12,368.37
6.32% 3Y 8,185.60 -1,821.60 1,822.54 1,822.54 10,008.14
4.01% 4Y 5,717.75 -636.21 636.53 636.53 6,354.28
1.12% 5Y 1,599.67 -177.99 178.09 178.09 1,777.76
2.67% 6Y 3,801.61 -423.00 423.22 423.22 4,224.82
1.33% 7Y 1,947.47 -159.51 159.59 159.59 2,107.06
18.54% 8Y 29,360.67 0.00 0.00 0.00 29,360.67
1.33% 9Y 1,947.47 159.51 -159.59 159.51 2,106.98
2.67% 10Y 3,801.61 423.00 -423.22 423.00 4,224.61
1.12% 11Y 1,599.67 177.99 -178.09 177.99 1,777.664.01% 12Y 5,717.75 636.21 -636.54 636.21 6,353.95
6.32% 13Y 8,185.60 1,821.60 -1,822.54 1,821.60 10,007.20
7.81% 14Y 10,116.02 2,251.19 -2,252.35 2,251.19 12,367.21
24.70% 15Y 29,360.67 9,755.39 -9,760.43 9,755.39 39,116.06
2.20% 16Y 3,344.37 -136.96 137.03 137.03 3,481.41
2.20% 17Y 3,344.37 136.96 -137.03 136.96 3,481.34
119.50%
-
5/21/2018 hojas_de_calculo(1).xls
57/67
Piso 03
Vx3 = 124,099.13 kg.
% de
Absorcin Muro V_tras V1x V2x
Vx
(asumido)
Vx
(diseo)11.11% 1X 12,306.26 1,486.70 -347.76 1,486.70 13,792.96
4.40% 2X 5,218.88 240.72 -56.31 240.72 5,459.60
8.17% 3X 9,692.20 447.05 -104.57 447.05 10,139.26
7.93% 4X 9,692.20 149.58 -34.99 149.58 9,841.78
1.68% 5X 2,061.12 -94.71 22.15 22.15 2,083.28
12.70% 6X 15,595.51 -716.63 167.63 167.63 15,763.14
9.39% 7X 11,308.27 -1,468.29 343.45 343.45 11,651.72
5.44% 8X 6,549.96 -850.46 198.93 198.93 6,748.89
11.11% 9X 12,306.26 1,486.70 -347.76 1,486.70 13,792.96
4.40% 10X 5,218.88 240.72 -56.31 240.72 5,459.608.17% 11X 9,692.20 447.05 -104.57 447.05 10,139.26
7.93% 12X 9,692.20 149.58 -34.99 149.58 9,841.78
1.68% 13X 2,061.12 -94.71 22.15 22.15 2,083.28
9.39% 14X 11,308.27 -1,468.29 343.45 343.45 11,651.72
0.20% 1Y 244.92 9.29 -2.17 9.29 254.21
0.10% 2Y 114.39 9.55 -2.23 9.55 123.94
0.08% 3Y 101.19 -1.23 0.29 0.29 101.48
0.02% 4Y 20.75 1.73 -0.41 1.73 22.48
0.01% 5Y 10.91 -0.29 0.07 0.07 10.98
0.01% 6Y 16.50 -1.64 0.38 0.38 16.88
0.04% 7Y 51.33 1.58 -0.37 1.58 52.91
0.20% 8Y 244.92 9.29 -2.17 9.29 254.21
0.04% 9Y 51.33 1.58 -0.37 1.58 52.91
0.01% 10Y 16.50 -1.64 0.38 0.38 16.88
0.01% 11Y 10.91 -0.29 0.07 0.07 10.98
0.02% 12Y 20.75 1.73 -0.41 1.73 22.48
0.08% 13Y 101.19 -1.23 0.29 0.29 101.48
0.10% 14Y 114.39 9.55 -2.23 9.55 123.94
0.20% 15Y 244.92 9.29 -2.17 9.29 254.21
0.01% 16Y 15.43 -1.14 0.27 0.27 15.70
0.01% 17Y 15.43 -1.14 0.27 0.27 15.70
104.67%
Piso 03
Vy3 = 124,099.13 kg.
Cortantes de diseo en la direccin "X"
Cortantes de diseo en la direccin "Y"
-
5/21/2018 hojas_de_calculo(1).xls
58/67
% deAbsorcin
Muro V_tras V1y V2y Vy
(asumido)V