| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <HTML> |
| <head> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE>Optimization Solver component</TITLE> |
| <META NAME="GENERATOR" CONTENT="StarOffice 7 (Win32)"> |
| <META NAME="AUTHOR" CONTENT="Niklas Nebel"> |
| <META NAME="CREATED" CONTENT="20031022;12222170"> |
| <META NAME="CHANGEDBY" CONTENT="Niklas Nebel"> |
| <META NAME="CHANGED" CONTENT="20031022;12223596"> |
| </head> |
| <body LANG="de-DE" DIR="LTR"> |
| <H2>Short description of a possible Solver (optimization tool) |
| component</H2> |
| <P>A Solver component modifies a set of input cells in a spreadsheet, |
| observing the impact on result and constraint formula cells. The goal |
| is to find an optimal set of input values, for which the result is |
| minimized, maximized or approximated to a target value, while the |
| constraints remain within specified limits. There has to be a user |
| interface to select the input and result cells, constraints and |
| internal parameters. The component would then use the StarOffice API |
| to fill the input cells and read the resulting formula results. For |
| best results, a selection of algorithms (for example linear and |
| non-linear) should be available.</P> |
| <P> |
| </P> |
| </body> |
| </HTML> |