Spreadsheet Alert System for Patent Docketing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Automated docketing systems face challenges in efficiently managing and updating large numbers of alerts related to project parameters, often requiring time-consuming individualized updates and failing to effectively flag inconsistencies or errors across related parameters.
Innovation Solution
A user-configurable spreadsheet interface is developed that receives changes in project parameters and creates embedded alerts based on predefined phase rules, allowing for simultaneous updates of alerts and notifications to users, thereby streamlining the management of alerts and inconsistencies within the docketing system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If individualized updates are used for each alert in the docketing system, then each alert can be managed precisely, but the time and effort required for updates increases significantly
Solution Approach 1:
The patent merges multiple individual alert updates into a single batch operation. When a parameter changes in the spreadsheet, the system identifies all alerts related to that parameter and updates them simultaneously through a single user action, eliminating the need to manually update each alert individually while maintaining precise control over each alert's state
Solution Approach 2:
The system automatically detects parameter changes in the spreadsheet and triggers the appropriate alert updates without requiring manual intervention for each alert. The batch update mechanism self-services by identifying which alerts need updating and executing the updates automatically when the user initiates a single refresh action
2Reliability
If the docketing system monitors all project parameters for changes, then inconsistencies and errors can be detected effectively, but the system complexity increases
Solution Approach 1:
The patent introduces an intermediary layer between the spreadsheet data and the alert system. This intermediary mechanism monitors parameter changes through spreadsheet event listeners and translates them into appropriate alert updates, simplifying the overall system architecture while maintaining comprehensive monitoring capabilities across all project parameters
Solution Approach 2:
The system implements a universal parameter monitoring mechanism that handles multiple different parameter types through a single unified approach. The same change detection and batch update infrastructure works for various parameter kinds (deadlines, status changes, assignments), reducing system complexity by avoiding separate monitoring logic for each parameter type
3Productivity
If multiple alerts are updated simultaneously based on parameter changes, then the productivity of the docketing system improves, but the risk of updating incorrect alerts increases
Solution Approach 1:
The system performs preliminary identification of which alerts need updating before executing the batch update. When a parameter changes, the system first determines the scope of affected alerts by analyzing the parameter's relationships, then presents this information to the user for confirmation before executing the updates, ensuring only the correct alerts are modified
Solution Approach 2:
The system provides feedback to the user about which alerts will be updated before the actual update occurs. The batch update mechanism includes a review step where the user can see the list of alerts that will be affected by the parameter change and confirm or adjust the update scope, ensuring accuracy while maintaining high productivity
Data Source
AI summary
Various embodiments disclosed relate to spreadsheet driven alert methods and tools for patent prosecution. The present disclosure includes a method including: producing a user-configurable database on a user interface, the database describing a plurality of matters, wherein for each of the plurality of matters, each of the plurality of matters associated with one or more parameters, receiving an indication in a change in the one or more parameters; creating one or more embedded alerts in the spread sheet according to the change in the one or more parameters, each of the one or more embedded alerts associated with one of the plurality of matters; and notifying a user of one or more embedded alerts in the database.