Match the trial values across the top or down the left to the corresponding input cell. With two inputs, put the formula in the top-left corner. With one, put formulas along the other edge.
To refresh the results, run Data Table again.
For example, set a limit with D3 ≤ 10 or D3 ≤ E3.
Use Simplex LP for linear formulas, such as 4×B2 + 3×C2. Use Nonlinear for models with terms such as B2².
Version 0.8.36
The application is provided without warranty. You use it at your own risk. Check your calculations and keep backup copies of important data.
Click a line in the preview to add or select it. Edit its color, width, and style independently; click the selected line again to remove it.
Built-in lists cannot be deleted.
Drag the fill handle after entering a list item to continue the sequence. Custom lists are saved on this computer.
Exports the active sheet as values. Formulas are exported as calculated results; styles, charts and additional sheets are not included.