Modeling Support

Analytic Solver Models in Excel

• Allow Variables to take only specific values in the Standard Solver
• Objective does not converge
• Optimization problem over multiple worksheets
• Analytic Solver Scaling Issue
• Where can I find the IF Transformation example model?
• Using Psi Functions to Define a Model on Worksheet

Analytic Solver in Excel Solver with VBA

• Using a Callback Function when Calling the standard Excel Solver through VBA
• Calling Analytic Solver through VBA