[rawbot]

> Excel is the best spreadsheet software in my experience when you have to move beyond the basics. I’ve even tried hard to use the open/Libre alternatives.

I agree 100% with this, since I've been trying the same. Although I do think some power-users take it way too far and should be using more robust data analysis tools (Python, DBs) instead of having these monstrous Excel spreadsheets with millions of rows and columns.

[wvenable]

> power-users take it way too far and should be using more robust data analysis tools (Python, DBs)

But they they wouldn't be power-users anymore, they'd be developers. It's just an entirely different world.

[tcfhgj]

excel power users are developers

[reactordev]

When all you know is Hammer...

I agree and you'd be surprised at the response when I showed some of them how to do it in python numpy.

[acidburnNSA]

I tried showing a finance guy a Python version of a levelized cost of electricity spreadsheet he made. He laughed in my face and continued using Excel to drive executive decisions.

[esafak]

Dinosaurs gonna dinosaur. Teach his kids about the virtues of source control and testability, and the problem will be resolved in the next generation.

[eviks]

How are you going to get access to his kids?

[esafak]

Schools, Youtube, etc.