copy monorail design excel

8/9/2019 Copy Monorail Design Excel

1/28

"MONORAIL" --- MONORAIL BEAM ANALYSIS

Program Description:

"MONORAIL" is a spreadsheet program written in MS-Excel for the purpose of analsis of either S-shape or

!-shape underhung monorail eams anal#ed as simple-spans with or without o$erhangs %cantile$ers&'

Specificall( the x-axis and -axis ending moments as well as an torsion effects are calculated' )he actual and

allowale stresses are determined( and the effect of lower flange ending is also addressed two different

approaches'

)his program is a wor*oo* consisting of three %+& wor*sheets( descried as follows,

Workseet Name Description

oc )his documentation sheet

S-shaped Monorail .eam Monorail eam analsis for S-shaped eams

!-shaped Monorail .eam Monorail eam analsis for !-shaped eams

Program Ass!mptions an Limitations:

/' )he following references were used in the de$elopment of this program,

a' 0luor Enterprises( Inc' - 1uideline 222'3/4'/345 - "6oisting 0acilities" %August 33( 3224&

' upont Engineering esign Standard, ./7 - "esign and Installation of Monorail .eams" %Ma 3222

c' American National Standards Institute %ANSI&, M635'/ - "8nderhung 9ranes and Monorail Satems"

d' American Institute of Steel 9onstruction %AIS9& :th Edition Allowale Stress esign %AS& Manual %/:

e' "Allowale .ending Stresses for O$erhanging Monorails" - N' Stephen )anner -

AIS9 Engineering ulication No' 5? -

"Specifications for )op Running @ 8nder Running Single 1irder Electric )ra$eling 9ranes

8tili#ing 8nder Running )rolle 6oist" %322?&

g' "esign of Monorail Sstems" - )homas 6' Orihuela h( >E and 9harlie


2/28

4' )his program contains comment oxesJ which contain a wide $ariet of information including explanations of

input or output items( eKuations used( data tales( etc' %Note, presence of a comment oxJ is denoted a

red triangleJ in the upper right-hand corner of a cell' Merel mo$e the mouse pointer to the desired cell to $ie

the contents of that particular "comment ox"'&


3/28

&

;:&

d'

ge'


4/28


5/28

"MONORAIL'xls" >rogramersion /'

4 of 3; 2F24F32/4 /4,23,45

MONORAIL BEAM ANALYSIS#or S-sape $ner!ng Monorai%s Ana%&'e as Simp%e-Spans (it ) (ito!t O*erang

Per AIS+ ,t Eition ASD Man!a% an +MAA Speciication No. /0 123304

D '222 *ips A D /?'2 in'3 dFAf D +'+3

)rolle !eight( !t D 2'?22 *ips d D /3'222 in' Ix D +2+'22

6oist !eight( !h D 2'/22 *ips tw D 2';5 in' Sx D 42'2

ert' Impact 0actor( i D /4 f D 4'?;2 in' I D /4'2

6or#' Load 0actor( 6L0 D /2 tf D 2'4: in' S D 4':

)otal No' !heels( Nw D ? *D /'?+; in' < D 3'552

!heel Spacing( S D 2'5422 ft' rt D /'342 in' 9w D 423'2

istance on 0lange( a D 2'+542 in'

S!pport Reactions: %with o$erhang&

Res!%ts: :'/+ D >$G%L%Lo-SF3&&FLwF/222F%3GL&G%L

-2'5+ D ->$G%Lo-SF3&FLwF/222F%3GL&G%L3-

Parameters an +oeicients:

>$ D 5'?22 *ips >$ D >G%/iF/22&!t!h %$ertical load&

>w D /';42 *ipsFwheel >w D >$FNw %load per trolle wheel&

>h D 2'22 *ips >h D 6L0G> %hori#ontal load&

ta D 2'?:+ in' ta D tf-fF3?aF %for S-shape&

2'/4

9xo D -2';42

9x/ D 2'22

9#o D 2'/4

9#/ D /':?; I

Is dFt

Bening Moments or Simp%e-Span: Is FtPD4F

x D ;'+/+ ft' x D /F3G%L-SF3& %location of max' moments from left end of simple-spIs Ft:4F

Mx D +/';; ft-*ips Mx D %>$F3&F%3GL&G%L-SF3&3wF/222GxF3G%L-x&

M D 3'?? ft-*ips M D %>hF3&F%3GL&G%L-SF3&3

Latera% #%ange Bening Moment rom 9orsion or Simp%e-Span: %per 8SS Steel esign Manual( /

e D '222 in' e D dF3 %assume hori#' load ta*en at ot' flange&

at D 3/'3 at D S=R)%EG9wF%


6/28


of 3; 2F24F32/4 /4,23,4;

-a6is Stresses or Simp%e-Span:

fx D 5'4 *si fx D MxFSx

LFrt D /+'32 LFrt D LG/3Frt

0x D /5'53 *si 0x D /3222G9F%LG/3G%dFAf&& PD 2'2G0 86 ;< #


7/28


5 of 3; 2F24F32/4 /4,23,4;

Y-a6is Stresses or Simp%e-Span:

f D 4'/? *si f D MFS

fwns D /'3/ *si fwns D MtG/3F%SF3& %warping normal stress&

f%total& D '+4 *si f%total& D ffwns

0 D 35'22 *si 0 D 2'54G0 8& ;< #

+om8ine Stress Ratio or Simp%e-Span:

S'R' D 2'3 S'R' D fxF0xf%total&F0 S.R. ;<

?ertica% De%ection or Simp%e-Span:

>$ D '422 *ips >$ D >!h!t %without $ertical impact&

2'/?/3 in' >$F3G%L-S&F3F%3?GEGI&G%+GL3-?G%%L-S&F3&3&4GwF/3222GL?F%+;

LF/??4

2'?4++ in' De%.1ma64 ;< De%.1a%%o

Bening Moments or O*erang:

Mx D /:'4 ft-*ips Mx D %>$F3&G%Lo%Lo-S&&wF/222GLo3F3

M D /'4; ft-*ips M D %>hF3&G%Lo%Lo-S&&

Latera% #%ange Bening Moment rom 9orsion or O*erang: %per 8SS Steel esign Manual( /Is

e D '222 in' e D dF3 %assume hori#' load ta*en at ot' flange& Is dFt

at D 3/'3 at D S=R)%EG9wF%$ D >!h!t %without $ertical impact&

2'25/4 in' >$GLo3G%LLo&F%+GEGI&wF/3222GLoG%?GLo3GL-L++GLo+&F%3?GEGI&

LF42+

2'2;22 in' De%.1ma64 ;< De%.1a%%o

Bottom #%ange Bening 1simp%iie4:

e D 5':2; in' Min' of, e D /3Gtf or SG/3 %effecti$e flange ending length&

tf3 D 2';4: in' tf3 D tf%fF3-twF3&F3G%/F& %flange th*' at we ased on /, slope of

am D /';/; in' am D %fF3-twF3&-%*-tf3& %where, *-tf3 D radius of fillet&

Mf D +'++ in'-*ips Mf D >wGam

∆%max& D ∆%max& D

∆%ratio& D ∆%ratio& D LG/3F∆%max&

∆%allow& D ∆%allow& D LG/3F?42


∆%ratio& D ∆%ratio& D LoG/3F∆%max&

∆%allow& D ∆%allow& D LoG/3F?42


8/28


; of 3; 2F24F32/4 /4,23,4;

Sf D 2'453 in'+ Sf D eGtf3F

f D 4';; *si f D MfFSf

0 D 35'22 *si 0 D 2'54G0 8 ;


9/28


: of 3; 2F24F32/4 /4,23,4;

Bottom #%ange Bening per +MAA Speciication No. /0 123304: %Note, torsion is neglected&

Loca% #%ange Bening Stress @ Point 3: %Sign con$ention, D tension( - D co

-'? *si

/'34 *si

Loca% #%ange Bening Stress @ Point 5:

?'4 *si

/?';3 *si


'? *si

-/'34 *si

Res!%tant Bia6ia% Stress @ Point 3:

/+'4 *si

-?';4 *si

2'22 *si

/'/ *si ;< #8 < 3.#& < 2C./


3+';3 *si

+'?3 *si

2'22 *si

33'+2 *si ;< #8 < 3.#& < 2C./


//'5 *si

?';4 *si

2'22 *si

/2'3? *si ;< #8 < 3.#& < 2C./

σxo D σxo D 9xoG>wFta3

σ#o D σ#o D 9#oG>wFta3

σx/ D σx/ D 9x/G>wFta3

σ#/ D σ#/ D 9#/G>wFta3

σx3 D σx3 D -σxo

σ#3 D σ#3 D -σ#o

σ# D σ# D fxf2'54Gσ#o

σx D σx D 2'54Gσxo

τx# D τx# D 2 %assumed negligile&

σto D σto D S=R)%σx3σ#3-σxGσ#+Gτx#3&

σ# D σ# D fxf2'54Gσ#/

σx D σx D 2'54Gσx/


σt/ D σt/ D S=R)%σx3σ#3-σxGσ#+Gτx#3&

σ# D σ# D fxf2'54Gσ#3

σx D σx D 2'54Gσx3


σt3 D σt3 D S=R)%σx3σ#3-σxGσ#+Gτx#3&

tw

tf

Y

>w>w

>w >w

)roll!he

S-shape


10/28


/2 of 3; 2F24F32/4 /4,23,4;

f

tafF?

twF3

>oint 3

>oint 2

>oint /


11/28


// of 3; 2F24F32/4 /4,23,4;

ta D

9xo D

9x/ D

9#o D

9#/ D

fF%3Gtf& D

dFtw D

=s D

in'?

in'+

in'?

in'+

in'?

in'

x D

Mx D

Lo&3M D

o3&

e D

at D

Mt D

fx D

Lc D

Lu D

LFrt D

faF0 D

LPDLcQ

PDallowQ

=R)%0&Q

an&=R)%0&Q

0x D

0x D

0x D

:;/&0x D

0x D

0x D

0x D

se, 0x D

λ D


12/28


/3 of 3; 2F24F32/4 /4,23,4;

f D

fwns D

86= O.>.

%continued&


13/28


/+ of 3; 2F24F32/4 /4,23,4;

S'R' D

>$ D

8&= O.>.

.3= O.>.

M D

e D

?GEGI& at D

Mt D

4= O.>.

fx D

Lc D

Lu D

LoFrt D

faF0 D

:;/&LoPDLcQ

PDallowQ

=R)%0&Q

=R)%0&Q

0x D

0x D

0x D

0x D

= O.>.0x D

0x D

0x D

se, 0x D

f D

O.>.fwns D

%total& D

0 D

= O.>.

S'R' D

>$ D

4= O.>.

e D

flange&tf3 D

am D

Mf D

∆%max& D

∆%allow& D

∆%max& D

∆%ratio& D


14/28


/? of 3; 2F24F32/4 /4,23,4;

Sf D

f D

8= O.>.

%continued&


15/28


/4 of 3; 2F24F32/4 /4,23,4;

pression&

ksi= O.>.

ksi= O.>.

ksi= O.>.

σxo D

σ#o D

σ#/ D

σx3 D

σ#3 D

σ# D

σx D

τx# D

σto D

σ# D

σx D

τx# D

σt/ D

σx D

τx# D

σt3 D

eel


16/28


17/28


/5 of 3; 2F24F32/4 /4,23,4;

MONORAIL BEAM ANALYSIS#or W-sape $ner!ng Monorai%s Ana%&'e as Simp%e-Spans (it ) (ito!t O*erang

Per AIS+ ,t Eition ASD Man!a% an +MAA Speciication No. /0 123304

D '222 *ips A D /?'2 in'3 dFAf D 3'+

)rolle !eight( !t D 2'?22 *ips d D /3'322 in' Ix D +:/'22

6oist !eight( !h D 2'/22 *ips tw D 2'+52 in' Sx D ?'32

ert' Impact 0actor( i D /4 f D ;'2;2 in' I D 4'+2

6or#' Load 0actor( 6L0 D /2 tf D 2'?2 in' S D /+':2

)otal No' !heels( Nw D ? *D /'/?2 in' < D /'5/2

!heel Spacing( S D 2'5422 ft' rt D 3'/52 in' 9w D /;;2'2

istance on 0lange( a D 2'+542 in'

S!pport Reactions: %with o$erhang&

Res!%ts: :'/+ D >$G%L%Lo-SF3&&FLwF/222F%3GL&G%L

-2'5+ D ->$G%Lo-SF3&FLwF/222F%3GL&G%L3-

Parameters an +oeicients:

>$ D 5'?22 *ips >$ D >G%/iF/22&!t!h %$ertical load&

>w D /';42 *ipsFwheel >w D >$FNw %load per trolle wheel&

>h D 2'22 *ips >h D 6L0G> %hori#ontal load&

ta D 2'?2 in' ta D tf %for !-shape&

2'2:5

9xo D -/':2+

9x/ D 2'4+4

9#o D 2'/:3

9#/ D 3'+/: I

Is dFt

Bening Moments or Simp%e-Span: Is FtPD4F

x D ;'+/+ ft' x D /F3G%L-SF3& %location of max' moments from left end of simple-spIs Ft:4F

Mx D +/';; ft-*ips Mx D %>$F3&F%3GL&G%L-SF3&3wF/222GxF3G%L-x&

M D 3'?? ft-*ips M D %>hF3&F%3GL&G%L-SF3&3

Latera% #%ange Bening Moment rom 9orsion or Simp%e-Span: %per 8SS Steel esign Manual( /

e D '/22 in' e D dF3 %assume hori#' load ta*en at ot' flange&

at D 4+'+4? at D S=R)%EG9wF%


18/28


/; of 3; 2F24F32/4 /4,23,4;

-a6is Stresses or Simp%e-Span:

fx D 4': *si fx D MxFSx

LFrt D :?'2/ LFrt D LG/3Frt

0x D 3/'2 *si 0x D /3222G9F%LG/3G%dFAf&& PD 2'2G0 86 ;< #


19/28


/: of 3; 2F24F32/4 /4,23,4;

Y-a6is Stresses or Simp%e-Span:

f D 3'// *si f D MFS

fwns D /'/ *si fwns D MtG/3F%SF3& %warping normal stress&

f%total& D +'35 *si f%total& D ffwns

0 D 35'22 *si 0 D 2'54G0 8& ;< #

+om8ine Stress Ratio or Simp%e-Span:

S'R' D 2'+:5 S'R' D fxF0xf%total&F0 S.R. ;<

?ertica% De%ection or Simp%e-Span:

>$ D '422 *ips >$ D >!h!t %without $ertical impact&

2'/2:? in' >$F3G%L-S&F3F%3?GEGI&G%+GL3-?G%%L-S&F3&3&4GwF/3222GL?F%+;

LF/;4

2'?4++ in' De%.1ma64 ;< De%.1a%%o

Bening Moments or O*erang:

Mx D /:'4 ft-*ips Mx D %>$F3&G%Lo%Lo-S&&wF/222GLo3F3

M D /'4; ft-*ips M D %>hF3&G%Lo%Lo-S&&

Latera% #%ange Bening Moment rom 9orsion or O*erang: %per 8SS Steel esign Manual( /Is

e D '/22 in' e D dF3 %assume hori#' load ta*en at ot' flange& Is dFt

at D 4+'+4? at D S=R)%EG9wF%$ D >!h!t %without $ertical impact&

2'244? in' >$GLo3G%LLo&F%+GEGI&wF/3222GLoG%?GLo3GL-L++GLo+&F%3?GEGI&

LF42

2'2;22 in' De%.1ma64 ;< De%.1a%%o

Bottom #%ange Bening 1simp%iie4:

e D 5';2 in' Min' of, e D /3Gtf or SG/3 %effecti$e flange ending length&

am D +'+44 in' am D %fF3-twF3&-%*-tf& %where, *-tf D radius of fillet&

Mf D '325 in'-*ips Mf D >wGam

Sf D 2'43? in'+ Sf D eGtf3F


∆%ratio& D ∆%ratio& D LG/3F∆%max&

∆%allow& D ∆%allow& D LG/3F?42


∆%ratio& D ∆%ratio& D LoG/3F∆%max&

∆%allow& D ∆%allow& D LoG/3F?42


20/28


32 of 3; 2F24F32/4 /4,23,4;

f D //';? *si f D MfFSf

0 D 35'22 *si 0 D 2'54G0 8 ;


21/28


3/ of 3; 2F24F32/4 /4,23,4;

Bottom #%ange Bening per +MAA Speciication No. /0 123304: %Note, torsion is neglected&

Loca% #%ange Bening Stress @ Point 3: %Sign con$ention, D tension( - D co

-;'2 *si

2';5 *si


3'?3 *si

/2'?5 *si


;'2 *si

-2';5 *si


;'53 *si

-'?4 *si

2'22 *si

/+'/; *si ;< #8 < 3.#& < 2C./


/4':3 *si

/';/ *si

2'22 *si

/4'2: *si ;< #8 < 3.#& < 2C./


5'?/ *si

'?4 *si

2'22 *si

':; *si ;< #8 < 3.#& < 2C./

σxo D σxo D 9xoG>wFta3

σ#o D σ#o D 9#oG>wFta3

σx/ D σx/ D 9x/G>wFta3

σ#/ D σ#/ D 9#/G>wFta3

σx3 D σx3 D -σxo

σ#3 D σ#3 D -σ#o

σ# D σ# D fxf2'54Gσ#o

σx D σx D 2'54Gσxo


σto D σto D S=R)%σx3σ#3-σxGσ#+Gτx#3&

σ# D σ# D fxf2'54Gσ#/

σx D σx D 2'54Gσx/


σt/ D σt/ D S=R)%σx3σ#3-σxGσ#+Gτx#3&

σ# D σ# D fxf2'54Gσ#3

σx D σx D 2'54Gσx3


σt3 D σt3 D S=R)%σx3σ#3-σxGσ#+Gτx#3&

tw

>w >w

>oint 3

Y


22/28


33 of 3; 2F24F32/4 /4,23,4;

>oint /

>oint 2

f

tf


23/28


3+ of 3; 2F24F32/4 /4,23,4;

ta D

9xo D

9x/ D

9#o D

9#/ D

fF%3Gtf& D

dFtw D

=s D

in'?

in'+

in'?

in'+

in'?

in'

x D

Mx D

Lo&3M D

o3&

e D

at D

Mt D

fx D

Lc D

Lu D

LFrt D

faF0 D

LPDLcQ

PDallowQ

=R)%0&Q

an&=R)%0&Q

0x D

0x D

0x D

:;/&0x D

0x D

0x D

0x D

se, 0x D

λ D


24/28


25/28


34 of 3; 2F24F32/4 /4,23,4;

S'R' D

>$ D

8&= O.>.

.3= O.>.

M D

e D

?GEGI& at D

Mt D

4= O.>.

fx D

Lc D

Lu D

LoFrt D

faF0 D

:;/&LoPDLcQ

PDallowQ

=R)%0&Q

=R)%0&Q

0x D

0x D

0x D

0x D

= O.>.0x D

0x D

0x D

se, 0x D

f D

O.>.fwns D

%total& D

0 D

= O.>.

S'R' D

>$ D

4= O.>.

e D

tf3 D

am D

Mf D

∆%max& D

∆%allow& D

∆%max& D

∆%ratio& D


26/28


27/28


35 of 3; 2F24F32/4 /4,23,4;

pression&

ksi= O.>.

!3?

!3?

ksi= O.>.

!3?

!3?

!3?

!3?

!3?

ksi= O.>.

!3?

!3?

!3?

!3?

!3?

!3?

!3

!3

!3

!3

!3

!3

!3/

!3/

!3/

!3/

!3/

!3/

σxo D

σ#o D

σ#/ D

σx3 D

σ#3 D

σ# D

σx D

τx# D

σto D

σ# D

σx D

τx# D

σt/ D

σx D

τx# D

σt3 D


28/28


!3/

!3/

!3/

!3/

!3/

copy monorail design excel

Documents