portico hoja excel ejemplo apoyo ficticio

30
1 2 3 4 5 6 1 2 +M=0 1 12.073 0.703 0 2.667 0 0 2.667 2.667 0 2 0.703 13.948 0.938 0 2.667 0 2.667 2.667 2.25 3 0 0.938 12.542 0 0 2.667 2.667 2.667 -2.25 4 2.667 0 0 6.740 0.703 0 0 2.667 5.33 5 0 2.667 0 0.703 8.615 0.938 0 2.667 -5.33 6 0 0 2.667 0 0.938 7.208 0 2.667 0 1 2.667 2.667 2.667 0 0 0 5.333 0 -10 2 2.667 2.667 2.667 2.667 2.667 2.667 0 5.333 -4 0.132203825 0.028529277 0.039840743 -0.00565544 0.027312658 0.027993275 -0.10028692 -0.12511217 0.028529277 0.105726497 0.025680434 0.032625132 -0.00488571 0.031716319 -0.0799681 -0.10969598 0.039840743 0.025680434 0.12489326 0.029321393 0.027731963 -0.00495155 -0.09520722 -0.12125812 -0.00565544 0.032625132 0.029321393 0.21625163 0.019787996 0.049877899 -0.02814554 -0.17110431 0.027312658 -0.00488571 0.027731963 0.019787996 0.150756994 0.013444305 -0.02507946 -0.11707411 0.027993275 0.031716319 -0.00495155 0.049877899 0.013444305 0.197113264 -0.02737902 -0.15759676 -0.10028692 -0.0799681 -0.09520722 -0.02814554 -0.02507946 -0.02737902 0.325231123 0.178033135 -0.12511217 -0.10969598 -0.12125812 -0.17110431 -0.11707411 -0.15759676 0.178033135 0.588420719

Upload: nestor-gonzalo-vera-chavez

Post on 26-Oct-2014

83 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: Portico  hoja excel ejemplo apoyo ficticio

1 2 3 4 5 6 1 2 +M=0 -M=0 41 12.073 0.703 0 2.667 0 0 2.667 2.667 0 02 0.703 13.948 0.938 0 2.667 0 2.667 2.667 2.25 -2.253 0 0.938 12.542 0 0 2.667 2.667 2.667 -2.25 2.254 2.667 0 0 6.740 0.703 0 0 2.667 5.33 -5.33 M=5 0 2.667 0 0.703 8.615 0.938 0 2.667 -5.33 5.336 0 0 2.667 0 0.938 7.208 0 2.667 0 01 2.667 2.667 2.667 0 0 0 5.333 0 -10 10 42 2.667 2.667 2.667 2.667 2.667 2.667 0 5.333 -4 4

ΔB0.132203825 0.028529277 0.039840743 -0.00565544 0.027312658 0.027993275 -0.10028692 -0.12511217 -1.30206 4.3955901190.028529277 0.105726497 0.025680434 0.032625132 -0.00488571 0.031716319 -0.0799681 -0.10969598 -1.618520.039840743 0.025680434 0.12489326 0.029321393 0.027731963 -0.00495155 -0.09520722 -0.12125812 -1.22226 M=-0.00565544 0.032625132 0.029321393 0.21625163 0.019787996 0.049877899 -0.02814554 -0.17110431 -2.020390.027312658 -0.00488571 0.027731963 0.019787996 0.150756994 0.013444305 -0.02507946 -0.11707411 0.0528660.027993275 0.031716319 -0.00495155 0.049877899 0.013444305 0.197113264 -0.02737902 -0.15759676 -1.18083 6-0.10028692 -0.0799681 -0.09520722 -0.02814554 -0.02507946 -0.02737902 0.325231123 0.178033135 3.946414-0.12511217 -0.10969598 -0.12125812 -0.17110431 -0.11707411 -0.15759676 0.178033135 0.588420719 4.39559

M=

ΔA3.946414401

1

M=

B4
Ʃ Kc1+Kv1+Kc4
C4
a viga 1
E4
a col4
H4
b col1
I4
b col 4
C5
Ʃ Kc2+ Kv1+Kv2+Kc5
D5
a viga2
F5
a col5
H5
b col2
I5
b col5
D6
Ʃ kc3+kv2+kc6
G6
a col 6
H6
b col 3
I6
b col 6
E7
Ʃ kc4+kv3
F7
a viga 3
I7
b col 4
F8
Ʃ kc5+kv3+kv4
G8
a viga 4
I8
b col 5
G9
Ʃ kc6+kv4
I9
b col 6
H10
T1
I11
T2
Page 2: Portico  hoja excel ejemplo apoyo ficticio

10

123456

ABCD

Page 3: Portico  hoja excel ejemplo apoyo ficticio

5.33 -5.33 0.00 0.00k= 1.406

w= 4 t/m k= 1.875-2.02039128 C a= 0.703 0.052866039 D a= 0.938 -1.18082619

2.529329525 -6.67957809 -1.00790073 -2.1644871970026-2.52599619 M= 7.687478817 es 2.164487197

5 6k= 5.3333 k= 5.3333 k= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667t= 1.778 t= 1.778 t= 1.778

-0.61043577 M= 3.230455669 M= 2.054010276-2.96903664 -3.19154864 -1.93058467 -6.0590884824643

0 0 2.25 k= 1.875 -2.25k= 1.406 w= 3 t/m

-1.30205612 A a= 0.703 -1.61851764 B a= 0.938 -1.22225504

3.5794724 M= 1.8916777 M= 4.005078206

k= 5.333 k= 5.3333 k= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667

2 3t= 1.778 t= 1.778 t= 1.778

7.0516221 M= 6.2077247 M= 7.2644250

Page 4: Portico  hoja excel ejemplo apoyo ficticio

= 10.00 3.54369816 2.699800781 3.756501059

T1= 5.333T2= 5.333

COLUMNASb h Lc k a b

30 40 3 5.3333 2.667 2.66730 40 3 5.3333 2.667 2.66730 40 3 5.3333 2.667 2.66730 40 3 5.3333 2.667 2.66730 40 3 5.3333 2.667 2.66730 40 3 5.3333 2.667 2.667

vigasb h Lv k W a MOMENTOS

25 30 4 1.406 0 0.703 0 025 30 3 1.875 3 0.938 2.25 -2.2525 30 4 1.406 4 0.703 5.33 -5.3325 30 3 1.875 0 0.938 0 0

Page 5: Portico  hoja excel ejemplo apoyo ficticio

4.550519947669 -4.85171708 1.36517056583512 0.4022799

5.33 1.406 -5.33 0 1.875 0-4.55051995 4 -0.970544840125 0.703 5 0.827755087306699 0.938 6 -0.199328237723

-0.402279953.48654651668636

K= 5.3333 K= 5.3333 K= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667

0.351052334919125 0.790066005

-1.33668117 0.085242775003 -0.32446811 1.82971034343808 -2.111673976341

0 1.406 0 2.25 1.875 -2.250.234644699875 0.703 -0.34805523085601 0.938 0.2478014947126

1.251438399 -1.85629456456541 1.321607972

K= 5.3333 K= 5.3333 K= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667

0.6257192 -0.9281472822827 0.660803986

1 2 3

Page 6: Portico  hoja excel ejemplo apoyo ficticio

COLUMNASb h Lc k a b

1 30 40 3 5.3333 2.667 2.6672 30 40 3 5.3333 2.667 2.6673 30 40 3 5.3333 2.667 2.6674 30 40 3 5.3333 2.667 2.6675 30 40 3 5.3333 2.667 2.6676 30 40 3 5.3333 2.667 2.667

VIGASb h Lv k W a MOMENTOS

25 30 4 1.406 0 0.703 0 025 30 3 1.875 3 0.938 2.25 -2.2525 30 4 1.406 4 0.703 5.33 -5.3325 30 3 1.875 0 0.938 0 0

Page 7: Portico  hoja excel ejemplo apoyo ficticio

1 2 3 4 5 6 +m=0 =-m Incognitas

1 12.073 0.703 0 2.667 0 0 0 0 0.2346446998747972 0.703 13.948 0.938 0 2.667 0 2.25 -2.25 -0.3480552308560143 0 0.938 12.542 0 0 2.667 -2.25 2.25 0.2478014947126474 2.667 0 0 6.740 0.703 0 5.33 -5.33 -0.9705448401254255 0 2.667 0 0.703 8.6146 0.938 -5.33 5.33 0.8277550873066996 0 0 2.667 0 0.938 7.208 0 0 -0.199328237722602

0.091238119 -0.00555696 0.000594903 -0.03660111 0.004799448 -0.00084429-0.00555696 0.077212757 -0.00701268 0.004799448 -0.0249283 0.0058364070.000594903 -0.00701268 0.087285601 -0.00084429 0.005836407 -0.0330497-0.03660111 0.004799448 -0.00084429 0.164440349 -0.01515586 0.0022834750.004799448 -0.0249283 0.005836407 -0.01515586 0.127069359 -0.01868549-0.00084429 0.005836407 -0.0330497 0.002283475 -0.01868549 0.153384996

Page 8: Portico  hoja excel ejemplo apoyo ficticio

REACCIONES COLUMNAS

1.9624004 -1.27919962 -0.12926202 0.553938738159727

-1.96240037 1.279199617 0.129262019 -0.553938738159728

-0.6257192 0.928147282 -0.66080399 -0.358375903283816

0.6257192 -0.92814728 0.660803986 0.358375903283816

Page 9: Portico  hoja excel ejemplo apoyo ficticio

0.7431824 0.6337949568 0.8085974678 0.917985

0.00 1.406 0.00 0 1.875 0-0.74318238 4 0.404181240344004 0.703 5 0.2486080157 0.938 6 0.3652879342

-0.9179848914

-2.667 -2.667 -1.4423924246 -2.667

K= 5.3333 K= 5.3333 K= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667

-2.667 -2.667 -2.667-2.2069823084 -2.0916065896

-2.05314802 -0.149220659038591 -0.1148078353 -0.1416061725 -0.1760189962

0 1.406 0 0 1.875 0-0.087055873301133 0.703 -0.0381131907 0.938 -0.0748202027

2.202368676 2.667 2.667 2.4633963163 2.667 2.2676255859

K= 5.3333 K= 5.3333 K= 5.3333a= 2.667 a= 2.667 a= 2.667b= 2.667 b= 2.667 b= 2.667

2.434517671 2.5650314915 2.4671461263

1 2 32.667 2.667 2.667

4.8 1.54562878230809 1.6761426026 1.5782572374

Page 10: Portico  hoja excel ejemplo apoyo ficticio

COLUMNASb h Lc k a b

1 30 40 3 5.3333 2.667 2.6672 30 40 3 5.3333 2.667 2.6673 30 40 3 5.3333 2.667 2.6674 30 40 3 5.3333 2.667 2.6675 30 40 3 5.3333 2.667 2.6676 30 40 3 5.3333 2.667 2.667

VIGASb h Lv k W a MOMENTOS

25 30 4 1.406 0 0.703 0 025 30 3 1.875 0 0.938 0 025 30 4 1.406 0 0.703 0 025 30 3 1.875 0 0.938 0 0

Page 11: Portico  hoja excel ejemplo apoyo ficticio

1 2 3 4 5 6 +m=0 =-m Incognitas

1 12.073 0.703 0 2.667 0 0 0 0 -0.08705592 0.703 13.948 0.938 0 2.667 0 0 0 -0.03811323 0 0.938 12.542 0 0 2.667 0 0 -0.07482024 2.667 0 0 6.740 0.703 0 -2.667 2.667 0.404181245 0 2.667 0 0.703 8.6146 0.938 -2.667 2.667 0.248608026 0 0 2.667 0 0.938 7.208 -2.667 2.667 0.36528793

0.09123811939 -0.005557 0.000595 -0.0366011148 0.004799 -0.000844-0.00555696268 0.077213 -0.007013 0.0047994479 -0.024928 0.0058360.00059490344 -0.007013 0.087286 -0.0008442855 0.005836 -0.03305

-0.03660111483 0.004799 -0.000844 0.1644403491 -0.015156 0.0022830.00479944788 -0.024928 0.005836 -0.0151558584 0.127069 -0.018685

-0.00084428553 0.005836 -0.03305 0.0022834745 -0.018685 0.153385

Page 12: Portico  hoja excel ejemplo apoyo ficticio

REACCIONES EN LAS COLUMNAS

0.93211 1.2164582443 1.003 3.151766

-4.8

-0.93211013233 -1.2164582443 -1.003-7.9517941593

-1.54562878231 -1.6761426026 -1.578

1.54562878231 1.6761426026 1.5783 4.8

Page 13: Portico  hoja excel ejemplo apoyo ficticio

-0.5939617 -0.5189871214 -0.6669912953

0.00 1.406 0.00 0 1.8750.593962 4 -0.317125367 0.703 5 -0.210494825 0.938

2.667 2.667 1.1859784167

K= 5.3333 K= 5.3333a= 2.667 a= 2.667b= 2.667 b= 2.667

2.667 2.6671.3892487671

1.05826 -0.2955204032 -0.2893714508 -0.3837789502

0 1.406 0 0 1.875-0.1430136204 0.703 -0.1342684436 0.938

-0.762739 -0.7160983661

K= 5.3333 K= 5.3333a= 2.667 a= 2.667b= 2.667 b= 2.667

-0.38137 -0.3580491831

1 20.000 0.000

-1.1 -0.3813696545 -0.3580491831

COLUMNASb h Lc k

1 30 40 3 5.33332 30 40 3 5.33333 30 40 3 5.33334 30 40 3 5.33335 30 40 3 5.33336 30 40 3 5.3333

VIGASb h Lv k W

25 30 4 1.406 025 30 3 1.875 025 30 4 1.406 025 30 3 1.875 0

Page 14: Portico  hoja excel ejemplo apoyo ficticio

-0.7419659

0 1 2 3

6 -0.290468 1 12.073 0.703 00.74196589512 2 0.703 13.948 0.938

2.667 3 0 0.938 12.5424 2.667 0 0

K= 5.3333 5 0 2.667 0a= 2.667 6 0 0 2.667b= 2.667

2.6671.14100697592 0.091238 -0.005557 0.000595

-0.005557 0.077213 -0.007013-0.3899279026 0.000595 -0.007013 0.087286

0 -0.036601 0.004799 -0.000844-0.140827 0.004799 -0.024928 0.005836

-0.7510790733 -0.000844 0.005836 -0.03305K= 5.3333 a= 2.667b= 2.667

-0.37553953665

30.000

-0.37554REACCIONES COLUMNAS

a b2.667 2.6672.667 2.667 -0.55072.667 2.6672.667 2.6672.667 2.6672.667 2.667

a MOMENTOS0.703 0 0 0.550740.938 0 00.703 0.00 0.000.938 0 0 0.38137

Page 15: Portico  hoja excel ejemplo apoyo ficticio

-0.38137

Page 16: Portico  hoja excel ejemplo apoyo ficticio

4 5 6 +m=0 =-m Incognitas

2.667 0 0 2.667 -2.667 -0.1430140 2.667 0 2.667 -2.667 -0.1342680 0 2.667 2.667 -2.667 -0.140827

6.740 0.703 0 2.667 -2.667 -0.3171250.703 8.6146 0.938 2.667 -2.667 -0.210495

0 0.938 7.208 2.667 -2.667 -0.290468

-0.036601 0.004799 -0.0008440.004799 -0.024928 0.005836

-0.000844 0.005836 -0.033050.16444 -0.015156 0.002283

-0.015156 0.127069 -0.0186850.002283 -0.018685 0.153385

-0.858409 -0.627658 -2.03681

1.114958

0.858409 0.6276583.151766

0.358049 0.37554

Page 17: Portico  hoja excel ejemplo apoyo ficticio

-0.358049 -0.37554 -1.114958

Page 18: Portico  hoja excel ejemplo apoyo ficticio

PISO ETAPA 1 ETAPA 2 ETAPA P =-P SOLUCIONᾳ 1 1 -7.95179 3.151765537 6 -6 3.964443766833ᾳ 2 2 3.151766 -2.036807163 4 -4 8.098457988158

-0.32523 -0.503264257-0.50326 -1.269718111

2.68665 -6.54207 -0.830791 -1.9672

-2.686651 7.37286 1.9672

4.1340140

2.85237-1.839697 -5.96731 1.738406

-0.90600 -2.89959 -3.12308

3.805593 2.11041 4.22889977

3.9644440.0

7.188721 6.34113 7.400374908

3.66477 2.81718 3.87642

Δ1

MOMENTOS FINALES

Δt

Δ B

Δ A

Page 19: Portico  hoja excel ejemplo apoyo ficticio

10 = 10

Page 20: Portico  hoja excel ejemplo apoyo ficticio

etapa 013.472 1.406 0 2.667 0 0 1.333 -1.333

1.406 10.957 1.406 0 2.667 0 0 00 1.406 13.478 0 0 2.667 -1.333 1.333

2.667 0 0 8.145 1.406 0 1 -10 2.667 0 1.406 10.957 1.406 0 00 0 2.667 0 1.406 8.145 -1 1

etapa 1

13.472 1.406 0 2.667 0 0 0 01.406 10.957 1.406 0 2.667 0 -2.667 2.667

0 1.406 13.478 0 0 2.667 0 02.667 0 0 8.145 1.406 0 -2.667 2.667

0 2.667 0 1.406 10.957 1.406 -2.667 2.6670 0 2.667 0 1.406 8.145 -2.667 2.667

etapa2

13.472 1.406 0 2.667 0 0 2.667 -2.6671.406 10.957 1.406 0 2.667 0 2.667 -2.667

0 1.406 13.478 0 0 2.667 2.667 -2.6672.667 0 0 8.145 1.406 0 2.667 -2.667

0 2.667 0 1.406 10.957 1.406 2.667 -2.6670 0 2.667 0 1.406 8.145 2.667 -2.667

Page 21: Portico  hoja excel ejemplo apoyo ficticio

-0.0798150.0000060.079776

-0.096639-0.0000030.096653

-0.09299439630.24377847873-0.09295012980.341232832910.096496892440.34121833829

-0.1272944218-0.1784964563-0.1272338281-0.2628884635-0.1324887921-0.2629083043