|
|
In the workbookset node is where the settings to be applied to all existing workbooks can be defined.
.png)
1. Automatic calculation. Whenever a cell value is modified all values all recalculated.
2. Semi-automatic calculation. Calculations only when a modified cell value affects other cell values.
3. Manual calculation. Only when the calculation command is issued by pressing the F9 key.
4. Calculate before save. Calculations will be performed before the workbook file is saved.
5. Iteration. Check to consider iteration parameters in recursive calculations.
6. Max iterations. For formulas that contain circular references, the maximum number of iterations allowed can be specified.
7. Max change. For formulas that contain circular references, the maximum change to stop the iterations can be specified.
A circular reference occurs when a formula has a reference to a second formula result, and the second
formula has a reference to the first formula result.
The following example involves a circular reference:
TotalPrice = OldPrice + PriceIncrement
PriceIncrement = TotalPrice*10%
If OldPrice is 10,000 and the starting value of PriceIncrement is 1,000 the following iteration values are produced:
|
Iteration #
|
TotalPrice
|
PriceIncrement
|
PriceIncrement Difference
|
|
1
|
10,000 + 1000 = 11,000
|
11,000*10% = 1,100
|
1,100 - 1000 = 100
|
|
2
|
10,000 + 1,100 = 11,100
|
11,100*10% = 1,110
|
1,110 - 1,100 = 10
|
|
3
|
10,000 + 1,110 = 11,110
|
11,110*10% = 1,111
|
1,111 - 1,110 = 1
|
|
4
|
10,000 + 1,111 = 11,111
|
11,111*10% = 1,111.1
|
1,111.1 - 1,111 = 0.1
|
The PriceIncrement value converges at 1,111.11, fulfilling the two conditions:
TotalPrice = OldPrice + PriceIncrement = 10,000 + 1,111.11 = 11,111.11
PriceIncrement = TotalPrice*10% = 11,111.11*10% = 1,111.11.
|
|