Asklemmy

45180 readers

1659 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

Open-ended question
Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
!lemmy411@lemmy.ca: a community for finding communities

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago

MODERATORS

What's the worst thing you've seen Excel used for? (sh.itjust.works)

submitted 6 days ago by otp@sh.itjust.works to c/asklemmy@lemmy.ml

49 comments fedilink hide all child comments

(bonus points if it's being used for official business purposes)

you are viewing a single comment's thread
view the rest of the comments

[–] otacon239@lemmy.world 25 points 6 days ago

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.