Method and system for repeat 2D ordering of output from spreadsheet analytical functions

A non-transitory computer readable media loaded with computer instructions that, when executed on hardware, cause the hardware to carry out actions of evaluating data in a spreadsheet using a table generator prebuilt function that applies user specified algebraic formulas to user specified data fields to generate a table with two-dimensional headings with related multiple algebraic results, including:

• accessing from the spreadsheet the table generator prebuilt function entered in a first spreadsheet cell, wherein the table generator prebuilt function accepts as arguments at least two user specified algebraic formulas to generate a table of rows and columns with headings and
• respective results of the first and second user specified algebraic formulas;
• receiving as arguments in a structured argument list of the table generator prebuilt function, which structured arguments list has a predetermined ordering of arguments or argument groups separated by delimiters,
• at least one first, one second, two third and two fourth user specified data fields including user specified formulaic data description terms for accessing a non-cell source or a data cell range, wherein the first and second user specified data fields are different;
• using the first and the second user specified data fields to sort rows and columns of the results of applying the first and second user specified algebraic formulas to the third and fourth user specified data fields, respectively, to produce adjoining two-dimensional tables of respective results;
• and
• outputting from the table generator prebuilt function the adjoining two-dimensional tables of respective results in a table sharing either the headings for rows or columns of the first user specified data fields and replicating the second user specified field headings for complementary columns or rows.

A computer-implemented system including a processor and non-transitory computer readable media loaded with computer instructions that, when executed on the processor, cause the system to carry out actions of evaluating data in a spreadsheet using a table generator prebuilt function that applies user specified algebraic formulas to user specified data fields to generate a table with two-dimensional headings with related multiple algebraic results, including:

• accessing from the spreadsheet the table generator prebuilt function entered in a first spreadsheet cell, wherein the table generator prebuilt function accepts as arguments at least two user specified algebraic formulas to generate a table of rows and columns with headings and respective results of the first and second user specified algebraic formulas;
• receiving as arguments in a structured argument list of the table generator prebuilt function, which structured arguments list has a predetermined ordering of arguments or argument groups separated by delimiters,
• at least one first, one second, two third and two fourth user specified data fields including user specified formulaic data description terms for accessing a non-cell source or a data cell range, wherein the first and second user specified data fields are different;
• using the first and the second user specified data fields to sort rows and columns of the results of applying the first and second user specified algebraic formulas to the third and fourth user specified data fields, respectively, to produce adjoining two-dimensional tables of respective results;
• and
• outputting from the table generator prebuilt function the adjoining two-dimensional tables of respective results in a table sharing either the headings for rows or columns of the first user specified data fields and replicating the second user specified field headings for complementary columns or rows.