Optimization Solver for OpenOffice.org Calc 2006-06-16

The Linear and Non-Linear Optimization Solver (or simply the Optimization Solver) is designed to compute an optimized set of decision variables that either maximize or minimize a given objective function while also satisfying a set of arbitrary constraints defined by the user.
It is widely used in the field of operations research, and can also be a very useful business tool that helps you make an informed decision on a multitude of complex scenarios that you may encounter in your day-to-day business operations.
Version restrictions:
- Currently it only solves constrained linear models! An algorithm for non-linear model is being worked on.
- A constraint value must be a cell reference. Simply typing a value will not work.
- The Reset and Options buttons do absolutely nothing!
- It assumes that the model is linear. It does NOT solve a non-linear model yet.
Enhancements:
- The two packages have been combined into one, so that only one package needs to be installed.
- Preprocessing of the model has been disabled, because it was preventing lpsolve from solving certain models.