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ø2F¼@ $° ÒøW ùø2F¼@ $° êøW¸ù@ F¼@ < Ù<&òEXAMPLE HARDY-CROSS MOMENT DISTRIBUTIONMD>8° `ø`øTøPD9° $øÈ*ø@ aø@ ÿÿ>ø¸,P6° ^ø@ &¦LÍÿÿP^øLø[-ô#° ^øÿÿø0^øDDP1DSK0ø|ø2ø2ø2F¼@ $° ÒøW ùø2F¼@ $° êø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ùB8qjùB8MOMENT ÔJhùB8Cù&¦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
ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ
^|ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-%8@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

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

ò

JSUUUU
T@;þúÿò
þûû
ÿòû
ÿò
^|K£ªªªªªÀ<úò
ûûòû

ò

J £ªªªªª@;þúÿò
þûû
ÿòû
ÿò
ÿ
^|%:@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

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

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^|ÿ'|)þ; 93À*þþ ;^|9LMÀ*þþþ ; ) £ªªªªªÀþ;ÿ
^|%>@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^|ÿ'a) Fixed - 1ÿ'|#À ÿ þÿ^|ºªªªªªð¿ ÿ þÿÿ
^|%@@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

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

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^|ÿ'|ªªªªªÀ? ÿ þÿ^| ÿ þÿÿ
^|%B@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^| ÿ'|)ÿ; #ÿÿ ^|#þÿÿ ) ÿ;ÿ
^|%C@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^| ÿ'| ÿ þÿ^| ÿ þÿÿ
^|%D@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^| ÿ'|)ÿ; #ÿÿ ^|#þÿÿ ) ÿ;ÿ
^|%E@ÿù¹? (
ð! þÿ

Cð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

ÿ^| ÿ'| ÿ þÿ^| ÿ þÿÿ
^|ÿ^|ÿ'|)ÿ; #ÿÿ ^|#þÿÿ ) ÿ;ÿ
^|ÿ^|ÿ\-\-\-\-\-\-\- \-ÿ
\-ÿ'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ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

%24@þ¹? (2`,@! þÿ

C2ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

2 2
2 2 2%35@ÿ¹? (3`+@! þÿ

C3ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

3 3
3 3 3%45@ÿ¹? (4`*@! þÿ

C4ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

4 4
4 4 4%56@ÿ¹? (5`)@! þÿ

C5ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

5 5
5 5 5%66@ÿ¹? (6`(@! þÿ

C6ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

6 6
6 6 6%77@ÿ¹? (7`'@! þÿ

C7ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

7 7
7 7 7%87@ÿ¹? (8`&@! þÿ

C8ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

8 8
8 8 8%98@ÿ¹? (9`%@! þÿ

C9ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

9 9
9 9 9%:8@ÿ¹? (:`$@! þÿ

C:ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

: :
: : :%;9@ÿ¹? (;`#@! þÿ

C;ð40ÿÿÿÿÿÿ
ÿÿÿÿÿ

; ;
; ; ;

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

Daniel says:

January 27, 2013 at 3:59 pm

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

March 18, 2014 at 4:57 pm

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

January 14, 2015 at 10:57 pm

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/

3 Responses to “Category : Lotus and other SpreadsheetsArchive : 2SPANBM.ZIPFilename : 2SPANBM.WK1”

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