Recursive Multidimensional Spreadsheet Cell Splitting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Classical two-dimensional spreadsheets are inadequate for handling structured data and interacting with external applications, lacking flexibility and ease of use, and require tedious attention to detail for complex modeling and debugging.
Innovation Solution
The method involves splitting cells to create multidimensional structures, allowing cells to contain additional groups of cells recursively, using splitters that provide lexical scopes and iterators, enabling direct mapping to external data structures and combining the flexibility of traditional spreadsheets with OLAP-based tools.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If classical two-dimensional spreadsheet structure is used, then ease of operation is maintained, but flexibility for handling structured data deteriorates
Solution Approach 1:
The patent implements nested cells where a parent cell can contain multiple child cells, forming a hierarchical structure. This nesting capability allows the spreadsheet to represent multi-dimensional structured data while maintaining the familiar cell-based interface that users find easy to operate.
Solution Approach 2:
The patent extends the traditional two-dimensional spreadsheet grid by adding hierarchical dimensions through nested cells. Each cell can now contain additional levels of nested cells, transforming the flat 2D structure into a multi-dimensional hierarchy that can represent complex structured data while preserving the original grid's ease of use.
2Adaptability or versatility
If complex modeling is implemented cell-by-cell in traditional spreadsheets, then structured data handling capability is improved, but device complexity and difficulty of debugging increase
Solution Approach 1:
The patent segments complex structured data into hierarchical cell groups, where parent cells contain related child cells. This segmentation allows complex models to be organized into manageable hierarchical units, reducing the apparent complexity compared to cell-by-cell modeling while maintaining structured data handling capabilities.
Solution Approach 2:
By adding the hierarchical dimension to the traditional grid, the patent enables complex structured data to be represented naturally through nested cell structures rather than requiring complex cell-by-cell configurations. This dimensional extension simplifies the modeling process by providing a more natural representation for hierarchical data.
3Reliability
If traditional spreadsheet structure is used, then ease of operation is maintained, but reliability and auditability deteriorate
Solution Approach 1:
The nested cell structure creates a hierarchical organization that naturally supports auditing and reliability by grouping related cells under parent cells. This hierarchy makes it easier to track data provenance, understand data relationships, and perform systematic audits compared to flat two-dimensional spreadsheets.
Data Source
AI summary
Methods for structuring electronic documents having an ordered set of cells (e.g., spreadsheets or web documents) are provided. In general, the methods provide for multidimensionality by allowing cells to be split by splitting operators, thus allowing cells to contain additional groups of cells, and recursively so. Disclosed are tools and operations for building and modifying various multi-dimensional structures and for interacting with them. Splitting operators provide a two-dimensional equivalent of lexical scopes and iterators in programming languages and allow a direct mapping to external data structures. With these features, the disclosed methods are able to combine the flexibility and unstructured nature of traditional spreadsheet with the structuring capabilities of online analytic processing (OLAP)-based tools.