4 ms·
Having used Excel for many years on the trading floor, I have to say it's awful. It does everything, badly. Which is why it's popular. People can get by withou
by lordnacho 8y ago
Having used Excel for many years on the trading floor, I have to say it's awful.
It does everything, badly. Which is why it's popular. People can get by without properly thinking things through, just jamming a few formulas on a spreadsheet, and patching the calculation when something comes up. You're never forced to think rigorously.
You can use it as a crappy database. Or a crappy UI. Or a crappy place to call external DLLs from. It's the perfect tool for that guy who "has a great idea, but just needs it coded up".
If a guy comes to you with an Excel question, he wants you to help him. Contrast this with a range of other technologies. If a guy comes to you with a question about c++, you tend to be helping each other. Same can be said for any number of things that non-techies would not think to ask. When was the last time someone asked you about Haskell or Erlang where you were treated merely as a means to someone else's end?
- bachmeier 8y ago> Having used Excel for many years on the trading floor, I have to say it's awful. But the interface is not awful - it's absolutely wonderful as a quick way to enter and share data and do a fast analysis. The part that's awful is when you do more than that. And once you've got the data into Excel, why go through the trouble of changing to something else just to do one additional thing, even if that additional thing is complex?
- lordnacho 8y agoAs technological scrap paper, I admit it can be useful. But as soon as your "fast analysis" is done, you need to be hardening whatever process it is you are creating. After all, that is what your analysis is about, right? Building some sort of repeatable, often auditable, transparent process.
- bachmeier 8y agoI'm certainly not arguing in favor of Excel. I only open spreadsheets when I have no other choice, but I understand why others use them.
- intended 8y agoBut that’s a great job done. You’ve described both - the ethos of hacker news from back in the day, and the point of excel with that original sentence. Just Get stuff done. Your boss will worry about an auditable process after the prototype shows merit. Nothing in the world is feee/without trade offs. Any excel like program will have excel like problems. The alternative being a world fragmented between different spreadsheet programs and no interop.
- Mister_Snuggles 8y ago> It does everything, badly. Yes, it does do everything[0] badly. [0] https://www.youtube.com/watch?v=bkQJdaGGVM8 https://www.youtube.com/watch?v=bkQJdaGGVM8
- another-cuppa 8y agoI've concluded that Excel is never the best tool for any job whatsoever. I actually think it's incredibly harmful.