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

I use three tables to control the extraction of CarsEvents ...

SCTTuse. For these tiers use the listed car(s).

SCTTignore. For these tiers ignore Showcase / Time Trial rules and use all cars in the series.

SCTTreplace. Tthe name in the tier is incorrect/incomplete, use the replacement.

1. Check SCTTuse. This allows for tiers where the name specifies the wrong car-name (e.g. Porsche 911 RSR 2013/2015, McLaren F1/F1 GTR and P1/P1 GTR etc) or where the car-name is generic (e.g. SC/TT LMP tiers for Porsche and Audi, no year specifed) or where a subset of the series cars are to be used (e.g. OSC, Power VS Grip Time Trial). Basically, this can be used for most special rules.

2. Check for "Showcase" or "Time Trial". Check SCTTignore, if the tier is in there, use all cars. Check SCTTreplace, if the car-name in the tier is in there, use the replacement car name (to match back to the correct Wiki car name).

Most of the differences are down to the tier names not having the words Showcase or Time Trial which is what I check for. I have added rules for the above to the SCTT tables.

The aim of my spreadsheet is to be informative and help, if it's causing more work then let me know and I'll stop!