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

 
Output of file : 2SPANBM.WK1 contained in archive : 2SPANBM.ZIP
;–";!;;;; ;
; ; ;
0 /ÿ ñ
&H
  G\0ÿÿÿÿÿÿÿÿÿÿÿÿÿýþýþG\Iÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
% 0%%ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$ÿ%òò÷Ò÷@ =ø>˜>>˜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)'*ÿÿÿÿÿÿÿÿ-·&;&;ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿSHEAR AND MOMENT DIAGRAMàøwê@ Ù@ &TWO SPAN CONTINUOUS BEAM@ ø8°LENGTH ˜ù@ Hù@ ÿÿ&ù¸,P6° Fù@ &¦LÍÿVALUES4ù[-ô#° Fùÿÿvù0Fù|ù0SHEARbùB8ˆqjùB8ˆMOMENT ÔJhˆ†ù‚B8ˆC†ù&¦LÍ–ù@ Ch¶ù@ r;° &¦–ù@ r° 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(ÿ'(2-SPAN)ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ \-ƒ
\-ƒ \-ƒ \-ƒ
\-ƒ\-ƒ\-ÿ'SECTION PROPERTIESÿ'| ÿ'L =
 ÿ'L =
ÿ
^|  "DIST.
ÿ
^SHEARS 
^MOMENTÿ^|Cÿ'This worksheet calculates the support moments and reactions ÿ'| ÿ'EI =
 ÿ'EI =
ÿ
^|
 !
þ€!þ€ þ€€
 /ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

ÿ^|?ÿ'for a two span continuous beam. Input consists of beam ÿ'|ÿ
^|% @€ÿŸù€š™™™™™¹? !
<Àþ€!þ€ þ€€
 /ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

ÿ^|Aÿ'dimensions and properties, span end conditions and uniformÿ'GEOMETRYÿ'END CONDÿ'|ÿ^FIX/PIN ÿ'CONT ÿ'CONTÿ ^FIX/PINÿ
^|% @€ÿŸù€š™™™™™¹? !
LÀþ€!þ€ þ€€
 /ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

ÿ^|ÿ'and concentrated loads.ÿ'END COEFÿ'|

ÿ
ÿ
 è?ÿ
^|% @€ÿŸù€š™™™™™¹? !
UÀþ€!þ€ þ€€
 /ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

ÿ^|ÿ'CAR COEFÿ'|&ÿà?€à?;&ÿà?€à?;&ÿà?€à?;&ÿ €à?;ÿ
^|%  @€ÿŸù€š™™™™™¹? !
\Àþ€!þ€ þ€€
 /ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

ÿ^|Fÿ'The worksheet automatically recalulates the moment distributionÿ'DIST COEFÿ'| ÿ€;TÿÐ?E€ÿ€þ€ ÿ€ ÿ€þ€ ÿ€ €€ €  ;Tÿè?E€€€ € ý€ü€ ý€ €€ €  ; ÿ ð?€;ÿ
^|% $@€ÿŸù€š™™™™™¹? '
€cÀþ€!þ€ þ€€
þ€

 Bð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ^|Eÿ'table for all input changes and loads. Results can be printed ÿ'|ÿ
^|% (@€ÿŸù€š™™™™™¹? '
gÀþ€!þ€ þ€€
þ€

 Bð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ^|Eÿ'as displayed in the worksheet. Shear and moment diagrams are  ÿ 'LOADSÿ 'UNIFORMÿ '|
    
    ÿ
^|% ,@€ÿŸù€š™™™™™¹? '
€jÀþ€!þ€ þ€€
þ€

  B ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ ^|Fÿ 'also automatically created for uniform loads only. Concentrated ÿ
'POINTÿ
'|

2ÿ
^@

 


ÿ
^@

ÿ

^|%
0@€ÿŸù€š™™™™™¹? '

nÀþ€!þ€ þ€€
þ€

 
B
ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ
^|Cÿ
'loads must be added to the spans in the diagram table at theÿ \-ƒ \-ƒ \-ƒ \-ƒ \-ƒ \-ƒ \-ƒ \-ÿ
\-% 2@€ÿŸù€š™™™™™¹? '
ÀpÀþ€!þ€ þ€€
þ€

  B ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ ^|ÿ 'DISTRIB MOMENTÿ '|ƒ ófÀ P ƒ ƒ xN@ Pƒ ^|ƒ xNÀ P ƒ ƒ   Pÿ
^|% 4@€ÿŸù€š™™™™™¹? '
€rÀþ€!þ€ þ€€
þ€

  B ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


ÿ ^|ƒ
\-ƒ
\-ƒ
\-ƒ
\-ƒ
\-ƒ
\-ƒ
\-ƒ
\-ƒ

\-%
6@€ÿŸù€š™™™™™¹? (

ð€!€ þ€€ÿ€

C
ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ
^|ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-% 8@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|ÿ'FIXD END MOMENTÿ'|KƒŸªªªª¾eÀ<€úŸ€òŸ
 €ûŸ€ûŸ €òŸ€ûŸ

€òŸ

 ƒJƒSUUUU
T@;þ€úŸÿ€òŸ
 þ€ûŸ€ûŸ
ÿ€òŸ€ûŸ
 ÿ€òŸ
ƒ^|Kƒ£ªªªªªÀ<€úŸ€òŸ
 €ûŸ€ûŸ €òŸ€ûŸ

€òŸ

 ƒJƒ £ªªªªª@;þ€úŸÿ€òŸ
 þ€ûŸ€ûŸ
ÿ€òŸ€ûŸ
 ÿ€òŸ
ÿ
^|% :@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|5ÿ'End conditions should be specified as follows:ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-% <@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|ÿ'|)ƒ€€þŸ€ ; ƒ9ƒˆ3À*€€þŸ€þŸ € €€ ;ƒ^|9ƒLMÀ*€þ€þŸ€þŸ € €€ ; ƒ)ƒ £ªªªªªÀ€€þŸ€ ;ÿ
^|% >@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|ÿ'a) Fixed - 1ÿ'|ƒˆ#À €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒºªªªªªð¿ €ÿŸ€  ƒƒ  þ€ÿŸ€ ÿ
^|% @@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|<ÿ'b) Hinged - .75 (Push page-dn)ÿ'|)ƒ€€ÿŸ€ ; ƒ#ƒ±ªªªªªÐ?€ÿŸ€ÿŸ € ƒ^|#ƒé?þ€ÿŸ€ÿŸ €  ƒ)ƒ €€ÿŸ€ ;ÿ
^|% A@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|ÿ'|ƒŸªªªªªÀ? €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒ €ÿŸ€  ƒƒ  þ€ÿŸ€ ÿ
^|% B@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|       ÿ'|)ƒ€€ÿŸ€ ; ƒ#ƒ€ÿŸ€ÿŸ € ƒ^|#ƒþ€ÿŸ€ÿŸ €  ƒ)ƒ €€ÿŸ€ ;ÿ
^|% C@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|       ÿ'|ƒ €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒ €ÿŸ€  ƒƒ  þ€ÿŸ€ ÿ
^|% D@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|       ÿ'|)ƒ€€ÿŸ€ ; ƒ#ƒ€ÿŸ€ÿŸ € ƒ^|#ƒþ€ÿŸ€ÿŸ €  ƒ)ƒ €€ÿŸ€ ;ÿ
^|% E@€ÿŸù€š™™™™™¹? (
ð€!€ þ€€ÿ€

Cð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 ÿ^|       ÿ'|ƒ €ÿŸ€  ƒƒ þ€ÿŸ€ ƒ^|ƒ €ÿŸ€  ƒƒ  þ€ÿŸ€ ÿ
^|ÿ^|ÿ'|)ƒ€€ÿŸ€ ; ƒ#ƒ€ÿŸ€ÿŸ € ƒ^|#ƒþ€ÿŸ€ÿŸ €  ƒ)ƒ €€ÿŸ€ ;ÿ
^|ÿ^|ÿ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ \-ÿ
\-ÿ'DISTRIB MOMENTÿ'|ƒófÀ P ƒƒxN@ Pƒ^|ƒxNÀ P ƒƒ    Pÿ
^|ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ\-ƒ \-ƒ
\-ÿ'REACTNSÿ'FIXD END8‚ÀG@)€êŸ€âŸ  €ëŸ€âŸ€ëŸ
 €âŸ  ‚8‚ÀG@)þ€êŸÿ€âŸ  þ€ëŸÿ€âŸ€ëŸ
 ÿ€âŸ  ‚8‚@)€êŸ€âŸ  €ëŸ€âŸ€ëŸ
 €âŸ  ‚8‚ @)þ€êŸÿ€âŸ  þ€ëŸÿ€âŸ€ëŸ
 ÿ€âŸ ÿ 'CORRCTNS#‚ ˆ@€ûŸ€ûŸ €áŸ  ‚ "‚ ˆÀþ€ûŸ€ûŸ ÿ€áŸ  ‚ #‚ `(@€ûŸ€ûŸ €áŸ  ‚ "‚ `(Àþ€ûŸ€ûŸ ÿ€áŸ  ÿ!'FINAL‚!ÑJ@
€þŸ€ÿŸP ‚!‚!¯D@ €þŸ€ÿŸP ‚!‚!`-@ €þŸ€ÿŸP ‚!‚ !`#À
€þŸ€ÿŸP ÿ"'TOTAL&‚"Y@€ÿŸ€ÿŸ€ÿŸ€ÿŸP %"DIST.
ÿ%^SHEARS %
%^MOMENT %  % 
%  %  % 
%
&!&ÑJ@þ€!þ€ þ€€
 &/&ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

 &  & 
&  &  & 
&%'@€ÿŸ€š™™™™™¹? !'ÑI@þ€!þ€ þ€€
 '/'ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

 '  ' 
'  '  ' 
'%(@€ÿŸ€š™™™™™¹? !(ÑH@þ€!þ€ þ€€
 (/(ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

 (  ( 
(  (  ( 
(%)@€ÿŸ€š™™™™™¹? !)ÑG@þ€!þ€ þ€€
 )/)ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

 )  ) 
)  )  ) 
)%* @€ÿŸ€š™™™™™¹? !*ÑF@þ€!þ€ þ€€
 */*ð ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

 *  * 
*  *  * 
*%+$@€ÿŸ€š™™™™™¹? '+xÀþ€!þ€ þ€€
þ€

 +B+ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 +  + 
+  +  + 
+%,(@€ÿŸ€š™™™™™¹? ',¼ Àþ€!þ€ þ€€
þ€

 ,B,ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 ,  , 
,  ,  , 
,%-,@€ÿŸ€š™™™™™¹? '-¼$Àþ€!þ€ þ€€
þ€

 -B-ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 -  - 
-  -  - 
-%.0@€ÿŸ€š™™™™™¹? '.¼(Àþ€!þ€ þ€€
þ€

 .B.ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 .  . 
.  .  . 
.%/2@€ÿŸ€š™™™™™¹? '/¼,Àþ€!þ€ þ€€
þ€

 /B/ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 /  / 
/  /  / 
/%04@€ÿŸ€š™™™™™¹? '0^0Àþ€!þ€ þ€€
þ€

 0B0ð3ÿ€&ÿÿÿÿ þ€ ÿÿÿÿ

þ€
ÿÿÿÿ€


 0  0 
0  0  0 
0%1ÍÌÌÌÌ 4@€ÿŸ€{®Gáz„? (1fffffF-@€!€ þ€€ÿ€

C1ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

 %2€4@€þŸ€š™™™™™¹? (2`,@€!€ þ€€ÿ€

C2ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  2  2 
2  2  2%35@€ÿŸ€š™™™™™¹? (3`+@€!€ þ€€ÿ€

C3ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  3  3 
3  3  3%4€5@€ÿŸ€š™™™™™¹? (4`*@€!€ þ€€ÿ€

C4ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  4  4 
4  4  4%56@€ÿŸ€š™™™™™¹? (5`)@€!€ þ€€ÿ€

C5ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  5  5 
5  5  5%6€6@€ÿŸ€š™™™™™¹? (6`(@€!€ þ€€ÿ€

C6ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  6  6 
6  6  6%77@€ÿŸ€š™™™™™¹? (7`'@€!€ þ€€ÿ€

C7ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  7  7 
7  7  7%8€7@€ÿŸ€š™™™™™¹? (8`&@€!€ þ€€ÿ€

C8ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  8  8 
8  8  8%98@€ÿŸ€š™™™™™¹? (9`%@€!€ þ€€ÿ€

C9ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  9  9 
9  9  9%:€8@€ÿŸ€š™™™™™¹? (:`$@€!€ þ€€ÿ€

C:ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  :  : 
:  :  :%;9@€ÿŸ€š™™™™™¹? (;`#@€!€ þ€€ÿ€

C;ð4€0ÿ€€ÿÿÿÿÿ€
 € ÿÿÿÿÿ€

  ;  ; 
;  ;  ;

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : 2SPANBM.ZIP
Filename : 2SPANBM.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/