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

I’ve re-run all the queries and uploaded a new version, v1.4.3, to my Google Drive.

https://drive.google.com/open?id=0B2-oGcug6THkRExxOURCWTVpcHM

Minimum Events  The Formula-E numbers were wrong because in the SCTT rules I copy-replaced the tier-names but forgot to change the numbers, I, II, III, etc! I had already corrected that in the version uploaded yesterday.

I found a mistake in one Spada SCTT rule which I’ve now corrected.

FYI, the qInfoSeries and qInfoEvents sheets are useful for checking cars. As requested by Michael, I've listed them in separate columns so there's now one line per series/event. First check qInfoSeries that the series has the correct (number of) cars. Then check the specific events in qInfoEvents to see if they have the correct (number of) cars. If they're wrong, they probably need an SCTT rule. Let me know and I can make the change. At the moment, SCTT rules work at a Tier level, I assume that all events within a Tier will use the same car(s).

Minimum Upgrades 

I included various upgrade options (minimum PR, minimum Gold, minimum Cash, etc) as I thought it might be useful but it just seems to be confusing people! I’ve changed it to show one entry for each car-series combination with “No”, “Ok” or “Match”. See the Read.Me sheet for an explanation.

With regards to “I’ve added a special check for “Exclusive Series” and added Car’s maximum PR. I’ve included the same check in the qInfoSeries query.

'''Sheets. '''

The q prefix indicates that the sheet is the result of a query. There are other sheets which don’t have the q prefix.

Some of the queries (qGroups, qGroupsCars, qSeries, qSeriesCars, qSeriesTiers) are not required, only the sheets marked as “Necessary” in the Read.Me sheet are required for other queries to run.

