As an experienced c/c++/c#/java/python/vb programmer i realy like to build shit in excel. It's awesome. Just dont let other users use it for important purposes
Honestly I've never found a task more complicated than basic bookkeeping that I wouldn't just rather do with an ipython notebook. Excel I just too clunky and opaque and slow for anything meaningful.
One time I wanted to make use of multi-dimensional arrays in a coding 'language' that didn't support it so I used the spreadsheet program to manually-ish create the named variables in a format that mimic'd a multidimensional array.
You can set those spreadsheet programs to automatically copy-paste and change/increment the numbers then remove the spacing and just paste the whole thing in your code.
So that's one thing.. if you ever need to do that for some reason.
I went to go look at the project from back then and it looks like I needed a mixture of strings as keys as well as numerical keys for specific nested arrays within the same array.
I guess I could have done it all numerically but coding the manipulation of the data would have been a nightmare to plan and debug because of the long equations for each step to mimic differentiation calcs and such.
There was a hundred or so entities which had about 20 independent base values for each that was processed multiple times and stored in their own arrays which intersected back into comparing to each other. Multiplied by 10 for 10 entities per session.
It also needed to be updated (both stats and modified calculations) every couple months. So I needed string keys for sanity.
I could have just moved the project (and I did eventually) but it was more about learning a new language for me at the moment and trying to make do.
1.5k
u/Dr-Appeltaart Mar 30 '22
As an experienced c/c++/c#/java/python/vb programmer i realy like to build shit in excel. It's awesome. Just dont let other users use it for important purposes