Aligning Data from Different Spreadsheets

The modeling of spreadsheet data gives rise to another important question: what if two (or more) spreadsheets have a difference in the significance of data that should be closely aligned?

Furthermore what if there must be a resolution of the numbers? In some cases resolution is not important. Differences can be overlooked. Or differences can simply be ignored. As an example of the case when a number can be ignored, suppose the results of a football game were being discussed. The spreadsheet says that the score was 35-14 in favor of Dallas. In fact the score might have been 35-21. As long as the winner is recorded correctly, the exact score is not of a great concern (except perhaps to a bookmaker).

But in other cases, structural differences between data cannot be ignored. In such a case, how can a resolution be made?

There are lots of possibilities when it comes to resolving data differences. The easiest option is to find the data that...