hojas_de_calculo(1).xls

download hojas_de_calculo(1).xls

of 67

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