Tabular Widget Mergable Cells Decision Table Automation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The process of updating, sorting, and modifying decision tables in spreadsheets is laborious, error-prone, and time-consuming due to the need for manual unmerging, filling, and updating of cells, especially when handling complex logic representations like insurance premium calculators.
Innovation Solution
The implementation of a grid widget that separates data from its graphical representation, enabling implicit cell merging, collapsing, and grouping, which allows for flexible 'group by' behavior and automatic merging based on value thresholds, reducing the manual effort required for managing decision tables.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual unmerging and cell population is performed to update decision tables, then data consistency can be maintained, but the process becomes laborious and time-consuming
Solution Approach 1:
The system performs preliminary actions by automatically populating cells with appropriate values before the user needs to update the decision table. When cells are unmerged, the system proactively fills them with correct data based on the decision table logic, rather than waiting for manual input. This preliminary population maintains data consistency while eliminating the time-consuming manual filling process.
Solution Approach 2:
The decision table system serves itself by automatically maintaining its own data consistency. When structural changes occur (like unmerging cells), the system self-corrects by populating appropriate cells with correct values based on the underlying decision logic, without requiring external manual intervention. This self-service mechanism ensures reliability while reducing user workload and time investment.
2Ease of operation
If manual cell manipulation is required for sorting and updating, then precise control over cell positions is achieved, but the complexity of the operation increases
Solution Approach 1:
The system introduces an intermediary layer between the user and the decision table cells. This intermediary automatically handles the complex coordination of unmerging, sorting, and population operations based on user intent. The user simply specifies the desired outcome (e.g., sort by a column), and the intermediary manages the complex sequence of cell manipulations, reducing operational complexity while maintaining ease of use.
Solution Approach 2:
The system segments the decision table management into distinct, manageable operations. Instead of requiring users to manually coordinate multiple complex steps (unmerge, sort, populate), the system breaks down the process into automated segments that can be triggered independently. Each segment handles a specific aspect of cell manipulation, reducing the overall complexity perceived by the user while maintaining precise control.
3Shape
If cells are merged for organizational purposes in decision tables, then visual organization is improved, but manual unmerging and refilling becomes necessary for updates
Solution Approach 1:
Before the user attempts to update merged cells, the system performs preliminary unmerging actions automatically. When an update operation is initiated on a merged cell, the system proactively unmerges the cell group, populates the individual cells with appropriate values based on the decision logic, and then re-merges them if appropriate. This preliminary handling maintains visual organization while eliminating the manual unmerging and refilling burden.
Solution Approach 2:
The merged cell structure serves itself during update operations. When users interact with merged cells for updates, the system automatically manages the unmerging, population, and re-merging process without requiring manual intervention. The merged cell structure maintains its visual organizational benefit while the system handles the complexity of updates internally, making the process as easy as editing regular cells.
Data Source
AI summary
Disclosed herein are systems, methods, and non-transitory computer-readable storage media for managing spreadsheets with decision tables. The exemplary method includes generating an underlying data model associated with a visual data model of a spreadsheet containing a decision table, populating the underlying data model based on information contained in the visual data model and based on the decision table, generating a first index for mapping cells in the visual data model to cells in the underlying data model consistent with the decision table, and generating a second index for mapping cells in the underlying data model to cells in the visual data model consistent with the decision table.