Equation-Bound Spreadsheet Visualizations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional spreadsheet applications offer limited options for generating customized visualizations, requiring users to have extensive knowledge of graphical primitives and geometry systems, and the created visualizations are often not data-bound or adaptable to different datasets.
Innovation Solution
The system allows users to bind parameters of primitive visual objects with user-generated equations, enabling the creation of customized visualizations that can be saved as templates for reuse with different datasets, and supports nesting of templates for complex data visualization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users manually alter visualizations by adding graphical objects, then customization capability is improved, but device complexity and ease of operation deteriorate due to requiring extensive knowledge of graphical primitives and geometry systems
Solution Approach 1:
The patent introduces an intermediary layer between data and visualization by allowing users to bind data to visual properties through simple equations rather than directly manipulating graphical primitives. This intermediary equation-based binding mechanism translates complex visualization requirements into simple mathematical relationships, eliminating the need for users to understand underlying graphical geometry systems while still achieving full customization capability.
Solution Approach 2:
The patent enables parameter changes by allowing users to modify visual properties (position, size, color, shape) through equation-based bindings to data parameters. Instead of manually adjusting graphical objects, users change the equations that define these parameters, which automatically updates the visualization. This transforms the interaction from direct manual manipulation to parameter-driven automatic adjustment, significantly improving ease of operation while maintaining versatility.
2Adaptability or versatility
If users create visualizations from scratch using specialized languages, then customization capability is improved, but device complexity and ease of operation worsen due to requiring extensive knowledge of graphical primitives
Solution Approach 1:
The patent introduces an intermediary equation-based binding system that sits between the user's simple equation inputs and the complex graphical rendering system. This intermediary layer abstracts away the complexity of graphical primitives and geometry systems, allowing users to create customized visualizations through simple equations without needing to understand or specify the underlying graphical language complexity.
Solution Approach 2:
The patent substitutes the mechanical system of manually manipulating graphical primitives with an equation-based mathematical system. Instead of directly controlling graphical objects through specialized visualization languages, users define relationships through equations, and the system automatically translates these into the appropriate graphical representations. This substitution replaces complex mechanical manipulation with simpler mathematical specification.
3Ease of operation
If conventional spreadsheet applications provide predefined visualizations, then ease of operation is improved, but adaptability worsens as visualizations are not adaptable to other datasets
Solution Approach 1:
The patent achieves universality by creating a visualization system where the same equation-based binding mechanism can be applied to any dataset. The bindings define relationships between data parameters and visual properties that work universally across different data types and datasets. This allows a single visualization template with bindings to adapt to multiple datasets, providing both ease of operation (using the same simple binding mechanism) and broad adaptability (across different data).
Solution Approach 2:
The patent introduces dynamics by making visualizations adaptable through equation-based bindings that automatically adjust to different datasets. Instead of static predefined visualizations, the system creates dynamic visualizations where the equations bind visual properties to data parameters, allowing the visualization to automatically adapt its appearance and behavior based on the underlying data. This dynamic adaptation maintains ease of operation while significantly improving versatility.
4Adaptability or versatility
If users bind parameters to user-generated equations, then adaptability is improved, but device complexity increases due to equation binding mechanism
Solution Approach 1:
The patent introduces an intermediary equation binding layer that mediates between user equations and the visualization system. This intermediary mechanism handles the complexity of equation parsing, evaluation, and translation into graphical commands, shielding users from the underlying complexity while enabling powerful adaptability through equation-based parameter binding.
Data Source
AI summary
Descried herein are various technologies to visualizing data in a spreadsheet application. Customized visualizations are generated by binding a user-defined equation with a parameter of a primitive visual shape that has been selected by the user to visualized a dataset. The user-defined equation takes as input a value of data in a cell of the spreadsheet application, and the primitive visual shape is displayed to the user as a function of the output of the user-defined equation.