this post was submitted on 01 Apr 2024
233 points (95.7% liked)

Technology

59605 readers
3501 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
L3s@lemmy.world
L3s@fry.gs
L4s@fry.gs
L4s@lemmy.world
enu@lemmy.world
233
How a Microsoft Excel Spreadsheet From Hell Slowed Williams' F1 Cars For Years (www.thedrive.com)
submitted 7 months ago by boem@lemmy.world to c/technology@lemmy.world
48 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] Aleric@lemmy.world 24 points 7 months ago (2 children)

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.

[–] KingThrillgore@lemmy.ml 8 points 7 months ago* (last edited 7 months ago) (1 children)

Well if you're trying to use Excel as a database, get them behind SQL Server or something. Hell, Access is a step up.

Using Excel outside of simulation proofs is not a wise business decision, because it means (going off my experience) institutional knowledge

[–] Aleric@lemmy.world 10 points 7 months ago

Indeed, I'm pushing for SQL but work in a field that sees Excel as a huge improvement over past practices. They're about one step removed from writing on toilet paper.

My original career was in a much more data intensive field, so I've become "that guy" regarding proper data storage and hygiene. Case in point: we sit directly next to IT. Every time we talk about data collection, I'll get up on my SQL soap box and one of the IT folks will let out a comical groan.

[–] expr@programming.dev 2 points 7 months ago

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.