233
this post was submitted on 01 Apr 2024
233 points (95.7% liked)
Technology
59605 readers
3435 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
This doesn't sound like an Excel problem it sounds like a management/software upkeep/bus factor problem.
I'm going to be the odd man out and say that Excel isn't even that bad: I use it a lot for RPG simulations and engineering simulations, and not just because CSV is normalized. It can be part of the tech stack, but not in a mission critical way. There's really no tool like it especially if you are doing simulations.
100%, excel is great for spreadsheets and garbage as a database, yet so many people keep using it as a database. I'm currently pushing for my department to transition their many "excel databases" to proper databases and I'm getting mass surprised Pikachu face because no one else knows they're not the same.
If you're working with csv data, https://www.visidata.org/ >>>>> excel (assuming you're comfortable with terminal UIs, anyway). You can very rapidly slice and dice data and for formulas and such, you can just write Python.