What's the worst thing you've seen Excel used for?
-
There's the guy who built a roller coaster . https://youtu.be/yYaLQ3LazYM
-
In two different companies I've seen people refer to "the database" when they actually mean a spreadsheet. That's not just a terminology mixup, these things were super complex, with pseudo-relational tables, lookups, links to other files etc. The sort of thing that should be in an actual database, that has less chance of breaking in obscure ways when someone inserts a row or types a value over a formula. It was actually pretty impressive, in an "impending doom at any moment" kind of way.
Also had one where there was a spreadsheet of everyone in the business top to bottom, shared by HR and IT. Both groups needed a list of staff, so why not just keep one, right? This thing had personal details like home address and medical conditions, plus things like salary (inc garnishments), performance management notes etc, as well as of course their username and password (which was assigned to them and they couldn't change) and security questions and answers. It didn't even have a password on the file. I noped tf out of that place as quickly as I could, but for reasons even worse than that stupid spreadsheet.
-
Holy crap
-
Sex tracker... So many empty sheets...
-
A CRM for a large client. A VERY large client.
-
Company-internal service where the users would write their desired configuration into an Excel file. Then they push that into a Git repo, which triggers a deployment of the service with the configuration read from all the Excel files.
-
OP asked for the worst thing you’ve seen Excel used for…
-
To send images for graphic design.
-
Ahem In my defense, the way I did it wasn't totally terrible. The dates are all gathered from other sheets, the chart is generated automatically with conditional formatting, and it's locked so there's no moving of cells or changing the colour manually. Don't hate me.
-
Let me blow your mind a bit more...
-
Not exactly what you’re looking for, but how about a flight simulator?
-
Lmao. I once had a senior dev put database passwords into documentation, and then was about to email those out to interview candidates with the passwords 'blacked' out. I caught it quick enough before it could be sent thankfully.
-
That sounds like watching people play Jenga with railroad ties.
-
Judgment is God's purview. I just arrange the meeting.
Honestly, if it worked well for you and all the other affected stakeholders, I think that's what matters most.
-
i was unfortunately responsible for this one...
we developed a wireless communication protocol which was specified in an excel sheet, and it fell on us devs to implement the message types specified in the sheet. however since the specification kept changing we had to constantly update the message types in our tests to make sure they conformed. so i said "fuck it" and built a program that allowed me to "import" an excel file in a python program, which exposed all messages as classes that could be instantiated with automatic unit conversions. just drop the excel file of the day in the right place and run the test suite.
anyway that's how the excel sheet became the formal API definition
-
https://www.bbc.com/news/technology-54423988
The tracing of Covid in the UK (specifically England) was collected in .xls files
-
I remember a story my dad told me about a guy at his work who didn't really know how to use Excel, and so had dragged the cell and column spacing out in order to have one huge cell, in which he typed all of his calculations - which he did manually with a calculator before typing them all longhand into his giant cell
-
Creative solution
-
Biologists love excel, and it makes sense why - the sheer convenience of copying and pasting across datapoints.
-
Creative solutions....
