EuroOffice Solver is a useful OpenOffice extension that helps you to solve optimization probles in Calc.
Here are some key features of "EuroOffice Solver Professional":
· The tried and true simplex algorithm performs well on practically occuring cases of linear optimization. All kinds of linear inequalities (= and =) are supported.
· The quadratic solver can find the minima and maxima of functions such as quadratic functions while observing linear inequalities.
· The non-linear solver can be used to find the extreme value of any function you can describe in an OpenOffice.org Calc formula and it can still observe the constraints given in linear inequalities!
· The Hungarian algorithm solves a completely different class of optimization problems: assignment problems. Useful for deciding on logistics, splitting up work and splitting up cookies!
Requirements:
· OpenOffice.org
Limitations:
· Its only limitation is that it only includes the simplex solver.