Similar Column Headings

What if two column headings are very similar, but still have slight differences? This is a very common circumstance. Consider when an analyst submits a spreadsheet for the month of May.

The column headings are captured into an ssdef table. Now for the month of June, the analyst adds a simple column. Out of a large spreadsheet containing many values, only one new value has been added.

Is the definition of the columns as created in May going to be able to be used for the month of June? The answer is no. If definitions of column headings are to be reused, they must be exact matches.

Now suppose the analyst has defined column headings for the month of August to the system in the ssdef table. However, there is no new data to report in September, so the analyst simply reuses the same spreadsheet from August. Will the header lines that were defined in August still work for the month of September? Because there have been no changes to the spreadsheet, yes...