And that's including the people this morning who are apparently excited for LLMs to file their taxes.
'oh you do x? You don't do y? You're an idiot'
That's not productive.
But you are correct, this entire site is full of idiots confidently spouting nonsense... :-)
"Floating-point arithmetic may give inaccurate results in Excel" - https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...
"Classification of Spreadsheet Errors" - https://arxiv.org/pdf/0805.4224
"A study conducted by Coopers & Lybrand found errors in 90% of the spreadsheets audited."
"Impact of Errors in Operational Spreadsheets" - https://arxiv.org/abs/0801.0715
"What We Don’t Know About Spreadsheet Errors Today" - https://arxiv.org/pdf/1602.02601
You could think 500 random internet articles - it doesn't matter. The assertion is still ridiculous. You literally will not be able to get a job as an accountant without being able to use Excel. Don't be an idiot.
You can also link to hundreds of articles showing that dynamic types cause errors. People don't care, they still use them when it makes sense to use them. There is no better mainstream alternative for accounting than Excel right now, period.
I think we agree...this site is indeed full of idiots confidently spouting nonsense. :-)
I'm not arguing about whether or not Excel is perfect, or if it causes problems, or if it makes demons fly out of your nose. I am educating you about the real world and how it's important to understand that no matter how "well akshually" technically correct you are, it doesn't matter at all if the advice you're giving is WRONG and not useful to people.
So, I repeat. Idiots confidently spouting nonsense.
There's a big difference between geeks and hippies. Too many of the former here and not enough of the latter here - people who can understand other people, culture etc and then think about how technology can fit into ones life.
> "Floating-point arithmetic may give inaccurate results in Excel"
Well.. yes? That's what floating point numbers do.
https://stackoverflow.com/questions/40168077/floating-point-...
So what?
> "Classification of Spreadsheet Errors"
It's a taxonomy of the types of bugs spreadsheets have.
There are these for most other programming languages too.
etc, etc
Look, my first job was translating an Excel spreadsheet into an actual application and we found errors all the time.
Once Excel spreadsheets get too complicated they tend to fall apart. This is very well known by people who use it heavily.
It doesn't mean that it is useless.
Too right - this goes for the arrogant geeks at the within the orgs of LLM producers who still havent displaced call center workers with their technology.
Comical stuff. Really is.
The lack of disconnect with what people actually do in jobs is absolutely breathtaking.
Some have shares in these AI companies and need to off-load them either on secondaries or IPO.
These are the clear incentives to show performative results to give the impression that you can replace accountants with AI without any of the risks involved.