HDR Photography in Microsoft Excel (2017) [video]
youtube.com
youtube.com
At National Supercomputing Center For Energy and the Environment we retrofitted all the PowerPoints to use timed animations. Now all computations execute in constant time. There is no need to click! As a special bonus, the code is no longer susceptible to side-channel timing attacks.
Solitaire does one thing and it does it quite well.
Less snarkily, Excel is so capable that lots of office workers learn IT and never bother going any deeper, and so they do things like re-inventing relational databases using Excel, etc.
Often none, and that's the bigger problem; those aren't vehicles that are good for storing business knowledge, so the business knowledge that went into them is often either stuck in someone's head (who may have left long ago) or lost entirely.
An (possibly entirely correct in context, possibly not) application of that knowledge in a particular context is captured in the macro or formula, but the knowledge itself, including the factors from the context contributing to the particular application, is not captured.
And this whole malady is especially common in finance departments, which are (typically) horribly documented anyway. It's all institutional knowledge, and those in that area tend to be long-term employees who don't know the difference between "things that are part of accounting and finance everywhere" and "things that are idiosyncratic to Acme Corp."
I'm also reminded of a guy I knew in college. He would LOVE this, because when we were working together at a university computer lab, he was the guy who would learn a tool, and then use that tool to the exclusion of all else, even to the point of absurdity.
The only tool he really knew when he started working there was Lotus, and he ended up figuring out how to automate all sorts of network administration tasks in Lotus macros.
https://www.gamasutra.com/view/feature/131968/microsoft_exce...
Powershell = Powexcel = Powered by Excel
Yes perfect