But what about those of us in R1C1 mode using lambdas to do recursive cell operations across data pulled from multiple sheets? Am I anywhere near the kinda of Eldritch horrors discussed? I’ve also written indirect references based on Sheet name to populate filters from web scraped tables. I just don’t know how deep the pit goes at this point.
I will give it to you, when it works, it does some magical stuff. But try designing such complex things that are miracles in coding and then it have to run on a half-ass computer. I want to say terminal, it’s not that, but it’s those small fake computers that companies seem to think are better to get than an actual desktop because they’re cheap. I know that’s hardware, not Excel, but Excel does not run well on that, so…
Or worse, you get moved to 365 which doesn’t do most scripting and breaks all that was working. That cloud shit is a problem.
Oh yeah, the 365 version is terrible. And post of the time, it could have been a Python Gradio interface or similar simple implementation without having to fight so much to make basic things work. Most of what I want Excel to do it just isn’t efficient enough for; particularly with lets and lambdas, it’s gotten quite powerful as a programming paradigm where you can visualize and manipulate your data spatially in a kind of Logo / NetLogo style way which is really interesting, but the second you reference a few thousand cells a few times even a solid CPU starts screaming.
I use Excel for a decent number of tasks and can do some magic with it, but only ever really for work where it’s easier to share a weird Excel sheet than it is to pass around a Python script (which given I teach Python, isn’t actually as often as most people experience).
But what about those of us in R1C1 mode using lambdas to do recursive cell operations across data pulled from multiple sheets? Am I anywhere near the kinda of Eldritch horrors discussed? I’ve also written indirect references based on Sheet name to populate filters from web scraped tables. I just don’t know how deep the pit goes at this point.
I will give it to you, when it works, it does some magical stuff. But try designing such complex things that are miracles in coding and then it have to run on a half-ass computer. I want to say terminal, it’s not that, but it’s those small fake computers that companies seem to think are better to get than an actual desktop because they’re cheap. I know that’s hardware, not Excel, but Excel does not run well on that, so…
Or worse, you get moved to 365 which doesn’t do most scripting and breaks all that was working. That cloud shit is a problem.
Oh yeah, the 365 version is terrible. And post of the time, it could have been a Python Gradio interface or similar simple implementation without having to fight so much to make basic things work. Most of what I want Excel to do it just isn’t efficient enough for; particularly with lets and lambdas, it’s gotten quite powerful as a programming paradigm where you can visualize and manipulate your data spatially in a kind of Logo / NetLogo style way which is really interesting, but the second you reference a few thousand cells a few times even a solid CPU starts screaming.
I use Excel for a decent number of tasks and can do some magic with it, but only ever really for work where it’s easier to share a weird Excel sheet than it is to pass around a Python script (which given I teach Python, isn’t actually as often as most people experience).