Methods and systems for union combining and further manipulating data sets in a spreadsheet function
AssigneeAdaptam Inc.
InventorsRobert E. DVORAK, Yuriy GARIN, Alexey VERKHOVSKIY
Life of this patent
Estimating the term…
Abstract
The disclosed technology creates spreadsheet prebuilt functions to union combine and sort data from two or more data sets from in-cell spreadsheet data and/or non-spreadsheet cell external data. Further embodiments then filter, limit and change the orientation of the data input or the data output.
Claims25
A method of combining data in a spreadsheet using a prebuilt spreadsheet function that union combines and then sorts the data from different data sets, including:
- accessing from the spreadsheet a data combination function entered in a first spreadsheet cell;
- receiving arguments in a structured arguments list of the data combination function, which structured arguments list has a predetermined ordering of arguments separated by delimiters, the arguments including at least one each of a first and a second user specified data set, wherein:
- a first argument for at least one first user specified data set includes formulaic data description terms for accessing two or more non-spreadsheet sourced data fields;
- and
- a second argument for at least one second data set data set argument includes specification of a spreadsheet cell range for accessing two or more spreadsheet cell sourced data fields;
- wherein the first and the second user specified data sets have data fields in matching order;
- the data combination function executing and union combining the first and second user specified data sets data, and then sorting the combined data based on values of the data fields;
- and
- outputting for display the combined and sorted data into a plurality of spreadsheet cells.
A non-transitory computer readable medium holding instructions that, when executed on hardware, configure the hardware to implement a method of combining data in a spreadsheet using a prebuilt spreadsheet function that union combines and then sorts the data from different data sets, including:
- accessing from the spreadsheet a data combination function entered in a first spreadsheet cell;
- receiving arguments in a structured arguments list of the data combination function, which structured arguments list has a predetermined ordering of arguments separated by delimiters, the arguments including at least one each of a first and a second user specified data set, wherein:
- a first argument for at least one first user specified data set includes formulaic data description terms for accessing a non-spreadsheet sourced data;
- and
- a second argument for at least one second data set data set argument includes specification of a spreadsheet cell range for accessing spreadsheet cell sourced data;
- wherein the first and the second user specified data sets have data fields in matching order;
- the data combination function executing and union combining the first and second user specified data sets data, and then sorting the combined data based on values of the data fields;
- and
- outputting for display the combined and sorted data into a plurality of spreadsheet cells.
A system including processing hardware coupled to memory, the memory impressed with computer instructions that, when executed, cause the hardware to carry out a method of combining data in a spreadsheet using a prebuilt spreadsheet function that union combines and then sorts the data from different data sets, including:
- accessing from the spreadsheet the data combination function entered in a first spreadsheet cell;
- receiving arguments in a structured arguments list of a data combination function, which structured arguments list has a predetermined ordering of arguments separated by delimiters, the arguments including at least one each of a first and a second user specified data set, wherein:
- a first argument for at least one first user specified data set includes formulaic data description terms for accessing a non-spreadsheet sourced data;
- and
- a second argument for at least one second data set data set argument includes specification of a spreadsheet cell range for accessing spreadsheet cell sourced data;
- wherein the first and the second user specified data sets have data fields in matching order;
- the data combination function executing and union combining the first and second user specified data sets data, and then sorting the combined data based on values of the data fields;
- and
- outputting for display the combined and sorted data into a plurality of spreadsheet cells.
Dependencies are inferred from the claim text.