Obligatory Krazam sketch: https://youtu.be/xubbVvKbUfY?si=h6QR2gzac48R6kca
There is little difference between (if (> a b) c d) and =IF((A1 > B1), C1, D1)
Excel is the most widely installed functional programming language IDE.
programming languages aren't allowed to be in non-english somehow?
I enjoy the idea, and love watching it grow.
When I was in the air force we had a complete aircraft maintenance planning and performance management system entirely in Excel. It can connect to remote workbooks on a shared drive/SharePoint too, so the higher headquarters would tie into our dashboard for their own operational readiness tracking.
It was a total shit show of undocumented pseudo APIs with zero change management or version control but it worked somehow.
It’s gone quite far now - one of the many challenges was a mock terrain map where you’d calculate distances to hike while considering the weight of your pack. Even the way they walk through the tunnel is done for show.
The only thing I still enjoy is that any data smaller than 1M rows is sliced and diced almost without thinking. I am sometimes really grateful that MS did not break the shortcuts, while almost breaking the product overall. The muscle memory works perfectly.
Edit: Of course, they changed the title! [1]
jjmarr•1h ago
lysace•59m ago