I have a complex excel model with which I would like to run many iterations on. I am interested in the compile and dispatch pipe functionality but I can't see how to return and record the results using a loop to change the input cell each time.
In addition, it takes a long time (and a lot of memory) to load my model even from a .json file, is there any way to speed this up? Can I save a compiled model somehow and use that without having to load the model from the .json each time?
Hello,
I have a complex excel model with which I would like to run many iterations on. I am interested in the compile and dispatch pipe functionality but I can't see how to return and record the results using a loop to change the input cell each time.
In addition, it takes a long time (and a lot of memory) to load my model even from a .json file, is there any way to speed this up? Can I save a compiled model somehow and use that without having to load the model from the .json each time?
Any help appreciated, Thanks.