1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski 3*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 4*b1cdbd2cSJim Jagielski 5*b1cdbd2cSJim Jagielski<!--*********************************************************** 6*b1cdbd2cSJim Jagielski * 7*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 8*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 9*b1cdbd2cSJim Jagielski * distributed with this work for additional information 10*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 11*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 12*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 13*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 14*b1cdbd2cSJim Jagielski * 15*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 16*b1cdbd2cSJim Jagielski * 17*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 18*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 19*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 21*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 22*b1cdbd2cSJim Jagielski * under the License. 23*b1cdbd2cSJim Jagielski * 24*b1cdbd2cSJim Jagielski ***********************************************************--> 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski<meta> 30*b1cdbd2cSJim Jagielski<topic id="textscalc01solverxml" indexer="include" status="PUBLISH"> 31*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Solver</title> 32*b1cdbd2cSJim Jagielski<filename>/text/scalc/01/solver.xhp</filename> 33*b1cdbd2cSJim Jagielski</topic> 34*b1cdbd2cSJim Jagielski</meta> 35*b1cdbd2cSJim Jagielski<body> 36*b1cdbd2cSJim Jagielski<section id="solverhead"> 37*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id7654652"><bookmark_value>goal seeking;solver</bookmark_value> 38*b1cdbd2cSJim Jagielski<bookmark_value>what if operations;solver</bookmark_value> 39*b1cdbd2cSJim Jagielski<bookmark_value>back-solving</bookmark_value> 40*b1cdbd2cSJim Jagielski<bookmark_value>solver</bookmark_value> 41*b1cdbd2cSJim Jagielski</bookmark> 42*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:SolverDialog" id="bm_id5634022" localize="false"/><comment>mw changed "what-if...", "goal seek;" and made "back-solving;" a one level entry</comment> 43*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id9216284" xml-lang="en-US" level="1" l10n="NEW"><variable id="solver"><link href="text/scalc/01/solver.xhp">Solver</link> 44*b1cdbd2cSJim Jagielski</variable></paragraph> 45*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9210486" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Opens the Solver dialog. A solver allows to solve equations with multiple unknown variables by goal seeking methods.</ahelp></paragraph> 46*b1cdbd2cSJim Jagielski</section> 47*b1cdbd2cSJim Jagielski<section id="howtoget"> 48*b1cdbd2cSJim Jagielski<embed href="text/scalc/00/00000406.xhp#solver"/> 49*b1cdbd2cSJim Jagielski</section><comment>target cell</comment> 50*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_OBJECTIVECELL" id="bm_id8861964" localize="false"/> 51*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id8538773" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized.</ahelp></paragraph><comment>maximum</comment> 52*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_OPTSOLVER:RB_MAX" id="bm_id8373973" localize="false"/> 53*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7564012" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Try to solve the equation for a maximum value of the target cell.</ahelp><comment>where is the equation?</comment></paragraph><comment>minimum</comment> 54*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_OPTSOLVER:RB_MIN" id="bm_id6767174" localize="false"/> 55*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id1186254" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Try to solve the equation for a minimum value of the target cell.</ahelp></paragraph><comment>value of</comment> 56*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_OPTSOLVER:RB_VALUE" id="bm_id5222022" localize="false"/> 57*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7432477" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Try to solve the equation to approach a given value of the target cell.</ahelp></paragraph><comment>value of text field</comment> 58*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_TARGET" id="bm_id2756126" localize="false"/> 59*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7141026" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the value or a cell reference.</ahelp></paragraph><comment>by changing cells</comment> 60*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_VARIABLECELLS" id="bm_id4908902" localize="false"/> 61*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id8531449" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the cell range that can be changed.</ahelp></paragraph><comment>cell reference</comment> 62*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_LEFT1" id="bm_id8499099" localize="false"/> 63*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_LEFT2" id="bm_id9544663" localize="false"/> 64*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_LEFT3" id="bm_id5762199" localize="false"/> 65*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_LEFT4" id="bm_id9534287" localize="false"/> 66*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9183935" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter a cell reference.</ahelp></paragraph><comment>operators</comment> 67*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_OPTSOLVER:LB_OP1" id="bm_id9408551" localize="false"/> 68*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_OPTSOLVER:LB_OP2" id="bm_id1329386" localize="false"/> 69*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_OPTSOLVER:LB_OP3" id="bm_id4931180" localize="false"/> 70*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_OPTSOLVER:LB_OP4" id="bm_id5970030" localize="false"/> 71*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id946684" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select an operator from the list.</ahelp><comment>what do these operators do? what is the meaning of Integer and Binary here? 72*b1cdbd2cSJim JagielskiI hate such spec docs that leave so many questions</comment></paragraph><comment>value</comment> 73*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_RIGHT1" id="bm_id496841" localize="false"/> 74*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_RIGHT2" id="bm_id7440717" localize="false"/> 75*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_RIGHT3" id="bm_id2470778" localize="false"/> 76*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_OPTSOLVER:ED_RIGHT4" id="bm_id3389080" localize="false"/> 77*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9607226" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter a value or a cell reference.</ahelp></paragraph><comment>shrinker</comment> 78*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_OBJECTIVECELL" id="bm_id5104220" localize="false"/> 79*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_TARGET" id="bm_id6714" localize="false"/> 80*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_VARIABLECELLS" id="bm_id8507339" localize="false"/> 81*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_LEFT1" id="bm_id5296792" localize="false"/> 82*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_LEFT2" id="bm_id3949400" localize="false"/> 83*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_LEFT3" id="bm_id9991760" localize="false"/> 84*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_LEFT4" id="bm_id2726828" localize="false"/> 85*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_RIGHT1" id="bm_id6034424" localize="false"/> 86*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_RIGHT2" id="bm_id6998809" localize="false"/> 87*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_RIGHT3" id="bm_id71413" localize="false"/> 88*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_RIGHT4" id="bm_id2924283" localize="false"/> 89*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id1939451" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to shrink or restore the dialog. You can click or select cells in the sheet. You can enter a cell reference manually in the input box.</ahelp></paragraph><comment>delete row</comment> 90*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_DELETE1" id="bm_id5781731" localize="false"/> 91*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_DELETE2" id="bm_id6942045" localize="false"/> 92*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_DELETE3" id="bm_id4721823" localize="false"/> 93*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_OPTSOLVER:IB_DELETE4" id="bm_id5806756" localize="false"/> 94*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9038972" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to remove the row from the list. Any rows from below this row move up.</ahelp></paragraph><comment>options button</comment> 95*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_OPTSOLVER:BTN_OPTIONS" id="bm_id8915372" localize="false"/> 96*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2423780" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Opens the Options dialog.</ahelp></paragraph><comment>solve button</comment> 97*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_OPTSOLVER:BTN_SOLVE" id="bm_id6070436" localize="false"/> 98*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2569658" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to solve the equation with the current settings. The dialog settings are retained until you close the current document.</ahelp></paragraph> 99*b1cdbd2cSJim Jagielski<paragraph role="heading" id="par_id5474410" xml-lang="en-US" level="2" l10n="NEW">To solve equations with the solver</paragraph> 100*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id2216559" xml-lang="en-US" l10n="NEW">The goal of the solver process is to find those variable values of an equation that result in an optimized value in the <emph>target cell</emph>, also named the "objective". You can choose whether the value in the target cell should be a maximum, a minimum, or approaching a given value.</paragraph> 101*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id7869502" xml-lang="en-US" l10n="NEW">The initial variable values are inserted in a rectangular cell range that you enter in the <emph>By changing cells</emph> box. </paragraph> 102*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id9852900" xml-lang="en-US" l10n="NEW">You can define a series of limiting conditions that set constraints for some cells. For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or not bigger than a given value. You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed).</paragraph> 103*b1cdbd2cSJim Jagielski<paragraph role="note" id="par_id5323953" xml-lang="en-US" l10n="NEW">The default solver engine supports only linear equations.</paragraph><comment>Add an example. A good one is at http://www.solver.com/stepbystep.htm but that is not OpenSource</comment> 104*b1cdbd2cSJim Jagielski</body> 105*b1cdbd2cSJim Jagielski</helpdocument> 106