Two converters are provided to import and export Lotus 1-2-3 data into and out of GRAMS data format. The LOTUS_1A is used for version 1/1A, and the LOTUS_2 is used for version 2 files. The version 1/1A converter allows a maximum of 2000 points per worksheet column and uses a worksheet extension of *.WKS. The version 2 converter allows up to 8000 points per column and uses an extension of *.WK1. Data imported from Lotus 1-2-3 must be formatted as follows:
| Cell |
Contents |
Cell |
Contents |
| A1 |
Comment or memo text |
B1 |
not used (blank) |
| A2 |
not used (blank) |
B2 |
not used (blank) |
| A3 |
Number of points (integer) |
B3 |
not used (blank) |
| A4 |
First point's X value (float) |
B4 |
not used (blank) |
| A5 |
Last point's X value (float) |
B5 |
not used (blank) |
| A6 |
X unit type as text or integer |
B6 |
not used (blank) |
| A7 |
Y unit type as text or integer |
B7 |
not used (blank) |
| A8 |
Resolution as text Integer or Float |
B8 |
not used (blank) |
| A9 |
not used (blank) |
B9 |
not used (blank) |
| A10 |
First Y Data Point (float) |
B10 |
not used (blank)
8000th Y Data Point (V2) |
| A11 |
Second Y Data Point (float) |
B11 |
2001st Y Data Point (V1/1A)
8001st Y Data Point (V2) |
| A2009 |
Last Y value in first column
(Version 1/1A) |
B2009 |
4000th Y Data Point (V1/1A) |
| A8009 |
Last Y value in first column
(Version 2) |
B8009 |
16000th Y Data Point (V2) |
Data points may be integers, numeric (float) values, Lotus formulas, or text strings (labels). Any text data is evaluated as a numeric string. Cells with Lotus values "NA" or "ERR" are evaluated as zero. Any formula with a string result (version 2) is also evaluated as zero (i.e., @LEFT("1 2 3 4",1) evaluates as zero even though it displays as "1" in the worksheet cell). The import conversion stops when the number of points specified in cell A3 has been read or a cell is found missing. Data always begins in cell A10 and proceeds down column A for 8000 data points (version 2) or 2000 data points (version 1/1A), then wraps up to the next column in row 10 (i.e., to cell B10) and so on.
Any non-blank cells to the right of the range specified by the number of points in cell A3 (or to the right of the first column if A3 is blank) are ignored although they do slow down the conversion process. Any or all of the values in the header (Cells A1 to A9) may be omitted if desired as long as the data begins in cell A10. If the number of points is missing, the conversion will search for the maximum number of continuous data points beginning in cell A10 and continuing down the column to cell A8009 (version 2) or cell A2009 (version 1/1A). Note that only a maximum of one column of data points (2000 points version 1/1A or 8000 points version 2) may be imported if the number of points in cell A3 is omitted.
If the number of data points found does not equal the number specified in cell A3 or if A3 is left blank, a warning message is displayed and the number of points actually found is used.
Users of Version 3 must export to a *.WKS or *.WK1 file format before import. | 
1 Artículos Total 7,000.00 USD 