Profilers • Excel Profiler • Use Linear Constraints
Previous
 • 
Next
Use Linear Constraints
Within the JMP Profiler, you can alter the linear constraints in order to restrict the model input values. You are prompted to save the constraints to the Excel workbook. After constraints are saved to the Excel workbook, whenever the model is profiled from the Excel Add-In, the constraints are incorporated.
1.
From the red triangle menu next to Prediction Profiler, select Alter Linear Constraints.
2.
Click Add Constraint.
3.
Type in the constraining values.
4.
Click OK.
5.
From the red triangle menu next to Prediction Profiler, select Save Linear Constraints.
You are prompted to save the constraints to the Excel workbook.
6.
Click Yes.
Note: When you save the .xls file, you might see a compatibility error. If so, click Continue to save the file.
The workbook opens in Excel. When you run the model, the constraints are reflected in the JMP Profiler. For more information about linear constraints, see Linear Constraints in Introduction to Profilers.
Tip: To delete a linear constraint, set all constraint values to zero.

Previous
 • 
Next
Help created on 7/12/2018