Contents - Index

JMP

VarTran will automatically convert equations from version 4.0 of the JMP software package into the format required for either an output variable or objective function.  This task is performed using the Paste Equation dialog box.

To obtain the equation from JMP, first perform the analysis.  Then right mouse click over one of the header bars in the analysis window to display a popup menu.  Select the Save Columns menu item followed by the Prediction Formula menu item as shown below:



This creates a new column in the data window that starts with "pred formula".  Right mouse click over the column header to display another popup menu.  Select the Formula menu item as shown below:



This results in the Formula dialog box shown below being displayed.  The equation is displayed with a red box around it showing that the entire equation is currently selected.  Press the Ctrl-C keystroke combination to copy the equation to the clipboard.  It is now ready to be pasted into the Paste Equation dialog box.  



The following conversions are performed automatically:
  • Variables in the form :SILICA and :Name("SILCA * SILANE") are converted to valid symbols.  Illegal characters are replaced by underscores and the symbol may be shortened.  The original variable name from JMP is preserved in the variable name field of VarTran when input variables are automatically created.
  • Categorical variables and the associated Match function:

      Match( :SULFUR, "1.8", 0.0609, "2.3", -0.0717, "2.8", 0.0109, .)

    are converted to VarTran's equivalent format:

      (0.0609 * SULFUR{_1_8} + -0.0717 * SULFUR{_2_3} + 0.0109 * SULFUR{_2_8})
  • Categorical variables and the associated Name function:

      :Name("Silica{1.7&1.2-0.7}")

    are converted to VarTran's equivalent format:

      Silica{_1_7} + Silica{_1_2} - Silica{_0_7}
  • The following JMP functions are converted: Abs, Root, Exp, Log, Log10, Sine, Cosine, Tangent, ArcSine, ArcCosine, ArcTangent, SinH, CosH, TanH, Minimum, Maximum, LGamma, Beta and Gamma.
  • In addition the parenthesis in JMP are replaced with the square brackets required by VarTran.
  • Numbers are converted from the e-format (1e-50) to the 10^ format (1 10^-50) used by VarTran.