Mobile Spreadsheet Navigation via Weighted Historical Actions
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing user interfaces for mobile devices, particularly in spreadsheets, fail to provide adequate navigation options for users to determine their initial display region effectively, especially when dealing with large datasets on small screens.
Innovation Solution
A method that weights historical user actions to determine initial display positions within a document, allowing users to select and navigate directly to relevant areas based on recorded interactions, such as frequently accessed cells or regions, thereby improving data access efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a preferential starting position (top, leftmost cell) or most recently edited cell is used as the initial display region, then the system provides a deterministic starting point, but the user experience is inadequate for navigation in large spreadsheets on mobile devices
Solution Approach 1:
The system performs preliminary analysis of historical user actions and pre-calculates multiple relevant starting positions before the user opens the spreadsheet. This allows the system to present context-aware initial display regions that are determined in advance based on user behavior patterns, rather than using simple default positions.
Solution Approach 2:
The initial display position is no longer fixed but dynamically determined based on weighted historical user actions. The system adapts the starting position according to user behavior patterns, making the navigation context-aware and responsive to individual user needs rather than following a static rule.
2Productivity
If very little data is displayed at once on the mobile screen, then the interface remains simple and manageable, but users cannot determine their location in the spreadsheet or access needed data efficiently
Solution Approach 1:
The system pre-identifies and weights multiple potential starting positions based on historical user actions before the user opens the document. This preliminary analysis enables the system to present the most relevant starting positions upfront, eliminating the need for users to manually navigate through large datasets to find their needed information.
3Adaptability or versatility
If the spreadsheet opens to a fixed position, then the system behavior is predictable, but it fails to provide adequate navigation options for mobile users accessing large datasets
Solution Approach 1:
The system performs preliminary weighting of historical user actions to identify multiple relevant starting positions before the user opens the spreadsheet. This pre-computation allows the system to present context-aware options without adding significant runtime complexity, balancing adaptability with system simplicity.
Data Source
AI summary
Methods and systems for navigating to an initial position in a document include weighting historical user actions within a document. Initial display positions within the document are determined based on the weighted historical user actions. A selected initial display positions is navigated to in accordance with a user selection.