DYNAMIC FORMULAS FOR SPREADSHEET CELLS

摘要

Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculation scenarios. Each of the formulas associated with the cell are dynamically updated and adjusted to react to changes elsewhere in the spreadsheet such that a user can recalculate the whole spreadsheet and move formulas around in the spreadsheet causing both the external data formula and all the adjustment formulas that may exist in the same cell to be updated accordingly.