In Summary
Spreadsheets serve a wide variety of purposes. Two of the purposes they serve are for storage of valuable data, and for exchanging data between different entities. It is in these two roles that spreadsheets are often cast into the form of corporate data.
Spreadsheets can be characterized in many ways. One way to characterize spreadsheets is on a spectrum of non-recurring spreadsheets to recurring spreadsheets. As a rule, the more recurring the spreadsheet is, the more formal it is.
In terms of selecting spreadsheets for a basis for corporate data, the more formal and the more recurring a spreadsheet is, the more likely that the spreadsheet be transformed into corporate data.
In order to change spreadsheet data into corporate data, it is necessary to have both value and context. The best way to find the context of data found on a spreadsheet is to identify the column name and the row identifier of a value. Unfortunately, the cell formula found in a spreadsheet is...