| <!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> |