System and method for managing a spreadsheet
A system and method for managing a spreadsheet are disclosed. The method may include determining a portion of a digital image of a data statement, determining data of the data statement based on the portion of the digital image, and mapping a data cell of a standardized spreadsheet to the portion of the digital image based on the data of the data statement. The data of the data statement may be determined by applying an optical character recognition process to the digital image. The data cell may be mapped to the portion of the digital image based on a label or key included in the data of the data statement, a set of coordinate values, a mathematical equation, and/or the like. The method may further include determining a location of a second data statement based on the mapping data.
1. A method for managing a standardized spreadsheet, the method comprising:
retrieving mapping data associated with one or more data cells of the standardized spreadsheet, the mapping data mapping at least one of the data cells of the standardized spreadsheet to a first portion of a first data statement;
comparing the first data statement and a second data statement, the first and second data statement being digital images;
updating the mapping data based on the comparison of the first data and the second data;
retrieving data of the second data statement based on the updated mapping data; and
storing the retrieved data of the second data statement in a data cell of the standardized spreadsheet based on the updated mapping data.
2. The method of claim 1 , further comprising performing an optical character recognition process on the first data statement and the second data statement.
3. The method of claim 1 , wherein the mapping data comprises:
first data indicative of the identity of a first portion of the second data statement;
second data indicative of a location of a second portion of the second data statement, the second portion being a sub-set of the first portion; and
third data indicative of the spatial location of the second portion.
4. The method of claim 3 , wherein the first data is a name associated with the first portion, the second data includes a row number of a table, and the third data includes a set of coordinates.
5. A computer comprising:
a processor, and
a memory device electrically coupled to the processor, the memory device having stored therein a plurality of instructions which, when executed by the processor result in the computer:
retrieving mapping data associated with one or more data cells of the standardized spreadsheet, the mapping data mapping at least one of the data cells of the standardized spreadsheet to a first portion of a first data statement;
comparing the first data statement and a second data statement, the first and second data statement being digital images;
updating the mapping data based on the comparison of the first data and the second data;
retrieving data of the second data statement based on the updated mapping data; and
storing the retrieved data of the second data statement in a data cell of the standardized spreadsheet based on the updated mapping data.
6. The computer of claim 5 , wherein the plurality of instructions further result in the computer performing an optical character recognition process on the first data statement and the second data statement.
7. The computer of claim 5 , wherein the mapping data comprises:
first data indicative of the identity of a first portion of the second data statement;
second data indicative of a location of a second portion of the second data statement, the second portion being a sub-set of the first portion; and
third data indicative of the spatial location of the second portion.
8. The computer of claim 7 , wherein the first data is a name associated with the first portion, the second data includes a row number of a table, and the third data includes a set of coordinates.
9. An article comprising a non-transitory, computer-readable signal bearing medium having a plurality of instructions stored thereon that, in response to being executed by a computer, result in the computer:
retrieving mapping data associated with one or more data cells of the standardized spreadsheet, the mapping data mapping at least one of the data cells of the standardized spreadsheet to a first portion of a first data statement;
comparing the first data statement and a second data statement, the first and second data statement being digital images;
updating the mapping data based on the comparison of the first data and the second data;
retrieving data of the second data statement based on the updated mapping data; and
storing the retrieved data of the second data statement in a data cell of the standardized spreadsheet based on the updated mapping data.
10. The article of claim 5 , wherein the plurality of instructions further result in the computer performing an optical character recognition process on the first data statement and the second data statement.
11. The article of claim 5 , wherein the mapping data comprises:
first data indicative of the identity of a first portion of the second data statement;
second data indicative of a location of a second portion of the second data statement, the second portion being a sub-set of the first portion; and
third data indicative of the spatial location of the second portion.
12. The article of claim 11 , wherein the first data is a name associated with the first portion, the second data includes a row number of a table, and the third data includes a set of coordinates.