5 ms·
My 4th order Runge-Kutta ODE solver I did in an afternoon in Excel the other day, because I didn't want to pirate Matlab to do a homework assignment, begs to di
by TeMPOraL 6y ago
My 4th order Runge-Kutta ODE solver I did in an afternoon in Excel the other day, because I didn't want to pirate Matlab to do a homework assignment, begs to differ :). Not to mention, the entire financial industry and many (most?) small businesses.
Lots of people use Excel for various types of math, and it works fine, if you know what you're doing. Excel not being idiot-proof doesn't mean it's not usable.
And that's all without writing a single line of VBA.
(We can have a separate discussion about some of the newer Excel features, like automatically suggesting what kind of statistical analyses to perform on your data - I consider this to be a potential future source of serious fuckups, as it allows people to easily transform data using methods, whose assumptions and implications they do not understand.)
> "looks fine" until it shows a result someone doesn't want, and then an error is found that changes results and the cycle repeats
That's a feature, though. Excel is interactive, which means you get ample opportunity to do sanity checks on results (both partial and final) as you work on your sheet, as well as immediate feedback on corrections. In "properly written" IT systems, this is rarely the case - you end up discovering a problem further down the chain, and have to figure out which component did something wrong, and why.
- lordnacho 6y ago> Not to mention, the entire financial industry That IS the dumpster fire. Trust me, the reason I know is that I used to be that guy who thought Excel was a great tool. I built derivatives spreadsheets, backoffice spreadsheets, trading systems with realtime data, all sorts of crap in Excel. Really, it's Stockholm Syndrome. People who previously had zero computing power at their disposal think they've found the hammer that solves all problems when they're introduced to Excel, because now they can calculate lots of numbers. They just get blinded by the revelation that they can now calculate "anything" and are happy to pay whatever the cost is in terms of future maintenance, ease of understanding, etc. > Excel not being idiot-proof doesn't mean it's not usable. This is absolutely true, I'd be able to do much better with Excel now than earlier. The problem is Dunning Krueger. There are too many people who think they can code once they're able to get a bit of Excel going, and they don't know that they can't. Not trying to be condescending, I've been there myself. It's just that you get a lot of "coding is a thing I have to do in order to get to some target", and so people think that once they've finally bashed out their spreadsheet, they've figured it all out.
- TeMPOraL 6y agoYou bring up some very good points. But to those, I have a question: what is the alternative? Both now (for UK healthcare), and in general? The "people who previously had zero computing power at their disposal" may be wrong in thinking "they've found the hammer that solves all problems" - but there's literally no other hammer available for them. They're not programmers, they won't write their own software (nor would they be allowed to). Any other option involves so much organizational overhead - both initial and ongoing - that it's a non-starter. I agree that people routinely use Excel way beyond their own skills. But I haven't heard of any viable alternative.
- _AzMoo 6y agoThe alternative is to pay professionals to do it for them.
- lordnacho 6y agoGrovel to Google or MSFT or whatever big name tech firm to borrow their coders. They already have the infrastructure. They have loads of coders sitting at home, not completely utilized. (Dunno how true it is, but a lot of people here comment that.) They've already written programs to do something similar. They're well aware of side issues like data protection, security, cross-platform, etc. They could use the goodwill. Wasn't Google already involved somewhere? Surely they can figure out how to count some tests as well. I suppose if you're clueless you'll think Accenture or Capita are the same as Google, so yeah maybe we are screwed.
- ekianjo 6y agoThe alternative is to stop using your house wrench to fix the pipes and call a real plumber.
- dmitryminkovsky 6y agoExcel is an excellent hammer. A spreadsheet is a system to develop pure functional graphs and to interact with them in real time. I spent lots of time on finance spreadsheets myself and also thought it was Stockholm syndrome, but when I transitioned to working on software I came to see exactly why spreadsheets are entrenched the way they are, enjoy seeing them used creatively, and would never wish bespoke software on finance people. And good for them, they seem to know better, themselves!
- sudosysgen 6y agoIf you don't already know, Octave is a very good free and open source Matlab compatible interpreter and solution. Was of great use in my time in college.
- TeMPOraL 6y agoBack in the day, it wasn't "very good", at least not in terms of getting it to work. That RK4 in Excel happened because I got extremely annoyed at Octave.
- sudosysgen 6y agoWere you on Windows? Octave really, truly shines as a command line tool on a Unix OS. The GUI is ok on Linux tho.
- konjin 6y agoPeering into my crystal ball: You were between 16 and 22, you were 'great with computers', you had never used an OS other than Windows. There is a difference between a calculator and a type writer and there is a difference between an office os and one for programming. Using Windows and blaming Octave for Windows sucking is a rite of passage for everyone in a BSc program. I hope you got better and switched to a Unix.
- TeMPOraL 6y agoHoly shit, how much does it cost to rent out your crystal ball for a few hours? Because you got it 80% right. I was 19 or 20 back then, and Windows was my main OS - though I did have some experience with Linux as well (running several distributions for desktop use, as well as working with Cygwin and SFU on Windows), and I was a relatively proficient C++ programmer, having spent ~6 years of pretty much all my after-school time coding game engines. So it's not that I couldn't make it work - I eventually did. But it was so rough around the edges that I gave up in frustration twice. And yeah, these days, Linux is my daily driver (well, technically Emacs - Linux distros are just various flavors of Emacs bootloaders for me).
- konjin 6y agoHaving worked in the financial industry, my first job was writing a system to cover for a $10m fuck up in excel where yahoo exchange rates stopped updating and the same spreadsheet was used for a few weeks until someone noticed "Shit, we're losing a lot of money here.". Excel is the right solution in the same way playdoh is a valid building material.
- syshum 6y ago>>Excel is the right solution in the same way playdoh is a valid building material. I sooo badly want that on a T-Shirt.....
- icedchai 6y agoSeems seems there were at least a couple of problems here. Why were financial professionals using Yahoo as a source of exchange rates?
- konjin 6y agoBecause excel couldn't authenticate into our internal server and it was good enough.
- sokoloff 6y agoWas it good enough? I would argue that if it enabled your firm to make $12M before being the proximate cause of losing $10M, and the alternative was "we don't win $12M nor lose $10M because we can't afford the project" then I agree it was good enough.
- konjin 6y agoNo, which is why I was hired to replace it.
- icedchai 6y agoOkay, so you write a script to take the data from your internal server and post it somewhere that Excel can access. You don't use Yahoo.
- dmitryminkovsky 6y agoI really agree with this. Excel/spreadsheets are great and should be used whenever possible instead of some bespoke solution that will always be worse unless millions and millions of dollars are sunk into it, and even then, will probably be worse, given the state of software development in 2020. Like all tools, you have to know how to use Excel. If this is the only error that’s come up, well, so many other problems would have come up with a bespoke solution that Excel is still miles ahead in my book