Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 11 Feb 2016 01:39:47 +0100Calc, how to properly set Iterations?https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/Hi guys,
Can someone tell me what the default settings for "Iterations" are in Calc?
To what amount should I set "Steps" and "Minimum change"?
I would also like to know what "steps" means. For example if I set "steps" to 10, will each cell be evaluated 10 times??? What is the exact use? And does it make a difference if I set steps to (for example) 5 or 5.000? For example does it increase or decrease performance?
I hope someone can explain how this works. Many thanks in advance!Wed, 10 Feb 2016 14:21:31 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/Answer by m.a.riosv for <p>Hi guys,</p>
<p>Can someone tell me what the default settings for "Iterations" are in Calc?</p>
<p>To what amount should I set "Steps" and "Minimum change"?</p>
<p>I would also like to know what "steps" means. For example if I set "steps" to 10, will each cell be evaluated 10 times??? What is the exact use? And does it make a difference if I set steps to (for example) 5 or 5.000? For example does it increase or decrease performance?</p>
<p>I hope someone can explain how this works. Many thanks in advance!</p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?answer=64257#post-id-64257Please take a look to the help:
https://help.libreoffice.org/Common/Calculate
If you have not iterative references, usually you can disable it. Wed, 10 Feb 2016 23:26:38 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?answer=64257#post-id-64257Comment by m.a.riosv for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64271#post-id-64271Or maybe Menu/Tools/Goal seek or Menu/Tools/Solver is what you are looking for.Thu, 11 Feb 2016 01:30:52 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64271#post-id-64271Comment by LibreGuy for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64272#post-id-64272Yes there are circular references. This is done intentionally. I would like to know what amount I need to set "Steps". Should I set it to 100? Or maybe to 10? Is there a difference?Thu, 11 Feb 2016 01:32:59 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64272#post-id-64272Comment by LibreGuy for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64261#post-id-64261Thanks, I read that already but I do not exactly understand it. If I disable Iterations I get error messages, so I do need iterations. However, I don't understand what "steps" means. What does an amount of 100 steps mean? Does it mean that each cell in the spreadsheet can be iterated 100 times? Or is 100 the maximum of all cells? And does increasing or decreasing the amount of steps slow down or speed up my spreadsheet?Thu, 11 Feb 2016 00:06:53 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64261#post-id-64261Comment by oweng for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64264#post-id-64264*Step* means a single calculation on a single cell, thus 100 steps implies calculating the formula in a *each* cell (in all sheets in a document) 100 times. The term equates to iteration, so more will slow down calculating.Thu, 11 Feb 2016 00:59:20 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64264#post-id-64264Comment by m.a.riosv for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64274#post-id-64274I think it depends on the Minimum change value, if I'm not wrong it's for that, once achieved stops the iterations.Thu, 11 Feb 2016 01:36:13 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64274#post-id-64274Comment by LibreGuy for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64269#post-id-64269Thanks for your reply oweng, that clarifies a bit. You say "more will slow down calculating". But when a cell needs for example only 10 iterations, will it then automatically stop iterating? Or will it continue to (for example) 100?Thu, 11 Feb 2016 01:20:17 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64269#post-id-64269Comment by m.a.riosv for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64270#post-id-64270@LibreGuy, you get the error message because you have circular references, one o more cells have through other cells references to themselves. If you have done intentionally, then for that is the option for iterations, if not you need to repair the logical of your formulas.Thu, 11 Feb 2016 01:25:54 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64270#post-id-64270Comment by LibreGuy for <p>Please take a look to the help:</p>
<p><a href="https://help.libreoffice.org/Common/Calculate">https://help.libreoffice.org/Common/C...</a></p>
<p>If you have not iterative references, usually you can disable it. </p>
https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64275#post-id-64275Allright, I think it's quite complicated. Documentation is not quite clear actually ... :(Thu, 11 Feb 2016 01:39:47 +0100https://ask.libreoffice.org/en/question/64224/calc-how-to-properly-set-iterations/?comment=64275#post-id-64275