Abstract: The disclosed technology creates a range of manual to automated ways of setting up and verifying the correct joining of data sets for use generating charts within a spreadsheet visualizer. Handling pairing of data sets and then chaining/sequencing of joins resulting in joins of three or more data sets. Limiting joins, as desired, to data value matching criteria and data modelling cardinality requirements. Allowing the qualification of the data sets for joining to be done within or before spreadsheet visualizer input panel. Making the qualified joinable data sets available in situationally intelligent data field/column selection lists for use populating the data visualizer inputs. Availing those joined data fields/columns to be used to generate spreadsheet visualizer charts.

Abstract: The disclosed technology creates a range of manual to automated ways of setting up and verifying the correct joining of data sets within spreadsheet cell formulas. Handling pairing of data sets and then chaining/sequencing of joins resulting in joins of three or more data sets. Limiting joins, as desired, to data value matching criteria and data modelling cardinality requirements. Allowing the qualification of the data sets for joining to be done within or before the cell formula. Making the qualified joinable data sets available in situationally intelligent data field/column selection lists for use populating those cell formulas. Availing those joined data fields/columns to be used in regular cell formula calculations.

Abstract: Disclosed is a method giving an alternative to typing, cell selecting, single list selecting and pasting in arguments for a built-in spreadsheet function and flex copy paste capabilities through the use of a broad spectrum of selection list panels supporting multiple selections from multiple lists with fixed and/or situationally specific specification options. Those and other arguments can be invisible in the spreadsheet formula text while more understandably visible in UIs. Also disclosed is function and flex copy-paste control of cell formatting overriding any cell formatting otherwise applied to those cells employing a broad spectrum of specification types and selection list panels not previously utilized for spreadsheet functions or copy paste.

Abstract: The disclosed technology creates a family of (predefined formula) spreadsheet functions which allows users to create programming loop equivalents in their regular spreadsheet cells employing familiar range functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The data can be sourced from multiple cells within the spreadsheet or a broad spectrum of numeric, date and text data not stored in a spreadsheet, including data not discretely defined. The technology disclosed can use as inputs either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to specify standardized or highly custom calculations capable of executing millions of loops through a (predefined formula) spreadsheet function.

Abstract: The disclosed technology creates a family of (predefined formula) spreadsheet functions which allows users to create programming loop equivalents in their regular spreadsheet cells employing familiar range functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The data can be sourced from multiple cells within the spreadsheet or a broad spectrum of numeric, date and text data not stored in a spreadsheet, including data not discretely defined. The technology disclosed can use as inputs either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to specify standardized or highly custom calculations capable of executing millions of loops through a (predefined formula) spreadsheet function.

Abstract: The disclosed technology creates a set of technologies that formulaically and/or positionally link cell(s) to spreadsheet functions or capabilities that flex the number of cells they instantiate. Thereby automatically altering the cell formula and/or the cell position reflecting those linked/connected flex range changes. Automatically ensuring no overlap of linked/connected cells and automatically adjusting linked/connected formulas for the referenced flex changes.

Abstract: The disclosed technology creates three families of (predefined formula) spreadsheet functions which allows users to functional formulas that create multiple two-dimensional repetitions of range or array function formula calculations, non-range or non-array function algebraic formulas, or two-dimension fields with complementary vertical and horizontal headings in their regular spreadsheet cells. The data can be sourced from multiple cells within the spreadsheet or a broad spectrum of numeric, date and text data not stored in a spreadsheet, including data not discretely defined. The technology disclosed can use as inputs either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to specify standardized or highly custom calculations capable of executing millions of calculations through a (predefined formula) spreadsheet function.

Abstract: The disclosed technology creates new families of (predefined formula) spreadsheet functions which allow users to bucket values, supports use of those bucketing functions in other functions, and adds value bucketing capabilities as an option in existing spreadsheet functions. The technology disclosed can use as inputs either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to bucket numerical, text and time/date values.

Abstract: Disclosed is a method giving an alternative to typing, cell selecting, single list selecting and pasting in arguments for a built-in spreadsheet function and flex copy paste capabilities through the use of a broad spectrum of selection list panels supporting multiple selections from multiple lists with fixed and/or situationally specific specification options. Those and other arguments can be invisible in the spreadsheet formula text while more understandably visible in UIs. Also disclosed is function and flex copy-paste control of cell formatting overriding any cell formatting otherwise applied to those cells employing a broad spectrum of specification types and selection list panels not previously utilized for spreadsheet functions or copy paste.

Abstract: The technology disclosed relates to accessing data within or external to spreadsheet cells (NSC data) and presenting it to users, so they can select one or more value to populate the cell. In one implementation, the technology disclosed is a spreadsheet function (predefined formula) where the user inputs a cell range or NSC data formula resulting in a button operated drop-down (pop-up or other visual) populating one value within the cell. Once the formula is completed the user can change that value by clicking the button and selecting the desired value from the multiple values presented. In another implementation the function input can be altered to add a constraint (filter) limiting the values presented for selection. In variants of any of the implementations, the presented values can be organized in ascending or descending orders for easy selection and show all values or only the unique (distinct) values.

Abstract: The disclosed technology creates a family of (predefined formula) spreadsheet functions which allows users to create programming loop equivalents in their regular spreadsheet cells employing familiar range functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The data can be sourced from multiple cells within the spreadsheet or a broad spectrum of numeric, date and text data not stored in a spreadsheet, including data not discretely defined. The technology disclosed can use as inputs either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to specify standardized or highly custom calculations capable of executing millions of loops through a (predefined formula) spreadsheet function.