For your use case, what if you could use Python in Excel with pandas, numpy and the Anaconda ecosystem readily available? How would that change things?
Disclosure: I was a founding member of the Python in Excel team and am looking for new problems that Python in Excel could solve.