FIELD: information technology.
SUBSTANCE: multiple formulae are associated with one spreadsheet cell. A base formula represents the actual value extracted from a data source. Adjustment formulae represent formulae for calculating adjustments to the value contained in the cell and other formulae can represent other calculation scenarios. Each of the formulae 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 formulae around in the spreadsheet causing both the external data formula and all the adjustment formulae that may exist in the same cell to be updated accordingly.
EFFECT: high efficiency of processing data using spreadsheets.
20 cl, 3 dwg
| Title | Year | Author | Number |
|---|---|---|---|
| SPREADSHEET FILLING METHOD | 2014 |
|
RU2563144C1 |
| METHOD AND MACHINE-READABLE MEDIUM FOR PROVIDING KEY PERFORMANCE INDICATORS BASED ON SPREADSHEETS | 2006 |
|
RU2409835C2 |
| DATA FORMATING ON SAMPLE | 2012 |
|
RU2602786C2 |
| SYSTEM AND METHOD OF ESTIMATING THE COST OF A DEVICE | 2016 |
|
RU2698769C1 |
| SYSTEM AND METHOD FOR DATA DISPLAY WITH ENCLOSED TABLES WITHOUT CIRCUIT DIAGRAM | 2005 |
|
RU2370808C2 |
| COMPILATION OF TRANSFORMATIONS IN RECALCULATION USER INTERFACE | 2014 |
|
RU2666238C2 |
| USE OF TEXT MESSAGES FOR INTERACTION WITH ELECTRONIC SPREADSHEETS | 2011 |
|
RU2598795C2 |
| METHOD AND SYSTEM FOR FORMATTING BASED ON CONDITION ACTIVATED BY ONE MOUSE CLICK FOR PROGRAMS | 2005 |
|
RU2398271C2 |
| OFFERING ALLIED TERMS FOR MULTISEMANTIC INQUIRY | 2005 |
|
RU2393533C2 |
| OPTIMISATION OF FACT EXTRACTION USING MULTI-STAGE APPROACH | 2007 |
|
RU2451999C2 |
