Calc, how to properly set Iterations?

English
,
#1

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!

#2

Please take a look to the help:

https://help.libreoffice.org/Common/Calculate

If you have not iterative references, usually you can disable it.

#3

Thanks, 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?

#4

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.

#5

Thanks 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?

#6

@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.

#7

Or maybe Menu/Tools/Goal seek or Menu/Tools/Solver is what you are looking for.

#8

Yes 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?

#9

I think it depends on the Minimum change value, if I’m not wrong it’s for that, once achieved stops the iterations.

#10

Allright, I think it’s quite complicated. Documentation is not quite clear actually … :frowning:

#11

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.