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

Full description

Saved in:
Bibliographic Details
Main Authors JEFFREY J. DUZAK, CHARLES D. ELLIS, ALLAN FOLTING
Format Patent
LanguageEnglish
Published 11.09.2009
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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.
Bibliography:Application Number: AU20090220127