Hoja Excel para el Diseño estructural de un pórtico por el método de Takabeya

PREDIMENSIONADO DE VIGAS B

L2

B

C2

L3

B

C2

C2

VS-101

VS-101

2 0 1 P V

t

1 0 1 P V

2 0 1 P V

VS-101

t

VS-101

C2

L

C1

C2 L1

L2/2

B

L3/2

B colaborante



0%30

0%,0

#APA$A ELEMEN$O S VP-101 VS-101 C1 ALIGER. RECUBR. TABIQUERIA ZAPATA S/C 1° PISO S/C 2° PISO

N.

B

PERAL$E

LONGI$"D

PESO ESPECI%

2.00 2.00 1.00 2.00 2.00

0.30 0.30 0.30 3.90 4.20

0.60 0.40 0.50

4.90 3.90 7.20 4.60 4.90

2400.00 2400.00 2400.00 286.48 100.00

1.00 1.00 1.00

2.30 4.20 4.20

0.50

2.40 4.90 4.90

2400.00 300.00 300.00

PESO 4233.60 2246.40 2592.00 10278.72 4116.00 0.00 6624.00 6174.00 6174.00

(2(3%2 DIMENSIONES INALES DE #APA$A

PESO

RESIS$% $N $N $ERRENO $N/M2

42.44

9.00

AREA CM2

LARGO

ANC!O

PERAL$E

4.72

2.20

2.14

0.50

!

1

!

1 3%00

2

t

2 (%20

L

t

l1

ELEMEN$O S VP-101 VS-101 C1 ALIGER. RECUBR. TABIQUERIA ZAPATA S/C 1° PISO S/C 2° PISO

N.

B

2.00 2.00 1.00 2.00 2.00

0.30 0.30 0.30 3.90 4.20

1.00 1.00 1.00

2.30 4.20 4.20

DIMENSIONES INALES DE #APA$A

PESO

RESIS$% $N $ERRENO $N/M2 32.75

9.00

AREA CM2 3.64

PERAL$E

LONGI$"D

PESO ESPECI%

0.60 0.40 0.50

3.40 3.90 7.20 3.10 3.40

2400.00 2400.00 2400.00 286.48 100.00

0.50

2.40 3.40 3.40

2400.00 300.00 300.00

P ES O 2937.60 2246.40 2592.00 6927.09 2856.00 0.00 6624.00 4284.00 4284.00

32,1%0&

LARGO

ANC!O

PERAL$E

1.90

1.92

0.50

PREDIMENSIONADO DE VIGAS B

L2

B

C2

L3

B

C2

C2

VS-101

VS-101

2 0 1 P V

t

1 0 1 P V

2 0 1 P V

VS-101

t

VS-101

C2

L

C1

C2 L1

L2/2

B

L3/2

B colaborante



ANALISIS SISMICO DE LAS ES$R"C$"RAS ES$"DIO SISMICO DE LA ES$R"C$"RA

! ' #%"%S%C%P/R6 S!"#$% & Z U S C R$ P

' ' ' ' ' '

()*+%, $" Z%#) ()*+%, $" U% ()*+%, $" S"% C%"!*!"#+" S!*% ()*+%, $" $*+!!$)$ P"% $" ) E$!!*)*!#

actor 6e #ona * # +

actor 6e "7o e I89ortanc:a * " +

#ona

#ona 1

#ona 2

#ona 3

Cate;or
B

C

actor =>=

1%00

0%0

0%30

actor ="=

1%30

1%00

E ()*+%, $" Z%#) $""#$" $" ) :%#) !*) $%#$" "+= >!*)$) ) E$!!*)*!#

P),) ) E+,*+,) $" T!% A " ,%"*+!+) $">",= ,""#+), " "+$!% ,""*+!%  ),) " T!%  #% " #"*"),!% ,")!:), $!"?% !*%

Per:o6o Pre6o8:nate 6e la E7trat:;ra?
$:9o S5elo

$7

Ran;o

I II III

0%30 0%)0 0%&0

0%37e;  $7  0%& 7e;

Coe?:c:ente S<78:co * C +

$:9o S5elo

Ran;o

C' 0%/**$/$7+1%0+

0%1)  C  0%(0

VERIICACION MODAL

0.12 0.12  ZUSC/ ZUSC/R$ R$

Z U S T T C R$

1.00 1.30 1.00 0.16 0.30 0.40 6

0.522

EC"ACION

! ' 0%12 P

5er>a !or:>ontal S:78:ca *!+ Ec5ac:@n

!

!' 0%12 P

,10%,0

HH " ) C),@) %,!:%#+) S!!*) "# ) >)" $" ) "+,*+,)

D:7tr:b5: D:7tr:b5:@n @n 6e =!= =!= en la alt5ra alt5ra 6el 6el e6:?:c:o e6:?:c:o

Relac:@n Relac:@n Anco Anco - Alto Alto 6el e6:?:c: e6:?:c:o o

Ec5ac:@n

b



/b

/b3

?

' ?%!*P:%:/ 7*P:%:+

%00

%20

1%02&

OF

1%00

5er>a !or:>ontal $otal $otal en ca6a 9:7o 6el e6:?:c:o*  + P:7o 1° 2°

!

; 7510.50 7510.50

P:

: ;

8%

62587.54 30861.77

4.20 7.20

P:%: ;  8%



; 

ton

262867.66 222204.74

4070.05 3440.45

7.51 3.44

(,02%(0

,10%,0

10%&,

ES$ADO I CALC"LO DE ES$R"C$"RA APOR$ICADA POR $AABEHA 5.22 5.22 +#/ +#/2 2 3

2I

4

1

I 3.00

5.22 5.22 +#/ +#/2 2 5

2I

6

I

2

I 4.20

7

8 6.00

T!%

V!@)

T,)%

34 56 53

L%#@!+$ 

> *

S"**!#  *

%"#+% $" I#",*!) *4

6.00 6.00 3 00

30.00 30.00 30 00

60.00 60.00 50 00

6480000 6480000 3750000

1.40

C%"!*!"#+" $" R!@!$": 

R",""#+)*!#

10800 10800 12500

3.63 3.63 4 20

C),@) !+,!>!$) T%#/ 5.22 5.22

%"#+% E%+,). P",""*+% !D D! -15.666 -15.666

15.666 15.666

DIAGRAMA DE I$ERACION

0%000

0%000

3

4

1,%)

-0%2)

-0%232

-1,%)

1,%)

1%001 0%&)3 1%013 1%021 1%02( 1%02( 1%02, 1%02,

-0%)( -0%)) -0%1 -0%&3 -0%&, -0%&, -0%&, -0%&,

-0%232

-10%,,

-0%2)

-,%12

DIAGRAMA DE MOMEN$O LEC$OR EN VIGAS H COL"MNAS

-11.11

-13.61 -5.12

3

4.00

-11.11

3

4

-8.50

-3.58

5

6

-2.60

11%1, -12.90

-14.69 -5.12

5

6

9 32

6 98

7

8

ES$ADO II CALC"LO DE ES$R"C$"RA APOR$ICADA POR $AABEHA AABEHA

2.95 2.95 +#/ +#/2 2 3

2I

4

1

I 3.00

5.22 5.22 +#/ +#/2 2 5

2I

6

I

2

I 4.20

7

8 6.00

T!%

V!@)

T,)%

34 56

L%#@!+$ 

> *

S"**!#  *

%"#+% $" I#",*!) *4

6.00 6 00

30.00 30 00

60.00 60 00

6480000 6480000

1.40

C%"!*!"#+" $" R!@!$": 

R",""#+)*!#

C),@) !+,!>!$) T%#/

10800 10800

3.63 3 63

2.95 5 22

%"#+% E%+,). P",""*+% !D D! -8.862 15 666

8.862 15 666

DIAGRAMA DE ITERACION

0%000

0%000

3

4

%)

-0%2)

-0%232

-%)

%)

0%,)) 0%()0 0%(,( 0%((& 0%(,0 0%(,0 0%(,0 0%(,0

-0%31 -0%3, -0%33 -0%3(0 -0%3(0 -0%3(0 -0%3(0 -0%3(0

-0%232

-,%&

-0%2)

-2%&


-6.83

-8.03 -2.89

3

4.00

-6.83

3

4

-5.13

-4.36

5

6

-3.26

,% -12.36

-14.36 -5.12

5

6

8.00

5.99

ES$ADO III CALC"LO DE ES$R"C$"RA APOR$ICADA POR $AABEHA

5.22 5.22 +#/2 +#/2 3

2I

4

1

I 3.00

2.95 2.95 +#/2 +#/2 5

2I

6

I

2

I 4.20

7

8 6.00

T!%

V!@)

T,) %

34

L%#@!+$ 

> *

S"**!#  *

%"#+% $" I#",*!) * 4

6 00

30 00

60 00

6480000

1.40

C%"!*!"#+" $" R!@!$": 

R",""#+)*!#

C),@) !+,!>!$) T%#/

10800

3 63

5 22

%"#+% E%+,). P",""*+% !D D ! 15 666

15 666


0%000

0%000

3

4

1,%)

-0%2)

-0%232

-1,%)

1,%)

1%001 1%0( 1%132 1%1( 1%1,3 1%1,( 1%1,( 1%1,,

-0%)( -0%(2 -0%, -0%&01 -0%&0( -0%&0, -0%&0, -0%&0,

-0%232

-10%,,

-0%2)

-,%12


-10.57

-13.29 -5.12

3

4.00

-10.57

3

4

-8.17

-1.25

5

6

-0.81

11%,& -7.84

-8.64 -2.89

5

6

6.60

4.93

)))))

)))))

)))))

)))))

)))))

)))))

ES$ADO IV CALC"LO DE ES$R"C$"RA APOR$ICADA POR $AABEHA

2 TO;

3.44 3

2I

4

I

I 3.00

1 TO;

7.51 5

2I

6

I

I 4.20

7

8 5.00

$:9o

V:;a7

$ra8o

Lon;:t56

Secc:@n

Mo8ento Coe?:c:ente 6e R:;:6e> 6e Inerc:a c8( F Re9re7entac:@n

8

b c8

 c8

34

5.00

30

50.40

3840000.0003

7680

3.6000000003

56

5.00

30

50.40

3840000.0003

7680

3.6000000003


0%000

0%000

3

4

RE

-0%23

-0%22

-0.750

-0.860 -2.074 -2.625 -2.834 -2.911 -2.938 -2.948 -2.952

RE

0%00

0%1&, 0%303 0%332 0%33 0%33 0%33& 0%33& 0%33&

0%1(2 0%22 0%2&, 0%323 0%333 0%33 0%33 0%33

-0%23

0%00

-0%22

-0.750

-0.86 -2.074 -2.625 -2.834 -2.911 -2.938 -2.948 -2.952

-0%1,) 5

-0%1,) 6

-3.66

3.65

-3.65

9.91

-9.91

3.66

-11.41

-1.50

1.50

13 08

13 08

11.41

MOMEN$OS H COR$AN$ES DE DISEO SOLICI$ACION SOLICI$ACION ES$R"C$"RAL 5.22 5. 22 +# +#/2 /2 2 TO;

3.44 2I

4

1

I 3.00

5.22 5. 22 +# +#/2 /2 1 TO;

7.51 5

2I

I

6

2

I 4.20

7

8 6.00

MOMEN$OS INALES Ele8ento

V:;a7

S:;no

*-+

1.40

COR$AN$ES INALES $ra8o

34 49 56 69J

Mo8ento7 :nale7 M:

M :

-14.77 -5.12 -24.31 5 12

-17.27 0.00 -26.10 0 00

Ele8ento

V:;a7

$ra8o

34 49 56 69J

Cortante7 :nale7 V:

V:

16.71 7.31 19.93 7 31

-17.58 0.00 -20.56 0 00

DIAGRAMA DE "ER#AS COR$AN$ES 1)%1

%31

(

3

3

(

& -1%, -%,3

1&%&3

)%

%31

) (

,

,

)

& -20%,) -&%22





DC VIGAS

%3





DC COL"MNAS

DISEO DE ACERO EN VIGAS S:;no

$ra8o

M:

M:

*-+

34 49

-14.77 -5.12

-17.27 0.00

56

-24.31

-26.10

69J

-5.12

0.00

34 56

11.59 10.15

*+

Mo8ento7 :nale7

B *%)>.

V

20.00

60.00

30.00

Ver:?:c Ver:?:cac:on ac:on 6e Ele8ento

V:;a7

Col58na7

$ra8o

Cortante7 : :nale7 V:

V:

34 49 56 69J

16.71 7.31 19.93 7.31

-17.58

75 53 86

-9.22 -8.53 8.83

64

6.88

Pb '0%,1 *)000/)000?+% ?c/? a8a' P8a%?%6/0%,?c

-20.56

M8a' Q% 0%,b ?c a 8a*6-0%,a8a+ P8a ' 0%, P b

P8a ' 0%, Pb

Pb

a8a

0.02125

B+ Mo8ento7 "lt:8o7

Ver:?:cac:@n 6e

0%, Pb 0.01594

20.81

M8a 45.23

D:7eo 6el Area 6e acero ACERO NEGA$IVO $:9o

$ra8o

M5

Q

T%#-

34 49 56 69J 43 65

14.77 5.12 24.31 5.12 17.27 26.10

0.9 0.9 0.9 0.9 0.9 0.9

$ra8o

A7 8:n

Ver:?:cac:@n

;"@)+!%

$:9o

*2

;"@)+!%

ACERO POSI$IVO

34 49 56 69J 43 65

4.02 4.02 4.02 4.02 4.02 4.02

O ), A !# O ), A !# O O

b

6

?c

?

A7

*

*

@/*2

@/*2

*2

30.00 30.00 30.00 30.00 30.00 30.00

55.50 55.50 55.50 55.50 55.50 55.50

210.00 210.00 210.00 210.00 210.00 210.00

4200.00 4200.00 4200.00 4200.00 4200.00 4200.00

3/8H 10 3 18 3 12 19

1/2H 7 2 12 2 9 14

7.43 2.48 12.74 2.48 8.78 13.79

N. 6e ar:lla7 5/8H 4 1 6 1 4 7

3/4H

3 1 , 1 3 ,

1H 1 0 3 0 2 3

DISEO DE VIGA =$= b V

t Q b b 6

)0%00

?c 30%00 b

? t 1

l ala t 20

b/2 1,

b/2  t O%

V:;a $

A7 ' M5 / Q?*6-0%,t+ a ' A7%? / 0%,%?c%b C ' a/1

b 0

(b 120

0%& 30%00 c8 0 c8 ,,%,0 c8 210%00 210%00 F;/c82 F;/c82 (200 F;/c82 20 c8 0%,

b (b O%

DISEO DE ACERO EN COL"MNAS t

b

r

USO E ABACOS )#+" ",!!*), ">"+":.

r ;t

; ' * t-2r + / t

e ' M5 / P5

'P5 / ?c%b%t

 e/t 'P5%e / ?c%b%t 2

P+.'A/>.+./0.85J*

A7'Pt%8%b%t% A7'Pt%8%b%t% 0%,%?c/?

V49 V43 V69J V65

$ra8o 68 64 75 53

7.31 17.58

e8:n'0%1t

V34 V56

16.71

19.93

7.31 20.56

P5

2%

P5

2(%&

P5

1&%&3

P5

1)%1

68 86

13.17 14.71

46 64

12.15 8.48

57 75

14.27 15.26

35 53

14.77 10.82

M5

13%1

M5

12%1,

M5

1,%2)

M5

1(%

;

?c

?

210.00 210.00 210.00 210.00

4200.00 4200.00 4200.00 4200.00

P

P8:n

A78:n

0.83 0.86 1.40 1.39

1.00 1.00 1.00 1.00

15.00 15.00 15.00 15.00

t

r

b

*

*

*

50.00 50.00 50.00 50.00

4.00 4.00 4.00 4.00

30.00 30.00 30.00 30.00

$ra8o

e/t



 e/t

68 64 75 53

0.94 0.98 1.53 1.77

0.09 0.08 0.06 0.05

0.08 0.08 0.10 0.09

M5

P5

e

T%#-

T%#

*

0.84 0.84 0.84 0.84

13.17 12.15 15.26 14.77

27.88 24.89 19.93 16.71

47.24 48.82 76.57 88.39

;'0%0

;'0%(

;'0%&0

*2

0.20 0.21 0.35 0.34

0.20 0.20 0.33 0.33

0.19 0.19 0.30 0.31

12.50 12.88 21.04 20.91

Pt%8

A7

*2

DISEO DISE O DE D E #APA #APA$ $A P M ELEMEN$O S

!

VP-101 VS-101 C1 ALIGER. RECUBR. TABIQUERIA ZAPATA



S/C 1° PISO S/C 2° PISO

N.

B

PERAL$E

LONGI$"D

PESO ESPECI%

PESO

2.00 2.00 1.00 2.00 2.00 0.00 1.00 1.00 1.00

0.30 0.30 0.30 3.90 4.20 0.00 2.30 4.20 4.20

0.60 0.40 0.50

4.90 3.90 7.20 4.60 4.90 0.00 2.40 4.90 4.90

2400.00 2400.00 2400.00 286.48 100.00 0.00 2400.00 300.00 300.00

4233.60 2246.40 2592.00 10278.72 4116.00 0.00 6624.00 6174.00 6174.00

PP> P7 P

(2%(( 2%2 (,%1)

A78:n c82

S ,/=

10.87

18

0.50

T8a

T 8:n e R A/2

A/2 A

M %(1

! ,%0(

T8a 1(%2

T8:n 2%0&

T8a

T8:n

2(%2)

3%,,

 1

T9ro8% $on/82 13%&1

M'M!% 13%(,

Tneto $/8l 33%3

,) $! $!" "?) ?),, +%$ %$% % % %  " "" "" "

Ve:?:c% Por Corte a 5na 6:7tanc:a =6= V 'M#"+% 16.69

V*'0.850.53J*1/2>$

29.38

O

V)$K V)*+.

e 0%2&

8 0%&,

A 2%(0

M5

$-8l

1,%0)

A/) 0%(00

Q 0.9

b

6

?c

?

A7

*

*

@/*2

@/*2

*2

100.00

45.00

210.00

4200.00

9.07

L

0%,t

P1

P2

M1

M2

!1

!2





T

T R1

R2

A/2

A/2

A/2

A

A/2 A

ATOS P1 1 1 P2 2 2  N L +

32.75 8.72 9.22 42.44 8.41 8.83 1.20 9.00 6.50 0.50

TO; TO;- TO; TO; TO;- TO;  TO;/2  

ASUIE;O

Area a9ro% ' P1/J

A,") ),% '

3.64

A ' *Area a9ro+1/2

A'

1.91

R1'* P1%L-*!1!2+%-*M1M2++/*L0 P1%L-*!1!2+%-*M1M2++/*L0%,t-0%,A+ %,t-0%,A+

R1'

30.04

R2'* *!1!2+%*M1M2+-0%,P1*A *!1!2+%*M1M2+-0%,P1*A-t++/*L0%,t-0%,A -t++/*L0%,t-0%,A+P2 +P2

R2'

45.15

Area1 ' R1/J A1 ' *Area 1+1/2

Area2 ' R1/J A2 ' *Area 1+1/2

A,") 1 '

3.34

A1'

1.83

A,") 2 '

5.02

A2'

2.24

T1 ' JUB1

F1

16.44 TO;/L

T2 ' JUB2

F2

20.16 TO;/L

(C 19.86

4.11

0.00

-2.71

-28.64

-2.71

-22.58

Hoja Excel para el Diseño estructural de un pórtico por el método de Takabeya

Recommend Documents