System and method for cell comparison between spreadsheets

A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to execute a process, the process comprising:

• assigning a unique first identifier to each cell containing data within a first spreadsheet;
• identifying characteristics of each cell containing data within the first spreadsheet and each cell containing data within at least one second spreadsheet, wherein the characteristics include data and metadata associated with each of the cells and wherein the first spreadsheet and the at least one second spreadsheet comprise at least a two-dimensional array of cells;
• analyzing the cells of the at least one second spreadsheet to compare each cell therein to the cells of the first spreadsheet, wherein the comparison is based on the identified characteristics of each cell, and wherein a comparison above a predetermined threshold is identified as a match;
• and
• assigning the unique first identifier of a cell of the first spreadsheet to a matching cell of the at least one second spreadsheet.

A system for cell tracking between spreadsheets, comprising:

• a processing circuitry;
• and
• a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:
• assign a unique first identifier to each cell containing data within a first spreadsheet;
• identify characteristics of each cell containing data within the first spreadsheet and each cell containing data within at least one second spreadsheet, wherein the characteristics include data and metadata associated with each of the cells and wherein the first spreadsheet and the at least one second spreadsheet comprise at least a two-dimensional array of cells;
• analyze the cells of the at least one second spreadsheet to compare each cell therein to the cells of the first spreadsheet, wherein the comparison is based on the identified characteristics of each cell, and wherein a comparison above a predetermined threshold is identified as a match;
• and
• assign the unique first identifier of a cell of the first spreadsheet to a matching cell of the at least a second spreadsheet.