News for hackers. Stuff that matters.
Re:Ask HN: Do you feel Excel is dangerously overused? by viraptor on Monday May 11, 2015 @10:19AM (#9524911)
Oooh! Horror story time. There's a power plant which used an excel spreadsheet connected to SQL server stored procedures (live connect? active connect? can't remember) to calculate and show cooling conditions and active states of the generators. With lots of macros written by a teenager who didn't even understand the SQL part properly at the time. (don't judge me, they paid and I had no idea how bad that project was...)

Fortunately, if I remember correctly it was just read-only for monitoring. If it wasn't, I'm sorry... so so sorry.

Re:Ask HN: Do you feel Excel is dangerously overused? by crdb on Monday May 11, 2015 @10:27AM (#9524970)
Wait... a POWER PLANT?!

I undertand relying on piles of crappy Excel models built by underpaid, skill-lacking interns in cash-strapped e-commerce companies where investors don't really care about the real profit margin, but... I mean, we're talking about millions of dollars of hardware and human lives here...

Re:Ask HN: Do you feel Excel is dangerously overused? by viraptor on Monday May 11, 2015 @11:05AM (#9525287)
Yup. A power plant. It wasn't an official, approved project BTW. Just a "this would make our lives so much easier, you know excel, right?" kind of deal.

I'm more worried about IT culture which creates a need for such secret side projects really. That this existed and someone potentially made decisions based on that spreadsheet (no testing happened, I got the formulas and test data, but no results for comparison) is just a reflection of the priorities in that place.

Re:Ask HN: Do you feel Excel is dangerously overused? by crdb on Monday May 11, 2015 @12:00PM (#9525672)
Oh, that's always the case unfortunately. Doing things "properly" means you can't do them "tomorrow" or even better, "yesterday". It's funny to hear the same story everywhere - including on something as critical as a power plant, and including the "secret" part.

That several-hundred-person Excel nightmare? It had grown from "quick and dirty" shortcuts from middle managers, none of which were still around, none of which did the work (that's why you have unpaid interns), designed to bypass the official data warehouse project. They got promoted because they delivered the processes, and nobody checked the numbers (that's another "feature" of Excel shops - "if it looks like it works, it works").

The problem is that it's hard to sell "your numbers are off" to new clients. I toyed with the idea of making it conditional: "if your profit margin is more than 5% off, you pay us"...