Talk:RR3 Wiki:Upgrades Strategy For 100% Completion/@comment-30967537-20170508145826/@comment-30967537-20170613134409

Made the usual mistake, spent a long time composing an answer (during which I created a new Sandbox page just for you!) which then got lost, doh!
 * Yes, all auto-generated. All of this has been done in Power Query. So, if the data isn't (easily) available then I haven't included it.
 * Future Upgrades ... Complementary Strategy. In short, NO!
 * If you look at my Sandbox14a first attempt you'll see that I included the cars-upgrades which would allow you to complete the series. But the problem with this is that every subsequent upgrade to a car is based on the previous upgrades. If the user is trying for an optimum strategy then they won't have upgraded all the cars, so every subsequent upgrade to a car is meaningless! For this reason I made that table sortable by car so users could see the upgrde progression. But this didn't take into account the mandatory (Car-specific events with a PR) events.
 * On this Sandbox14e attempt I allowed for the mandatory events (which got tricky with the one mandatory event which was for more than one car ... EC-10.1) and then included only the "best" (lowest-cost, highest-PR) entry to complete the series. But, of course, this is no good if users don't follow the suggested strategy AND it doesn't allow for complementary upgrade strategies as you mentioned.
 * Unless we build a program to allow users to enter their garage (car and upgrades) and career progress there really is no ideal way of creating a strategy page!
 * I have just mocked up Sandbox14f with valid data included the rejected (i.e. not "best") entries for each series. The "best" entry is highlighted in blue. The other possibles are listed with upgrades based on previous "valid" entries. Any subsequent entries for the same car will not take into account upgrades done on possibles.
 * Table layout/information. Yes, it's all subjective, I was trying to go for something clean but it's a balance between having information and being cluttered! And if you start putting information in separate columns then it will throw off other columns. I think it would definitely benefit from an example event-car line at the top of the page. One of the things I did consider was changing the PRs column (Car minimum, event, Car maximum) to use a graphic.
 * This really was an exercise in what I could achieve with Power Query, once I decided I wanted to do it I had to struggle on, believe me it was not easy. It's a work-in-progress which will probably never go live. I'm happy to take on-board any suggestions.