SPREADSHEET FILLING METHOD Russian patent published in 2015 - IPC G06F17/00 G06F3/00 

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