ANALYTIC NETWORK ENGINE AND SPREADSHEET INTERFACE SYSTEM

摘要

A method and system for calculating values for fields interrelated by circular formulas in a data network (10) is described. The system contains a first calculator for which a first field serves as an input value and a second field serves as an output and a second calculator (34) for which the second field serves as an input value and the first field serves as an output (16). A conflict checker (32) determines whether a circular conflict exists after input of the input value into the first field or the second field, and a conflict resolver resolves the conflict by suppressing the input value in the first field or second field upon determination of the circular conflict.