Thread:QuickNick/@comment-26829117-20170414231731/@comment-26829117-20170520100322

Nick,

You'll have to do a lot more than saving me time and effort to upset me. I'm extremely impressed with what you've achieved and whilst I created a spreadsheet for the cars and series to enable us to maintain the car tables and 100% strategy, you seem to be miles ahead of me.

The comment about taking over the strategy page was in jest, it's the most time consuming thing on this wiki. We have a (joke) rule, last one to edit it owns it and as I did some extensive changes to it last year I seem to own it. Being able to automatically calculate cheapest PR would make this maintenance much easier. If I crack it, I'll let you know.

I'm sure your calculations are correct and the errors are in the strategy page as this is manually calculated and when FM change something we don't always get it right. I want to go over it and make sure that all the numbers are correct but this does take time and effort. It's not enough to use a spreadsheet, you have to check in game to see that nothing has changed.

Intermediate, duplicate and complementary strategies are where the same car can be used to complete more than one series.

Duplicate: The car has been upgraded in another series to the same level and therefore is effectively free to complete this series.

Intermediate: The car must be upgraded more in a later series and is therefore effectively free in the earlier series. However, I record the initial upgrades and costs against the first upgrade and only the delta cost against the second/third upgrades.

Complimentary: The car has already been upgraded further than required in an earlier series and is therefore free in this series.

As you can see these combinations of series mean that you can't just use the cheapest car in each series to work out the cheapest strategy.

I'm currently working on simplifying these tables to make them easier to maintain and to make them easier to understand. I also want to get the automatic totals working properly. I'll certainly be using your data to validate against.