logoalt Hacker News

theshrike79yesterday at 8:07 AM0 repliesview on HN

There are SO MANY Excel sheets someone automated a decade+ ago still used in essential parts of the government and big corporations.

Nobody knows how they work, very few have the skills or time to edit them or check them. People just use them for the convenience.

The magic sauce of Excel is that it's free an scriptable (programmable even). If you want a SaaS, you need to involve IT, Legal, your supervisors and it's a whole-ass thing of contracts and shit.

Excel? It's just there.

There are so many stories and anecdotes of people being in stupid data entry jobs, getting bored and finding out their whole job can be automated with a single smartly done Excel sheet. Then they press F9 once per day and do something else for the rest of the time =)

And just because, my main gripe about Excel: there are no unit tests or validators for it. There's no easy way to programmatically confirm that Cell C5 has the same formula as C875

If (when?) people start AI-coding the things they used to use Excel for, we might get some actual tests and validation to confirm what the code is supposed to actually happens.