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

Technology

75434 readers
2065 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 news or articles.
  3. Be excellent to each other!
  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, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
  9. Check for duplicates before posting, duplicates may be removed
  10. Accounts 7 days and younger will have their posts automatically removed.

Approved Bots


founded 2 years ago
MODERATORS
top 48 comments
sorted by: hot top controversial new old
[–] ladicius@lemmy.world 112 points 2 years ago (1 children)

Pretty sure someone or even several people had that problem pointed out for years - and the management didn't care for those "negativlings" and ignored the problem.

The rot starts at the top.

[–] IWantToFuckSpez@kbin.social 46 points 2 years ago* (last edited 2 years ago)

The team was just heavily under funded when it was still managed by the Williams family. There was no money to change anything. Former drivers that have visited the factory have all told that it felt like they had traveled back in time, everything is outdated at the Williams factory. They were stuck in a downward spiral. They couldn’t build a fast car to get into the points because of the outdated factory, which meant they didn’t get a lot of prize money and also couldn’t attract enough sponsorship money. Thus they didn’t have the money to improve the car for the next season. When the team was sold to an investor group they finally got enough funds to turn this sinking ship around.

[–] Olap@lemmy.world 62 points 2 years ago (5 children)

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

[–] Hackerman_uwu@lemmy.world 25 points 2 years ago* (last edited 2 years ago) (1 children)

SQL would like a little chat with you.

[–] Olap@lemmy.world 63 points 2 years ago (3 children)

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

[–] 0x0@programming.dev 16 points 2 years ago (2 children)

Because the tech-illiterate people who have authority only know "productivity" tools and couldn't care less about the opinions of the people who actually know what they're doing.

[–] Olap@lemmy.world 11 points 2 years ago (2 children)

Those at the top are often more tech literate than I give them credit for. I suspect it is actually those armies of analysts that are holding it back

[–] dogslayeggs@lemmy.world 4 points 2 years ago

Yeah, I have access to database tools to do my job, but I don't know how to use those tools so I use Excel to do shit it really isn't optimized to do.

I am 100% part of the problem when I create a spreadsheet with formulas cross correlating data from 41000 entries, 9000 entries, and 1200 entries.

[–] 0x0@programming.dev 4 points 2 years ago (1 children)

The Peter principle says otherwise, but analysts are a factor for sure.

[–] Olap@lemmy.world 2 points 2 years ago

I've witnessed the dilbert principle more

[–] dogslayeggs@lemmy.world 5 points 2 years ago

I disagree. It's way more that they aren't hiring the right people to do the job. I've been asked to do some analysis, but the only tool I know how to use is Excel so that's what I use to answer the mail. If I had access to a database person to help me build a better tool I'd be happy to not use Excel. But I don't so I do what I can to do my job.

[–] jkrtn@lemmy.ml 4 points 2 years 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 2 years 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

[–] woelkchen@lemmy.world 4 points 2 years ago (1 children)
[–] Olap@lemmy.world 7 points 2 years ago

I suspect slightly more useful than a cockroach. Believe it or not, it's actually good at what it does. That's why it's still here. And also why I'm in a job, as there are plenty of things it shouldn't be doing too

[–] jaybone@lemmy.world 12 points 2 years ago (1 children)

You could use a database, and SQL. Or is that crazy talk?

[–] herrvogel@lemmy.world 3 points 2 years ago

Yes. Your boss needs to be able to double click on an email attachment otherwise it's like you never even did anything.

[–] CptEnder@lemmy.world 12 points 2 years ago (1 children)

Naw other F1 teams just pay for custom data management software.

[–] Olap@lemmy.world 12 points 2 years ago (1 children)

Supply chain management software exists. Do they meet f1 demands? Doubtful, but this is why you partner with a software company. They add more, you pay less, and give them some good sponsorship

[–] themeatbridge@lemmy.world 2 points 2 years ago (1 children)

Do they meet f1 demands?

If the alternative is a spreadsheet that gets updated manually, literally anything would be an improvement.

[–] Olap@lemmy.world 2 points 2 years ago

Markdown file on a shared windows drive enters the chat

[–] RagingRobot@lemmy.world 3 points 2 years ago (1 children)

But in a language like Python there are established patterns for dealing with complexity unlike Excel lol

[–] Olap@lemmy.world 1 points 2 years ago (1 children)

How do the handle version control? I'm yet to actually meet it in the wild

[–] RagingRobot@lemmy.world 3 points 2 years ago (1 children)

Version control for any kind of code can be done with git if that's what you are asking. There are other systems available too but that's the standard for most things now.

[–] Olap@lemmy.world 1 points 2 years ago

Python in excel is in git?? Better than I thought

[–] Miaou@jlai.lu 1 points 2 years ago (1 children)

Did you even read the article?

[–] Olap@lemmy.world 7 points 2 years ago (2 children)

Yup. And extra extra, excel can be beaten for specific examples with lots of extra tooling. But you know what that tooling will also do? Generate excel reports

[–] daddy32@lemmy.world 6 points 2 years ago (1 children)

hmm generating static excel reports doesn't sound bad, as long as these are used just as output format - basically a familiar GUI.

[–] Olap@lemmy.world 2 points 2 years ago

Yeah, it is a good data dense gui, and is ubiquitous. But now it does python too! What a dreadful decision that was

[–] Bonehead@kbin.social 5 points 2 years ago

Generating a report using Excel as a format is a lot different from using Excel as a database.

[–] KingThrillgore@lemmy.ml 39 points 2 years ago* (last edited 2 years ago) (1 children)

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.

[–] Aleric@lemmy.world 24 points 2 years 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 2 years ago* (last edited 2 years 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 2 years 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 2 years 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.

[–] tedu@azorius.net 14 points 2 years ago (1 children)

Was this article sponsored by Oracle?

[–] jqubed@lemmy.world 1 points 2 years ago (1 children)

Oracle sponsors enough sports like this, the least they can do is offer a discounted/free ERP and then turn it around for their marketing use cases

[–] KingThrillgore@lemmy.ml 3 points 2 years ago (1 children)

Free and Oracle? What is today, April Fools Day?

[–] jqubed@lemmy.world 1 points 2 years ago

Oh, just for the teams they sponsor. Don’t worry, it still needs to benefit them.

[–] MonkderDritte@feddit.de 12 points 2 years ago

Pretty sure every professional CAD software has interfaces for external parts, which can then trigger an analysis in accounting for parts not on storage.

[–] JoMomma@lemm.ee 11 points 2 years ago (1 children)

They should have used an Access database

[–] NeoNachtwaechter@lemmy.world 30 points 2 years ago (1 children)

Replacing a working excel "solution" with access is like replacing an old rickety hammer with a bigger old rickety hammer.

[–] JoMomma@lemm.ee -2 points 2 years ago (1 children)

That cannot be true, Access is an enterprise class solution that can handle any workload and the performance is out of this world

[–] NeoNachtwaechter@lemmy.world 2 points 2 years ago (1 children)

Access is an enterprise class solution

Don't mix it up with Acetone

[–] JoMomma@lemm.ee 1 points 2 years ago

Huffing is bad for your health

[–] Tronn4@lemmy.world 10 points 2 years ago

I use Minecraft developed in-game built computers for all my parts inventory needs

[–] rachthegoldberg@lemmy.world 2 points 2 years ago

excel 4 lyfe

[–] ggnoredo@lemm.ee 2 points 2 years ago* (last edited 2 years ago)

clear example of why people should only work on their "single" proficiency. Excel? really?