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

Hi MIchael,

The qGroupSeriesCars query (which drives the rest of the data-extraction) pulls data from the All Series and Special Events page and then cross-matches all series against the list of Series and Abbreviation on the Tips & FAQs page … if there’s no match then the series is ignored. This is why I think the Series Abbreviation should be held in the Series tables … I’m sure I’m not the only who would like this!

On re-checking that page I see that the NASCAR All-Star Series has "only" 10 cars, the Toyota Camry 2015 and 2016 have been omitted. That's why they only have one series each in the extracted data. I tested this by including them in the GroupsSeriesCars table and they were then included in the CarsEvents extract.

Unfortunately the Footnotes are not available for extraction so I can't check them.

This is why I added the filter tables. I realised (before your email) that the Use (these cars for this tier) table should be checked first so I’ve changed the query-function to check this before doing any SCTT checks AND changed it to check for the full tier name in the Use and Ignore tables. I think it works better now.

I checked your email and made the necessary additions/amendments to the filter tables for those tiers/cars.

Previously I tried to clean up the tier names but I think it’s better to leave mistakes in there so they can be corrected on the Wiki … which kind of proves the point I was trying to make ... the spreadsheet can be used to check the data for inconsistencies in the web-pages, typos and just plain mistakes by FM  e.g. the Porsche 911 RSR 2015!. My main aim when creating the All-Events Exporter was to give you a tool to easily and consistently generate the data for other pages  e.g. the All Events page.

I’m sure you understand the code BUT I’ve added comments (for myself and others) to show the logic used to determine the cars for each tier. My hope is that this will make enough sense for you to be able to maintain the filter tables yourself. Let me know if you need more information on how to use them OR if the code need changing.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;font-family:"Calibri Light",sans-serif; mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-GB">I think the spreadsheet is effectively also giving you the other information you mentioned in your Wiki post that you’d like to have … please let me know if you think it isn’t.

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;font-family:"Calibri Light",sans-serif; mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-GB">I’ve been trying to clean up the scripts and move common code into functions. This seems to me to be a sensible thing to do … create “black boxes” for certain common functions AND reduce common-code clutter in scripts. But it seems to have highlighted one of the (many) issues with PowerQuery … every time you make a change to a function it seems to re-process any query which references that function! This is obviously absurd, maybe there’s a setting that I need to switch off, any ideas?

<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; line-height:normal"><span style="font-size:12.0pt;font-family:"Calibri Light",sans-serif; mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-GB">I’m going to hold back on sending you the updated version until I get a resolution to the above, I don’t want to send you an update which is actually a step backwards! So, if you think of anything else which should be included, let me know and I’ll try to include it in the next update.

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

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

<p class="MsoNormal">