Talk:Series and Special Events/@comment-30967537-20170530173805

NOTE TO POWER QUERY USERS ...

The "Best race for each series" table has had a makeover and is now more inline with the Series pages' Events tables.

The column data is consistently ... The best race is the one which pays the highest R$. This does not take into account endurance races. If there is more than one race with the same highest R$ they will be included in the table.
 * Index. Career series number (from above tables).
 * Series. Series name.
 * Tier. Separate lines for Tier number and Tier description.
 * Event. Event type. Image (not exported) and description.
 * Location. Separate lines for Circuit and (optionally) Track Layout, Time of Day, Rolling Start and Battery.
 * Laps/PR. Separate lines for Laps and PR.
 * R$ (+CRB). Separate lines for R$ reward and Clean Race Bonus.
 * Fame. Fame reward.

All data is retrieved automatically from the Series pages using Power Query. If you find a mistake please correct the relevant series page and notify the Admins so the table can be rebuilt.