home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.whtech.com
/
ftp.whtech.com.tar
/
ftp.whtech.com
/
club100
/
bus
/
lucnv.do
< prev
next >
Wrap
Text File
|
2006-10-19
|
5KB
|
130 lines
DOCUMENTATION FOR LUCNV.BA
This program is designed to convert a Lucid spreadsheet file to a form
which can be uploaded for use on another spreadsheet program. Specifically,
the Lucid file is converted to a VISICALC ASCII file. This file can be
uploaded to another PC, and, in turn, can be converted to LOTUS 1-2-3 format.
This is what I use this program for. I developed it to handle spreadsheets
developed on the M100, but which either grew too large for my 32K, or which
needed to be used on several PC's at work.
The program is in BASIC, and when it is executed the Lucid file to be
converted must be in RAM. The output file can either be in RAM, if there's
room, or any other colon delimited file, such as CAS:, or, as I use it, a 0:
disk file.
All Lucid cell entries can be handled by the program, although some either
don't have a VISICALC equivalent, or may operate differently. Listed below are
some known cautions:
1.The Lucid REF function is converted to a text string. There is no equivalent
in either VISICALC or Lotus.
2. TBL is converted to a combination of VLOOKUP and HLOOKUP which acts
similarly.
2a. Note that Lucid and Lotus work differently for values between exact
figures in the lookup tables. Lucid goes to the next higher entry, while Lotus
goes to the lower bound entry.
2b. Lotus needs the upper left corner filled.
2c. A very important note is that you have to add, either on the Lucid
lookup table or in Lotus, a row after the last row of lookup values counting
the columns 1,2,3,... This is needed to make the one dimensional Lotus lookup
functions work like Lucid's two dimensional TBL function.
3. Lotus may not work the same for text entries referenced by equations.
4. Cell formulas are converted with lots of parentheses because VISICALC uses
left to right priority, not algebraic like Lucid and Lotus.
5.Finally, most formats from Lucid are ignored, so you'll have to fix them when
the conversion is complete.
When you run the program, you'll be prompted for an output file type, ie
RAM:, CAS:, 0:, LCD:, LPT:. Then you'll be prompted for the Lucid file name.
If the program finds the .CA file, then, conversion will proceed. Converted
cell entries are echoed to the screen. The converted file will be named
XXXXXX.DO, where XXXXXX is the Lucid file name. The converted statements will
be echoed to the screen.
The file name finder is acknowledged as borrowed from another program, but
I don't recall which one.
Listed below is a formula listing for a sample spreadsheet and the
resulting converted file. Good luck.
row/colA1B1 C1 D1 E1
+2 +5 +4 +B2*C2
+3 this is a test file for lucid id conversion
+4 +RND(5) +INT(C2) +SUM(B4:C4)
+5 +TBL(B2,C2,B7:D11) +EXP(B2) +LOG(C5)
+6 +(B2+C2*D2-C5/D5)/(B5)
+7 +0 +1000000
+8 +2 -1 -10
+9 +4 +1 +10
+10 +6 +2 +11
+11 +8 +3 +12
The listing following is the resulting .DO file which was created from
this file.
>D11:/FD+12
>C11:/FD+3
>B11:/FD+8
>A11:/FD+11
>D10:/FD+11
>C10:/FD+2
>B10:/FD+6
>A10:/FD+10
>D9:/FD+10
>C9:/FD+1
>B9:/FD+4
>A9:/FD+9
>D8:/FD-10
>C8:/FD-1
>B8:/FD+2
>A8:/FD+8
>D7:/FD+1000000
>C7:/FD+0
>A7:/FD+7
>B6:/FD+(B2+(C2*D2)-(C5/D5))/(B5)
>A6:/FD+6
>D5:/FD+@LN(C5)
>C5:/FD+@EXP(B2)
>B5:/FD+@VLOOKUP(B2,B7...D11,@HLOOKUP(C2,B7...D12,5))
>A5:/FD+5
>D4:/FD+@SUM(B4...C4)
>C4:/FD+@INT(C2)
>B4:/FD+(5)*@RAND
>A4:/FD+4
>E3:/FD"id conversion.
>B3:/FD"this is a test file for lucid
>A3:/FD+3
>D2:/FD+B2*C2
>C2:/FD+4
>B2:/FD+5
>A2:/FD+2
>E1:/FD"E1
>D1:/FD"D1
>C1:/FD"C1
>B1:/FD"B1
>A1:/FD"row/colA1
NOTE: After you've converted this to a Lotus worksheet file, you have to add
the following to make the table function operate properly:
cell entry
---- -----
B12 1
C12 2
D12 3
Thanks to Phil Wheeler for all his help in getting this program uploaded and
checked out.
Dave Lapinski