aboutsummaryrefslogtreecommitdiff
path: root/source/om/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/om/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/om/helpcontent2/source/text/scalc/01.po1021
1 files changed, 884 insertions, 137 deletions
diff --git a/source/om/helpcontent2/source/text/scalc/01.po b/source/om/helpcontent2/source/text/scalc/01.po
index 2de280ea519..12e694aafac 100644
--- a/source/om/helpcontent2/source/text/scalc/01.po
+++ b/source/om/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-05-05 14:59+0200\n"
+"POT-Creation-Date: 2020-05-27 11:43+0200\n"
"PO-Revision-Date: 2018-11-12 13:58+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5829,14 +5829,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Calculates the amount of depreciation for a settlement period as degressive amortization.</ahelp> Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here."
msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Yeroodhaaf depireeshinii akka appoortayizeeshinii degreesiviitti shallagi.</ahelp> AMORLINC malee, coffishantiin dipreeshinii asitti fayyada."
-#. i8TkC
+#. DEtMa
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3147427\n"
"help.text"
-msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
-msgstr "AMORDEGRC(gatii; guyyaa gurgurame;yeroo duraa; kan balaarraa hafe; yeroo;maakkii;Bu'uura)"
+msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
+msgstr ""
#. bA2pT
#: 04060103.xhp
@@ -5919,14 +5919,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Hamma dipireeshinii kuusama yerootiif akka ammoortizeeshiniitti shallaga.Yoo caapitaalli yeroo kuufamaatti bitame,hangi prooporshinii dipirisheeshinii ilaalcha keessa gala.</ahelp>"
-#. 3n4Kb
+#. jD9JZ
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3147363\n"
"help.text"
-msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis)"
-msgstr "AMORDEGRC(gatii; guyyaa gurgurame;yeroo duraa; kan balaarraa hafe; yeroo;maakkii;Bu'uura)"
+msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])"
+msgstr ""
#. PsFjE
#: 04060103.xhp
@@ -6018,14 +6018,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Kanfaltii yeroo yeroon ta'u keessatti dhala kennaa ittisaa shallaga.</ahelp>"
-#. oHnfa
+#. yGdCf
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3159092\n"
"help.text"
-msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis)"
-msgstr "ACCRINT(Kennaa; Dhala jalqabaa; Kuufama; Makkii; paarii; firkuweensiin ;Bu'uura)"
+msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])"
+msgstr ""
#. PKp6i
#: 04060103.xhp
@@ -6126,14 +6126,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calculates the accrued interest of a security in the case of one-off payment at the settlement date.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Kanfaltii yeroo yeroon ta'u keessatti dhala kennaa ittisaa shallaga.</ahelp>"
-#. uRZWP
+#. zFkiX
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3147074\n"
"help.text"
-msgid "ACCRINTM(Issue; Settlement; Rate; Par; Basis)"
-msgstr "ACCRINTM(Kennaa;Kuufama;Makkii;Paarii;Bu'uura)"
+msgid "ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])"
+msgstr ""
#. pTobQ
#: 04060103.xhp
@@ -6333,14 +6333,14 @@ msgctxt ""
msgid "Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under <emph>Rate</emph> and <item type=\"productname\">%PRODUCTNAME</item> Calc with automatically calculate the correct factor."
msgstr "Gatii kana akka lakkoofsotaatti,ibsaatti ykn akka wabiitti galchaa.Yoo, fakkeenyaaf,dhalli waggaatti 8% kanfalame,garuu yoo ji'a akka yeroo keessaniitti fayyadamuu barbaaddan,8%/12 makkii jala <emph>galchuu</emph>fi<item type=\"productname\">%PRODUCTNAME</item>Calc batalumatti faaktarii sirrii shallaga."
-#. BVQTK
+#. uiDaD
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3150395\n"
"help.text"
-msgid "PV(Rate; NPer; Pmt; FV; Type)"
-msgstr "PV(Makkii; NPer; Pmt; FV; Gosa)"
+msgid "PV(Rate; NPer; Pmt[; FV][; Type])"
+msgstr ""
#. JrCA6
#: 04060103.xhp
@@ -7359,14 +7359,14 @@ msgctxt ""
msgid "Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type."
msgstr "Gatii dippirisheeshinii jalqabaa olaanaa faallaa dippirisheeshinii liinarii ta'e yoo barbaadde unka kana fayyadami. Tokko tokkoo yerootti gatiin dippirisheeshinii hir'achaa deema dabalataanis bittaa booda qabeenyota kasaaraan gatii isaanii guddaa ta'eef (fakkeenyaaf, konkolaattota,kompiiyuutaroota) yeroo hunda fayyada.Maaloo gosa shallagii kana jalatti gatiin buukii gonkuma akka zeeroo hin taane hubadhu."
-#. GnhjW
+#. EV3DT
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3166452\n"
"help.text"
-msgid "DDB(Cost; Salvage; Life; Period; Factor)"
-msgstr "DDB(Gatiis Salvage; Liriod; Hirmaataa)"
+msgid "DDB(Cost; Salvage; Life; Period[; Factor])"
+msgstr ""
#. VKnDB
#: 04060103.xhp
@@ -7467,14 +7467,14 @@ msgctxt ""
msgid "This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost."
msgstr "Yoo jalqaba dippirisheeshinii irratti(akka faallaa dippirisheeshinii sorooroo ta'etti) gatii dippiakkrisheeshii guddaa yoo barbaadde unki dippirisheeshinii kun ni fayyadamama.Gatiin dippirisheeshinii dippirisheeshinii gatii jalqabaa irraa xiinxalameetiin yeroo dippirisheeshinii hunda waliin hir'ata."
-#. zaXLw
+#. EDXF8
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3153349\n"
"help.text"
-msgid "DB(Cost; Salvage; Life; Period; Month)"
-msgstr "DB(Gatii; Salveejii; Jiruu; Yeroo; Ji'a)"
+msgid "DB(Cost; Salvage; Life; Period[; Month])"
+msgstr ""
#. caSta
#: 04060103.xhp
@@ -7584,14 +7584,14 @@ msgctxt ""
msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link> function."
msgstr ""
-#. CCfhc
+#. zWTAW
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3155427\n"
"help.text"
-msgid "IRR(Values; Guess)"
-msgstr "IRR(Gatiiwwan; Tilmaama)"
+msgid "IRR(Values[; Guess])"
+msgstr ""
#. o9R77
#: 04060103.xhp
@@ -9447,14 +9447,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ZELLE\">Returns information on address, formatting or contents of a cell.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ZELLE\">odeeffannoo teessoo irratti,dhangii ykn qabeentoota man'ee deebisa.</ahelp>"
-#. P9UHc
+#. RWBPC
#: 04060104.xhp
msgctxt ""
"04060104.xhp\n"
"par_id3147355\n"
"help.text"
-msgid "CELL(\"InfoType\"; Reference)"
-msgstr "CELL(\"Gosa oduu\"; Wabii)"
+msgid "CELL(\"InfoType\"[; Reference])"
+msgstr ""
#. wjBKt
#: 04060104.xhp
@@ -10194,14 +10194,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WENN\">Specifies a logical test to be performed.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_WENN\">sirna yaadaa hojjatamu adda baasa.</ahelp>"
-#. QQdtE
+#. qT9mo
#: 04060105.xhp
msgctxt ""
"04060105.xhp\n"
"par_id3154558\n"
"help.text"
-msgid "IF(Test; ThenValue; OtherwiseValue)"
-msgstr "Yoo(Yaalii;Achumaan gatii; Yoo hin taane gatii\")"
+msgid "IF(Test[; ThenValue][; OtherwiseValue])"
+msgstr ""
#. JnjcT
#: 04060105.xhp
@@ -63060,14 +63060,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WOCHENTAG\">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below."
msgstr ""
-#. Q6BXr
+#. EDmeN
#: func_weekday.xhp
msgctxt ""
"func_weekday.xhp\n"
"par_id3149033\n"
"help.text"
-msgid "WEEKDAY(Number; Type)"
-msgstr "WEEKDAY(Lakkoofsa;akaakuu)"
+msgid "WEEKDAY(Number[; Type])"
+msgstr ""
#. mcF52
#: func_weekday.xhp
@@ -63807,13 +63807,13 @@ msgctxt ""
msgid "<ahelp hid=\".\">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp>"
msgstr ""
-#. RRr3i
+#. ZFLiY
#: func_workday.intl.xhp
msgctxt ""
"func_workday.intl.xhp\n"
"par_id241020160008306838\n"
"help.text"
-msgid "WORKDAY.INTL(StartDate; Days; Weekend; Holidays)"
+msgid "WORKDAY.INTL(StartDate; Days[; Weekend][; Holidays])"
msgstr ""
#. gJg5G
@@ -63978,14 +63978,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> Firiin isaa lakkoofsa guyyaa kan akka guyyaatti gulaalamuu danda'uu dha.Itti fufuun lakkoofsa guyyaa kan lakkoofsa murta'aa ta'ee tokko <emph>guyyaa hojiiwwaani</emph> <emph>jalqaba guyyaa</emph> irra adda kan ta'e.</ahelp>"
-#. gSoD4
+#. fo6sg
#: func_workday.xhp
msgctxt ""
"func_workday.xhp\n"
"par_id3154844\n"
"help.text"
-msgid "WORKDAY(StartDate; Days; Holidays)"
-msgstr "WORKDAY(Aduu Jalqaba;Guyyoota;Guyyaa Ayyaanota)"
+msgid "WORKDAY(StartDate; Days[; Holidays])"
+msgstr ""
#. 35EG5
#: func_workday.xhp
@@ -64167,14 +64167,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>"
msgstr ""
-#. C3aRF
+#. AASCJ
#: func_yearfrac.xhp
msgctxt ""
"func_yearfrac.xhp\n"
"par_id3155823\n"
"help.text"
-msgid "YEARFRAC(StartDate; EndDate; Basis)"
-msgstr "YEARFRAC(Aduu Jalqaba;Aduu Xumura;Hunde)"
+msgid "YEARFRAC(StartDate; EndDate[; Basis])"
+msgstr ""
#. JAA8u
#: func_yearfrac.xhp
@@ -64338,14 +64338,14 @@ msgctxt ""
msgid "Solver"
msgstr "Furaa"
-#. i2Coz
+#. pDGKS
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"bm_id7654652\n"
"help.text"
-msgid "<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>"
-msgstr "<bookmark_value>barbaachisaa galchii;furaa</bookmark_value><bookmark_value>maal yoo dalagoota;furaa</bookmark_value><bookmark_value>duuba-furuu</bookmark_value><bookmark_value>furaa</bookmark_value>"
+msgid "<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>"
+msgstr ""
#. cBvDd
#: solver.xhp
@@ -64356,131 +64356,230 @@ msgctxt ""
msgid "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Solver</link></variable>"
msgstr "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Furaa</link></variable>"
-#. VvLwc
+#. JGk9s
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id9210486\n"
"help.text"
-msgid "<ahelp hid=\".\">Opens the Solver dialog. A solver allows you to solve equations with multiple unknown variables by goal-seeking methods.</ahelp>"
-msgstr "<ahelp hid=\".\">Qaaqa fura bana.Seerota ga'uumsaa barbaada fayyadamuun qixxaatoota jijjiiraamoota danuu qabu akka furtuuf furaan si eeyyama.</ahelp>"
+msgid "<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>"
+msgstr ""
+
+#. wszcE
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id21589912365601\n"
+"help.text"
+msgid "Solver settings"
+msgstr ""
-#. ivjGw
+#. 36mEY
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id501589912905479\n"
+"help.text"
+msgid "The dialog settings are retained until you close the current document."
+msgstr ""
+
+#. GgVk7
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id121589913023217\n"
+"help.text"
+msgid "Target Cell"
+msgstr ""
+
+#. EsgHG
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id8538773\n"
"help.text"
-msgid "<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>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\"> galtii man'eef wabii man'ee galcha ykn cuqaasa.Dirreen kunis teessoo gatii man'ee guutoola'ee qabata</ahelp>."
+msgid "<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>"
+msgstr ""
+
+#. 9j2m7
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id441589913036601\n"
+"help.text"
+msgid "Optimize results to"
+msgstr ""
-#. pcopF
+#. U8Ttv
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id7564012\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation for a maximum value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gatii ol'aantoo galtii man'ee Qixxaatoota furuuf yaala.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Maximum:</emph> Try to solve the equation for a maximum value of the target cell.</ahelp>"
+msgstr ""
-#. MBtDo
+#. N5C2U
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id1186254\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation for a minimum value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gatii gad'aantoo galtii man'ee Qixxaatoota furuuf yaala.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Minimum:</emph> Try to solve the equation for a minimum value of the target cell.</ahelp>"
+msgstr ""
-#. 7KTjo
+#. JAo82
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id7432477\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Try to solve the equation to approach a given value of the target cell.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gatii ol'aantoo kenname galtii man'ee Qixxaatoota adeemsa ittiin furaamu yaala.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Value of:</emph> Try to solve the equation to approach a given value of the target cell.</ahelp>"
+msgstr ""
-#. xAB7a
+#. 5BC94
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id7141026\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter the value or a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gatii ykn wabii man'ee galchi.</ahelp>"
+msgid "<ahelp hid=\".\">Enter the value or a cell reference in the text field.</ahelp>"
+msgstr ""
-#. AkKFT
+#. KMA6B
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id761589914010085\n"
+"help.text"
+msgid "By Changing Cells"
+msgstr ""
+
+#. VvrzV
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id8531449\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter the cell range that can be changed.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Hangii man'ee jijjiiramuu danda'u galchi.</ahelp>"
+msgid "<ahelp hid=\".\">Enter the cell range that can be changed.</ahelp> These are the variables of the equations."
+msgstr ""
-#. o7jUm
+#. if7S9
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id671589914927836\n"
+"help.text"
+msgid "Limiting Conditions"
+msgstr ""
+
+#. QQCWC
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id421589915278885\n"
+"help.text"
+msgid "Add the set of constraints for the mathematical problem. Each constraint is represented by a cell reference (a variable), an operator, and a value."
+msgstr ""
+
+#. YApta
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id9183935\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Wabii man'ee galchi.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Cell reference:</emph> Enter a cell reference of the variable.</ahelp>"
+msgstr ""
-#. 7s5ZD
+#. eyxy9
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id1939451\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. CWWbZ
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id946684\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Select an operator from the list.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Ogeejjii tarree keessaa fili.</ahelp>"
+msgid "<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)."
+msgstr ""
-#. Gj2Eo
+#. CtpNG
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id9607226\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter a value or a cell reference.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gatii ykn wabii man'ee galchi.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Value:</emph> Enter a value or a cell reference.</ahelp> This field is ignored when the operator is Binary or Integer."
+msgstr ""
-#. 2iEku
+#. GzohM
#: solver.xhp
msgctxt ""
"solver.xhp\n"
-"par_id1939451\n"
+"par_id9038972\n"
"help.text"
-msgid "<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>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Bakkabuusuuf ykn huuqisuuf qaaqa cuqaasi.Man'ee barruu keessa cuqaasuu ykn filuu dandessa.Hujeeqadhaan wabii man'ee sanduuqa naqaatti galchuu dandeessa.</ahelp>"
+msgid "<ahelp hid=\".\"><emph>Remove button:</emph> Click to remove the row from the list. Any rows from below this row move up.</ahelp>"
+msgstr ""
-#. FvWnk
+#. H3FEH
#: solver.xhp
msgctxt ""
"solver.xhp\n"
-"par_id9038972\n"
+"par_id511589916338595\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. B4DtG
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id441589917031236\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Click to remove the row from the list. Any rows from below this row move up.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Tarree tarree keessaa haquuf cuqaasi.tarreen geejjella tarree kanatti argamu ol dhufa.</ahelp>"
+msgid "Options"
+msgstr ""
-#. GqxKL
+#. AheHK
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id2423780\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Opens the Options dialog.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Qaaqa filaannoowwani bana.</ahelp>"
+msgid "<ahelp hid=\".\">Opens the <link href=\"text/scalc/01/solver_options.xhp#solveroptionsh1\" name=\"solveroptions\">Solver Options</link> dialog.</ahelp>"
+msgstr ""
+
+#. jDGPG
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id221589917833431\n"
+"help.text"
+msgid "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."
+msgstr ""
-#. ssqdF
+#. 8YGDA
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id771589917064147\n"
+"help.text"
+msgid "Solve"
+msgstr ""
+
+#. jFwTt
#: solver.xhp
msgctxt ""
"solver.xhp\n"
"par_id2569658\n"
"help.text"
-msgid "<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>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Qindeessiitoota amma fayyadamun qixxaatoo furuuf cuqaasi.galmeewwaan amma hanga cuuftutti qaaqa qindeessitoota tursi.</ahelp>"
+msgid "<ahelp hid=\".\">Click to solve the problem with the current settings. The dialog settings are retained until you close the current document.</ahelp>"
+msgstr ""
#. VFnjv
#: solver.xhp
@@ -64518,122 +64617,770 @@ msgctxt ""
msgid "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)."
msgstr "Man'eewwaan murtaa'oof ittisamoota qindeessuuf walfaannee haloota murteessoo ta'an hikuu dandeessa.Fakkeenyaaf,jijjiramoota ykn man'eewwwaan man'eewwaan biraa kan hin caalle ykn gatii kennamee irra kan hin caalle ittisamootasa qindeessu dandessa. Akkasummas ittisaamoota jijjiramaan isaa tokko ykn isa oli dirqiin intiijera ta'ee(gatiin kan kurnyee hin taane),ykn gatiiwwaan lamee(kan 0 fi 2 qoofti eeyyamamedha)."
-#. bZZnv
+#. irGoh
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"hd_id0603200910430882\n"
+"help.text"
+msgid "Using Non-Linear solvers"
+msgstr ""
+
+#. UTzzV
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430845\n"
+"help.text"
+msgid "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>."
+msgstr ""
+
+#. gJGz2
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430821\n"
+"help.text"
+msgid "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)."
+msgstr ""
+
+#. GFZqJ
+#: solver.xhp
+msgctxt ""
+"solver.xhp\n"
+"par_id0603200910430873\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. ZUeCC
#: solver.xhp
msgctxt ""
"solver.xhp\n"
-"par_id5323953\n"
+"par_id271589981559367\n"
"help.text"
-msgid "The default solver engine supports only linear equations."
-msgstr "Malli furaa durti qixxaatoo sorooroo qofa deegara."
+msgid "<link href=\"https://wiki.documentfoundation.org/\" name=\"wikipage\">Wiki page on solvers and theirs algorithms</link>"
+msgstr ""
-#. dAcyJ
+#. akxrP
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
"tit\n"
"help.text"
-msgid "Options"
-msgstr "Dirqalaalee"
+msgid "Solver Options"
+msgstr ""
+
+#. UBnZK
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"bm_id291590166034871\n"
+"help.text"
+msgid "<bookmark_value>solver for Calc;options</bookmark_value>"
+msgstr ""
-#. 2p755
+#. vZkr3
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
"hd_id2794274\n"
"help.text"
-msgid "Options"
-msgstr "Dirqalaalee"
+msgid "<variable id=\"solveroptionsh1\"><link href=\"text/scalc/01/solver_options.xhp\" name=\"Solver Options\">Solver Options</link></variable>"
+msgstr ""
-#. 4v4nE
+#. LHgS8
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id6776940\n"
+"par_id3163853\n"
"help.text"
-msgid "The Options dialog for the <link href=\"text/scalc/01/solver.xhp\">Solver</link> is used to set some options."
-msgstr "Qaaqni dirqaaloota<link href=\"text/scalc/01/solver.xhp\">furaadhaaf</link>dirqaalota murta'a ta'ee tokko qindeessuuf oola."
+msgid "Use the Options dialog to configure the solver engine."
+msgstr ""
+
+#. mFtPo
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"par_id9999694\n"
+"help.text"
+msgid "Click OK to accept the changes and to go back to the <link href=\"text/scalc/01/solver.xhp\">Solver</link> dialog."
+msgstr "Wanta jijjiiramee fudhaachuuf ykn qaaqa <link href=\"text/scalc/01/solver.xhp\">Furaa</link> duubatti deebisuuf Tole cuqaasi."
-#. 8D7tG
+#. gE7WZ
+#: solver_options.xhp
+msgctxt ""
+"solver_options.xhp\n"
+"hd_id581589922716672\n"
+"help.text"
+msgid "Solver engine"
+msgstr ""
+
+#. A7MrG
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
"par_id393993\n"
"help.text"
-msgid "<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>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Mala fura filadhu.sanduuqni tarree kan inni hojjii isaa dhaabu malli furaa tokko qofaa yoo ijaaramudha , mallootni fura kun akka dheeraattoowwaanitti ijaaramuu danda'u.</ahelp>"
+msgid "<ahelp hid=\".\">Select a solver engine. The listbox is disabled if only one solver engine is installed.</ahelp>"
+msgstr ""
-#. JuBPY
+#. NMHJR
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id5871761\n"
+"par_id221589959855748\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Configure the current solver.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">furaa ammaa qindeessa.</ahelp>"
+msgid "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."
+msgstr ""
-#. 9ATtL
+#. QtDyE
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id6531266\n"
+"hd_id711589922750833\n"
"help.text"
-msgid "<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>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Galumsi ammaa kan qindaa'iinoota tarree sanduqa keessatti argamuu akka gulaaluuf yoo si eeyyame,qabdu gulaalaa cuqaasu dandessa.Bakka gatii jijjiiruuf barbaaddutti qaaqa bani.</ahelp>"
+msgid "Settings"
+msgstr ""
-#. yRRMt
+#. ncgjf
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id3912778\n"
+"par_id130619\n"
"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enter or change the value.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Gati galchi ykn jijjiiri.</ahelp>"
+msgid "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."
+msgstr ""
-#. FdSQu
+#. DPYew
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id3163853\n"
+"hd_id481589922813764\n"
"help.text"
-msgid "Use the Options dialog to configure the current solver engine."
-msgstr "Mala furaa ammaa fayyadamuun qaaqa dirqalaa qindeessi."
+msgid "Edit"
+msgstr ""
-#. edT9Q
+#. XZbDB
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id121158\n"
+"par_id6531266\n"
"help.text"
-msgid "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."
-msgstr "Yoo jira ta'eef,maloota furaa baay'ee akka dheeraattoowwaanitti ijaaruu dandeessa.Dheeraattoowwaan barbaadduuf Meeshaalee bani-Taaliga Dheeratessii itti ansuun dheerattoowwaan saphaphuu sakkata'i."
+msgid "<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>"
+msgstr ""
-#. YGbpY
+#. JzS8w
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id3806878\n"
+"hd_id331589923158248\n"
"help.text"
-msgid "Select the solver engine to use and to configure from the listbox. The listbox is disabled if only one solver engine is installed."
+msgid "Edit settings spin box"
msgstr ""
-#. kk9QD
+#. B4WMx
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id130619\n"
+"par_id3912778\n"
"help.text"
-msgid "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."
-msgstr "Sanduuqa qindaa'inoota keessatti,qindaa'inoota dalaagaalee barbacha galchii ammaa siif ta'aan hundaa mirkanneessii yoo dirqalli ammmaa gatiiwwaan kan biraa qabaate,qabduu gulaaltu hojii eegala.Gulaltu cuqasun qaaqa banuun bakkaa itti gatii jijjiirtuu argatta."
+msgid "<ahelp hid=\".\">Enter or change the value of the selected setting.</ahelp>"
+msgstr ""
-#. mFtPo
+#. cYCVf
#: solver_options.xhp
msgctxt ""
"solver_options.xhp\n"
-"par_id9999694\n"
+"par_id271589981559367\n"
"help.text"
-msgid "Click OK to accept the changes and to go back to the <link href=\"text/scalc/01/solver.xhp\">Solver</link> dialog."
-msgstr "Wanta jijjiiramee fudhaachuuf ykn qaaqa <link href=\"text/scalc/01/solver.xhp\">Furaa</link> duubatti deebisuuf Tole cuqaasi."
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgstr ""
+
+#. A843R
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"tit\n"
+"help.text"
+msgid "Options"
+msgstr ""
+
+#. U9kTW
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"bm_id0503200917110375_scalc\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. atkqE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"hd_id0503200917103593\n"
+"help.text"
+msgid "<variable id=\"SolverAlgorithmsOptionsh1\"><link href=\"text/scalc/01/solver_options_algo.xhp#SolverAlgorithmsOptionsh1\" name=\"Solver Algorithms Options\">Solver Algorithms Options</link></variable>"
+msgstr ""
+
+#. RjM8p
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id651589925044267\n"
+"help.text"
+msgid "<variable id=\"DEPSEvolutionaryalgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#DEPSEvolutionaryalgorithmh2\" name=\"DEPS Evolutionary algorithm\">DEPS Evolutionary Algorithm</link></variable>"
+msgstr ""
+
+#. xBZfN
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id931590164412542\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. EFbzc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394232\n"
+"help.text"
+msgid "Agent Switch Rate"
+msgstr ""
+
+#. E3ZoK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394248\n"
+"help.text"
+msgid "Specifies the probability for an individual to choose the Differential Evolution strategy."
+msgstr ""
+
+#. DbnUB
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394277\n"
+"help.text"
+msgid "DE: Crossover Probability"
+msgstr ""
+
+#. phaC2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394280\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. G4GC9
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0643200910394216\n"
+"help.text"
+msgid "DE: Scaling Factor"
+msgstr ""
+
+#. qKt78
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id360320091039424\n"
+"help.text"
+msgid "During crossover, the scaling factor decides about the “speed” of movement."
+msgstr ""
+
+#. HPPHg
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0507200917103771\n"
+"help.text"
+msgid "Learning Cycles"
+msgstr ""
+
+#. ED86j
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503210917103720\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. M5Ka8
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id3603200910394222\n"
+"help.text"
+msgid "PS: Cognitive Constant"
+msgstr ""
+
+#. bVENc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id3603200915394212\n"
+"help.text"
+msgid "Sets the importance of the own memory (in particular the best reached point so far)."
+msgstr ""
+
+#. ujBHP
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060324091037421\n"
+"help.text"
+msgid "PS: Constriction Coefficient"
+msgstr ""
+
+#. Z86BZ
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0608200910394225\n"
+"help.text"
+msgid "Defines the speed at which the particles/individuals move towards each other."
+msgstr ""
+
+#. nFnAu
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060320091039425\n"
+"help.text"
+msgid "PS: Mutation Probability"
+msgstr ""
+
+#. fGiKi
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394272\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. nn4Ms
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394292\n"
+"help.text"
+msgid "PS: Social Constant"
+msgstr ""
+
+#. nAD2Z
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910394284\n"
+"help.text"
+msgid "Sets the importance of the global best point between all particles/individuals."
+msgstr ""
+
+#. GAGDE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200217103891\n"
+"help.text"
+msgid "<variable id=\"enhstatusheader\">Show Enhanced Solver Status</variable>"
+msgstr ""
+
+#. na8Ee
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0523200917103832\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. 3LaZ7
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200417103780\n"
+"help.text"
+msgid "<variable id=\"swarmheader\">Size of Swarm</variable>"
+msgstr ""
+
+#. UhBid
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503100917103723\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. r62GH
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0504200917103794\n"
+"help.text"
+msgid "<variable id=\"stagnationheader\">Stagnation Limit</variable>"
+msgstr ""
+
+#. LDNEL
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id050320091710377\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. vGYwe
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103762\n"
+"help.text"
+msgid "<variable id=\"stagtolheader\">Stagnation Tolerance</variable>"
+msgstr ""
+
+#. wqeXY
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103834\n"
+"help.text"
+msgid "<variable id=\"stagtoldesc\">Defines in what range solutions are considered “similar”.</variable>"
+msgstr ""
+
+#. jKuiG
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103740\n"
+"help.text"
+msgid "<variable id=\"acrheader\">Use ACR Comparator</variable>"
+msgstr ""
+
+#. D8e8D
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103766\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. 7LWoa
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103744\n"
+"help.text"
+msgid "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)."
+msgstr ""
+
+#. GZ7C2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103792\n"
+"help.text"
+msgid "Use Random Starting Point"
+msgstr ""
+
+#. EdJoF
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103790\n"
+"help.text"
+msgid "If <emph>enabled</emph>, the library is simply filled up with randomly chosen points."
+msgstr ""
+
+#. oCPc4
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103765\n"
+"help.text"
+msgid "If <emph>disabled</emph>, the currently present values (as given by the user) are inserted in the library as reference point."
+msgstr ""
+
+#. ctLqK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103732\n"
+"help.text"
+msgid "<variable id=\"variableguessheader\">Variable Bounds Guessing</variable>"
+msgstr ""
+
+#. rc95a
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id050320091710378\n"
+"help.text"
+msgid "<variable id=\"variableguessdesc\">If enabled (default), the algorithm tries to find variable bounds by looking at the starting values.</variable>"
+msgstr ""
+
+#. JctSA
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103794\n"
+"help.text"
+msgid "<variable id=\"variablethresheader\">Variable Bounds Threshold</variable>"
+msgstr ""
+
+#. NNyfL
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103710\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. UDXDh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id391589925078747\n"
+"help.text"
+msgid "<variable id=\"SCOEvolutionaryAlgorithmh2\"><link href=\"text/scalc/01/solver_options_algo.xhp#SCOEvolutionaryAlgorithmh2\" name=\"SCO Evolutionary Algorithm\">SCO Evolutionary Algorithm</link></variable>"
+msgstr ""
+
+#. tqkJh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id681590165847694\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. wovoy
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103771\n"
+"help.text"
+msgid "Learning Cycles"
+msgstr ""
+
+#. wgKE5
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0503200917103720\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. wrasx
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id0603200910401382\n"
+"help.text"
+msgid "Size of Library"
+msgstr ""
+
+#. 4PmLg
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id060320091040136\n"
+"help.text"
+msgid "Defines the amount of information to store in the public library. Each individual stores knowledge there and asks for information."
+msgstr ""
+
+#. EPiZn
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id741589980722689\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/solver_options_algo.xhp#variablethresheader\"/>"
+msgstr ""
+
+#. Ltucz
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id901589980722691\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/solver_options_algo.xhp#variablethresdesc\"/>"
+msgstr ""
+
+#. 46h4u
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id671589925148891\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. PNEaC
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id731589925837981\n"
+"help.text"
+msgid "<variable id=\"settingshead\">Setting</variable>"
+msgstr ""
+
+#. DhVRA
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id611589925837982\n"
+"help.text"
+msgid "<variable id=\"descriptionhead\">Description</variable>"
+msgstr ""
+
+#. MqHfE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id511589925837984\n"
+"help.text"
+msgid "<variable id=\"integerhead\">Assume variables as integers</variable>"
+msgstr ""
+
+#. Javmc
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id11589925837985\n"
+"help.text"
+msgid "<variable id=\"integerdesc\">Mark to force variables to be integers only.</variable>"
+msgstr ""
+
+#. yie3u
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id221589961756407\n"
+"help.text"
+msgid "<variable id=\"noneghead\">Assume variables as non negative</variable>"
+msgstr ""
+
+#. ij2he
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id861589961756408\n"
+"help.text"
+msgid "<variable id=\"nonegdesc\">Mark to force variables to be positive only.</variable>"
+msgstr ""
+
+#. uEDEh
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id971589961907787\n"
+"help.text"
+msgid "Epsilon level"
+msgstr ""
+
+#. JSVtE
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id421589961907788\n"
+"help.text"
+msgid "Epsilon level. Valid values are in range 0 (very tight) to 3 (very loose). Epsilon is the tolerance for rounding values to zero."
+msgstr ""
+
+#. rtCLo
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id71589961998523\n"
+"help.text"
+msgid "Limit branch-and-bound depth"
+msgstr ""
+
+#. yeTw2
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id331589961998525\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. pnUYs
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id91589962070327\n"
+"help.text"
+msgid "<variable id=\"timelimithead\">Solver time limit</variable>"
+msgstr ""
+
+#. PPtR8
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id331589962070329\n"
+"help.text"
+msgid "<variable id=\"timelimitdesc\">Sets the maximum time for the algorithm to converge to a solution.</variable>"
+msgstr ""
+
+#. 9WDm6
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id711589925192067\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. TFadK
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id971589963431459\n"
+"help.text"
+msgid "Swarm algorithm"
+msgstr ""
+
+#. cgpYF
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id71589963431460\n"
+"help.text"
+msgid "Set the swarm algorithm. 0 for differential evolution and 1 for particle swarm optimization. Default is 0."
+msgstr ""
+
+#. ugAZb
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id271589981559367\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>"
+msgstr ""
+
+#. D2nCR
+#: solver_options_algo.xhp
+msgctxt ""
+"solver_options_algo.xhp\n"
+"par_id211590163660314\n"
+"help.text"
+msgid "<link href=\"http://lpsolve.sourceforge.net/\">lp_solve reference guide in sourceforge.net</link>"
+msgstr ""
#. Q6isn
#: stat_data.xhp