FIELD: information technologies.
SUBSTANCE: in this method through the data input device the source data are inserted into the influencing spreadsheet cell, their resultant parameter dependent by means of formulas on their change in the influencing cell is determined with subsequent display in the resultant cell by means of the data output device, designation of the resultant cell by a visual signal depending on the preset condition. The source data are inserted into the influencing or the resultant cell; if the source data have been inserted into the resultant cell, then there the inserted value is indicated as the resultant parameter, and if the source data have been inserted into the influencing cell, then in case of coincidence of the previous value of their resultant parameter with its value displayed in the resultant cell in the resultant cell the previous value of the resultant parameter is replaced by its new value, and by visual signal the resultant cell is designated if the value of the resultant parameter displayed in it doesn't conform to its value determined at least by one of its formulas.
EFFECT: automation and improvement of efficiency of data input and calculation.
4 dwg
Title | Year | Author | Number |
---|---|---|---|
DYNAMIC FORMULAE FOR SPREADSHEET CELLS | 2009 |
|
RU2487402C2 |
DEVICE FOR ESTIMATING COLLECTION ITEMS | 2004 |
|
RU2264654C1 |
METHOD OF MANAGING DATA IN DOCUMENT CREATED BY COMPUTER AND MACHINE-READABLE MEDIUM ON WHICH PROGRAM IS RECORDED | 2007 |
|
RU2379748C2 |
LINKING VISUAL PROPERTIES OF CHARTS TO CELLS WITHIN TABLES | 2009 |
|
RU2514102C2 |
MULTIFUNCTIONAL MULTIUSER AUTOMATED PUBLIC SERVICE POINT | 2011 |
|
RU2457540C1 |
METHOD AND MACHINE-READABLE MEDIUM FOR PROVIDING KEY PERFORMANCE INDICATORS BASED ON SPREADSHEETS | 2006 |
|
RU2409835C2 |
ENTERPRISE INFORMATION SYSTEM CONTROL METHOD | 2020 |
|
RU2736851C1 |
METHOD FOR AUTOMATED DESIGN OF PRODUCTION AND OPERATION OF APPLIED SOFTWARE AND SYSTEM FOR IMPLEMENTATION THEREOF | 2016 |
|
RU2676405C2 |
METHOD AND SYSTEM FOR FORMATTING BASED ON CONDITION ACTIVATED BY ONE MOUSE CLICK FOR PROGRAMS | 2005 |
|
RU2398271C2 |
APPARATUS AND METHOD OF SEARCHING FOR DIFFERENCES IN DOCUMENTS | 2013 |
|
RU2571378C2 |
Authors
Dates
2015-09-20—Published
2014-05-14—Filed