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

RR3 Michael P wrote: Hi Nick,

Not sure why, but the number of series tally Cars, except:
 * TOYOTA Camry (Joe Gibbs Racing - 2015) 1 (should be 2 series)
 * TOYOTA Camry (Joe Gibbs Racing - 2016) 1 (should be 2 series)

I've now corrected Aston Martin V12 Vantage S, to 2, on the Cars page.

For RR3 Wiki:Cars and Available Races, we need:
 * Minimum number of available Races = Unique races for that car, mostly TT & Showcase - SPADA are the exception.
 * Maximum number of available Races = count of 'EventNum' for that car
 * Number of series available - done.

RR3 Michael P (talk) 16:27, April 15, 2017 (UTC)

Hi Michael,

The Toyotas are still missing, I assume that's something you'll be dealing with pretty soon.

After having spent a while trying to work out why I was missing a row, I added queries to check for duplicates in the SeriesEvents and CarsEvents sheets ... I corrected the duplicate on the wiki.

I added a query to count the number of events for each car from the CarsEvents sheet. Obviously that information is available by filtering the CarsEvents data, it's just that it was on your list of requirements ... I think that now ticks everything on your list, yes?

Thanks to some help from Chris Webb (check out his excellent blog) I think I've resolved the PowerQuery functions issue I was I was having. There's an option to pre-load query data, turn it off!

I think that's everything, please let me know.

I'll upload the new version after I've done a dry data run tomorrow to make sure it all works.

Nick