The following tutorials are an introduction to solving linear and nonlinear equations with Excel. The solution to linear equations is through matrix operations while sets of nonlinear equations require a solver to numerically find a solution.

Linear and nonlinear equations can also be solved with MATLAB and Python. Click on the appropriate link for additional information and source code.

The APMonitor Modeling Language is optimization software for mixed-integer and differential algebraic equations. It is coupled with large-scale solvers for linear, quadratic, nonlinear, and mixed integer programming (LP, QP, NLP, MILP, MINLP). Modes of operation include data reconciliation, real-time optimization, dynamic simulation, and nonlinear predictive control. It is freely available through MATLAB, Python, Julia, or from a web browser interface.

comments powered by Disqus

Retrieved from http://apmonitor.com/che263/index.php/Main/ExcelSolveEquations

Page last modified on September 30, 2017, at 12:43 PM