Spreadsheet Multi-Output Functions via Named Ranges
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current spreadsheet systems are limited by array functions that return multiple values as a single block of contiguous numbers, making it difficult for users to understand the meaning of each value and preventing the creation of flexible user interfaces, and require explicit specification of cell locations for input parameters, which cannot be automatically populated.
Innovation Solution
Implementing automatic parameter mappings in spreadsheet worksheet functions that allow for multi-output functions, automatically populating input parameters, and mapping output values to named ranges, enabling arbitrary layouts and user customization of output formats.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If array functions return multiple values as a single block of contiguous numbers, then the function can return multiple calculated values, but the user cannot understand what each value represents and cannot create flexible user interfaces
Solution Approach 1:
The patent segments the contiguous array output into individually addressable named ranges. Each element of the array is mapped to a specific named range, allowing users to reference and understand each value separately through meaningful names rather than as an undifferentiated block of numbers.
Solution Approach 2:
The patent introduces named ranges as an intermediary layer between the array function output and the user interface. These named ranges serve as mediators that provide semantic meaning to numerical values, enabling users to create flexible interfaces with descriptive labels while maintaining the underlying array structure.
2Measurement precision
If users explicitly specify cell locations for input parameters, then the function can access specific data, but the parameter lists cannot be automatically populated
Solution Approach 1:
The patent enables automatic population of input parameters by allowing users to define named ranges that automatically serve as input sources. The system self-populates parameter lists by recognizing and mapping these predefined named ranges, eliminating the need for manual cell location specification while maintaining precise parameter control.
Solution Approach 2:
The patent requires users to pre-define named ranges for input data before using functions. This preliminary action allows the system to automatically populate parameter lists during function execution, as the named ranges are already established and can be automatically recognized and mapped to function inputs.
3Device complexity
If array functions return values as a single block, then the implementation is simple, but it is impossible to insert cells for descriptive labels
Solution Approach 1:
The patent adds a naming dimension to the array output. Instead of only spatial positioning (row, column), each array element is associated with a semantic name. This additional dimension enables flexible user interfaces with descriptive labels while maintaining the simple underlying array implementation.
Data Source
AI summary
A system and methods for defining spreadsheet worksheet functions capable of returning more than one output value to a worksheet with the layout of the returned values being customizable through the use of named ranges on the worksheet. The mapping of an output value to a destination cell (or range) is achieved by using a naming convention, wherein the name of the output parameter as defined in the worksheet function is automatically mapped to a worksheet range having the same name.