Ask Your Question

Calc, how to properly set Iterations? [closed]

asked 2016-02-10 14:21:31 +0100

LibreGuy gravatar image

updated 2016-02-10 14:26:38 +0100

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-29 22:42:50.497805

1 Answer

Sort by » oldest newest most voted

answered 2016-02-10 23:26:38 +0100

m.a.riosv gravatar image

Please take a look to the help:

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

edit flag offensive delete link more


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?

LibreGuy gravatar imageLibreGuy ( 2016-02-11 00:06:53 +0100 )edit

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.

oweng gravatar imageoweng ( 2016-02-11 00:59:20 +0100 )edit

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?

LibreGuy gravatar imageLibreGuy ( 2016-02-11 01:20:17 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2016-02-11 01:25:54 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2016-02-11 01:30:52 +0100 )edit

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?

LibreGuy gravatar imageLibreGuy ( 2016-02-11 01:32:59 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2016-02-11 01:36:13 +0100 )edit

Allright, I think it's quite complicated. Documentation is not quite clear actually ... :(

LibreGuy gravatar imageLibreGuy ( 2016-02-11 01:39:47 +0100 )edit

Question Tools

1 follower


Asked: 2016-02-10 14:21:31 +0100

Seen: 4,174 times

Last updated: Feb 10 '16