Spreadsheet Unit Parsing for Accurate Measurement Operations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional spreadsheets are inadequate in determining the intended result of operations due to insufficient context provided by cell display formats, often leading to incorrect results or formatting issues, as they fail to handle units of measure effectively in mathematical operations.
Innovation Solution
A system that parses, converts, and performs unit-based math for spreadsheet cell values by associating valid measures and units, allowing for compatible operations and displaying measured values with their units, including support for various units of measurement and mathematical transformations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If conventional display formats are used to provide context for cell values, then the spreadsheet application is simple to operate, but the ability to determine the intended result of operations is insufficient
Solution Approach 1:
The patent segments the cell value into distinct components: a numeric measure and a unit of measure. This segmentation allows the system to parse and process each component separately, enabling accurate determination of operational intent while maintaining manageable system complexity through modular processing of value components.
Solution Approach 2:
The patent adds a new dimension to cell values by incorporating units of measure beyond traditional display formats. This dimensional enhancement allows the system to capture contextual information about the intended result (such as addition vs. multiplication intent based on unit compatibility) without significantly increasing overall system complexity.
2Reliability
If display format is used to convey context for cell values, then the interface is simple, but the result of operations may be incorrect
Solution Approach 1:
The system automatically parses cell values to extract units of measure and uses this information to determine the correct operational intent. This self-service mechanism eliminates the need for users to manually specify operation types or complex formatting, maintaining ease of operation while improving result correctness through automatic contextual analysis.
Solution Approach 2:
The patent replaces manual user specification of operation intent with an automated parsing system that extracts units of measure and determines operational context programmatically. This substitution maintains user interface simplicity while reliably determining the correct operation type based on unit compatibility rules.
3Loss of information
If conventional spreadsheet operations are performed without unit parsing, then processing is fast, but contextual information is lost
Solution Approach 1:
The system performs preliminary parsing of cell values to extract units of measure before executing operations. This advance processing captures contextual information about the intended result while allowing the actual mathematical operations to proceed efficiently, as the unit analysis is completed in advance to guide operation selection.
Data Source
AI summary
A system for parsing units of measure for spreadsheet cell values includes a processor. The processor is to host a spreadsheet document; receive a cell value entered into a cell of the spreadsheet document; parse the cell value to determine whether the cell value includes at least a measure and a unit of measure; and associate a valid measure and a valid unit of measure with the cell in the event that the measure and the unit of measure are valid.