Thread:RR3 Michael P/@comment-27006659-20170319151020/@comment-30967537-20170423013943

Hi Michael,

1. Minimum Cars. I'm sorry, I still don't understand your minimum races for a car requirement, your explanation has not helped! Is it actually not a Cars list but an Events list you want  i.e. Events in order of minimum cars which are eligible for the event? If so, not a problem.

2. Series and cars. If I've understood that correctly (which, given my past performance is questionable!) that's no problem. Series, Car1, Car2, Car3, ..... . Ok? By the way, why have you still not added those two Toyotas to All Star Series on the All Series and Special Events page? The sequencing isn't a problem as I add an on-the-fly key to each Group, Series and Car as I retrieve them to ensure they stay in Wiki order. Just so you know, with regards to this request and in general, I retrieve the Career details (which drives all of the other queries) from the All Series and Special Events page, I don't go to the Series pages until I start retrieving the Events, I do this otherwise the Career query would be very slow.

3. Manufacturer Navbox. Please explain the requirement. I'm sure it won't be a problem.

4. Minimum Upgrades for Series. I've done this! It's rather slow, it would definitely be a lot faster if done with scripting in Excel but (given the restrictions of Power Query which required a lot of shoe-horning!) I wanted to see if I could do it ! One of the reasons it is slow is that there are an incredible number of possibilities which match  e.g. the cars with the most upgrades have 36 upgrades for which there are a staggering 224,000 upgrade possibilities!!! It may well be that there are other cars with less upgrades but more possibilities, it depends on the number of upgrades for each type. Even when you factor in the required PR and break out of the loop (for that upgrade type) once reached (and, believe me, that took some doing in PQ!) there are still LOTS of possibilites  e.g. I just tried with the Richard Petty series which has required PRs from 44 to 57, the Ford Fusion has 27 upgrades (5443344 which gives 130,000 upgrade possibilities!), I selected a minimum PR of 50, it returned 4565 unique upgrade possibilities all with a PR of 50 to 50.6. FOUR THOUSAND, FIVE HUNDRED AND SIXTY FIVE !!! I added additional code to return Cash, Gold and Minimum-Gold (i.e. only spend Gold if there is not a Cash option) values. Even when you select minimum PR or Cash or Gold or Minimum-Gold there are still LOTS of matching entries ... so which one do you select to be displayed on the Wiki? Or do you just select the first minimum entry and add a caveat that there may be other upgrade optons?

Nick