But there are the obvious problems, as formulas get inscrutable and you really want some more powerful data types.
So I’ve been playing with the new Excel features - lambdas and the new kind of array formulas. And they’re kind of great! I ported some non-trivial analysis algorithms from numpy to excel and it makes for a highly shareable and havkable programming environment for non-coders.
There’s all sorts of crazy excel warts (I’m doing maths with complex numbers, and the handling of those is a true “WAT”)
It’s kind of almost-great. I can’t put my finger on it but I feel like it’s close to a really winning programming environment for certain kinds of algorithms-transforming-data programs. I think Excel probably has too much baggage to get there, but these experiments are still really interesting.