Quote:
Originally Posted by ChrisV
This is a contender for "most frightening thing on dailywtf" for sure, but I think that title still belongs to The Hotel (reservation system) From Hell, which I think I've shared here before. Part 1, Part 2. God, just opening the articles is giving me weird flasbacks.
This actually isn't all too uncommon with Excel. At a prior job, we had an Excel guru who would write equations that would make your eyes bleed. One went sort of like this, to the best of my recollection:
page one:
long ass equation on c, references b.
page 2:
long ass equation on e, references b, references the result of b on page one, if it has a result, else reference b on page one, handle error, do some other auto-fill instead.
page 3:
well, you get the point, these would often go on for five pages.
Did I mention that he never once saved the results, despite each page 1 being entirely different and critical to the job?
I eventually pulled him aside and had a long talk about using VBA because using equations with 15 nested if's and errors, spanning 400 characters on each page was getting a bit out of hand.
He did some pretty interesting things with VBA after considerable practice. The bummer of using Excel was that our computers weren't strong enough to really do much outside of vanilla stuff. A saved macro-enabled book was bound to be corrupted in a few months.