Hybrid Spreadsheet Client Network Service Calculation Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Web-based spreadsheet applications typically offer a less rich user experience compared to client-based applications due to limitations in processing and data handling, particularly when dealing with non-local data.
Innovation Solution
A hybrid system where a client application performs calculations on local data and leverages a network service for non-local data calculations, integrating results from both sources to enhance user experience and efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a client application performs all calculations locally, then user experience and graphics quality are improved, but calculations involving non-local data cannot be performed
Solution Approach 1:
The calculation system is segmented into two independent parts: local calculation engine for local data and network service calculation engine for non-local data. Each handles specific calculation tasks separately, then results are integrated. This allows the client application to maintain rich local processing capabilities while adding non-local data processing capability through network services.
Solution Approach 2:
The system merges local calculation results and network service calculation results into a unified output. The client application integrates results from both local and remote calculation engines, providing a seamless user experience that combines the advantages of both approaches without requiring the user to be aware of the hybrid architecture.
2Adaptability or versatility
If a web based application is used, then accessibility and data access are improved, but user experience and graphics quality deteriorate
Solution Approach 1:
The application is segmented into a client-side component that provides rich user interface and local processing, and a network service component that provides data access and remote calculation. This segmentation allows each component to optimize for its specific function while working together to provide an overall system that achieves both good user experience and data accessibility.
3Power
If calculations are performed remotely via network service, then processing power and data access are improved, but response time and network dependency increase
Solution Approach 1:
Instead of performing all calculations remotely, the system performs partial calculations locally where possible and only sends calculations to the network service when non-local data is involved. This partial action approach minimizes network dependency and response time while still providing access to remote processing power when needed.
Data Source
AI summary
A client application uses a network service to perform calculations involving non-local data. A client application performs calculations relating to local data and the network service performs calculations relating to the non-local data. For example, a client spreadsheet application sends a command to the network service for performing calculations in a spreadsheet workbook that use data that is non-local to the client spreadsheet application. The calculation engine of the network service performs the calculations for the workbook relating to the non-local data and sends the results of the calculations back to the client application. The client application integrates the results received from the network service with any locally calculated results performed by the client application.