Calibration Constraint's RHS 0.9999

Question:

Why does the calibration function in NumXL show the constraint's rhs of 0.9999?

Answer:

When you click on the "Calibration" icon in the toolbar (or menu), NumXL prepares all inputs of the solver using the selected model, and add one constraint  (As shown below):

MS Excel Solver showing constraints with 0.999 limit value.

The constraint is added to make sure the solver searches only for a stable model (e.g. invertible, characteristics root outside unit-circle, etc.). NumXL has functions for the different models that check the stability of the model and returns either 0/1.

Ideally, the constrain above should state something like ($J$43=1), but due to an issue in the Excel Solver using VBA, we introduced a work-around to overcome situations where the first constraint is missing or dropped.

Comments

Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful