Web Spreadsheet Design Section and Preview Panel for Accurate Data Entry
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current computerized spreadsheet applications require users to learn complex commands, syntax, and formulas, making it difficult to create and manage spreadsheets, especially when multiple users or data sets are involved, as users may inadvertently input data into wrong cells or modify incorrect areas.
Innovation Solution
A web-based spreadsheet system that allows users to create and customize spreadsheets through a user-friendly interface with a design section and preview panel, enabling line-by-line construction without a starting grid, embedded worksheet functions, and the ability to lock certain fields for end-users, facilitating data entry and calculation while displaying embedded worksheets within the main spreadsheet.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users are provided with full access to all spreadsheet cells and functions, then the spreadsheet can be highly flexible and powerful for data analysis, but users may input data into wrong cells or modify cells that should not be changed
Solution Approach 1:
The spreadsheet interface is segmented into multiple distinct areas: a formula bar area for displaying and editing formulas, a worksheet area for data entry, and a formula toolbar with specific function buttons. This segmentation allows users to interact with different parts of the spreadsheet in controlled ways, reducing the risk of unintended modifications while maintaining full functionality.
Solution Approach 2:
The patent introduces an intermediary formula bar and formula toolbar that mediates between the user and the underlying spreadsheet data. Instead of directly editing cells, users interact through this intermediate interface layer, which provides validation, display of actual formulas, and controlled access to modification capabilities, thereby improving data entry accuracy without sacrificing versatility.
2Loss of information
If spreadsheet formulas and functions are displayed in the cells, then users can see the calculations being performed, but the spreadsheet becomes cluttered and harder to read
Solution Approach 1:
The patent moves formula display from the two-dimensional cell grid to a separate one-dimensional formula bar area above the worksheet. This dimensional relocation allows formulas to be displayed prominently without occupying cell space or cluttering the visual layout of the data, maintaining both formula visibility and spreadsheet readability simultaneously.
Solution Approach 2:
Instead of displaying formulas directly in the cells, the patent creates a copy of the formula content in the formula bar area. This copy provides full visibility of the calculation logic while the original cells remain clean and focused on data presentation, resolving the contradiction between information visibility and operational ease.
3Ease of operation
If a traditional grid-based spreadsheet interface is used, then users can easily navigate and reference cells using row and column labels, but new users find it difficult to learn commands, syntax, and formulas
Solution Approach 1:
The patent implements a formula toolbar with intuitive icons and buttons that allow users to insert common formulas and functions without needing to know the syntax or commands. The interface serves itself by providing visual, context-appropriate options based on the selected cell type, eliminating the need for users to learn complex command structures while maintaining easy cell navigation through the traditional grid interface.
Data Source
AI summary
Methods, systems and articles of manufacture for creating an electronic spreadsheet using a web-based spreadsheet application. A web-server hosting a web-based spreadsheet website comprises one or more computer(s) having at least one computer processor, memory, data storage and a network communication device (e.g. a network adapter). The web-server is configured to transmit a spreadsheet web application to a user computing device (e.g. a personal computer, smartphone, etc.) having a web-browser via the internet. The spreadsheet web application is configured to program the web-browser of the computing device to display and execute a spreadsheet web application having various features and functionality, including one or more of a separate design section and preview panel, a test data feature, line by line building of a spreadsheet without a starting grid of rows and columns, an embedded spreadsheet feature, an embedded worksheet display within a line feature, or any combination of these features.