View source for 20240028821. METHOD AND SYSTEM FOR IMPROVED SPREADSHEET ANALYTICAL FUNCTIONING simplified abstract (Adaptam Inc.)

=METHOD AND SYSTEM FOR IMPROVED SPREADSHEET ANALYTICAL FUNCTIONING=


==Organization Name==

[[:Category:Adaptam Inc.|Adaptam Inc.]]


[[Category:Adaptam Inc.]]

==Inventor(s)==

[[:Category:Robert E. Dvorak of Portola Valley CA (US)|Robert E. Dvorak of Portola Valley CA (US)]][[Category:Robert E. Dvorak of Portola Valley CA (US)]]

==METHOD AND SYSTEM FOR IMPROVED SPREADSHEET ANALYTICAL FUNCTIONING - A simplified explanation of the abstract==


This abstract first appeared for US patent application 20240028821 titled 'METHOD AND SYSTEM FOR IMPROVED SPREADSHEET ANALYTICAL FUNCTIONING

==Simplified Explanation==

The disclosed technology is a set of spreadsheet functions that allow users to create programming loop equivalents in their regular spreadsheet cells. These functions combine familiar range or array evaluating functions (such as sum, count, min, max, etc.) with data filtering and output selection. The input data for these functions can come from multiple cells within the spreadsheet or from a broad range of numeric, date, and text data that is not stored in a spreadsheet.

* Users can create programming loop equivalents in their regular spreadsheet cells.
* The functions combine range or array evaluating functions with data filtering and output selection.
* Input data can come from multiple cells within the spreadsheet or from external sources.
* The technology supports predefined combinations and user-specified combinations of functions.
* It can automate millions of looped calculations.

Potential applications of this technology:

* Financial modeling: Users can create complex calculations and simulations using the spreadsheet functions.
* Data analysis: The functions can be used to filter and analyze large datasets within a spreadsheet.
* Process automation: The technology can automate repetitive calculations and data processing tasks.

Problems solved by this technology:

* Simplifies the process of creating complex calculations and simulations in spreadsheets.
* Allows users to easily filter and analyze large datasets within a spreadsheet.
* Automates repetitive calculations and data processing tasks.

Benefits of this technology:

* Increases productivity by automating repetitive tasks and calculations.
* Simplifies the creation of complex calculations and simulations.
* Enables efficient data analysis within a spreadsheet environment.


==Original Abstract Submitted==

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.



[[Category:G06F40/18]]
[[Category:G06F17/18]]