On: An oral history of Bank Python

[jetbooster]

And I think here-in lies the trap of excel.

You've built this brilliant report because you're an excel wiz, but because of that you've gotten someone up the chain's attention and you need to do it every day/multiple times per day, and automating out all your shortcuts, hotkey and ui clicks with macros becomes a horrifying cludge that had you invested in something more automation oriented earlier would produce more resilient/repeatable solutions.

[alexilliamson → jetbooster]

If you're an excel wiz, you build it once and when you need to update, you drop in new data and everything magically is updated.