Technical data

Chapter 10 Creating Rules, Formulas, and User Functions

General tab

Description

Enter a description of the analytic model.

Note. This field pertains to the analytic model as a whole, not to circular

formula options.

Resolve circular system

through iteration

Select to attempt to resolve all of an analytic model’s circular systems through

iteration. By default, this option is disabled.

See C

hapter 10, “Creating Rules, Formulas, and User Functions,” Changing

Circular Formula and Cir cular System Options, page 136.

Maximum number of

iterations

Enter the number of iterations in which the analytic calculation engine is to

resolve circular systems. By default, the maximum number of iterations is 100.

If the analytic calculation engine cannot resolve a circular system during this

number of iterations, the analytic calculation engine returns an error.

Note. You must select the Resolve circular system through iteration check

box to activate this option.

Maximum change in values

Enter the maximum change in values. By default, the maximum change in

values is 0.001000.

A circular system is considered to be resolved when the values of its cells do

not change more than the specified maximum change. If you enter a smaller

value, the solution is more accurate but may require a longer calculation

time. If you enter a larger value, the solution not as accurate but requires a

shorter c alculation time.

Note. Yo u must enable the Resolve circular system through iteration check

box to activate this option.

Warn about circular

formulas

Every time a circular formula is defined: Select for the analytic calculation

engine to provide a circular formula warning every time a circular formula is

defined.