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

RR3 Michael P wrote: Hi Nick,

It can be thought of another way, minimum is the number of events only 1 car can enter. Normally only Time Trial and Showcase, but there are exceptions, like the SSS, some events are only SPADA Codatronca Barchetta, others only SPADA Codatronca TS.

RR3 Michael P (talk) 22:14, April 23, 2017 (UTC)

Hi Michael,

1. Minimum Events. Done. Added to existing query, qCarStats. Extracts Car, numGroups, numSeries, numTiers, numEvents, numMinEvents. Just checked against Graham's (manually created?) page, a couple of differences, either he's made a mistake or an additional SCTT rule is required. To create this I added a pre-query qEvents which lists all (6000+) events with the number of cars. This is based on qCarsEvents which uses the SCTT rules ... so as long as those are correct then qEvents and the qCarStats will also be correct.

2. Series and Cars. Done. Added sideways list (columns) of cars for each series. As I've previously mentioned, I am using the All Series Special Events page (the Career page) to drive the extract, on that page all the cars are listed in Make/Model order, if a car isn't there then it is not included, if it is there then it will be sorted in Make/Model order. If your order comment referred to how they're listed on the Series pages that's because there the Car names don't include the Make.

''3. Series Cross-Check. I started looking at this. I figured it would be a good idea to have a number of checks such as career series TO ' abbreviations, career-series ' TO  ' series page, career series cars ' TO 'all cars, career series cars ' TO  '<span style="font-size:12.0pt;mso-fareast-font-family: "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-fareast-language: EN-GB"> series page cars, series page cars '<span style="font-size:12.0pt;mso-fareast-font-family: "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-fareast-language: EN-GB"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family: "Times New Roman";mso-fareast-language:EN-GB"> TO  '<span style="font-size:12.0pt;mso-fareast-font-family: "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-fareast-language: EN-GB"> all cars, career series makes '<span style="font-size:12.0pt;mso-fareast-font-family: "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-fareast-language: EN-GB"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family: "Times New Roman";mso-fareast-language:EN-GB"> TO  <span style="font-size:12.0pt;mso-fareast-font-family: "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-fareast-language: EN-GB"> make (classic upgrades) page, etc. Which of these are relevant/useful? ''

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">4. Makes and Cars. Done. Used the same logic as I did for the Series query. Regarding the make name being an issue, I have a simple (hard-coded for now) function which derives the Wiki make from the model so that I can retrieve the Classic Upgrades with PR data. I am using this to set the make, please let me know if that is not correct. A similar rule could be applied for the concatenation OR the concatenation could be done in my spreadsheet queries. Let me know.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">5. Events and Cars. There is already a qSeriesEvents query. This new query is an extract from the qCarsEvents dataset. It includes the cars for each event.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">6.Groups. I haven't done it yet because it would add LOTS of columns but it's a simple change to add the cars if necessary.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">7. Events and Cars. This is available if necessary, it is the qCarsEvents list, if necessary it could be resorted in Events order.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">8. Series Minimum Upgrade Paths. Done. Very slow, takes about an hour! But it works.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-GB">Nick

<p class="MsoNormal">