Analisis de Cargas Excel

ANALISIS ESTRUCTURAL: EDIFICIO LOS PROFESIONALES MUROS DE MAMPOSTERIA

MATERIAL LADRILLO FAROL REVOQUE W. MUROS W. MUROS /m2 ALTURA M. (m) LON!. M.(m) AREA M. (m2) AREA TOTAL M.(m2) W. TOTAL M. (KN) AREA PLA%A (m2) ESFUER&O M. (KN/m2)

P. ESPE. (KN/m3) 13 21

DIMENSIONES (m) 0.10 * 0.20 * 0.30 0.025 * 1 * 1

2.35

2. 1"2.#2 501.0#2

1 22.$ 22.$

523.752

1230.$1# 3"."# 3.10

PLACA ENTREPISO

ESPESOR PLA%A MA%I&A (m)  DI  DIMENSIONES VI!UETA (m) DISTAN%IA EES VI!UETAS (m) MORTERO A%A. INF. %ASETON (m) A%AADO INFERIOR (m) MATERIAL %ON%RETO REFOR&ADO MORTERO

0.05 0'1*0'35 0. 0.02 0.02 P. ESPE. (KN/m3) 2 21

CARGAS PLACA ENTREPISO:

PLA%A MA%I&A A. SUPERIOR VI!UETAS %ASETON A.INF. %ASETON A. INFERIOR TOTAL TOTAL CARGA MUERTA (KN/m2)

ESFUER&O (KN/m2) 1.2 1.5 1.0 0. 0.35 0.2 3.## 6.12

CARGAS COLUMNAS:

 DI  DIMENSIONES %OLUMNAS (m) W %OL. (KN) + %OLUMNAS + %OLUMNAS * W %OL. (KN) TOTAL (KN)

0'*0'5 21.6

23 !6." !6."

CARGAS MURO:

ACENSOR

PANTALLA

LON!. MUROS (m) ESPESOR # (m)

#.2 0.15

.13 0.15

VOL. X m2 (m3) 0.1 0.025

W. MUROS (KN)

565.0!!2

5.600"

ESCALERA:

ESPESOR PLA%A # (m) DIMENSIONES PELDA,O (m) AN!ULO (-)

0.2 0'1$*0'25 35.#5 ESFUER&O (KN/m2) .$ 1.5 2.1 0.2

PLA%A MA%I&A A. SUPERIOR PELDA,O A. INFERIOR TOTAL

10.0!

CARGA CU$IERTA:

%ER%AS %AR!A MUERTA4  TEA LAMINA !ALVANI&ADA %ORREAS PERLIN A%%ESORIOS %IELO FALSO PESO PROPIO %ER%A

%AR!A VIVA %U. IN%LINADA (KN/m2) W %UIERTA KN/m2

0.05 0.05 0.05 0.25 0.1 0.5 0.35 0.5

E%ES A $ C D

LONG AF (m)

C. MUERTA (KN/m)

& (KN/m)

0 0 0 0

0.000 0.000 0.000 0.000

2.$$0 2.$$0 2.$$0 2.$$0



1.$ 3.0#5

0."00 1.53$

.# 5.3$

6

.3 3.15 .3 1.55 .1$

2.215 1.#0$ 2.215 0.##5 2.0"0

.0 5.55 .0 .2 5."3

7

5.33 .$ 5.33

2.5 2.30 2.5

.51 .1$ .51

"

2.# 3."5 2.# 3."5 2.#

1.350 1."#5 1.350 1."#5 1.350

5.1" 5.$2 5.1" 5.$2 5.1"

TOTAL CARGAS 'IGAS:

(KN/m2)

'.CARGA

 DIMENSIONES VI!A (m) W(KN/m)

0'*0' 3."

'.AMARRE

 DIMENSIONES VI!A (m) W(KN/m)

0'3*0' 2.""

CARGA MUERTA 'IGAS E%ES A $ C #*+#,* #*+#,* D

LONG AFER (m)

C. MUERTA (KN/m)

& (KN/m)

0 0 0 1.$ 1.$ 0

0.000 0.000 0.000 1$.##1 1$.##1 0.000

2.$$0 2.$$0 2.$$0 2$.$3 2$.$3 2.$$0



1.$ 3.0#5

1.$ 22.

6

.3 3.15 .3 1.55 .1$

11.01 1$.$1" 0.000 2#.112 20."00 2#.112 ".$ 25.5$2

7

5.33 .$

32.20 2$.2

3. 32.$

30."5 2.# 30."5 13.33 2".2

"

5.33

32.20

3.

2.# 3."5 2.# 3."5 2.#

1.52 2.1# 1.52 2.1# 1.52

20.3 2$.01 20.3 2$.01 20.3

TOTAL PESO TOTAL EDIFICIO CARGA 'IGA CARGA PANTALLA CARGA COLUMNA CARGA CU$IERTA  (&. COLUMNA)/2 TOTAL(KN)

- (KN)

213#.$0 5.0 ".$ $3.$ 3!32.6!

FUERA SISMICA :

UI%A%IN EDIFI%IO (ARMENIA QUINDIO) &ONA DE AMENA&A (ALTA) %OEF. A. DISE,O A (6 -) !RUPO DE USO I ( O%UPA%ION NORMAL) %OEF. DE IMPORTAN%IA (I)  TIPO DE PERFIL DEL SUELO (%) %OEF. VELO%IDAD PI%O EFE%TIVA (A7) %OEF. AMPLI%A%ION DE A%ELERA%ION (F7) %OEF. DE LA ESTRU%. DEF.(%8) EXPONENTE (;) ALTURA DE EDF. 9: (m)  T PROM. DE OS%ILA%ION () VALOR EP%T. A. DISE,O SA (6-) W DEL EDIF%IO (KN) FUERA DEL SISMO (KN)

0.25 1 0.25 1.55 0.0# 0." 20. 0.#2 0.5 3"32." 2556.02

EXPONENTE RELA%. %ON T (K)

1.11

 PISOS

 (m)

& (T4F)

&8 

%UIERTA #  5  3 2 1

20. 1#. 1. 11. $. 5. 2.$ 0

$3.$ 51.$# 51.$# 51.$# 51.$# 51.$# 51.$# 0.00

20#0.15 1231.$3 1003.0# ####.1 55$2."2 3#1.21 110.#3 0.00

3!32.6!

6""".0"

LONG AFER (m)

C. 'I'A (KN/m)

LOG. LU (m)

0 0 0 1.$ 1.$ 0

0.000 0.000 0.000 5.5$0 5.5$0 0.000

2.32 2.02 21.#" .5 .5 2#.0#

TOTAL CARGA 'I'A CARGA 'I'A 'I'IENDA (KN/m ) CARGA 'I'A ESCALERA (KN/m) ²

E%ES A $ C #*+#,* #*+#,* D

1.$ 3



1.$ 3.0#5

3.20 5.535

1.5 2.2#

6

.3 3.15 .3 1.55 .1$

1.5 2.2# 1.5$ .5 5.15

7

5.33 .$ 5.33

#."# .1# #."# 2.#"0 #.52 0.000 ".5" $.2 ".5"

5.3 .5 5.15

2.# 3."5 2.# 3."5 2.#

"

.$0 #.110 .$0 #.110 .$0

5.3 .5 1.2 3.0# 0.

TOTAL CARGA 'I'A CU$IERTA (KN/m ) ²

0.35

E%ES A $ C D

LONG AFER (m)

C. 'I'A (KN/m)

LOG. LU (m)

0 0 0 0

0.000 0.000 0.000 0.000

2.32 2.02 21.#" 2#.0#



1.$ 3.0#5

0.30 1.0#

1.5 2.2#

6

.3 3.15 .3 1.55 .1$

1.551 1.1"5 1.551 0.53 1.3

1.5 2.2# 1.5$ .5 5.15

7

5.33 .$ 5.33

1.$ 1.3$ 1.$

5.3 .5 5.15

"

2.# 3."5 2.# 3."5 2.#

0."5 1.3$3 0."5 1.3$3 0."5

5.3 .5 1.2 3.0# 0.

TOTAL CARGA 'I'A TOTAL (KN)

51!.1"

PESO W (KN) 1.3 0.525 2.35

OG. LU (m

- (KN)

2.32 2.02 21.#" 2#.0#

#0.0 ".1$ 2.# ##." 27!.!

1.5 2.2#

.$# 12.21 1!.0"

1.5 2.2# 1.5$ .5 5.15

$.#$ 12.5" ".5# 30." 30.5 !2.17

5.3 .5 5.15

3.$ 1.10 33.50 10!.07

5.3 .5 1.2 3.0# 0.

2#.51 3$.# #.3# 1#.$5 3.3 !."2 5!5.0"

OG. LU (m

- (KN)

2.32 2.02 21.#" .5 .5 2#.0#

#0.0 ".1$ 2.# 1$#.1 1$#.1 ##." 655.15

1.5 2.2#

21.5 51. 72.!"

1.5 2.2# 1.5$ .5 5.15

.$$ 5.1 $."0 $$.2 151.52 3!0.0"

5.3 .5

1"3.2 21.00

5.15

1$#.## 5!7.01

5.3 .5 1.2 3.0# 0.

10#."3 1$.2" 2$."2 $.00 13. 22.5" 2137."0

C9 

F (T4F)

0.3#1 0.1"0 0.155 0.120 0.0$ 0.053 0.025 0.000

"$.15 $.1 3"5.25 30.35 21"."2 13.# 3.5 0.00

1.000

2556.02

- (KN)

0.00 0.00 0.00 3.2# 3.2# 0.00

72.5

.#0 12.5 17.26

11.5 13."5 12.0 1$.55 3$.#5 !5.2

50.$5 5.02 ".1

156.2"

25.# #.2$ ."0 21.$3 3.21 10.!" 6.7

- (KN)

0.00 0.00 0.00 0.00 0.00

0."1 2. 3.36

2.25 2.#1 2.5 3.1 #.53 1".55

".$" 10.$" ".1 30.3!

5.01 ".1" 1.3 .2 0.2 20.1 72.71

S8< STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR?# STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR?5 STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR? STOR?

I8=m M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X

L DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX

P>:8

X 3 1 3 10 12 10 3 10 3 10 12 10 3 1 3 10 12 10 3 10 3 10 12 # 3 10 3 10 12  3 10 3 10 12  3 1 3 10 12 10 3 10 3 10 12

? 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12

0 0 0 1.5 1.5 1.5 0 1.5 0 1.5 1.5 1.5 0 0 0 1.5 1.5 1.5 0 1.5 0 1.5 1.5 10 0 1.5 0 1.5 1.5 5 0 1.5 0 1.5 1.5 5 0 0 0 1.5 1.5 1.5 0 1.5 0 1.5 1.5

STOR? STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?3 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?2 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1 STOR?1

M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ? M@ D>8 X M@ D>8 ?

30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX DEAD DEAD LIVE LIVE SISMOX SISMOX SISMO? SISMO? 30SISMO? 30SISMO? 30SISMOX 30SISMOX

10 3  3 1 12 10 3 10 3 10 12 # 3 1 3 10 12 10 3 10 3 10 12 10 3  3 10 12 10 3 10 3 10 12 10

0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0 12 0

1.5 0 5 0 0 1.5 1.5 0 1.5 0 1.5 1.5 10 0 0 0 1.5 1.5 1.5 0 1.5 0 1.5 1.5 1.5 0 5 0 1.5 1.5 1.5 0 1.5 0 1.5 1.5 1.5

&

D>8X D>8? 1$.2 0.00001 1$.2 0.000013 1$.2 0.000003 1$.2 0.000003 1$.2 0.000#$3 1$.2 0.00012 1$.2 0.000221 1$.2 0.0005# 1$.2 0.00051 1$.2 0.0010" 1$.2 0.002303 1$.2 0.000# 15. 0.000013 15. 0.000013 15. 0.000003 15. 0.000003 15. 0.000$0 15. 0.0001$# 15. 0.000233 15. 0.0002" 15. 0.000$5 15. 0.001$52 15. 0.0023#3 15. 0.00055 13 0.000012 13 0.000012 13 0.000003 13 0.000002 13 0.000$0 13 0.000211 13 0.00023" 13 0.000"" 13 0.000#0 13 0.00205$ 13 0.0023#1 13 0.00022 10. 0.00001 10. 0.00001 10. 0.000002 10. 0.000002 10. 0.000## 10. 0.000225 10. 0.000233 10. 0.000#3# 10. 0.000$5 10. 0.0021" 10. 0.00225$

10. #.$ #.$ #.$ #.$ #.$ #.$ #.$ #.$ #.$ #.$ #.$ #.$ 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 2. 2. 2. 2. 2. 2. 2. 2. 2. 2. 2. 2.

0.0001 0.00000# 0.00000# 0.000002 0.000001 0.000# 0.00021 0.00020 0.000#1# 0.00005 0.002111 0.001"$" 0.0003 0.000005 0.00000 0.000001 0.000001 0.000503 0.0001#3 0.000151 0.0005$# 0.0005 0.001#2" 0.001#" 0.00050$ 0.000002 0.000001 0 0 0.00020# 0.0000#5 0.00001 0.00023 0.0001$ 0.000## 0.0001 0.000222