Free Open-Source Models

Number Engine provides the general public with some open-source spreadsheet models. These models can be used with the Optimization Solver app to model and optimize various business operations. They can also be a good starting point to introduce you to modeling.

Check them out below! All models are completely free & open-source, subject to the MIT License. If you'd like to see a new model added that isn't available below, contact us about your idea.

Supported Functions

The Number Engine add-on supports optimization with many spreadsheet functions. Please see below for a comprehensive list of all 378 of them:

*Note that the linear solution method has some restrictions on functions with piecewise or discontinuous behavior, but the nonlinear solution method supports optimization with all of the functions below*

Nonlinear Optimization

Linear Optimization

Linear optimization requires that all functions used behave linear, continuous, and fully numeric. Listed below are the 18 functions that you may use on decision variables in your models.