Faq/Calc/109

Where is the solver in Calc ?
The multivariable solver integrated into LibreOffice is activated by the Menu. The solver engine by default supports only linear equations, but the NLPSolver extension allows you to handle non-linear problems. You will find a full explanation of its functioning on. Yous can also use the tool Goal seek :
 * 1) Set out the equations for your problem, with a cell to contain the initial value that is to be determined, and another containing the formula whose result needs to reach a certain value (the target value).
 * 2) Go to.
 * 3) In Formula Cell, indicate the coordinates of the cell containing the formula which needs to attain the target value.
 * 4) In Target Value, indicate the value that should be reached in the preceding case.
 * 5) In Variable Cell, indicate the coordinates of the cell whose value is unknown and will be modified.
 * 6) Click OK.

The spreadsheet will show you if it has reached the target value and will suggest inserting a suitable value into the variable cell. Failing that, it will suggest a value for the variable cell which gets you as close as possible to the target value.

It is possible to use other tools, such as the Fitoo macro, a non-linear correlation tool, created by Laurent Godard, available at.

For polynomial correlations, there is the CorelPolyGUI extension.