How would you classify the sorts of spreadsheets you see most often?
From a usage pov I can think of:
- transport s/s used for emailing info
- data stores
- one time use scratch pads
- enterprise data correctors/reformatters/ETL
- numerical analysis
Anyone got a link to research in this area?
The question I am seeking to answer is ‘if you couldn’t have spreadsheets what would you convert this type of spreadsheet to’.
Its a bit arbitary, I’m not claiming any particular classification is better or worse than another, or that any particular s/s would fit in one and only one category.
Do you think a classification based on life-time, or size/complexity (assuming you can measure it in a valid way), or number of users has much value?
I guess one way would be to look at alternative techs and say this should be a relational database, that should be in OLAP, that should be a web page, this should be in code, and those should stay in spreadsheets. And some could be split across multiple techs.