Howdy all!
I've got a problem that requires tweaking one input then running a pile of iterations between tweaks to the input. Basically a goal seek with ten or twenty thousand iterations per cycle....imagine sitting a through a whole tv episode with your finger on f9
Check if the converging value is headed in the write direction, tweak the input a bit more and repeat.
I'm imagining a VBA script to shut off screen updates, fire off the 20k interactions, or perhaps until the running average of the last hundred values flatlines close enough to a particular value, see if that value is too high or low, adjust the input appropriately and repeat
Anyway, it's been a while since I've done a deep dive on anything or written VBA so I though I'd ask for some help to get started with a version of Excel that about 15yrs newer than the last time I had to do something a little challenging.
I've got a problem that requires tweaking one input then running a pile of iterations between tweaks to the input. Basically a goal seek with ten or twenty thousand iterations per cycle....imagine sitting a through a whole tv episode with your finger on f9

Check if the converging value is headed in the write direction, tweak the input a bit more and repeat.
I'm imagining a VBA script to shut off screen updates, fire off the 20k interactions, or perhaps until the running average of the last hundred values flatlines close enough to a particular value, see if that value is too high or low, adjust the input appropriately and repeat
Anyway, it's been a while since I've done a deep dive on anything or written VBA so I though I'd ask for some help to get started with a version of Excel that about 15yrs newer than the last time I had to do something a little challenging.