232
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 01 Apr 2024
232 points (95.7% liked)
Technology
58810 readers
4625 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 1 year ago
MODERATORS
Pretty much all data heavy organisations use excel VERY heavily. And when nobody understands the model within them any more, they need retiring and are usually replaced with... Excel! This time with even more tabs and columns. To replace these things with computer models risks repeating the same problem the original sheet has: bus factors and complexities are hard, more so even in python/r than excel sadly. Maybe one day something will trump it, but that day is not today
SQL would like a little chat with you.
I do this for a living. I've spent basically my whole career (15 years full time professional at this stage) basically trying to kill excel. You can't, or at least I can't. You can add processes to it, you can programmatically read/write from it, but when it comes down to ditching it: every stakeholder is invested in excel. No other piece of office has the staying power that excel has, it will outlast us all
It's surely a nightmare for long term usage but is there a software that can beat the functional reactive sort of auto updates when using spreadsheets with a few thousand rows of data? I'd have to actually use my brain to do the same thing as a pivot table in an array programming language.
Any sort of actual database will let you do it. SQL based the obvious answer, but they are all way harder to use than they should be. SQLite never got anything as good as excel sadly, and parquet still lacks a decent windows client. The WYSIWYG of excel really is so intuitive, nothing I know matches it