Back to results
US 10,503,822 B1Granted
Application tracking, auditing and collaboration systems and methods
AssigneeApparity, LLC
InventorsGavin Spencer, Subash Kalbarga, Clark Gilder
Life of this patent
Estimating the term…
Abstract
An application data tracking, auditing and collaboration system and method are provided. The system and method may be used to track and manage spreadsheets, or similar documents, at the internal or grid level and allow for unlimited linking, consolidation, referrals, and lookups, or integration of any number of spreadsheets across any number of users across any level of security and deployment scenarios.
Claims23
A computer-implemented method for tracking spreadsheet application data, comprising executing on a processor the steps of:
- receiving a first communication from a network interface, the first communication comprising a first content of a cell of a native spreadsheet from an embedded tracking object within a native spreadsheet application on a client device, the embedded tracking object extracting the first content from the cell of the native spreadsheet, the first content including grid data identifying the cell;
- saving the first communication in a non-transitory computer storage remote from the client device;
- receiving a second communication from the network interface, the second communication comprising a second content of the cell of the native spreadsheet from the embedded tracking object within the native spreadsheet application on the client device, the embedded tracking object extracting the second content from the cell of the native spreadsheet, the content including the grid data identifying the cell;
- storing the changes in the cell between the first content and the second content, wherein the storing comprises:
- performing a difference operation on the first content and the second content for the cell, to produce a cell level change data, and
- saving the cell level change data to the non-transitory computer storage remote from the client device, only if the cell has changed between the first content and the second content;
- and
- generating a selected spreadsheet, wherein the generating step comprises:
- selecting a partial subset of the cell level change data, and
- merging the selected partial subset of the cell level change data into the first content to assemble the selected spreadsheet.
7 more elements
A system for tracking spreadsheet application cell data, the system comprising:
- a spreadsheet client device comprising:
- a network interface, and
- a native spreadsheet application comprising an embedded tracking object,
- wherein the embedded tracking object is configured to extract a first content of a native spreadsheet cell and transmit the first content via the network interface to a spreadsheet revision server, the first content including metadata identifying the cell, and extract a second content of the native spreadsheet cell and transmit the second content via the network interface to the spreadsheet revision server, wherein the second content contains a modification of the first content and the metadata identifying the cell;
- and
- the spreadsheet revision tracker server remote from the client device, the spreadsheet revisions tracker server comprising:
- a network interface,
- a non-transitory computer storage medium, and
- a spreadsheet revision tracking application configured to:
- receive the first content from a network interface,
- save the first content in a non-transitory computer storage,
- receive the second content from the network interface,
- store the changes in the cell, identified by the metadata, between the first content and the second content, wherein the storing comprises:
- performing a difference operation on the first content and the second content for the cell, to produce a cell level change data, and
- saving the cell level change data to the non-transitory computer storage, only if the cell has changed between the first content and the second content, and
- generate a selected spreadsheet, wherein the generating step comprises:
- selecting a partial subset of the cell level change data, and merging the selected partial subset of the cell level change data into the first content to assemble the selected spreadsheet.
14 more elements
A non-transitory computer-readable medium for tracking spreadsheet application cell data, comprising instructions stored thereon, that when executed on a processor, perform the steps of:
- receiving a first communication from a network interface, the first communication comprising a first content of a cell of a native spreadsheet from an embedded tracking object within a native spreadsheet application operating on a client device remote from the non-transitory computer readable medium, the first content including source code cell data identifying the cell;
- saving the first communication in a non-transitory computer storage remote from the client device;
- receiving a second communication from the network interface, the second communication comprising a second content of the cell of the native spreadsheet from the embedded tracking object within the native spreadsheet application operating on the client device, the second content the source code cell data identifying the cell:
- storing the changes in the cell between the first content and the second content, wherein the storing comprises:
- performing a difference operation on the first content and the second content for the cell, to produce a cell level change data, and
- saving the at least one cell level change data to the non-transitory computer storage, only if the cell has changed between the first content and the second content;
- and
- generating a selected spreadsheet, wherein the generating step comprises:
- selecting a partial subset of the cell level change data, and
- merging the selected partial subset of the cell level change data into the first content to assemble the selected spreadsheet in the cell identified by the source code cell data.
7 more elements
Dependencies are inferred from the claim text.