What's the worst thing you've seen Excel used for?
-
I admire your faith in the goodness of people. No, it went in the other direction: editing VBASIC in the developer options and all the horrors that brings. Obviously, that's too easy to break. So it was locked down. So, of course, people started making copies so they could make it do the things they wanted that it wasn't supposed to do. It seemed like by the end, each person probably had their own, slightly different copy with degrees of functionality depending on their Excel skills. Not a great environment for making a baseline and a critical path. Do not recommend.
-
Company schedule entirely written in Google Sheets. When I originally took the position over, the owner wouldn’t settle for an alternative solution.
The previous IT person worked there previously for about 10 years and had been compulsively adding features with AppScript the entire time. It was auto sending emails, handling inventory, maintaining project files, you name it. I briefly looked at how it worked and there were easily a dozen script files, a few of which were thousands of lines.
I was able to replicate most of the important parts of the system that he wanted to replicate in about two weeks in between other work with one script file and something like 50 lines.
I eventually left for reasons unrelated to the place and only ever had to fix issues once every 6 months or so, which I consider pretty decent for an unattended Google Sheet shared by 5 users.
I’ve since returned and rebuilt the schedule a second time with a proper database and the whole thing run 10x smoother and more reliably.
-
Someone once commented about a regional ISP with a customer base about five figures in size. Did they use a database system to track customer billing? Nope. All the customers and their billing info are on one spreadsheet. Billing customers means manually crawling through the spreadsheet and typing up the bill.
-
is this a UK isp?
-
Oh lord, it's hilarious that when I searched 'Gantt Chart' to learn what it was, the second or third link was to excel templates for it.
-
A Google Sheet used as a password manager that every employee had access to. To keep it “secure” the cells with the passwords were hidden by changing the background color to match the text color.
-
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.
