excell de trabajo de ccalla.xlsx

8/17/2019 EXCELL DE TRABAJO DE CCALLA.xlsx

1/23

CALCULO DE LA FUERZA SISMICA

LABORATORIO

AULAS: S/C 0.3

AZOTEA S/C 0.15

ACABADOS PISO TERMINADO 0.1

DIMENSIONES DE LOS ELEMENTOS

ELEMENTO b (m) h (m)

COLUMNAS

C-1 0.3 0.3

I!AS

-1 0."5 0.5

-" 0." 0.#LOSA ALI!ERADA 0."5

AREA CONSTRUIDA 1$5

METRADO DE 1% NIEL

CM:

ELEMENTO CAR!A (T&')

COLUMNAS:10.55

C-1I!AS : 13."0

-1 "1.$

-" .$$

LOSA ALI!ERADA #.50 $$

PISO TERMINADO 1$.50

TABI*UERIA 1#.$"

TOTAL CM 113.03

TOTAL C #.50

P 13+.+

CAR!A TRIBUTARIA 0.#

FUERZA CORTANTE EN LA BASE


2/23

Z 0.#

U 1.5

C ".5

S 1."

P "#3."1

R

ZONIFICACION (Z) 3 Z

SUELO (S) INTERMEDIO S

,

PERIODO DEL EDIFICIO

hm $.5 T

C, 35

USO (U) EDIFICACION ESENCIAL

FACTOR DE AMPLIFICACION SISIMICA

C .0 ".5

SISTEMA ESTRUCTURAL (R) R

/


3/23

2 "10

PESO ESPECIFICO ".#

PESO PROPIO ALI!ERADO 0.3MURO DE SO!A CON TARRAEO 0."5

NUMERO DE ELEMENTOS

RECTOS INCLINADOS

1" 3.15

# 10

" 1 15

METRADO DE "% NIEL

CM:

CAR!A (T&')

COLUMNAS5.1

C-1I!AS

-1 13."

-" .$$#$

LOSA ALI!ERADA #.5

PISO TERMINADO 1$.5

TABI*UERIA 0

TOTAL CM 3.05

TOTAL C "#.+5

P" 105.#3

CAR!A TRIBUTARIA 0.$#


4/23

5#.+"

0.#

P

1."

0.$

0.1 0.31"5

1.5

_ ( 4 _ 〗 )


5/23

1.

LON!ITUDES (m)

3.05

10.$+ 11.33 1"

15.13


6/23

NIEL P9 h9

"% 105.#3 $.50

1% 13+.+ 3."5

TOTAL

"#3."1

4 )/(67 〖8 _


7/23


8/23

P9h9 F9

$5." 33.10

##+.+ "1.$3

1133.0+


9/23

PRIMERA PLANTA

DIMENSIONES

ancho altura

VIGASVigas Principales 0.25 0.50

Vigas Secundarias 0."0 0.#0

LOSA ALIGERADA 0."0

A!I"#ERIA ODOS 0.$5 $.%0

&OL#'AS ODOS 0.30 0.30

VIGAS

ELE'E(O LO(GI#D PESO )n* +i ),*

V2 A-A $5.00 2. 0.$0

V2 !-! $5.00 2. /.00

V2 &-& $5.$ 2.%$ $$.$0

V$ $-$ $0.00 .00 5.00

V$ 2-2 $0.1/ .20 5.

V$ - $$. .0 5.1/

V$ - $2.00 .10 1.00

3 2$./

+ 5./5

4 /.2

&OL#'(AS

ELE'E(O LO(GI#D PESO )n* +i ),*

A-$ .$5 0.1 0.$0

A-2 .$5 0.1 0.$0

A- .$5 0.1 0.$0

A- .$5 0.1 0.$0

!-$ .$5 0.1 5.$0

!-2 .$5 0.1 5.$0

!- .$5 0.1 5.$0

!- .$5 0.1 5.$0

&-$ .$5 0.1 $0.0

&-2 .$5 0.1 $0.//

&- .$5 0.1 $$.

&- .$5 0.1 $2.$0

3 .$1

+ 5.

4 /.1


10/23

LOSA

ELE'E(O AREA OAL PESO )n* +i ),*

LOSA 165.00 66.00 5.16

'#ROS

ELE'E(O LO(GI#D PESO )n* +i ),*' A-A $5.00 .$2 0.$0

' - $2.00 1.50 1.$0

∑ 14.62

X 2.77

Y 10.89

PRIMERA PLANTA

ELE'E(O PESO )n* +i ),* 4i ),*

VIGAS 2$./ 5./5 /.2

&OL#'(AS .$1 5. /.1

LOSA 11.00 5.$1 /./

'#ROS $.12 2.// $0.%

∑ 110.65

1°NIVEL

+ .%

; .1$


11/23


12/23

4i ),*

7.73

4i ),* 6+i 64i

/.50 0.1 $0."

$5.$ 3.$# ."

#0.#5 15."0

6+i 64i

1"5.$3 1+1.00

##.35 $"."$

3#0."# 510.00

#0.#5 15."0

550.1/ 0".#$


13/23

SEGUNDA PLANTA

DIMENSIONES

ancho altura seccion

VIGASVigas Principales 0.25 0.5 0.$25

Vigas Secundarias 0." 0.# 0.0

LOSA ALIGERADA 0."

A!I"#ERIA ODOS 0.$5 $.% 0.25

&OL#'AS ODOS 0.3 0.3 0.0%

VIGAS

ELE'E(O LO(GI#D PESO )n* +i ),* 4i ),*

V2 A-A $5.00 2. 0.$0 /.50

V2 !-! $5.00 2. /.00 /.50

V2 &-& $5.$ 2.%$ $$.$0 /.1

V$ $-$ $0.00 .00 5.00 0.$

V$ 2-2 $0.1/ .20 5. 5.$

V$ - $$. .0 5.1/ $0.$

V$ - $2.00 .10 1.00 $5.$

3 2$./

+ 5./5

4 /.2

&OL#'(AS

ELE'E(O LO(GI#D PESO )n* +i ),* 4i ),*

A-$ .05 0.11 0.$0 0.$

A-2 .05 0.11 0.$0 5.$

A- .05 0.11 0.$0 $0.$

A- .05 0.11 0.$0 $5.$

!-$ .05 0.11 5.$0 0.$

!-2 .05 0.11 5.$0 5.$

!- .05 0.11 5.$0 $0.$

!- .05 0.11 5.$0 $5.$

&-$ .05 0.11 $0.0 0.$

&-2 .05 0.11 $0.// 5.$

&- .05 0.11 $$. $0.$

&- .05 0.11 $2.$0 $5.$

3 /.%$

+ 5.

4 /.1


14/23

LOSA

ELE'E(O AREA OAL PESO )n* +i ),* 4i ),*

LOSA 165 66 5.1551515 7.7272727

'#ROS

ELE'E(O LO(GI#D PESO )n* +i ),* 4i ),*' A-A 0 0 0.$ /.5

' - 0 0 1.$ $5.$25

∑ 0

X 0.000

Y 0.000

SEGUNDA PLANTA

ELE'E(O PESO )n* +i ),* 4i ),* 6+i

VIGAS 2$./ 5./5 /.2 1"5.$3

&OL#'(AS /.%$ 5. /.1 #".#

LOSA 11.00 5.$1 /./ 3#0."#

'#ROS 0.00 0.00 0.00 0.00

∑ 95.77 50.$

2° NIVEL

+ 5.$

; +.+#


15/23


16/23

6+i 64i

0 0

0 0

0 0

64i

1+1.00

$0."

510.00

0.00

+#1."


17/23


18/23

(22GH&)-.1$ 0.00 1.00 -#.

-.1$ 0.00 1.00 0.0"

-.1$ 0.1# 0. $.11

-.1$ 1.00 0.00 .1$

-3.1$ 1.00 0.00 3.1$

1.# 1.00 0.00 -1.#

$.# 1.00 0.00 -$.#

(22GH&)

-+.+# 0.00 1.00 -5.31

-+.+# 0.00 1.00 -0.31

-+.+# 0.1# 0. 5.+"

-+.+# 1.00 0.00 +.+#

-".+# 1.00 0.00 ".+#

"."$ 1.00 0.00 -"."$

+."$ 1.00 0.00 -+."$

9-

0 C&= @ S


19/23

SISMO X-X ANCO 15

< 5J

ESTADO 1

NIELES P (T&') M (T&'.m)

"% 33.10 01% "1.$3 0

ESTADO 2

NIELES P (T&') M (T&'.m) +

"% 33.10 "#."

1% "1.$3 1$.""

ESTADO 3

NIELES P (T&') M (T&'.m) -

"% 33.10 "#."

1% "1.$3 1$.""


20/23

SISMO Y-Y ANCO 1"

< 5J

ESTADO 4

NIELES P (T&') M (T&'.m)

"% 33.10 01% "1.$3 0

ESTADO 5

NIELES P (T&') M (T&'.m) +

"% 33.10 1.$

1% "1.$3 1".

ESTADO 6

NIELES P (T&') M (T&'.m) -

"% 33.10 1.$

1% "1.$3 1".


21/23

CM C

E?TREMO (T&CENTRO (T&' E?TREMO(T& E?TREMO (T&CENTRO (T&'

1.$# ".0" 5.3$ 0.$3 0."

+.#$ 5.0$ 3.3 3.03 ".0+0.# 1.## #.0# 0.3" 0.#"

5." 3. ".1# 1.53 1.1

U1

E?TREMO (T&CENTRO (T&' E?TREMO(T&'.m)

3.3$+ #.""" 11."+

15.55 10.$03 .13+

1.$ ".+3 +.5$

10.00+ +.33 #.1$


22/23

CS1 CS"

E?TREMO(T& E?TREMO (T&CENTRO (T&' E?TREMO(T& E?TREMO (T&CENTRO (T&'

"."" -11.5 0 .+$ 11.51 0

1.55 -+." 0 .$ +."1 01.1" -5.15 0 3.# 5.15 0

0.$ -3."$ 0 #.5 3."$ 0

U"

CK H< =9=m& ? C

E?TREMO (T&CENTRO (T&' E?TREMO(T&'.m) E

-.$$ 3.55 1."#

5.1 .1 1$.+1

-3.5 ".33 10."

5."+ $."5 .0#CK H< =9=m& -? C

1#.35 3.55 0.+"

"0.3" .1 -3.01

$.+3 ".33 ".$1

11.+ $."5 -0.$


23/23

E?TREMO(T&'.m)

-.+$

-.$-3.#

-#.5

U3

K H< =9=m& ?

TREMO (T&'. ENTRO (T&'. TREMO(T&'.m)

-10.0" 1." 13.5

-0.# #.55 13.#0

-#.30 1.30 +.#

1.50 3.51 $.#3K H< =9=m& -?

1". 1." -3.#

13." #.55 -$.3"

$.00 1.30 -0."0

.0" 3.51 -".5+

excell de trabajo de ccalla.xlsx

Documents