It's about time all those math types learned to relax a bit. These numbers in these spreadsheets don't need to be exact all the time. It's really more about the overall flavor of the spreadsheet than how "right" any individual field is. Error bars are there for a reason people!
post
Excel is the fucking backbone of Microsoft Office. It's solid and backwards compatible for a couple of decades. Excel is the one reason business sticks with Office. It never fails, everyone knows it, nothing can replace it. You cannot trust any other spreadsheet to perfectly translate if you move away from Excel. The world runs on Excel.
I never imagined Microsoft would fuck with Excel. Ever. There's a fairy tale about killing the golden goose, can't remember how it goes.
Just look what they're doing with their Xbox brand. One of the most well established brands in the most profitable entertainment sector and they are literally setting fire to it in every conceivable direction.
Microsoft must be taking business cues from GRRM... Kill all your main characters.
Forget Xbox, look at how they're treating Windows lately. Loaded with ads and bloat, forced hardware upgrades with Win11, forced MS account sign-in with no option for local accounts unless you're running one of the Enterprise/IoT SKUs....
You can operate without a local account - source, I‘m on Windows 11 and I‘ve never had a Microsoft account - but it‘s a massive PITA and takes a lot of playing around and disconnecting from the internet during install, and stuff like that.
You‘re right that 99% of people won‘t know/won‘t bother to go through the hassle and that Microsoft through the years have been making it harder and harder to have a local account, but at the moment it‘s still technically possible.
I'm on Win11 and see almost none of the issues people like you are talking about. No doubt they exist! Maybe it's because I'm on a plain vanilla ISO and I stripped the crap out early on? Same SSD I had 4 computers ago on Win10, just get moving it over. Talk like yours makes me afraid of a fresh install!
If it's as bad as people say, I'll give up and go Debian. I was largely staying Windows so I could be familiar and support my coworkers. Unemployed now. Who cares?
They've since relaxed a bit on the forced hardware upgrade part; you can install Win11 on 'unsupported' hardware now, you'll just have click a prompt saying you'll get no support and you're on your own if you attempt that, where initially it wouldn't even let you do that.
The forced MS account login is very much an issue with the consumer SKUs and the Enterprise/IoT SKUs still let you use a local account. Similarly, LTSC in particular is barren on the bloat front, while the consumer SKUs and even the non-LTSC Enterprise and IoT SKUs aren't much better in this regard, come loaded with bloat.
yep. it's the one tool that is incredibly versatile in the workplace and for which I do not have a replacement
are there better tools? quite often. would those tools be able to be used by anybody opening the files you are sharing with them? nope. and keeping things in the same format means it's very easy to move data across files and link things up.
forms, trackers, calculations, data logging, all easy to reference/transfer to one another and I can expect anybody on my team to be able to work with files I send them without having to teach them how to use a different program
Some computer scientists really went "we made a computer that is programmed in a different way and is sometimes correct" and these idiot corpos went "wow put it in everything"
Trillions of dollars to develop a calculator that's wrong sometimes.
I mean, most calculators are wrong quite often
I've never seen a calculator being wrong, and I'm genuinely curious what you're talking about.
Only when people use the wrong input, garbage in and garbage out.
In the same vein I can't think of any instance where excel had calculated things wrong unless there was a fault in the formula that I made.
That’s funny because I grew up with math teachers constantly telling us that we shouldn’t trust them.
Normal calculators that don’t have arbitrary precision have all the same problems you get when you use floating point types in a programming language. E.g. 0.1+0.2==0.3 evaluates to false in many languages. Or how adding very small numbers to very large numbers might result in the larger number as is.
If you’ve only used CAS calculators or similar you might not have seen these too since those often do arbitrary precision arithmetics, but the vast majority of calculators is not like that. They might have more precision than a 32 bit float though.
No, the user is wrong quite often, the calculator gives the answer to the question asked, not the answer to the question the user wanted to ask.
Garbage in, garbage out.
0% of the time it works because I shut that shit off the first minute I saw it
Excel is such an incredible piece of shit. There's many reasons to hate it for me, but what i hate the most is not being able to do relationships in any meaningful way. So often i need to have one to many relationships and this garbage makes it impossible. Data consistency? Nope. Opening a csv? Fuck you! Why the fuck are there online tools that are better at this shit? You had 40 years ffs. No amount of AI is going to fix this turd. God I hate Excel.
There's a ton of reasons to hate Excel, I'm sure, but I don't think lack of support for relational data is a reasonable one. There's tools for that job, but Excel isn't trying to be one of them.
I get that. But it's a case that's just so incredibly common. Tagging/categorization. We end up with multiple columns like 'cat 1', 'cat 2', etc. Or doing pivot tables. I guess to me there's pretty much always something that can do the job better, but the reality is that in the corporate setting I operate in everybody uses Excel.
You are trying to use Excel like a database and that’s not its job. Use Access for that, if you must stick within the Office ecosystem
If I'm the only one doing it then I'd prefer to stick with sqlite. But the reality is that everyone I work with does these kinds of things in excel, and it's a shitshow. Yes, u could say 'don't blame the tool', but it's ms shoving it down our throats and they could've done much better with the time they had.
With power query, Excel can perform more database-like functions, I use it all the time! It comes with it's own quirks however
Everyone else who's anti-AI:
- What is that smell? It smells like a used diaper filled with Indian food!
- What is that?! It smells like a turd covered in burnt hair!
- It smells like Bigfoot's dick!
- What is that stench?! It smells like the inside of a fake leg!
Did he just spend the first half of the article explaining why 'copilot in excel' (not agent mode) wasn't designed for calculation tasks, them finishes with complaining that on benchmarks it fails 80% of the time?
The 54% accuracy of agent mode should be called out, not the low accuracy of the thing that wasn't designed for it.
all 48 comments