this post was submitted on 01 Apr 2024
230 points (95.6% liked)

Technology

59300 readers
4927 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
230
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
[โ€“] jkrtn@lemmy.ml 4 points 7 months ago (1 children)

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.

[โ€“] Olap@lemmy.world 5 points 7 months ago

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