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

Abstract RU 2563144 C1

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

Similar patents RU2563144C1

Title Year Author Number
DYNAMIC FORMULAE FOR SPREADSHEET CELLS 2009
  • Folting Allan
  • Duzak Dzheffri Dzh.
  • Ehllis Charl'Z D.
RU2487402C2
DEVICE FOR ESTIMATING COLLECTION ITEMS 2004
  • Tamojkin M.Ju.
  • Tamojkin D.M.
RU2264654C1
METHOD OF MANAGING DATA IN DOCUMENT CREATED BY COMPUTER AND MACHINE-READABLE MEDIUM ON WHICH PROGRAM IS RECORDED 2007
  • Timchenko Maksim Sergeevich
RU2379748C2
LINKING VISUAL PROPERTIES OF CHARTS TO CELLS WITHIN TABLES 2009
  • Rehmpson Bendzhamin Ehdvard
  • Rabl Skott
  • Sklar Bendzhamin
  • Garg Anupam
RU2514102C2
MULTIFUNCTIONAL MULTIUSER AUTOMATED PUBLIC SERVICE POINT 2011
  • Avdeev Mikhail Aleksandrovich
  • Zabrodotskij Il'Ja Jur'Evich
  • Bornjakov Andrej Jur'Evich
RU2457540C1
METHOD AND MACHINE-READABLE MEDIUM FOR PROVIDING KEY PERFORMANCE INDICATORS BASED ON SPREADSHEETS 2006
  • Krou Khovard M.
  • Datars Ehndrju Eh.
  • Megiddo Ehran
  • Vong Al'Fred Faj Khang
RU2409835C2
ENTERPRISE INFORMATION SYSTEM CONTROL METHOD 2020
  • Bolshakov Dmitrij Nikolaevich
  • Kuzin Roman Valerevich
  • Gavrilova Olga Anatolevna
  • Khovrich Mariya Aleksandrovna
RU2736851C1
METHOD FOR AUTOMATED DESIGN OF PRODUCTION AND OPERATION OF APPLIED SOFTWARE AND SYSTEM FOR IMPLEMENTATION THEREOF 2016
  • Zaozerskij Sergej Anatolevich
  • Berezov Ivan Vladimirovich
  • Koromyslichenko Vladislav Nikolaevich
  • Nikolaev Dmitrij Andreevich
  • Nichiporovich Oleg Petrovich
  • Okhtilev Mikhail Yurevich
  • Pikulev Pavel Alekseevich
  • Rossiev Andrej Yurevich
  • Chernikov Andrej Dmitrievich
  • Chuprikov Aleksandr Yurevich
RU2676405C2
METHOD AND SYSTEM FOR FORMATTING BASED ON CONDITION ACTIVATED BY ONE MOUSE CLICK FOR PROGRAMS 2005
  • Chehmberlehjn Benzhamin K.
  • Veber Brehndon G.
  • Dzhons Brjus Kordell
  • Ehllis Charl'Z D.
  • Strit Kristofer M.
  • Gejner Dehvid F.
  • Vigesaa Ehrik B.
RU2398271C2
APPARATUS AND METHOD OF SEARCHING FOR DIFFERENCES IN DOCUMENTS 2013
  • Panferov Vasily Vladimirovich
  • Isaev Andrey Anatolievich
  • Bobrova Catherine Yurievna
  • Zhukovskaya Olga Anatolievna
RU2571378C2

RU 2 563 144 C1

Authors

Avdeev Vitalij Jur'Evich

Dates

2015-09-20Published

2014-05-14Filed