Patent attributes
The disclosed technology creates a family of spreadsheet functions (predefined formulas) which allows users to create programming loop equivalents in their regular spreadsheet cells combining familiar range or array evaluating functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The input data to these new functions 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 cell ranges or Non-spreadsheet Cell (NSC) data formulas. The technology supports functions with predefined combinations and user specified combinations all capable of automating, millions of looped calculations.