Export XYZ

The Export XYZ in the File menu option saves the current data table.

ASCII Format

The default format is a 15 digit precision ASCII file with a PRN extension. In a saved ASCII file, the titles are always in double quotes and each X,Y,Z data triplet is always on a new line. The flag character '*' will follow the Z value if the X,Y,Z triplet has been excluded. If weighting is used, the weights will then follow preceded by an uppercase W. Spaces are used to separate the data elements. These ASCII data files can be modified with any ASCII editor, including the ASCII Editor available from within the program.

Excel 95 and Excel 97/2000/XP Formats

You may optionally save the data table as an Excel 95 or Excel 97/Excel 2000/Excel XP spreadsheet file. These files will offer 15-16 digit binary floating point precision. The first row of the spreadsheet will contain the main title and the second row will contain the X, Y, and Z data titles. The X values will be in the first column, the Y values in the second, the Z values in the third, and if weighting is used, the weights will appear in the fourth column. The flags for active and inactive points are not preserved when saving an Excel file.

WK1,WK3 Formats

You may optionally save the data table as a Lotus WK1 or Lotus WK3 spreadsheet file. The WK1 will have 15-16 digit binary floating point precision and the WK3 will have the full 19 digit floating point precision. The first row of the spreadsheet will contain the main title and the second row will contain the X, Y, and Z data titles. The X values will be in the first column, the Y values in the second, the Z values in the third, and if weighting is used, the weights will appear in the fourth column. The flags for active and inactive points are not preserved when saving a WK1 or WK3 file.

SPSS SAV Format

You may also elect to save the data table as a compressed SPSS SAV file. The SAV will have 15-16 digit binary floating point precision. The X variable will use the name XVAR and its label will be the current X title. Similarly, the Y and Z variables will use the names YVAR and ZVAR and their labels will consist of the current Y and Z titles. A column named ACTIVE will contain 1 if a point is enabled, and 0 if disabled. A WEIGHT column will contain the weights, or values of 1.0 if weighting is not present. An SPSS file saved from TableCurve 3D will be automatically read upon import (no column selection) if these five variables comprise the file. In addition to offering direct export to SPSS, the SAV format is the most efficient of the available formats for disk storage.

SYSTAT SYS Format

For export to SYSTAT, the data table can be saved as an SYS file. The file will have 15-16 digit binary floating point precision. The X variable will use up to 12 characters of the current X title. Similarly, the Y and Z variables will use up to 12 characters of the current Y and Z titles. A WEIGHT column will contain the weights, if weighting is present. Since an SYS file does not preserve full title information, it is recommended only for export to SYSTAT.