Category : Lotus and other Spreadsheets
Archive   : 4SPANBM.ZIP
Filename : 4SPANBM.WK3

R#




&
#

R
R
R

"


"

"


"

"

"


#





&HEI = MI MI




\0õŠõ#Î
ÿ5## \IõŠõ#Î
ÿ5##

G9õ#Î
ÿ5'R

G:õ#Î
ÿ5'R

G?õ#Î
ÿ5'R

P3õ#Î
ÿ5#
DT0õ#Î
ÿ5& 1
DT1õ#Î
ÿ5&
&

DT2õ#Î
ÿ5& 1
DT3õ#Î
ÿ5&
&
!

 €ÿ?øÿ@
V



‚BLB*
EXAMPLE HARDY-CROSS MOMENT DISTRIBUTION²








qqq
SHEAR

MOMENT
LENGTH

VALUES
SHEAR AND MOMENT DIAGRAM

FOUR SPAN CONTINUOUS BEAM(ÿ€ÿ€ÿ€ÿ€ÿ€ÿ€  ÿ€€0
ÿ€ÿ€ÿ€ÿ€ÿÿ€ƒ€ÿ€ƒ€ÿ€€ÿ€ƒ€ ÿ€‚€! "!
#ÿ€‚&ÿ€ÿ€'ÿ€€
€(')(*)+*,+-,.-/.0/102ÿ€€
3ÿ€€
ÿ€435465768798:9;:<;=2>=?>@?A@BACBDCEDFEGFHGIHJIKJLKMLNMONPOQPRQ
ñ''INSTRUCTIONS AND COMMENTS#'{goto}aa1~
'SECTION PROPERTIES
'L =P
'L = P
 'L =
P
'L =PB'This worksheet calculates the support moments and reactions 
'EI =
'EI = 
 'EI =

'EI =?'for a four span continuous beam. Input consists of beam @'dimensions and properties, span end conditions and uniform
'GEOMETRY'END COND 'HINGED
'CONT
'CONT

'CONT
 'CONT
'CONT
'CONT 'HINGED'and concentrated loads.'END COEF
  'CAR COEF 

; €þ?

; €þ?

;
€þ?


; €þ?
 
; €þ?

; €þ?

; 

;E 'The worksheet automatically recalulates the moment distribution
'DIST COEF
€ÿ?

;]
mÛ¶mÛ¶mÛý?










 ;]
I’$I’$I’þ?




 






 ;]

€þ?




 


 




;]
€þ?
 







 




;]
I’$I’$I’þ?



 




 




;]
mÛ¶mÛ¶mÛý?






 




;
€ÿ?

;D
'table for all input changes and loads. Results can be printed D'as displayed in the worksheet. Shear and moment diagrams are 
'LOADS
'UNIFORM    E 'also automatically created for uniform loads only. Concentrated
'POINT


^@




^@





^@




^@

B
'loads must be added to the spans in the diagram table at the>'correct location (and to subsequent nodes to the right).\-\-\-\-\-\- \-
\-\- \-
\-\-\-\-\-\-\-
'FIXD END MOMENT'|QUUUUUUU…À
 
0







PUUUUUUU…@
 
0







^|QUUUUUUU…À
 
 0









 P
UUUUUUU…@
 
 0









 ^|Q UUUUUUU…À
 

0









PUUUUUUU…@


0









^|QUUUUUUU…À
 
0







PUUUUUUU…@
 
0







^|4'End conditions should be specified as follows:\-\-\-\-\-\- \-
\-\- \-
\-\-\-\-\-\-\-'|+UUUUUUU…@




;>€







;^|>€







;>
€




 







;^|> €
 


 


 

;>€







;^|>€







;+UUUUUUU…À




;^|'a) Fixed - 1'|€

 UUUUUUU…@

 ^|€


 
€


^| €

 €

 ^|UUUUUUU…À

 €

 ^|2'b) Hinged - .75 (Push page-dn)'|+




;%‘$I’$I’ä
À



^|%a†a†a˜À



%



 


^|%


 

%a†a†a˜@



^|%‘$I’$I’ä
@



+




;^|'|€

 

 ^|


 
a†a†a˜
À


^| a†a†a˜
@

 

 ^|

 

 ^|'|+




;%€



^|%€



%
€


 


^|% €


 

%€



^|%€



+€




;^|'|€

 

 ^|€


 
€


^| €

 €

 ^|€

 €

 ^|'|+




;%€



^|%€



%



 


^|%


 

%



^|%



+




;^|'|€

 

 ^|


 
€


^|

 

 ^|

 

 ^|'|+




;%€



^|%€



%
€


 


^|% €


 

%€



^|%€



+€




;^|\-\-\-\-\-\- \-
\-\- \-
\-\-\-\-\-\-\-
'DISTRIB MOMENT'|¿P
nÛ¶mÛ¶m«@¿P
^|mÛ¶mÛ¶m«À¿P

’$I’$I’ä@¿

P
^| ’$I’$I’äÀ¿  P
mÛ¶mÛ¶m«@¿P
^|nÛ¶mÛ¶m«À¿P
¿P
^|\-\-\-\-\-\- \-
\-\- \-
\-\-\-\-\-\-\-

'REACTNS 'FIXD END=  @
 






=  @
 






=  @
 
 






 =
 @
 
 






 =  @










=  @










=  @
 






=  @
 






!'CORRCTNS%!%I’$I’$‰À


$!%I’$I’$‰@


%!Ú¶mÛ¶mÛ¶þ?



 $!
Ú¶mÛ¶mÛ¶þ¿



 %! Ú¶mÛ¶mÛ¶þ¿



$!Ú¶mÛ¶mÛ¶þ?



%!%I’$I’$‰@


$!%I’$I’$‰À


"'FINAL"nÛ¶mÛ¶mû
@
 
!P"I’$I’$IÂ@¿ !P
"nÛ¶mÛ¶m«@¿ !P
"
’$I’$I’”@¿
!
P
" ’$I’$I’”@¿ ! P
"nÛ¶mÛ¶m«@¿ !P
"I’$I’$IÂ@¿ !P
"nÛ¶mÛ¶mû
@
 
!P#'TOTALA# @
"
"
"
"

"
"
"
"P&
'DIAGRAM TABLE &^SHEARS &^MOMENT'
#'nÛ¶mÛ¶mû
@
"
 
'2'
'
'
 
' (€@
'
‰ #(nÛ¶mÛ¶m»
@
"
 
(2(nÛ¶mÛ¶mÛ@
'
(
 
( )€
@
(
‰ #)ܶmÛ¶mÛö@
"
 
)2)nÛ¶mÛ¶m»@
'
)
 
) *À
@
)
‰ #*¸mÛ¶mÛ¶íÿ?
"
 
*2*$I’$I’$é@
'
*
 
* +€@
*
‰ #+@’$I’$I’ü¿
"
 
+2+ܶmÛ¶mÛö@
'
+
 
+ , @
+
‰ #,$I’$I’$‰À
"
 
,H,”$I’$I’ä@
'
,
 
,


,

 -À@
,
‰ #-’$I’$I’„
À
"
 
-H-H’$I’$I²@
'
-
 
-


-

 .à@
-
‰ #.’$I’$I’Ä
À
"
 
.H.À@
'
.
 
.


.

 /€@
.
‰ #/I’$I’$I‚À
"
 
/H/@’$I’$I’À
'
/
 
/


/

 0@
/
‰ #0I’$I’$I¢À
"
 
0H0$I’$I’¤À
'
0
 
0


0

 1 @
0
‰ #1I’$I’$IÂÀ
"
 
1H1lÛ¶mÛ¶m«À
'
1
 
1


1

 2š™™™™™™¡@
1
 ‹ +2:¨ƒ:¨ƒ:¨@
"
 
2
I2RË#˜èï¢À
1
2
2

 
2
 3°@
1
 ‰ +3nÛ¶mÛ¶m‹@
"
 
3
I3jÛ¶mÛ¶m»À
1
3
3

 
3
 4À@
3
 ‰ +4ܶmÛ¶mÛÖ
@
"
 
4
I4ðÿÿÿÿÿÿÿ
À
1
4
4

 
4
 5Ð@
4
 ‰ +5ܶmÛ¶mۖ
@
"
 
5
I5Û¶mÛ¶mÛ@
1
5
5

 
5
 6à@
5
 ‰ +6¸mÛ¶mÛ¶­@
"
 
6
I6ÀmÛ¶mÛ¶­@
1
6
6

 
6
 7ð@
6
 ‰ +7à¶mÛ¶mÛ¶þ?
"
 
7
I7œ$I’$I’ä@
1
7
7

 
7
 8€@
7
 ‰ +8$I’$I’¤ÿ¿
"
 
8
I8xÛ¶mÛ¶mÛ@
1
8
8

 
8
 9ˆ@
8
 ‰ +9H’$I’$IÒÀ
"
 
9
I9P’$I’$I’@
1
9
9

 
9
 :@
9
 ‰ +:$I’$I’$©
À
"
 
:
I:“$I’$I’þ?
1
:
:

 
:
 ;˜@
:
 ‰ +;$I’$I’$é
À
"
 
;
I;ðÿÿÿÿÿÿ¿À
1
;
;

 
;
 < @
;
 ‰ +<’$I’$I’”À
"
 
<
I<ˆ$I’$I’äÀ
1
<
<

 
<
 =ÍÌÌÌÌÌÌ @
<

‹ 2=^ñ_ñ_‘@
"

=

 W=Ÿ–7F0ÑßÕÀ
<
=
=




=


 >¨@
<

‰ 2>$I’$I’$é
@
"

>

 W>ìÿÿÿÿÿÿ¿À
<
>
>




>


 ?°@
>

‰ 2?$I’$I’$©
@
"

?

 W?€“$I’$I’þ?
<
?
?




?


 @¸@
?

‰ 2@H’$I’$IÒ@
"

@

 W@\’$I’$I’@
<
@
@




@


 AÀ@
@

‰ 2A$I’$I’¤ÿ?
"

A

 WA€Û¶mÛ¶mÛ@
<
A
A




A


 BÈ@
A

‰ 2Bà¶mÛ¶mÛ¶þ¿
"

B

 WB¤$I’$I’ä@
<
B
B




B


 CÐ@
B

‰ 2C¸mÛ¶mÛ¶­À
"

C

 WCÈmÛ¶mÛ¶­@
<
C
C




C


 DØ@
C

‰ 2DܶmÛ¶mۖ
À
"

D

 WDÀÛ¶mÛ¶mÛ@
<
D
D




D


 Eà@
D

‰ 2EܶmÛ¶mÛÖ
À
"

E

 WEàÿÿÿÿÿÿÿ
À
<
E
E




E


 Fè@
E

‰ 2FnÛ¶mÛ¶m‹À
"

F

 WFhÛ¶mÛ¶m»À
<
F
F




F


 Gð@
F

‰ 2GnÛ¶mÛ¶m«À
"

G

 WGlÛ¶mÛ¶m«À
<
G
G




G


 HÍÌÌÌÌÌÌð@
G
‹ 9H_ñ_ñ¿@
"
 
H

 
eH.‚‰þNVË¡À
G
H
H




 
H



 Iø@
G
‰ 9II’$I’$I¢@
"
 
I

 
eI$I’$I’¤À
G
I
I




 
I



 J€@
I
‰ 9JI’$I’$I‚@
"
 
J

 
eJ0’$I’$I’À
G
J
J




 
J



 K„@
J
‰ 9K’$I’$I’Ä
@
"
 
K

 
eKÀ@
G
K
K




 
K



 Lˆ@
K
‰ 9L’$I’$I’„
@
"
 
L

 
eLL’$I’$I²@
G
L
L




 
L



 MŒ@
L
‰ 9M$I’$I’$‰@
"
 
M

 
eM•$I’$I’ä@
G
M
M




 
M



 N@
M
‰ 9N@’$I’$I’ü?
"
 
N

 
eNÞ¶mÛ¶mÛö@
G
N
N




 
N



 O”@
N
‰ 9O¸mÛ¶mÛ¶íÿ¿
"
 
O

 
eO(I’$I’$é@
G
O
O




 
O



 P˜@
O
‰ 9PܶmÛ¶mÛöÀ
"
 
P

 
ePpÛ¶mÛ¶m»@
G
P
P




 
P



 Qœ@
P
‰ 9QnÛ¶mÛ¶m»
À
"
 
Q

 
eQpÛ¶mÛ¶mÛ@
G
Q
Q




 
Q



 R @
Q
‰ 9RnÛ¶mÛ¶mû
À
"
 
R

 
eR
G
R
R




 
R




-