Remix.run Logo
rawbot a day ago

> 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 13 hours ago | parent | next [-]

> 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 5 hours ago | parent [-]

excel power users are developers

reactordev 21 hours ago | parent | prev [-]

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 10 hours ago | parent [-]

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 9 hours ago | parent [-]

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 6 hours ago | parent [-]

How are you going to get access to his kids?