Spreadsheet Plugin for Transaction Data Synchronization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional approaches to interfacing transaction management platforms (TMPs) with spreadsheet programs, such as Microsoft Excel, are inefficient and disrupt user workflows due to the need for manual data updates and slow data sharing via CSV files, leading to stale data.
Innovation Solution
A plug-in system that allows users to select transactions from a list, maps data fields to corresponding cells in a spreadsheet workbook, and updates data fields automatically or on user command, enabling bidirectional data synchronization between the TMP and spreadsheet.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If CSV files are used to enable data sharing between TMP and spreadsheet, then data exchange is enabled, but data synchronization speed decreases and data becomes stale
Solution Approach 1:
The patent introduces an intermediary component (plug-in or API connector) that mediates between the TMP and spreadsheet program, enabling real-time or near-real-time data synchronization without requiring manual CSV exports and imports. This intermediary maintains a persistent connection, allowing data to flow automatically between systems, thus preserving data freshness while eliminating the slow manual update process inherent in CSV-based approaches.
2Loss of information
If manual upload of Excel file to TMP is required after each update, then data can be transferred, but user productivity decreases and time is lost
Solution Approach 1:
The system implements self-service automation where the plug-in automatically detects changes in the Excel workbook and initiates data synchronization to the TMP without requiring user intervention. The system monitors for updates, extracts changed data, and transfers it automatically, eliminating the manual upload step and significantly improving user productivity while ensuring data remains synchronized.
Solution Approach 2:
The patent incorporates feedback mechanisms where the plug-in continuously monitors the Excel workbook for changes and automatically triggers synchronization when updates are detected. This feedback loop ensures that data is transferred promptly after modification, maintaining data accuracy between systems without requiring manual intervention, thus improving both data synchronization and user productivity.
3Reliability
If users are forced to switch from Excel to another program, then TMP functionality can be accessed, but workflow efficiency decreases and user convenience is reduced
Solution Approach 1:
The patent makes the spreadsheet program universal by enabling it to perform both traditional spreadsheet functions and TMP-specific transaction management functions through the plug-in. Users can access TMP functionality (transaction tracking, document management, workflow management) directly within Excel, eliminating the need to switch programs while maintaining full TMP capabilities, thus improving workflow efficiency without sacrificing functionality access.
Solution Approach 2:
The patent merges the TMP interface and functionality with the spreadsheet program through the plug-in integration. By combining TMP features (transaction management, document storage, workflow automation) with Excel's familiar environment, users can access comprehensive TMP functionality within their preferred spreadsheet tool, eliminating program switching and improving ease of operation while maintaining reliable access to all TMP capabilities.
Data Source
AI summary
A computer-implemented method includes: allowing a user of a spreadsheet program to select a transaction from a list of transactions for a transaction management platform; creating a mapping sheet in a workbook of the spreadsheet program, the mapping sheet listing, in a first column, data fields associated with the selected transaction; receiving, in a second column of mapping sheet, references to cells of the workbook that correspond to the data fields in the first column; and using the mapping sheet to automatically update the data fields associated with the selected transaction with data values from the corresponding cells of the workbook in response to a user command.