The Cost of Transforming a Spreadsheet
Making the transformation from spreadsheet to corporate data can be achieved in a variety of ways. One way the data can be transformed is manually. It is possible to read a spreadsheet manually, strip off the data that is desired, and then place the data into a database. There is great appeal to the manual approach. It can be done immediately; all that is required is a little bit of training. No great investment is required. And as long as there aren’t too many spreadsheets and as long as the spreadsheets are not too complicated, the manual approach works just fine.
But what if there are a lot of spreadsheets? The manual approach quickly breaks down. Using the manual approach:
- • There is the ongoing cost of human involvement. Humans cost a lot.
- • There is the fatigue factor. The quality of human work deteriorates over time.
- • There is the mistake factor. Humans make mistakes.
- • There is...
