Thread:QuickNick/@comment-26829117-20170726202536/@comment-30967537-20170730215824

Hi Dave.

I kind of got interested in this again!

Rather than having to repeatedly open the "Advanced" editor, change the calculation factors, save and then close the editor again which takes an "age" I've now added a Weights sheet in which I can adjust the multipliers/dividers for Gold, R$, PR and Subsequent Series which makes it a lot easier and quicker to change the calculation factors and re-run the strategy scripts.

I've also (as I think you suggested) ignored the PR if the car is not used in subsequent series as there's no point in a car being selected because of it's higher PR if it's not used again! This will make a difference.

Given the 4 factors I now use in the calculation the number of permutations to test is effectively infinite so I will only test a few concentrating mostly on the priority given to cheaper Gold upgrade strategies.

What I meant by consistent strategies is ... it could be argued that if a car is not selected as the "best" for a series then the upgrades to complete that series should be ignored BUT if I do this it will make the upgrade strategy inconsistent if somebody has decided to apply those upgrades ... so I retain the upgrade strategy even if wasn't the "best" for the series ... this means that subsequent references to the same car will remember and use that strategy. I was wondering how you dealt with this situation?

My calculations are consistently coming out around the 40,000 Gold mark which includes the mandatory upgrades required in a series i.e. those events which feature a subset of the series' cars and have a PR ... these are the green-coloured events in my upgrade strategy.

I will run some more tests with some different calculation factors and let you know how I get on.

Nick