Comment Re:I'll say it again (Score 1) 58
Businesses needed computers long before spreadsheets were invented. They just weren't sitting on every desk.
Yes, clearly that wasn't way more significant than the 1 or 2 backroom computers.
A tool that can be used to set up and calculate thousands of numbers with multiple variables and graph the results in less than a minute is completely useless.
There are far better tools, especially if you're handling "thousands" of numbers.
Oh really? Name one that can do exactly what I said. Open program on a new empty file, import from a
If it's not a dedicated spreadsheet, it has spreadsheet embedded into it.
Are they used for the wrong purpose? Undoubtedly. So are databases. So what? How does that matter, except for smug nerd superiority complexes? If it works, it works. It might not be optimal, but if it works for the users and isn't causing problems significant enough for the users to care, then maybe optimal isn't needed.
I can, and have, created small to medium sized databases for businesses. I have also many times used spreadsheets for tasks better suited for databases, and will again, because when you factor in the time it takes to set it up, I can get results faster with the spreadsheet. Especially if it needs input or manipulation by a non-tech person, since it is trivial to put it in a format they can use, as they are already familiar with the tools.
And, yes, I know I can use databases for the data and the spreadsheet for input/results, but, again, is slower to create and only marginally faster to use in many cases.
Thousands isn't a lot of numbers for a spreadsheet to handle, I have tons of spreadsheets with thousands of numbers (spectral data) that update immediately if I change the calculations being done on all of them. Hundreds of thousands are when it starts slowing down, but then again, so would a database if it had to do calculations on all of them. Would a database be ultimately more efficient? Sure. Does that difference matter? Not to me, not to the users. Only the IT guy gets morally outraged, and the data isn't for him.