AllLangHelp_scalc.mk | 1
source/auxiliary/scalc.tree | 1
source/text/scalc/01/solver.xhp | 90 ++++--
source/text/scalc/01/solver_options.xhp | 51 ++-
source/text/scalc/01/solver_options_algo.xhp | 386 +++++++++++++++++++++++++++
5 files changed, 493 insertions(+), 36 deletions(-)
New commits:
commit abe8187060201a5e62844b53d3786c6b99070ec2
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri May 22 14:25:26 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Fri May 22 19:34:49 2020 +0200
tdf81599 Better Help pages for Calc Solvers
Add information on algorithms paramenters
Change-Id: I36f330593687efa616594e397cb7d6054c2198ed
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94703
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index d8660002b..d0599281e 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -266,6 +266,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/live_data_stream \
helpcontent2/source/text/scalc/01/solver \
helpcontent2/source/text/scalc/01/solver_options \
+ helpcontent2/source/text/scalc/01/solver_options_algo \
helpcontent2/source/text/scalc/01/statistics \
helpcontent2/source/text/scalc/01/statistics_anova \
helpcontent2/source/text/scalc/01/statistics_correlation \
diff --git a/source/auxiliary/scalc.tree b/source/auxiliary/scalc.tree
index a82517bec..8aeeaac28 100644
--- a/source/auxiliary/scalc.tree
+++ b/source/auxiliary/scalc.tree
@@ -190,6 +190,7 @@
<topic id="scalc/text/scalc/guide/auto_off.xhp">Deactivating Automatic
Changes</topic>
<topic id="scalc/text/scalc/guide/consolidate.xhp">Consolidating Data</topic>
<topic id="scalc/text/scalc/guide/goalseek.xhp">Applying Goal Seek</topic>
+<topic id="scalc/text/scalc/01/solver.xhp">Using Linear and Non-Linear
Solvers</topic>
<topic id="scalc/text/scalc/guide/multioperation.xhp">Applying Multiple
Operations</topic>
<topic id="scalc/text/scalc/guide/multitables.xhp">Applying Multiple
Sheets</topic>
<topic id="scalc/text/scalc/guide/validity.xhp">Validity of Cell
Contents</topic>
diff --git a/source/text/scalc/01/solver.xhp b/source/text/scalc/01/solver.xhp
index 956f21211..188b05f8c 100644
--- a/source/text/scalc/01/solver.xhp
+++ b/source/text/scalc/01/solver.xhp
@@ -27,54 +27,70 @@
<body>
-
<section id="solverhead">
<bookmark xml-lang="en-US" branch="index" id="bm_id7654652">
<bookmark_value>goal seeking;solver</bookmark_value>
<bookmark_value>what if operations;solver</bookmark_value>
<bookmark_value>back-solving</bookmark_value>
<bookmark_value>solver</bookmark_value>
+ <bookmark_value>mathematical programming;solver for Calc</bookmark_value>
+ <bookmark_value>mathematical optimization;solver for Calc</bookmark_value>
+ <bookmark_value>operations research;solver for Calc</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solverdlg/SolverDialog" id="bm_id5634023"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solverdlg/@@nowidget@@" id="bm_id5634023"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:SolverDialog" id="bm_id5634022"
localize="false"/>
-<paragraph id="hd_id9216284" role="heading" level="1"
xml-lang="en-US"><variable id="solver"><link
href="text/scalc/01/solver.xhp">Solver</link></variable></paragraph>
-<paragraph id="par_id9210486" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Opens the Solver dialog. A solver allows you to solve equations with
multiple unknown variables by goal-seeking methods.</ahelp></paragraph>
+<h1 id="hd_id9216284"><variable id="solver"><link
href="text/scalc/01/solver.xhp">Solver</link></variable></h1>
+<paragraph id="par_id9210486" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Opens the Solver dialog. A solver allows you to solve mathematical
problems with multiple unknown variables and a set of constraints on the
variables by goal-seeking methods.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#solver"/>
-</section><comment>target cell</comment>
+</section>
+<comment>target cell</comment>
+<h2 id="hd_id21589912365601">Solver settings</h2>
+
+<note id="par_id501589912905479">The dialog settings are retained until you
close the current document.</note>
+
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/targetedit"
id="bm_id8861964" localize="false"/>
-<paragraph id="par_id8538773" role="paragraph" xml-lang="en-US"><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>
+<h3 id="hd_id121589913023217">Target Cell</h3>
+<paragraph id="par_id8538773" role="paragraph" xml-lang="en-US"><ahelp
hid=".">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>
+
+<h3 id="hd_id441589913036601">Optimize results to</h3>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/max"
id="bm_id8373973" localize="false"/>
-<paragraph id="par_id7564012" role="paragraph" xml-lang="en-US"><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>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/min"
id="bm_id6767174" localize="false"/>
-<paragraph id="par_id1186254" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Try to solve the equation for a minimum value of the target
cell.</ahelp></paragraph><comment>value of</comment>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/value"
id="bm_id5222022" localize="false"/>
-<paragraph id="par_id7432477" role="paragraph" xml-lang="en-US"><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>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/valueedit"
id="bm_id2756126" localize="false"/>
-<paragraph id="par_id7141026" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Enter the value or a cell
reference.</ahelp></paragraph><comment>by changing cells</comment>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/value"
id="bm_id5222022" localize="false"/>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id7564012" role="listitem" xml-lang="en-US"><ahelp
hid="."><emph>Maximum:</emph> Try to solve the equation for a maximum value of
the target cell.</ahelp></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id1186254" role="listitem" xml-lang="en-US"><ahelp
hid="."><emph>Minimum:</emph> Try to solve the equation for a minimum value of
the target cell.</ahelp></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id7432477" role="listitem" xml-lang="en-US"><ahelp
hid="."><emph>Value of:</emph> Try to solve the equation to approach a given
value of the target cell.</ahelp></paragraph>
+ <paragraph id="par_id7141026" role="listitem" xml-lang="en-US"><ahelp
hid=".">Enter the value or a cell reference in the text
field.</ahelp></paragraph>
+ </listitem>
+</list>
+
+<h3 id="hd_id761589914010085">By Changing Cells</h3>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/changeedit"
id="bm_id4908902" localize="false"/>
-<paragraph id="par_id8531449" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Enter the cell range that can be
changed.</ahelp></paragraph><comment>cell reference</comment>
+<paragraph id="par_id8531449" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Enter the cell range that can be changed.</ahelp> These are the
variables of the equations.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/ref1edit"
id="bm_id8499099" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/ref2edit"
id="bm_id9544663" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/ref3edit"
id="bm_id5762199" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/ref4edit"
id="bm_id9534287" localize="false"/>
-<paragraph id="par_id9183935" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Enter a cell
reference.</ahelp></paragraph><comment>operators</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/op1list"
id="bm_id9408551" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/op2list"
id="bm_id1329386" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/op3list"
id="bm_id4931180" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/op4list"
id="bm_id5970030" localize="false"/>
-<paragraph id="par_id946684" role="paragraph" xml-lang="en-US"><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?
-I hate such spec docs that leave so many
questions</comment></paragraph><comment>value</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var1edit"
id="bm_id496841" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var2edit"
id="bm_id7440717" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var3edit"
id="bm_id2470778" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var4edit"
id="bm_id3389080" localize="false"/>
-<paragraph id="par_id9607226" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Enter a value or a cell
reference.</ahelp></paragraph><comment>shrinker</comment>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solverdlg/targetbutton" id="bm_id5104220"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/valuebutton"
id="bm_id6714" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solverdlg/changebutton" id="bm_id8507339"
localize="false"/>
@@ -86,22 +102,52 @@ I hate such spec docs that leave so many
questions</comment></paragraph><comment
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var2button"
id="bm_id6998809" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var3button"
id="bm_id71413" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/var4button"
id="bm_id2924283" localize="false"/>
-<paragraph id="par_id1939451" role="paragraph" xml-lang="en-US"><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>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/del1"
id="bm_id5781731" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/del2"
id="bm_id6942045" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/del3"
id="bm_id4721823" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/del4"
id="bm_id5806756" localize="false"/>
-<paragraph id="par_id9038972" role="paragraph" xml-lang="en-US"><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>
+
+<h3 id="hd_id671589914927836">Limiting Conditions</h3>
+<paragraph role="paragraph" id="par_id421589915278885">Add the set of
constraints for the mathematical problem. Each constraint is represented by a
cell reference (a variable), an operator, and a value.</paragraph>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id9183935" role="listitem" xml-lang="en-US"><ahelp
hid="."><emph>Cell reference:</emph> Enter a cell reference of the
variable.</ahelp></paragraph>
+ <paragraph id="par_id1939451" role="listitem" xml-lang="en-US"><ahelp
hid=".">Click the Shrink button 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>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id946684" role="listitem" xml-lang="en-US"><ahelp
hid="."><emph>Operator:</emph> Select an operator from the list.</ahelp> Use
Binary operator to restrict your variable to 0 or 1. Use the Integer operator
to restrict your variable to take only integer values (no decimal
part).</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id9607226" role="listitem" xml-lang="en-US"><ahelp
hid="." ><emph>Value:</emph> Enter a value or a cell reference.</ahelp> This
field is ignored when the operator is Binary or Integer.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id9038972" role="paragraph" xml-lang="en-US"><ahelp
hid="."><emph>Remove button:</emph> Click to remove the row from the list. Any
rows from below this row move up.</ahelp></paragraph>
+ </listitem>
+</list>
+<note id="par_id511589916338595">You can set multiple conditions for a
variable. For example, a variable in cell A1 that must be an integer less than
10. In that case, set two limiting conditions for A1.</note>
+
+<h3 id="hd_id441589917031236">Options</h3>
+
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/options"
id="bm_id8915372" localize="false"/>
-<paragraph id="par_id2423780" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Opens the Options dialog.</ahelp></paragraph><comment>solve
button</comment>
+<paragraph id="par_id2423780" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Opens the <link href="text/scalc/01/solver_options.xhp#solveroptionsh1"
name="solveroptions">Solver Options</link> dialog.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id221589917833431">The <emph>Solver
Options</emph> dialog let you select the different solver algorithms for either
linear and non-linear problems and set their solving parameters.</paragraph>
+<h3 id="hd_id771589917064147">Solve</h3>
+<comment>solve button</comment>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/solverdlg/solve"
id="bm_id6070436" localize="false"/>
-<paragraph id="par_id2569658" role="paragraph" xml-lang="en-US"><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>
+<paragraph id="par_id2569658" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Click to solve the problem with the current settings. The dialog
settings are retained until you close the current document.</ahelp></paragraph>
-<paragraph id="par_id5474410" role="heading" level="2" xml-lang="en-US">To
solve equations with the solver</paragraph>
+<h2 id="par_id5474410">To solve equations with the solver</h2>
<paragraph id="par_id2216559" role="paragraph" xml-lang="en-US">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>
<paragraph id="par_id7869502" role="paragraph" xml-lang="en-US">The initial
variable values are inserted in a rectangular cell range that you enter in the
<emph>By changing cells</emph> box.</paragraph>
<paragraph id="par_id9852900" role="paragraph" xml-lang="en-US">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>
-<paragraph id="par_id5323953" role="note" xml-lang="en-US">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>
+<h2 id="hd_id0603200910430882">Using Non-Linear solvers</h2>
+<paragraph xml-lang="en-US" id="par_id0603200910430845"
role="paragraph">Regardless whether you use DEPS or SCO, you start by going to
<menuitem>Tools - Solver</menuitem> and set the Cell to be optimized, the
direction to go (minimization, maximization) and the cells to be modified to
reach the goal. Then you go to the Options and specify the solver to be used
and if necessary adjust the according <link
href="text/scalc/01/solver_options.xhp">parameters</link>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id0603200910430821" role="paragraph">There
is also a list of constraints you can use to restrict the possible range of
solutions or to penalize certain conditions. However, in case of the
evolutionary solvers DEPS and SCO, these constraints are also used to specify
bounds on the variables of the problem. Due to the random nature of the
algorithms, it is <emph>highly recommended</emph> to do so and give upper (and
in case "Assume Non-Negative Variables" is turned off also lower) bounds for
all variables. They don't have to be near the actual solution (which is
probably unknown) but should give a rough indication of the expected size (0 ≤
var ≤ 1 or maybe -1000000 ≤ var ≤ 1000000).</paragraph>
+<paragraph xml-lang="en-US" id="par_id0603200910430873"
role="paragraph">Bounds are specified by selecting one or more variables (as
range) on the left side and entering a numerical value (not a cell or a
formula) on the right side. That way you can also choose one or more variables
to be <emph>Integer</emph> or <emph>Binary</emph> only.</paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/solver_options.xhp#solveroptionsh1"/>
+ <embed
href="text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1"/>
+ <paragraph role="paragraph" id="par_id271589981559367"><link
href="https://wiki.documentfoundation.org/"; name="wikipage">Wiki page on
solvers and theirs algorithms</link></paragraph>
+</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/solver_options.xhp
b/source/text/scalc/01/solver_options.xhp
index d77b3850a..e4e2291d4 100644
--- a/source/text/scalc/01/solver_options.xhp
+++ b/source/text/scalc/01/solver_options.xhp
@@ -20,7 +20,7 @@
<meta>
<topic id="textscalc01solver_optionsxml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Options</title>
+ <title id="tit" xml-lang="en-US">Solver Options</title>
<filename>/text/scalc/01/solver_options.xhp</filename>
</topic>
</meta>
@@ -29,29 +29,52 @@
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solveroptionsdialog/SolverOptionsDialog"
id="bm_id7214271" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solveroptionsdialog/@@nowidget@@"
id="bm_id7214271" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id291590166034871">
+ <bookmark_value>solver for Calc;options</bookmark_value>
+</bookmark>
+<h1 id="hd_id2794274"><variable id="solveroptionsh1"><link
href="text/scalc/01/solver_options.xhp" name="Solver Options">Solver
Options</link></variable></h1>
-<paragraph id="hd_id2794274" role="heading" level="1"
xml-lang="en-US">Options</paragraph>
-<paragraph id="par_id6776940" role="paragraph" xml-lang="en-US">The Options
dialog for the <link href="text/scalc/01/solver.xhp">Solver</link> is used to
set some options.</paragraph>
+<paragraph id="par_id3163853" role="paragraph" xml-lang="en-US">Use the
Options dialog to configure the solver engine.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000406.xhp#solver_options"/>
-</section><comment>solver engine</comment>
+</section>
+
+<paragraph id="par_id9999694" role="paragraph" xml-lang="en-US">Click OK to
accept the changes and to go back to the <link
href="text/scalc/01/solver.xhp">Solver</link> dialog.</paragraph>
+<h2 id="hd_id581589922716672">Solver engine</h2>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solveroptionsdialog/engine" id="bm_id7214270"
localize="false"/>
-<paragraph id="par_id393993" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Select a solver engine. The listbox is disabled if only one
solver engine is installed. Solver engines can be installed as
extensions.</ahelp></paragraph><comment>settings</comment>
+<paragraph id="par_id393993" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Select a solver engine. The listbox is disabled if only one solver
engine is installed.</ahelp></paragraph>
+<note id="par_id221589959855748">You can install more solver engines as
extensions, if available. Open <menuitem>Tools - Extension Manager</menuitem>
and browse to the Extensions web site to search for extensions.</note>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solveroptionsdialog/settings" id="bm_id1331217"
localize="false"/>
-<paragraph id="par_id5871761" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Configure the current
solver.</ahelp></paragraph><comment>edit</comment>
+<h2 id="hd_id711589922750833">Settings</h2>
+<paragraph id="par_id130619" role="paragraph" xml-lang="en-US">Configure the
current solver. In the Settings box, check all settings that you want to use
for the current goal seeking operation. If the current option offers different
values, the Edit button is enabled. Click <emph>Edit</emph> to open a dialog
where you can change the value.</paragraph>
+<list type="unordered">
+ <listitem>
+ <paragraph id="par_id651589925044267" role="listitem"
localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2"/></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id391589925078747" role="listitem"
localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2"/></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id671589925148891" role="listitem"
localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#LinearSolverh2"/></paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id711589925192067" role="listitem"
localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#SwarmNonLinearSolverh2"/></paragraph>
+ </listitem>
+</list>
+<h2 id="hd_id481589922813764">Edit</h2>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/solveroptionsdialog/edit" id="bm_id2186346"
localize="false"/>
-<paragraph id="par_id6531266" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">If the current entry in the Settings listbox allows you to
edit a value, you can click the Edit button. A dialog opens where you can
change the value.</ahelp></paragraph><comment>edit settings spin box</comment>
+<paragraph id="par_id6531266" role="paragraph" xml-lang="en-US"><ahelp
hid=".">If the current entry in the Settings listbox allows you to edit a
value, you can click the Edit button. A dialog opens where you can change the
value.</ahelp></paragraph>
+<h2 id="hd_id331589923158248">Edit settings spin box</h2>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/doubledialog/DoubleDialog" id="bm_id2761315"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/doubledialog/@@nowidget@@" id="bm_id2761315"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/integerdialog/IntegerDialog" id="bm_id2761314"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/integerdialog/@@nowidget@@" id="bm_id2761314"
localize="false"/>
-<paragraph id="par_id3912778" role="paragraph" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Enter or change the value.</ahelp></paragraph>
-<paragraph id="par_id3163853" role="paragraph" xml-lang="en-US">Use the
Options dialog to configure the current solver engine.</paragraph>
-<paragraph id="par_id121158" role="paragraph" xml-lang="en-US">You can install
more solver engines as extensions, if available. Open Tools - Extension Manager
and browse to the Extensions web site to search for extensions.</paragraph>
-<paragraph id="par_id3806878" role="paragraph" xml-lang="en-US">Select the
solver engine to use and to configure from the listbox. The listbox is disabled
if only one solver engine is installed.</paragraph>
-<paragraph id="par_id130619" role="paragraph" xml-lang="en-US">In the Settings
box, check all settings that you want to use for the current goal seeking
operation. If the current option offers different values, the Edit button is
enabled. Click Edit to open a dialog where you can change the value.</paragraph>
-<paragraph id="par_id9999694" role="paragraph" xml-lang="en-US">Click OK to
accept the changes and to go back to the <link
href="text/scalc/01/solver.xhp">Solver</link> dialog.</paragraph>
+<paragraph id="par_id3912778" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Enter or change the value of the selected setting.</ahelp></paragraph>
+<section id="relatedtopics">
+ <embed href="text/scalc/01/solver.xhp#solver"/>
+ <embed
href="text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1"/>
+ <paragraph role="paragraph" id="par_id271589981559367"><link
href="https://wiki.documentfoundation.org/NLPSolver"; name="wikipage">Wiki page
on non-linear solvers and theirs algorithms</link></paragraph>
+</section>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/01/solver_options_algo.xhp
b/source/text/scalc/01/solver_options_algo.xhp
new file mode 100644
index 000000000..486212284
--- /dev/null
+++ b/source/text/scalc/01/solver_options_algo.xhp
@@ -0,0 +1,386 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+ <meta>
+ <topic id="nlpsolveroptions" indexer="include">
+ <title xml-lang="en-US" id="tit">Options</title>
+ <filename>/text/scalc/01/solver_options_algo.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id0503200917110375_scalc">
+ <bookmark_value>Solver for Nonlinear Problems;Options</bookmark_value>
+ <bookmark_value>solver for Calc; DEPS evolutionary
algorithm</bookmark_value>
+ <bookmark_value>solver for Calc; SCO evolutionary
algorithm</bookmark_value>
+ <bookmark_value>solver for Calc; linear solver</bookmark_value>
+ <bookmark_value>solver for Calc; CoinMP linear solver</bookmark_value>
+ <bookmark_value>solver for Calc; swarm non-linear solver</bookmark_value>
+ </bookmark>
+
+ <h1 id="hd_id0503200917103593"><variable
id="SolverAlgorithmsOptionsh1"><link
href="text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1"
name="Solver Algorithms Options">Solver Algorithms
Options</link></variable></h1>
+
+ <h2 id="par_id651589925044267"><variable
id="DEPSEvolutionaryalgorithmh2"><link
href="text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2"
name="DEPS Evolutionary algorithm">DEPS Evolutionary
Algorithm</link></variable></h2>
+ <paragraph role="paragraph" id="par_id931590164412542">DEPS consists of
two independent algorithms: Differential Evolution and Particle Swarm
Optimization. Both are especially suited for numerical problems, such as
nonlinear optimization, and are complementary to each other in that they even
out their others shortcomings. </paragraph>
+ <table id="id=tab_id971589978166858">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91559962440066" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#settingshead"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111584962440067" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#descriptionhead"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394232"
role="tablecontent" >Agent Switch Rate</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394248"
role="tablecontent" >Specifies the probability for an individual to choose the
Differential Evolution strategy.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481559963120045" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#noneghead"
markup="ignore"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301589063120047" role="tablecontent"
xml-lang="en-US" localize="false" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#nonegdesc"
markup="ignore"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394277"
role="tablecontent" >DE: Crossover Probability</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394280"
role="tablecontent" >Defines the probability of the individual being combined
with the globally best point. If crossover is not used, the point is assembled
from the own memory of the individual.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0643200910394216"
role="tablecontent" >DE: Scaling Factor</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id360320091039424"
role="tablecontent" >During crossover, the scaling factor decides about the
“speed” of movement.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0507200917103771"
role="tablecontent" >Learning Cycles</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503210917103720"
role="tablecontent" >Defines the number of iterations, the algorithm should
take. In each iteration, all individuals make a guess on the best solution and
share their knowledge.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3603200910394222"
role="tablecontent" >PS: Cognitive Constant</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3603200915394212"
role="tablecontent" >Sets the importance of the own memory (in particular the
best reached point so far).</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id060324091037421"
role="tablecontent" >PS: Constriction Coefficient</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0608200910394225"
role="tablecontent" >Defines the speed at which the particles/individuals move
towards each other.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id060320091039425"
role="tablecontent" >PS: Mutation Probability</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394272"
role="tablecontent" >Defines the probability, that instead of moving a
component of the particle towards the best point, it randomly chooses a new
value from the valid range for that variable.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394292"
role="tablecontent" >PS: Social Constant</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910394284"
role="tablecontent" >Sets the importance of the global best point between all
particles/individuals.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200217103891"
role="tablecontent" ><variable id="enhstatusheader">Show Enhanced Solver
Status</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0523200917103832"
role="tablecontent" ><variable id="enhstatusdesc">If <emph>enabled</emph>, an
additional dialog is shown during the solving process which gives information
about the current progress, the level of stagnation, the currently best known
solution as well as the possibility, to stop or resume the
solver.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200417103780"
role="tablecontent" ><variable id="swarmheader">Size of
Swarm</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503100917103723"
role="tablecontent" ><variable id="swarmdesc">Defines the number of individuals
to participate in the learning process. Each individual finds its own solutions
and contributes to the overall knowledge.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0504200917103794"
role="tablecontent" ><variable id="stagnationheader">Stagnation
Limit</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id050320091710377"
role="tablecontent" ><variable id="stagnationdesc">If this number of
individuals found solutions within a close range, the iteration is stopped and
the best of these values is chosen as optimal.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103762"
role="tablecontent" ><variable id="stagtolheader">Stagnation
Tolerance</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103834"
role="tablecontent" ><variable id="stagtoldesc">Defines in what range solutions
are considered “similar”.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103740"
role="tablecontent" ><variable id="acrheader">Use ACR
Comparator</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <section id="acrdesc">
+ <paragraph xml-lang="en-US" id="par_id0503200917103766"
role="tablecontent" >If <emph>disabled</emph> (default), the BCH Comparator is
used. It compares two individuals by first looking at their constraint
violations and only if those are equal, it measures their current
solution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0503200917103744"
role="tablecontent" >If <emph>enabled</emph>, the ACR Comparator is used. It
compares two individuals dependent on the current iteration and measures their
goodness with knowledge about the libraries worst known solutions (in regard to
their constraint violations).</paragraph>
+ </section>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103792"
role="tablecontent" >Use Random Starting Point</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103790"
role="tablecontent" >If <emph>enabled</emph>, the library is simply filled up
with randomly chosen points.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id0503200917103765"
role="tablecontent" >If <emph>disabled</emph>, the currently present values (as
given by the user) are inserted in the library as reference point.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103732"
role="tablecontent" ><variable id="variableguessheader">Variable Bounds
Guessing</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id050320091710378"
role="tablecontent" ><variable id="variableguessdesc">If enabled (default), the
algorithm tries to find variable bounds by looking at the starting
values.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103794"
role="tablecontent" ><variable id="variablethresheader">Variable Bounds
Threshold</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103710"
role="tablecontent" ><variable id="variablethresdesc">When guessing variable
bounds, this threshold specifies, how the initial values are shifted to build
the bounds. For an example how these values are calculated, please refer to the
Manual in the Wiki.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+
+ <h2 id="par_id391589925078747"><variable
id="SCOEvolutionaryAlgorithmh2"><link
href="text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2"
name="SCO Evolutionary Algorithm">SCO Evolutionary
Algorithm</link></variable></h2>
+ <paragraph role="paragraph" id="par_id681590165847694">Social Cognitive
Optimization takes into account the human behavior of learning and sharing
information. Each individual has access to a common library with knowledge
shared between all individuals. </paragraph>
+ <table id="tab_id911589978200895">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id41589962440066" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#settingshead"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11158996249067" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#descriptionhead"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481552963120045" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#noneghead"
markup="ignore"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341589063120047" role="tablecontent"
xml-lang="en-US" localize="false" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#nonegdesc"
markup="ignore"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103771"
role="tablecontent" >Learning Cycles</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0503200917103720"
role="tablecontent" >Defines the number of iterations, the algorithm should
take. In each iteration, all individuals make a guess on the best solution and
share their knowledge.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id961589978701649" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#enhstatusheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id591589978701651" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#enhstatusdesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id0603200910401382"
role="tablecontent">Size of Library</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id060320091040136"
role="tablecontent"> Defines the amount of information to store in the public
library. Each individual stores knowledge there and asks for
information.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id201589979438102" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#swarmheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id51589979438103" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#swarmdesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id21589979541011" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#stagnationheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381589979541012" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#stagnationdesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id371589979941538" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#stagtolheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id991589979941539" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#stagtoldesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id921589980257791" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#acrheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <embed href="text/scalc/01/solver_options_algo.xhp#acrdesc"/>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id941589980611077" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#variableguessheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id561589980611078" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#variableguessdesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id741589980722689" role="tablecontent"
xml-lang="en-US" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#variablethresheader"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id901589980722691" role="tablecontent"
xml-lang="en-US" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#variablethresdesc"/></paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <h2 id="par_id671589925148891"><variable id="LinearSolverh2"><link
href="text/scalc/01/solver_options_algo.xhp#LinearSolverh2" name="%PRODUCTNAME
Linear Solver">%PRODUCTNAME Linear Solver and CoinMP Linear
solver</link></variable></h2>
+ <table id="tab_id251589925837980">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id731589925837981" role="tablehead"
xml-lang="en-US"><variable id="settingshead">Setting</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id611589925837982" role="tablehead"
xml-lang="en-US"><variable
id="descriptionhead">Description</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id511589925837984" role="paragraph"
xml-lang="en-US"><variable id="integerhead">Assume variables as
integers</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id11589925837985" role="paragraph"
xml-lang="en-US"><variable id="integerdesc">Mark to force variables to be
integers only.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id221589961756407" role="tablecontent"
xml-lang="en-US" ><variable id="noneghead">Assume variables as non
negative</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id861589961756408" role="tablecontent"
xml-lang="en-US" ><variable id="nonegdesc">Mark to force variables to be
positive only.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id971589961907787" role="tablecontent"
xml-lang="en-US" >Epsilon level</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421589961907788" role="tablecontent"
xml-lang="en-US" >Epsilon level. Valid values are in range 0 (very tight) to 3
(very loose). Epsilon is the tolerance for rounding values to zero.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id71589961998523" role="tablecontent"
xml-lang="en-US" >Limit branch-and-bound depth</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331589961998525" role="tablecontent"
xml-lang="en-US" > Specifies the maximum branch-and-bound depth. A positive
value means that the depth is absolute. A negative value means a relative
branch-and-bound depth limit.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91589962070327" role="tablecontent"
xml-lang="en-US" ><variable id="timelimithead">Solver time
limit</variable></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331589962070329" role="tablecontent"
xml-lang="en-US" ><variable id="timelimitdesc">Sets the maximum time for the
algorithm to converge to a solution.</variable></paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <h2 id="par_id711589925192067"><variable id="SwarmNonLinearSolverh2"><link
href="text/scalc/01/solver_options_algo.xhp#SwarmNonLinearSolverh2"
name="%PRODUCTNAME Swarm Non-Linear Solver (Experimental)">%PRODUCTNAME Swarm
Non-Linear Solver (Experimental)</link></variable></h2>
+ <table id="tab_id471589962440065">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91589962440066" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#settingshead"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111589962440067" role="tablehead"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#descriptionhead"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id581589962440069" role="paragraph"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#integerhead"
markup="ignore"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id161589962440070" role="paragraph"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#integerdesc"
markup="ignore"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481589963120045" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#noneghead"
markup="ignore"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301589963120047" role="tablecontent"
xml-lang="en-US" localize="false" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#nonegdesc"
markup="ignore"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id101589963304145" role="tablecontent"
xml-lang="en-US" localize="false" ><embedvar
href="text/scalc/01/solver_options_algo.xhp#timelimithead"
markup="ignore"/></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461589963304146" role="tablecontent"
xml-lang="en-US" localize="false"><embedvar
href="text/scalc/01/solver_options_algo.xhp#timelimitdesc"
markup="ignore"/></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id971589963431459" role="tablecontent"
xml-lang="en-US" >Swarm algorithm</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id71589963431460" role="tablecontent"
xml-lang="en-US" >Set the swarm algorithm. 0 for differential evolution and 1
for particle swarm optimization. Default is 0.</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/solver_options.xhp#solveroptionsh1"/>
+ <embed href="text/scalc/01/solver.xhp#solver"/>
+ <paragraph role="paragraph" id="par_id271589981559367"><link
href="https://wiki.documentfoundation.org/NLPSolver"; name="wikipage">Wiki page
on non-linear solvers and theirs algorithms</link></paragraph>
+ <paragraph role="paragraph" id="par_id211590163660314"><link
href="http://lpsolve.sourceforge.net/";>lp_solve reference guide in
sourceforge.net</link></paragraph>
+ </section>
+</body>
+</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
