Skip to content

SigmaPlot Export

You may export TableCurve's Curve-Fit to a SigmaPlot Windows graph file. The file is created via the Export to SigmaPlot button in the control panel of the Curve-Fit graph or the Save SigmaPlot item in the Curve-Fit graph's File menu. In addition to writing the SigmaPlot file, you may optionally generate a SigmaPlot Transform for the curve-fit equation.

SigmaPlot Format

The SP2000/v5 (All Graphs) format writes a SigmaPlot Windows file for use with SigmaPlot 2000 and SigmaPlot Windows v5. This option contains eight graph pages, four in black and white and four in color.

The remaining options write a SigmaPlot SP5 file format. The SP5 is a DOS-based SigmaPlot format that is portable to all versions of SigmaPlot. Since this format is limited to a single graph page, the following four options are available:

TableCurve will copy current log axis settings as well as X and Y titles to the generated SigmaPlot plots.

Generated Data

The SigmaPlot curve-fit worksheet contains all possible curve-fit information, including fit parameters, fit statistics, the original data with predicted values and confidence and prediction limits, and a generated section which contain X values determined by the values in the Starting X, Increment, and Ending X fields. This generated section will contain the predicted Y value as well as confidence and prediction intervals. The initial values in the X generation will produce a generated block of 100 points. The confidence value used will be the value currently set in the Intervals option.

Generate SigmaPlot Transform

If the Generate SigmaPlot Transform box is checked, TableCurve 2D will generate a SigmaPlot transform with the same prefix name as the generated SigmaPlot file, and an [XFM] extension. This transform can be used to compute the predicted values for the curve-fit equation for X values that are subsequently entered in SigmaPlot. The transform code assumes the initial columns for an empty worksheet and the last columns of a TableCurve-generated worksheet when there is information in the initial column. Note that this generated transform will contain only the native mathematical formula. There will be no conditional statements to manage undefined regions. Note also, that no transform will be generated for Chebyshev and Fourier Series equations.

Editing the Templates for SigmaPlot 2000/SPW5

If you would like to modify the format, styles, and general appearance of the generated SigmaPlot graphs, or delete or add graphs, this can be easily done. You must follow these steps:

From TableCurve 2D:

  • Export a SigmaPlot 2000/v5 file. If you want to add graphs that use curve-fit references, be sure that references are present before the SigmaPlot file is generated.

From the Operating System

  • Back up the files tcurvee.ovl, tcurvef.ovl, tcurveg.ovl, tcurveh.ovl that exist in the TableCurve 2D v5 directory.

From SigmaPlot:

  • Open this generated file. Open the data worksheet (Data 1) within this file. Click in the upper left corner of the grid (at the intersection of the row and column titles) to highlight the entire sheet. Click the Copy button. Close the data worksheet and the generated file.
  • Open the tcurvee.ovl file in the TableCurve 2D v5 directory. Open the data worksheet (Data 1) within this file. Place the cursor in row1 column1 of the worksheet and click Paste. This data is used temporarily so that graph elements are visible.
  • Edit the existing graphs, delete unneeded graphs, and add new graphs. You can add as many graph pages as you like. The unusual x title and y title strings in the existing graphs are tokens that are replaced with the current x and y titles at the time the file is generated. You must exactly copy these x and y title strings to all new graphs where you want the x and y titles to be automatically generated.
  • In the data worksheet, click in the upper left corner of the grid (at the intersection of the row and column titles) to highlight the entire sheet. Press the Delete key to clear all data. Click the Save button and then close the file.
  • TableCurve 2D uses four templates: tcurvee.ovl, tcurvef.ovl, tcurveg.ovl, tcurveh.ovl. The first is used for linear x, linear y axes states; the second for log x, linear y; the third for linear x, log y; and the last for log x, log y states. If you want your revisions generated for the four different axes states within TableCurve 2D, you must edit all four files. If you make extensive changes to tcurvee.ovl, it will be easier to import it, revise the log states of the various graphs, and then save out tcurvef.ovl, tcurveg.ovl, and tcurveh.ovl. Be sure the saved names match and do not have JNB extensions.