Right tool for the job. Sometimes it absolutely makes sense to have input/calc/output on the same "sheet" or set of "sheets." Unfortunately, most people don't

Right tool for the job. Sometimes it absolutely makes sense to have input/calc/output on the same "sheet" or set of "sheets." Unfortunately, most people don't know how to set up a spreadsheet in a way that makes this work (clearly delineating the input/calc/output sections with data validation, formatting, protection etc). Of course, if you were to make a solution that "forced" these choices on the user they'll cry about losing their freedom. So we are stuck with spreadsheets in many cases. And then there are the cases where using a spreadsheet makes no sense. I'd say it's about 50/50: Half the stuff currently done in spreadsheets makes sense, half of it would be better done elsewhere. I've managed to move more than half of our previous spreadsheet workload out of spreadsheets and into more appropriate software systems.