Category : Lotus and other Spreadsheets
Archive   : 3SPANBM.ZIP
Filename : 3SPANBM.WK1

 
Output of file : 3SPANBM.WK1 contained in archive : 3SPANBM.ZIP
#G–Š&#GGG 1< <
< < <
<1 !#/ÿÿ ñ &H G\0ÿÿÿÿÿÿÿÿÿÿÿÿÿ##G\Iÿÿÿÿÿÿÿÿÿÿÿÿÿ## &
1
&
&ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ#0ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$ÿ%ò LÍâ÷Ö÷ø >˜>>˜8° HøHøT÷MD>˜8° `ø`øTøPD9° $øȘ*ø@ aø@ ÿÿ>ø¸,P6° ^ø@ &¦LÍÿÿP^øLø[-ô#° ^øÿÿŽø0^øDDP1DSK0ø|ø2 ‚ø2 †ø2 F¼@ †$° ÒøW ùžø2 F¼@ †$° êøW¸ù@ F¼@ < Ù<&òEXAMPLE HARDY-CROSS MOMENT DISTRIBUTIONMD>˜8° `ø`øTøPD9° $øȘ*ø@ aø@ ÿÿ>ø¸,P6° ^ø@ &¦LÍÿÿP^øLø[-ô#° ^øÿÿŽø0^øDDP1DSK0ø|ø2 ‚ø2 †ø2 F¼@ †$° ÒøW ùžø2 F¼@ †$° êøW¸ù@ F¼@ < Ù<'(XAMPLE HARDY-CROSS MOMENT DISTRIBUTION(
‚B)'*ÿÿÿÿÿÿÿÿ-·'G'G'GÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿSHEAR AND MOMENT DIAGRAMàøwê@ Ù@ &THREE SPAN CONTINUOUS BEAMø8°LENGTH ˜ù@ Hù@ ÿÿ&ù¸,P6° Fù@ &¦LÍÿVALUES4ù[-ô#° Fùÿÿvù0Fù|ù0SHEARbùB8ˆqjùB8ˆMOMENT ÔJhˆ†ù‚B8ˆC†ù&¦LÍ–ù@ Ch¶ù@ <° &¦–ù@ ° PÆù¿P@ @ @ LÍ&¦ÖùÂù¢hqqh @SHEETS(h ž@INFO(hŸ@SUMPRODUCT(h  @ISRANGE(h ¡@DGET(h ¢@DQUERY(h
£@COORD(h¤@VDB(h
¥@DVARS(h
¦@DSTDS(h §@VARS(h ¨@STDS(h ©@D360(h
«@ISAPP(h
¬@ISAAF(h ­@WEEKDAY(h ®@DATEDIF(h ¯@RANK(h°@NUMBERSTRING(h±@DATESTRING(h ²@DECIMAL(h³@HEX(h´@DB(h µ@PMTI(h¶@SPI(h
·@FULLP(h
¸@HALFP(h ¹@PUREAVG(hº@PURECOUNT(h »@PUREMAX(h ¼@PUREMIN(h ½@PURESTD(h ¾@PUREVAR(h
¿@PURESTDS(h
À@PUREVARS(h Á@PMT2(hÂ@PV2(hÃ@FV2(h
Ä@TERM2(h Å@DSUM(h Æ@DAVG(h Ç@DCOUNT(h È@DMIN(h É@DMAX(h Ê@DVAR(h Ë@DSTD(h
Ì@INDEX(ÿ#'{goto}aa1~ ÿ'INSTRUCTIONS AND COMMENTSÿ'SECTION PROPERTIES ÿ'L =
 ÿ'L =
  ÿ 'L =

%Cÿ'This worksheet calculates the support moments and reactions  ÿ'EI =
 ÿ'EI =
  ÿ 'EI =

Aÿ'for a three span continuous beam. Input consists of beam Aÿ'dimensions and properties, span end conditions and uniformÿ'GEOMETRYÿ'END COND
'HINGED ÿ'CONT ÿ'CONT ÿ
'CONT ÿ 'CONT 'HINGEÿ'and concentrated loads.ÿ'END COEF
è?
ÿ
ÿ
ÿ

ÿ 
è?ÿ 'CAR COEF&ÿ €à?;&ÿ à?€à?;&ÿ à?€à?;&ÿ
à?€à?;&ÿ à?€à?;&ÿ €à?;Fÿ 'The worksheet automatically recalulates the moment distributionÿ
'DIST COEF ÿ
ð?€;Tÿ
Û¶mÛ¶mÛ?E€ÿ€þ€ ÿ€ ÿ€þ€ ÿ€ €€ €  ;Tÿ
’$I’$Iâ?E€€€ € ý€ü€ ý€ €€ €  ;Tÿ

Ҏ#íè?E€ÿ€þ€ ÿ€ ÿ€þ€ ÿ€ €€ €  ;Tÿ
·Ä©ßsKÌ?E€€€ € ý€ü€ ý€ €€ €  ; ÿ
ð?€;Eÿ
'table for all input changes and loads. Results can be printed Eÿ 'as displayed in the worksheet. Shear and moment diagrams are  ÿ 'LOADSÿ 'UNIFORM
 ¸…ëQ¸Þ?   
 ¸…ëQ¸Þ? 
 
 ¸…ëQ¸Þ?  Fÿ 'also automatically created for uniform loads only. Concentrated ÿ
'POINT

ÿ
^@




ÿ
^@






ÿ

^@

Cÿ
'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ÿ'|Kƒ\Âõ(\À<€üŸ€ôŸ
 €ýŸ€ýŸ €ôŸ€ýŸ

€ôŸ

 ƒJƒ\Âõ(\@;þ€üŸÿ€ôŸ
 þ€ýŸ€ýŸ
ÿ€ôŸ€ýŸ
 ÿ€ôŸ
ƒ^|Kƒ\Âõ(\À<€üŸ€ôŸ
 €ýŸ€ýŸ €ôŸ€ýŸ

€ôŸ

 ƒ Jƒ
\Âõ(\@;þ€üŸÿ€ôŸ
 þ€ýŸ€ýŸ
ÿ€ôŸ€ýŸ
 ÿ€ôŸ
ƒ ^|Kƒ q‚1µ`oSÀ<€üŸ€ôŸ
 €ýŸ€ýŸ €ôŸ€ýŸ

€ôŸ

 ƒ
Jƒ¡=!äíD[@;þ€üŸÿ€ôŸ
 þ€ýŸ€ýŸ
ÿ€ôŸ€ýŸ
 ÿ€ôŸ
ÿ^|5ÿ'End conditions should be specified as follows:ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-ÿ \-ÿ \-ÿ
\-ÿ\-ÿ\-ÿ'|)ƒ\Âõ(\@€€þŸ€
; ƒ9ƒ€*€€þŸ€þŸ €
€€
;ƒ^|9ƒ€*€þ€þŸ€þŸ €
€€
; ƒ 9ƒ
é».òl9K@*€€þŸ€þŸ €
€€
;ƒ ^|9ƒ 9Üïe=ç.@*€þ€þŸ€þŸ €
€€
; ƒ
)ƒ¡=!äíD[À€€þŸ€
;ÿ^|ÿ'a) Fixed - 1ÿ'|ƒ€ €ÿŸ€  ƒƒ\Âõ(\@ þ€ÿŸ€ ƒ^|ƒé».òl9;@ €ÿŸ€  ƒ ƒ
€ þ€ÿŸ€ ƒ ^|ƒ ¡=!äíDKÀ €ÿŸ€  ƒ
ƒ þ€ÿŸ€ ÿ^|9ÿ'b) Hinged - .75 (Push page-dn)ÿ'|)ƒ€€ÿŸ€
; ƒ#ƒHç|ô±*À€ÿŸ€ÿŸ €
ƒ^|#ƒ0š¨ øË1Àþ€ÿŸ€ÿŸ €
 ƒ #ƒ
WPBÇÆ=E@€ÿŸ€ÿŸ €
ƒ ^|#ƒ %µ{sœ(@þ€ÿŸ€ÿŸ €
 ƒ
)ƒ€€€ÿŸ€
;ÿ^|ÿ'|ƒ€ €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒWPBÇÆ=5@ €ÿŸ€  ƒ ƒ
0š¨ øË!À þ€ÿŸ€ ƒ ^|ƒ € €ÿŸ€  ƒ
ƒ þ€ÿŸ€ ÿ^|        !ÿ'|)ƒ€€ÿŸ€
; ƒ#ƒ&×8†ó4"À€ÿŸ€ÿŸ €
ƒ^|#ƒˆÉKšF(Àþ€ÿŸ€ÿŸ €
 ƒ #ƒ
k„¸O¸¹@€ÿŸ€ÿŸ €
ƒ ^|#ƒ Ô¿bßxÿ?þ€ÿŸ€ÿŸ €
 ƒ
)ƒ€€€ÿŸ€
;ÿ^|        !ÿ'|ƒ€ €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒk„¸O¸¹ @ €ÿŸ€  ƒ ƒ
ˆÉKšFÀ þ€ÿŸ€ ƒ ^|ƒ € €ÿŸ€  ƒ
ƒ þ€ÿŸ€ ÿ^|        !ÿ'|)ƒ€€ÿŸ€
; ƒ#ƒ–yÂÃ÷¿€ÿŸ€ÿŸ €
ƒ^|#ƒÄr÷®¯ÿ¿þ€ÿŸ€ÿŸ €
 ƒ #ƒ
¶Â`þØè@€ÿŸ€ÿŸ €
ƒ ^|#ƒ K¬'wõ?þ€ÿŸ€ÿŸ €
 ƒ
)ƒ€€€ÿŸ€
;ÿ^|        !ÿ'|ƒ€ €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒ¶Â`þØè@ €ÿŸ€  ƒ ƒ
Är÷®¯ï¿ þ€ÿŸ€ ƒ ^|ƒ € €ÿŸ€  ƒ
ƒ þ€ÿŸ€ ÿ^|ÿ'|)ƒ€€ÿŸ€
; ƒ#ƒå¦ÀGL5ð¿€ÿŸ€ÿŸ €
ƒ^|#ƒ†Þµeœõ¿þ€ÿŸ€ÿŸ €
 ƒ #ƒ
žNÖ^’®è?€ÿŸ€ÿŸ €
ƒ ^|#ƒ ˜„ÌnÌ?þ€ÿŸ€ÿŸ €
 ƒ
)ƒ€€€ÿŸ€
;ÿ^|ÿ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ \-ƒ
\-ƒ \-ƒ \-ƒ
\-ƒ\-ÿ\-ÿ'DISTRIB MOMENTÿ'|ƒ €ôŸ€þŸP ƒƒˆ ·ê`*À €ôŸ€þŸPƒ^|ƒˆ ·ê`*@ €ôŸ€þŸP ƒ ƒ
a1Ö§šOY@ €ôŸ€þŸPƒ ^|ƒ a1Ö§šOYÀ €ôŸ€þŸP ƒ
ƒ €ôŸ€þŸPÿ^|ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ \-ƒ
\-ƒ \-ƒ \-ƒ
\-ƒ\-ƒ\-ÿ 'REACTNSÿ 'FIXD END8‚ áz®Gá
@)€ìŸ€äŸ  €íŸ€äŸ€íŸ
 €äŸ  ‚ 8‚ áz®Gá
@)þ€ìŸÿ€äŸ  þ€íŸÿ€äŸ€íŸ
 ÿ€äŸ  ‚ 8‚ áz®Gá
@)€ìŸ€äŸ  €íŸ€äŸ€íŸ
 €äŸ  ‚ 8‚
áz®Gá
@)þ€ìŸÿ€äŸ  þ€íŸÿ€äŸ€íŸ
 ÿ€äŸ  ‚ 8‚ 唞߸´'@)€ìŸ€äŸ  €íŸ€äŸ€íŸ
 €äŸ  ‚
8‚ 唞߸´'@)þ€ìŸÿ€äŸ  þ€íŸÿ€äŸ€íŸ
 ÿ€äŸ ÿ!'CORRCTNS#‚!œ° ˆž%î?€ûŸ€ûŸ €ãŸ  ‚!"‚!œ° ˆž%î¿þ€ûŸ€ûŸ ÿ€ãŸ  ‚!#‚!f0ûlûX À€ûŸ€ûŸ €ãŸ  ‚ !"‚
!f0ûlûX @þ€ûŸ€ûŸ ÿ€ãŸ  ‚ !#‚ !v?¹`ûã@€ûŸ€ûŸ €ãŸ  ‚
!"‚!v?¹`ûãÀþ€ûŸ€ûŸ ÿ€ãŸ  ÿ"'FINAL‚"„Ó ¨W5@
€þŸ€ÿŸP ‚"‚"ºN àW@ €þŸ€ÿŸP ‚"‚"[#ìSAÀ €þŸ€ÿŸP ‚ "‚
"O€XM'@ €þŸ€ÿŸP ‚ "‚ "ÃäÌ··--@ €þŸ€ÿŸP ‚
"‚"Epº;"@
€þŸ€ÿŸP ÿ#'TOTAL0‚#+iT[®’B@!€ÿŸ€ÿŸ€ÿŸ€ÿŸ€ÿŸ
€ÿŸPÿ&'DIAGRAM TABLE &
ÿ&^SHEARS
&^MOMENT & &  & 
&  &  & 
& &
'!'„Ó ¨W5@ÿ€"ÿ€ ÿ€€
/' ÿ€'þ€€ þ€ þ€€

 ' '  ' 
'  '  ' 
' '%(ffffffö?€ÿŸ€š™™™™™¹? !(B[àÆm
@ÿ€"ÿ€ ÿ€€
/(3gp.Ê5@ ÿ€'þ€€ þ€ þ€€

 ( (  ( 
(  (  ( 
( (%)ffffff@€ÿŸ€š™™™™™¹? !){©=,ª@ÿ€"ÿ€ ÿ€€
/)á?ФT$@ ÿ€'þ€€ þ€ þ€€

 ) )  ) 
)  )  ) 
) )%*ÍÌÌÌÌÌ@€ÿŸ€š™™™™™¹? !*´Ãq´êI@ÿ€"ÿ€ ÿ€€
/*Ö$Ȩ«+@ ÿ€'þ€€ þ€ þ€€

 * *  * 
*  *  * 
* *%+ffffff@€ÿŸ€š™™™™™¹? !+ÛïtVRÓù?ÿ€"ÿ€ ÿ€€
/+<ñ‘¸0@ ÿ€'þ€€ þ€ þ€€

 + +  + 
+  +  + 
+ +%,@€ÿŸ€š™™™™™¹? %,ö4¦"Àÿ€"ÿ€ ÿ€€


>,2Þõe-H@/ÿ€'þ€€ þ€ þ€€


þ€€


 , ,  , 
,  ,  , 
, ,%-ÍÌÌÌÌÌ @€ÿŸ€š™™™™™¹? %-èÍy¶u#Àÿ€"ÿ€ ÿ€€


>-ò¹»žšA@/ÿ€'þ€€ þ€ þ€€


þ€€


 - -  - 
-  -  - 
- -%.š™™™™™#@€ÿŸ€š™™™™™¹? %.ÚÚÜÆÍ$Àÿ€"ÿ€ ÿ€€


>.º3,d5@/ÿ€'þ€€ þ€ þ€€


þ€€


 . .  . 
.  .  . 
. .%/ffffff&@€ÿŸ€š™™™™™¹? %/Ë­h>×%&Àÿ€"ÿ€ ÿ€€


>/™ŸzX³O@/ÿ€'þ€€ þ€ þ€€


þ€€


 / /  / 
/  /  / 
/ /%0333333)@€ÿŸ€š™™™™™¹? %0½€¶ ç}'Àÿ€"ÿ€ ÿ€€


>0,·‹‰ÅÊ#À/ÿ€'þ€€ þ€ þ€€


þ€€


 0 0  0 
0  0  0 
0 0%1,@€ÿŸ€š™™™™™¹? %1¯SøÕ(Àÿ€"ÿ€ ÿ€€


>1¼rz¤ŠÏ:À/ÿ€'þ€€ þ€ þ€€


þ€€


 1 1  1 
1  1  1 
1 1%2Ház®G,@€ÿŸ€{®Gáz„? (2‹M•#†À€"€ ÿ€€€

C2S«E};À4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

 %3ÍÌÌÌÌÌ.@€þŸ€š™™™™™¹? (3>ɇÇsñÀ€"€ ÿ€€€

C3xčAÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  3  3 
3  3  3 
3%4ÍÌÌÌÌÌ0@€ÿŸ€š™™™™™¹? (4!o#Œ”¡À€"€ ÿ€€€

C4gYF áEÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  4  4 
4  4  4 
4%53333332@€ÿŸ€š™™™™™¹? (5¿PµQÀ€"€ ÿ€€€

C5*øf‘¡IÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  5  5 
5  5  5 
5%6š™™™™™3@€ÿŸ€š™™™™™¹? (6èºZÖÀ€"€ ÿ€€€

C6 ïM­¥NÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  6  6 
6  6  6 
6%75@€ÿŸ€š™™™™™¹? (7f0ûlûX À€"€ ÿ€€€

C7—)pÑRÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  7  7 
7  7  7 
7%8ffffff6@€ÿŸ€š™™™™™¹? (8WIÏ ±!À€"€ ÿ€€€

C8¸‡
• UÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  8  8 
8  8  8 
8%9ÍÌÌÌÌÌ7@€ÿŸ€š™™™™™¹? (9I֖1 #À€"€ ÿ€€€

C9ÃêüYEBXÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  9  9 
9  9  9 
9%:3333339@€ÿŸ€š™™™™™¹? (:;©ä“,a$À€"€ ÿ€€€

C:¸R¸+µ[À4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  :  : 
:  :  : 
:%;š™™™™™:@€ÿŸ€š™™™™™¹? (;,|2ö<¹%À€"€ ÿ€€€

C;—¿Y'Hd_À4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  ;  ; 
;  ;  ; 
;%<<@€ÿŸ€š™™™™™¹? (<O€XM'À€"€ ÿ€€€

C<°ëSͧaÀ4€1ÿ€€þ€€ÿ€
 € þ€€ÿ€

  <  < 
<  <  < 
<%=…ëQ¸^<@€ÿŸ €{®Gáz„? .=ºZ­TÉÒ,@€"€ ÿ€€€
€

O=ö ß·uÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %>33333³?@€þŸ €š™™™™™¹? .>i€‘Øg )@€"€ ÿ€€€
€

O>(™õ¹H²rÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %?33333³A@€ÿŸ €š™™™™™¹? .?Vù&@€"€ ÿ€€€
€

O?m7ٝàoÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %@ÍÌÌÌ̌C@€ÿŸ €š™™™™™¹? .@´·ȅ"@€"€ ÿ€€€
€

O@½+÷ï.kÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %AffffffE@€ÿŸ €š™™™™™¹? .Aµ¦¾uðð@€"€ ÿ€€€
€

OAC` ŠOgÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %B@G@€ÿŸ €š™™™™™¹? .BÞG·PÖ@€"€ ÿ€€€
€

OBýáøŽkBdÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %Cš™™™™I@€ÿŸ €š™™™™™¹? .C˜*¢ñaw@€"€ ÿ€€€
€

OCì£ÊB”bÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %D33333óJ@€ÿŸ €š™™™™™¹? .D0™´t"B@€"€ ÿ€€€
€

ODUÕ;Ÿ`À@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %EÍÌÌÌÌÌL@€ÿŸ €š™™™™™¹? .E<>8¾gØ?€"€ ÿ€€€
€

OEiõz»`À@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %Ffffff¦N@€ÿŸ €š™™™™™¹? .FBM
¹Pö¿€"€ ÿ€€€
€

OF÷„•ý¹D`À@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 %G@P@€ÿŸ €š™™™™™¹? .G œ] À€"€ ÿ€€€
€

OG¹KÆÿRaÀ@€<ÿ€€þ€€ÿ€
€
 € þ€€ÿ€
€

 

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : 3SPANBM.ZIP
Filename : 3SPANBM.WK1

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/