gustavo examen.xlsx

7/23/2019 GUSTAVO EXAMEN.xlsx

1/34

GUSTAvo 7

DNI 7 3 3

3

1

2

1.5

2

3

3

DATOS DE VIGAS

A

1

4

7


2/34

VIGA 1-2 Y 4-5 Y 7-8

DATOS TRAMO 1-2

fc280 B=

E=250998.00796 H=

I=0.0054 L=

W= -- A=

ECUACION DE RI

ECUACIO DE RIGIDE! VIG

"1 V1 #1 "1

6454.23 0 0 -6454.23

0 47.42 165.97 0

$ 1 -2= 0 165.97 774.51 0-6454.23 0 0 6454.23

0 -47.42 -165.97 0

0 165.97 387.25 0


"2 V4 #4 "2

6454.23 0 0 -6454.230 47.42 165.97 0

$ 4-5= 0 165.97 774.51 0

-6454.23 0 0 6454.23

0 -47.42 -165.97 0

0 165.97 387.25 0


"3 V7 #7 "3

6454.23 0 0 -6454.23

0 47.42 165.97 0

$ 7-8= 0 165.97 774.51 0

-6454.23 0 0 6454.23

0 -47.42 -165.97 0

0 165.97 387.25 0


3/34

DATOS DE COLUM

COLUMA A -1 Y B-2

DATOS TRAMO A

fc =280 A%c&'=E=250998.00796 L()*'=

I=0.000675 L=

W=0 A=

"( V( #( "1

75.30 0 -112.95 -75.30

0 7529.94 0 0

-112.95 0 225.90 112.95

$ A -1 = -75.30 0 112.95 75.30

0 -7529.94 0 0-112.95 0 112.95 112.95

"+ V+ #+ "1

75.30 0 -112.95 -75.30

0 7529.94 0 0

-112.95 0 225.90 112.95

$ B -2 = -75.30 0 112.95 75.30

0 -7529.94 0 0

-112.95 0 112.95 112.95

ma!"# $% $%&'(a#

V1 #1 V2 #2

V1 15645.152217 165.96602975 -47.418865644 165.96602975

#1 165.96602975 1242.4401394 -165.96602975 387.25406942

V2 -47.418865644 -165.96602975 15749.246111 -35.848662427

#2 165.96602975 387.25406942 -35.848662427 1459.3024183

V3 0 0 -104.09389386 -130.11736733

#3 0 0 130.11736733 108.43113944

V4 -8067.793113 0 0 0

#4 0 121.0168967 0 0

V5 0 0 -8067.793113 0

#5 0 0 0 121.0168967

V, 0 0 0 0

#, 0 0 0 0


4/34

V7 0 0 0 0

#7 0 0 0 0

V8 0 0 0 0

#8 0 0 0 0

"1 0 -16.711857163 0 -16.711857163

"2 0 129.66096074 0 129.66096074

"3 0 0 0 0

V1 #1 V2 #2

V1 0.0001327643 -1.81215E-005 3.883179E-008 -1.81215E-005

#1 -1.81215E-005 0.0009935617 1.812150E-005 -0.0001998741

V2 3.883179E-008 1.812150E-005 0.0001327643 1.812150E-005

#2 -1.81215E-005 -0.0001998741 1.812150E-005 0.0009935617

V3 -4.52649E-005 -0.0004815637 0.0001780681 0.0025020256

#3 -1.81215E-005 -0.0001998741 1.812150E-005 0.0009935617

V4 0.0001327626 -1.89206E-005 4.054423E-008 -1.89206E-005#4 -1.89206E-005 -6.12382E-005 1.892064E-005 0.0001090655

V5 4.054423E-008 1.892064E-005 0.0001327626 1.892064E-005

#5 -1.89206E-005 0.0001090655 1.892064E-005 -6.12382E-005

V, -4.72611E-005 0.0002915844 0.0001800642 -0.0001341748

#, -1.89206E-005 0.0001090655 1.892064E-005 -6.12382E-005

V7 0.0001327626 -1.89583E-005 4.062496E-008 -1.89583E-005

#7 -1.89583E-005 2.270771E-005 1.895831E-005 -0.000010043

V8 4.062496E-008 1.895831E-005 0.0001327626 1.895831E-005

#8 -1.89583E-005 -0.000010043 1.895831E-005 2.270771E-005

"1 2.718225E-005 -0.0005952657 -2.71823E-005 -0.0005952657

"2 7.904125E-005 -0.0011843261 -7.90413E-005 -0.0011843261

"3 0.0001320718 -0.0012266705 -0.0001320718 -0.0012266705

V1 -0.001718019

#1 -0.0038873546

V2 -0.0027640883

#2 -0.0006467595

V3 -0.0836363564

#3 -0.043876961

V4 -0.0027578927

#4 -0.0038432391

V5 -0.0041412325

#5 -0.0011271866

V, -0.0838128905

#, -0.0472394015

V7 -0.0034580608


5/34

#7 -0.0069940938

V8 -0.0047425355

#8 -0.0036231218

"1 0.0034005856

"2 0.0100537635

"3 0.0209651124

REACCIONES + *O*ENTOS

V1 #1 V2 #2

"( 0 -112.94910358 0 0

V( -7529.9402388 0 0 0

#( 0 112.94910358 0 0

"+ 0 0 0 -112.94910358

+ 0 0 -7529.9402388 0

#+ 0 0 0 112.94910358V1 15645.152217 165.96602975 -47.418865644 165.96602975

#1 165.96602975 1242.4401394 -165.96602975 387.25406942

V2 -47.418865644 -165.96602975 15749.246111 -35.848662427

#2 165.96602975 387.25406942 -35.848662427 1459.3024183

V3 0 0 -104.09389386 -130.11736733

#3 0 0 130.11736733 108.43113944

V4 -8067.793113 0 0 0

#4 0 121.0168967 0 0

V5 0 0 -8067.793113 0

#5 0 0 0 121.0168967

V, 0 0 0 0

#, 0 0 0 0

V7 0 0 0 0

#7 0 0 0 0

V8 0 0 0 0

#8 0 0 0 0

"1 0 -16.711857163 0 -16.711857163

"2 0 129.66096074 0 129.66096074

"3 0 0 0 0

"( 0.18301

V( 12.93658

#( -0.05498

"+ -0.18301

+ 20.81342

#+ 0.31104


6/34

V1 -5.25000

#1 -4.12500

V2 -6.37500

#2 4.60000

V3 -2.62500

#3 0.93750

V4 -3.50000#4 -4.08333 33.75

V5 -3.50000

#5 4.08333

V, -2.00000

#, 0.00000

V7 -7.35000

#7 -7.35000

V8 -3.15000

#8 -4.90000

"1 0.00000"2 0.00000

"3 0.00000


7/34

3 8 3 . 2

9

2

3

3

2.5

,

5

2

8

3

6


8/34

VIGA 2-3 Y 5-,

Y 4-5 Y 7-8 DATOS TRAMO

0.3 fc2.8 B=

0.6 E=25099.800796 H=

7 I= 0.0054 L=

0.18 W= -- A=

GIDEZ EN VIGAS

1-2 ECUACIO

V2 #2 "1

0 0 "1 1807.19

-47.42 165.97 V1 0

-165.97 387.25 #1 $ 2 - 3= 00 0 "1 -1807.19

47.42 -165.97 V2 0

-165.97 774.51 #2 0

4-5 ECUACIO

V5 #5 "2

0 0 "2 1807.19-47.42 165.97 V4 0

-165.97 387.25 #4 $ 5-,= 0

0 0 "2 -1807.19

47.42 -165.97 V5 0

-165.97 774.51 #5 0

7-8

V8 #8

0 0 "3

-47.42 165.97 V7

-165.97 387.25 #7

0 0 "3

47.42 -165.97 V8

-165.97 774.51 #8


9/34

S

COLUMA

- 1 Y B-2 DATOS

0.3 fc = 2800.3 E=250998.00796

3 I= 0.000675

0.09 W=0

V1 #1 "1

0 -112.95 "( 92.61

-7529.94 0 V( 0

0 112.95 #( -129.66

0 112.95 "1 $ 1-4 = -92.61

7529.94 0 V1 00 225.90 #1 -129.66

V2 #2 "1

0 -112.95 "+ 92.61

-7529.94 0 V+ 0

0 112.95 #+ -129.66

0 112.95 "1 $ 2 -5 = -92.61

7529.94 0 V2 0

0 225.90 #2 -129.66

m"%)o

V3 #3 V4 #4 V5

0 0 -8067.793113 0 0

0 0 0 121.0168967 0

-104.09389386 130.11736733 0 0 -8067.793113

-130.11736733 108.43113944 0 0 0

104.09389386 -130.11736733 0 0 0

-130.11736733 216.86227888 0 0 0

0 0 16183.005092 165.96602975 -47.418865644

0 0 165.96602975 1258.5757256 -165.96602975

0 0 -47.418865644 -165.96602975 16287.098986

0 0 165.96602975 387.25406942 -35.848662427

0 0 0 0 -104.09389386

0 0 0 0 130.11736733


10/34

0 0 -8067.793113 0 0

0 0 0 121.0168967 0

0 0 0 0 -8067.793113

0 0 0 0 0

0 0 0 -129.66096074 0

0 0 0 0 0

0 0 0 129.66096074 0

V3 #3 V4 #4 V5

-4.52649E-005 -1.81215E-005 0.0001327626 -1.89206E-005 4.054423E-008

-0.0004815637 -0.0001998741 -1.89206E-005 -6.12382E-005 1.892064E-005

0.0001780681 1.812150E-005 4.054423E-008 1.892064E-005 0.0001327626

0.0025020256 0.0009935617 -1.89206E-005 0.0001090655 1.892064E-005

0.0448599779 0.0255581331 -4.72611E-005 0.0002915844 0.0001800642

0.0255581331 0.0194384476 -1.89206E-005 0.0001090655 1.892064E-005

-4.72611E-005 -1.89206E-005 0.0002566761 -3.58184E-005 7.675380E-0080.0002915844 0.0001090655 -3.58184E-005 0.0010033215 3.581844E-005

0.0001800642 1.892064E-005 7.675380E-008 3.581844E-005 0.0002566761

-0.0001341748 -6.12382E-005 -3.58184E-005 -0.0002001578 3.581844E-005

-0.0001553728 -0.0001341748 -8.94693E-005 -0.0004645759 0.0003462222

-0.0001341748 -6.12382E-005 -3.58184E-005 -0.0002001578 3.581844E-005

-4.73552E-005 -1.89583E-005 0.0002566744 -3.66151E-005 7.846085E-008

-6.14919E-006 -0.000010043 -3.66151E-005 -8.58953E-005 3.661506E-005

0.0001801583 1.895831E-005 7.846085E-008 3.661506E-005 0.0002566744

7.572758E-005 2.270771E-005 -3.66151E-005 0.000145543 3.661506E-005

-0.0015153464 -0.0005952657 0.000028381 -3.58705E-005 -0.000028381

-0.0030398564 -0.0011843261 0.0001050157 -0.0006315642 -0.0001050157

-0.003198748 -0.0012266705 0.0002064226 -0.0012355323 -0.0002064226


11/34

V3 #3 V4 #4 V5

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 00 0 -8067.793113 0 0

0 0 0 121.0168967 0

-104.09389386 130.11736733 0 0 -8067.793113

-130.11736733 108.43113944 0 0 0

104.09389386 -130.11736733 0 0 0

-130.11736733 216.86227888 0 0 0

0 0 16183.005092 165.96602975 -47.418865644

0 0 165.96602975 1258.5757256 -165.96602975

0 0 -47.418865644 -165.96602975 16287.098986

0 0 165.96602975 387.25406942 -35.848662427

0 0 0 0 -104.09389386

0 0 0 0 130.11736733

0 0 -8067.793113 0 0

0 0 0 121.0168967 0

0 0 0 0 -8067.793113

0 0 0 0 0

0 0 0 -129.66096074 0

0 0 0 0 0

0 0 0 129.66096074 0


12/34


13/34

RESU*EN

RA 3

RVA 0

*AE 2

R, 3.15RV, 0

*,E -1.35

R1 3

RV1 5.25

*1E 4.125

2.8 R2 0.9

RV2 6.375

*2E -4.6

R3 0

RV3 2.625*3E -0.9375

R4 0

RV4 3.5

*4E 4.0833333333

2.8 R5 0

RV5 3.5

*5E -4.0833333333

R6 0

RV6 0

*6E 0R7 0

RV7 7.35

*7E 7.35

3 R8 0

RV8 3.15

*8E 4.9


14/34

-3 Y 5-,

0.3

0.6

2.5

0.18

DE RIGIDE! VIGA 2-3

V2 #2 "1 V3 #3

0 0 -1807.19 0 0

104.09 130.12 0 -104.09 130.12

130.12 216.86 0 -130.12 108.430 0 1807.19 0 0

-104.09 -130.12 0 104.09 -130.12

130.12 108.43 0 -130.12 216.86

DE RIGIDE! VIGA 5-,

V5 #5 "2 V, #,

0 0 -1807.19 0 0104.09 130.12 0 -104.09 130.12

130.12 216.86 0 -130.12 108.43

0 0 1807.19 0 0

-104.09 -130.12 0 104.09 -130.12

130.12 108.43 0 -130.12 216.86


15/34

1-4 Y 2-5

TRAMO 1-4 Y 2-5

A%c&'=0.3L()*'=0.3

L= 2.8

A=0.09

V1 #1 "2 V4 #4

0 -129.66 -92.61 0 -129.66

8067.79 0 0 -8067.79 0

0 242.03 129.66 0 121.02

0 129.66 92.61 0 129.66

-8067.79 0 0 8067.79 00 121.02 129.66 0 242.03

V2 #2 "2 V5 #5

0 -129.66 -92.61 0 -129.66

8067.79 0 0 -8067.79 0

0 242.03 129.66 0 121.02

0 129.66 92.61 0 129.66

-8067.79 0 0 8067.79 0

0 121.02 129.66 0 242.03

#5 V, #, V7 #7

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

121.0168967 0 0 0 0

0 0 0 0 0

0 0 0 0 0

165.96602975 0 0 -8067.793113 0

387.25406942 0 0 0 121.0168967

-35.848662427 -104.09389386 130.11736733 0 0

1475.4380045 -130.11736733 108.43113944 0 0

-130.11736733 104.09389386 -130.11736733 0 0

108.43113944 -130.11736733 216.86227888 0 0


16/34

0 0 0 8115.2119787 165.96602975

0 0 0 165.96602975 1016.5419322

0 0 0 -47.418865644 -165.96602975

121.0168967 0 0 165.96602975 387.25406942

-129.66096074 0 0 0 0

0 0 0 0 -129.66096074

129.66096074 0 0 0 129.66096074

#5 V, #, V7 #7

-1.89206E-005 -4.72611E-005 -1.89206E-005 0.0001327626 -1.89583E-005

0.0001090655 0.0002915844 0.0001090655 -1.89583E-005 2.270771E-005

1.892064E-005 0.0001800642 1.892064E-005 4.062496E-008 1.895831E-005

-6.12382E-005 -0.0001341748 -6.12382E-005 -1.89583E-005 -0.000010043

-0.0001341748 -0.0001553728 -0.0001341748 -4.73552E-005 -6.14919E-006

-6.12382E-005 -0.0001341748 -6.12382E-005 -1.89583E-005 -0.000010043

-3.58184E-005 -8.94693E-005 -3.58184E-005 0.0002566744 -3.66151E-005-0.0002001578 -0.0004645759 -0.0002001578 -3.66151E-005 -8.58953E-005

3.581844E-005 0.0003462222 3.581844E-005 7.846085E-008 3.661506E-005

0.0010033215 0.0025441223 0.0010033215 -3.66151E-005 0.000145543

0.0025441223 0.0451333736 0.0256002297 -9.14592E-005 0.0004004726

0.0010033215 0.0256002297 0.0194482075 -3.66151E-005 0.000145543

-3.66151E-005 -9.14592E-005 -3.66151E-005 0.0003805879 -5.34752E-005

0.000145543 0.0004004726 0.000145543 -5.34752E-005 0.001241876

3.661506E-005 0.000348212 3.661506E-005 1.145897E-007 5.347519E-005

-8.58953E-005 -0.0001781232 -8.58953E-005 -5.34752E-005 -0.0003917292

-3.58705E-005 -0.0001180571 -3.58705E-005 2.843747E-005 -9.49853E-006

-0.0006315642 -0.0016839263 -0.0006315642 0.0001062402 -6.01172E-005

-0.0012355323 -0.0032952532 -0.0012355323 0.0002323666 -0.0006969733


17/34

#5 V, #, V7 #7

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 00 0 0 0 0

0 0 0 0 0

0 0 0 0 0

121.0168967 0 0 0 0

0 0 0 0 0

0 0 0 0 0

165.96602975 0 0 -8067.793113 0

387.25406942 0 0 0 121.0168967

-35.848662427 -104.09389386 130.11736733 0 0

1475.4380045 -130.11736733 108.43113944 0 0

-130.11736733 104.09389386 -130.11736733 0 0

108.43113944 -130.11736733 216.86227888 0 0

0 0 0 8115.2119787 165.96602975

0 0 0 165.96602975 1016.5419322

0 0 0 -47.418865644 -165.96602975

121.0168967 0 0 165.96602975 387.25406942

-129.66096074 0 0 0 0

0 0 0 0 -129.66096074

129.66096074 0 0 0 129.66096074


18/34


19/34

5.25

4.125

6.375

-4.6

2.625

-0.9375

3.54.0833333333

3.5

-4.0833333333

0

0

7.35

7.35

3.15

4.9


20/34

"1

V2

#2"1

V3

#3

"2V5

#5

"2

V,

#,


21/34

COLUMA 4-7 Y 5-8

DATOS TRAMO 4-7 Y 5-8

fc = 280 A%c&'=0.3E= 250998.00796 L()*'=0.3

I= 0.000675 L=2.8

W=0 A=0.09

"2 V4 #4

"1 92.61 0 -129.66

V1 0 8067.79 0

#1 -129.66 0 242.03

"2 $ 4-7= -92.61 0 129.66

V4 0 -8067.79 0#4 -129.66 0 121.02

"2 V5 #5

"1 92.61 0 -129.66

V2 0 8067.79 0

#2 -129.66 0 242.03

"2 $5-8 = -92.61 0 129.66

V5 0 -8067.79 0

#5 -129.66 0 121.02

V8 #8 "1 "2 "3

0 0 0 0 0

0 0 -16.711857163 129.66096074 0

0 0 0 0 0

0 0 -16.711857163 129.66096074 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 -129.66096074 0 129.6609607

-8067.793113 0 0 0 0

0 121.0168967 -129.66096074 0 129.6609607

0 0 0 0 0

0 0 0 0 0


22/34

-47.418865644 165.96602975 0 0 0

-165.96602975 387.25406942 0 -129.66096074 129.6609607

8115.2119787 -165.96602975 0 0 0

-165.96602975 1016.5419322 0 -129.66096074 129.6609607

0 0 335.8287487 -185.22994392 0

0 -129.66096074 -185.22994392 370.45988784 -185.2299439

0 129.66096074 0 -185.22994392 185.2299439

V8 #8 "1 "2 "3

4.062496E-008 -1.89583E-005 2.718225E-005 7.904125E-005 0.000132072

1.895831E-005 -0.000010043 -0.0005952657 -0.0011843261 -0.00122667

0.0001327626 1.895831E-005 -2.71823E-005 -7.90413E-005 -0.000132072

1.895831E-005 2.270771E-005 -0.0005952657 -0.0011843261 -0.00122667

0.0001801583 7.572758E-005 -0.0015153464 -0.0030398564 -0.003198748

1.895831E-005 2.270771E-005 -0.0005952657 -0.0011843261 -0.00122667

7.846085E-008 -3.66151E-005 0.000028381 0.0001050157 0.0002064233.661506E-005 0.000145543 -3.58705E-005 -0.0006315642 -0.001235532

0.0002566744 3.661506E-005 -0.000028381 -0.0001050157 -0.000206423

3.661506E-005 -8.58953E-005 -3.58705E-005 -0.0006315642 -0.001235532

0.000348212 -0.0001781232 -0.0001180571 -0.0016839263 -0.003295253

3.661506E-005 -8.58953E-005 -3.58705E-005 -0.0006315642 -0.001235532

1.145897E-007 -5.34752E-005 2.843747E-005 0.0001062402 0.000232367

5.347519E-005 -0.0003917292 -9.49853E-006 -6.01172E-005 -0.000696973

0.0003805879 5.347519E-005 -2.84375E-005 -0.0001062402 -0.000232367

5.347519E-005 0.001241876 -9.49853E-006 -6.01172E-005 -0.000696973

-2.84375E-005 -9.49853E-006 0.0075330575 0.0084166481 0.008480165

-0.0001062402 -6.01172E-005 0.0084166481 0.0163575896 0.017325944

-0.0002323666 -0.0006969733 0.0084801647 0.0173259437 0.025430147


23/34

V8 #8 "1 "2 "3

0 0 -75.299402388 0 0

0 0 0 0 0

0 0 112.94910358 0 0

0 0 -75.299402388 0 0

0 0 0 0 0

0 0 112.94910358 0 00 0 0 0 0

0 0 -16.711857163 129.66096074 0

0 0 0 0 0

0 0 -16.711857163 129.66096074 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 -129.66096074 0 129.6609607

-8067.793113 0 0 0 0

0 121.0168967 -129.66096074 0 129.6609607

0 0 0 0 0

0 0 0 0 0

-47.418865644 165.96602975 0 0 0

-165.96602975 387.25406942 0 -129.66096074 129.6609607

8115.2119787 -165.96602975 0 0 0

-165.96602975 1016.5419322 0 -129.66096074 129.6609607

0 0 335.8287487 -185.22994392 0

0 -129.66096074 -185.22994392 370.45988784 -185.2299439

0 129.66096074 0 -185.22994392 185.2299439


24/34


25/34


26/34


27/34

"3 V7 #7

-92.61 0 -129.66 "2

0 -8067.79 0 V4

129.66 0 121.02 #4

92.61 0 129.66 "3

0 8067.79 0 V7129.66 0 242.03 #7

"3 V8 #8

-92.61 0 -129.66 "2

0 -8067.79 0 V5

129.66 0 121.02 #5

92.61 0 129.66 "3

0 8067.79 0 V8

129.66 0 242.03 #8

-1

R1-R1E

*1-*1E

R2-R2E

*2-*2E

R3-*3E

*3-*3E

R4-R4E

*4-*4E

R5-*5E

*5-*5E

R6-R6E

*6-*6E


28/34

R7-R7E

*7-*7E

R8-R8E

*8-*8E

1-1E

4-4E

7-7E

/

-5.25

-4.125

-6.375

4.6

-2.625

0.9375

-3.5-4.08333333

-3.5

4.08333333

-2

0

-7.35

-7.35

-3.15

-4.9

0

0

0


29/34

/

-0.00171802

-0.00388735

-0.00276409

-0.00064676

-0.08363636

-0.04387696-0.00275789

-0.00384324

-0.00414123

-0.00112719

-0.08381289

-0.0472394

-0.00345806

-0.00699409

-0.00474254

-0.00362312

0.00340059

0.01005376

0.02096511


30/34


31/34

)/(cc0'%/ '/%' / /6

1

,1 15 -,1

7

525 525

3 3 -2

2.0

1 1 1

3 3

1 2

A 1


32/34

%)(0/%' /% 0*(

3

,25 -.375

25

1125 2,25

3

. -135

3

135 315

2 ,

2 3


33/34

735

41 1 -41

7

35 35

7

4 5


34/34

RA 3

RVA 0

*AE 2.0

R, 3.15

RV, 0

3 *,E -1.35

4. R1 3RV1 5.25

*1E 4.1

R2 0.9

7 RV2 6.375

*2E -4.6

735 315 R3 0

RV3 2,25

*3E -0.9375

R4 0

RV4 3.5*4E 4.1

R5 0

RV5 3.5

*5E -4.1

R6 0

RV6 0

*6E 0

R7 0

RV7 7.35

*7E 7.35

R8 0

RV8 3.15

*8E 4.9

8

gustavo examen.xlsx

Documents