For the latest version of JMP Help, visit JMP.com/help.


Profilers > Excel Profiler > Use Linear Constraints
Publication date: 04/28/2021

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. Click the Prediction Profiler red triangle and select Alter Linear Constraints.

2. Click Add Constraint.

3. Type in the constraining values.

4. Click OK.

5. Click the Prediction Profiler red triangle and 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 the Introduction to Profilers section.

Tip: To delete a linear constraint, set all constraint values to zero.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).