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.
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
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.
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
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.
The Peter principle says otherwise, but analysts are a factor for sure.
I’ve witnessed the dilbert principle more
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.
So Excel=cockroach?
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
You could use a database, and SQL. Or is that crazy talk?
Yes. Your boss needs to be able to double click on an email attachment otherwise it’s like you never even did anything.
Naw other F1 teams just pay for custom data management software.
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
Do they meet f1 demands?
If the alternative is a spreadsheet that gets updated manually, literally anything would be an improvement.
Markdown file on a shared windows drive enters the chat
But in a language like Python there are established patterns for dealing with complexity unlike Excel lol
How do the handle version control? I’m yet to actually meet it in the wild
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.
Python in excel is in git?? Better than I thought
They should have used an Access database
Replacing a working excel “solution” with access is like replacing an old rickety hammer with a bigger old rickety hammer.
That cannot be true, Access is an enterprise class solution that can handle any workload and the performance is out of this world
Access is an enterprise class solution
Don’t mix it up with Acetone
Huffing is bad for your health
Pretty sure every professional CAD software has interfaces for external parts, which can then trigger an analysis in accounting for parts not on storage.
I use Minecraft developed in-game built computers for all my parts inventory needs
clear example of why people should only work on their “single” proficiency. Excel? really?
excel 4 lyfe
