Patent ID: 9734139
Date: 2017-08-15
CPC Classifications: G06F

Claim:
1. A system for monitoring and auditing data in one or more spreadsheets, each of the one or more spreadsheets comprising a plurality of cells, the system comprising: a file store within which files containing spreadsheet data can be stored; a database stored in a computer hardware memory module separately from the file store, wherein the database is a programmed database that supports computer application for performing specific actions on data stored within the database; database building means for loading the database with the content of the one or more spreadsheet files; and monitoring means, the monitoring means being operative to continuously detect changes in spreadsheet data within the file store, and to record the changes in the database, the changes including changes in formulae in cells of the database; the monitoring means including comparison means operative to repeatedly compare successive versions of a file in the file store by comparing each cell in a current version of the file with a corresponding cell in a previous version of the file and, if it is determined that the content of a cell has changed, creating a record of the change in said database, the record including data that classifies the change, such that the database contains a history of changes for recovering an earlier state of the spreadsheet starting with the file as it is in the file store.