Patent ID: 11972204
Assignee: ADAPTAM INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method of evaluating data in a spreadsheet using a table generator function that applies a user specified formula to user specified data fields, including:
accessing from the spreadsheet the table generator function entered in a first spreadsheet cell, wherein the table generator function applies at least one user specified formula to generate a table of labeled results populated in a plurality of cells;
receiving as arguments in a structured arguments list of the table generator function, which structured arguments list has a predetermined ordering of argument groups separated by delimiters and which arguments are grouped within the argument groups, at least first and second user specified data fields as inputs, the data field arguments including user specified formulaic data description terms for accessing a non-cell source or a data cell range;
using at least the first user specified data field input to create loop equivalents over distinct values of the first user specified data field, wherein a loop equivalent groups the input based on two or more records or cell ranges that have matching values in the first user specified data field;
receiving as a further argument in the arguments list the user specified formula, including at least one spreadsheet range function or array function;
evaluating data in the second data field input by applying the user specified formula grouped by the distinct values in the loop equivalents to generate loop equivalent function results; and
outputting from the table generator function the loop equivalent function results and outputting adjacent thereto at least related labels from the first user specified data field.