Spreadsheet Cell Multi-Value Dropdowns for Formula-Based Data Selection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing spreadsheet applications lack an easy way to create multi-value dropdowns or pop-ups within regular cell formulas, which are limited to single selections and require complex programming, and do not support multi-select filters or work with external data sources.
Innovation Solution
A technology that allows users to create single or multi-value dropdowns or pop-ups within spreadsheet cells using predefined formulas, which automatically organize and deduplicate data, support constraints, and work with external data sources without requiring programming.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users create dropdown selectors as inputs to regular cell formulas, then data selection capability is improved, but the process becomes complicated and limited to single selections
Solution Approach 1:
The patent segments the dropdown functionality into distinct components: data source identification, value extraction, deduplication, and presentation. By breaking down the complex dropdown creation process into these manageable segments, users can easily create multi-value dropdowns without dealing with the overall complexity of the entire system.
Solution Approach 2:
The patent introduces an intermediary mechanism that sits between the data source and the cell formula. This intermediary automatically extracts values, removes duplicates, and presents them as a multi-value dropdown list, mediating the interaction between raw data and user selection without requiring users to manually program the complex extraction and deduplication logic.
2Adaptability or versatility
If users use Pivot Tables for multi-select filters, then filtering capability is improved, but the complexity increases and formula support is limited
Solution Approach 1:
The patent creates a universal dropdown mechanism that combines the multi-select filtering capability of Pivot Tables with the formula flexibility of regular cells. This multi-functional solution allows users to perform multi-value selection, filtering, and formula integration all in one interface, eliminating the need to choose between Pivot Tables and regular formulas.
Solution Approach 2:
Instead of requiring users to learn the complex Pivot Table interface to achieve multi-select filtering, the patent inverts the approach by bringing the simplicity of regular cell formulas to the multi-select filtering capability. Users can now achieve Pivot Table-like filtering through familiar formula-based cells, reversing the traditional complexity hierarchy.
3Adaptability or versatility
If dropdowns are created with external data sources, then data accessibility is improved, but the setup process becomes more complex
Solution Approach 1:
The patent implements a self-service mechanism where the dropdown system automatically identifies and connects to external data sources without requiring manual configuration. The system autonomously extracts values from external sources, handles data transformation, and presents the multi-value dropdown, allowing users to benefit from external data connectivity without dealing with the complexity of setting up such connections.
Data Source
AI summary
The technology disclosed relates to accessing multiple data values by an improved spreadsheet function referencing a single spreadsheet cell. The multiple data value can reside in a range of cells, at locations other than the single spreadsheet cell, or in an external data source (NSC data). The multiple values are used by the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet. In implementations, the spreadsheet function is a preexisting spreadsheet function. It can be a range function or an array function. The syntax of the preexisting spreadsheet function is unchanged by the returning multiple values from the first cell.