Thread:RR3 Michael P/@comment-27006659-20170319151020/@comment-25956839-20170423103259

Hi Nick,

1. Minimum Cars. Let me re-explain, I'm trying to automate the data for this page:

RR3 Wiki:Cars and Available Races:

the data comes from the series then the min and max number of events for each car:
 * 1) HC
 * 2) Hennessey Venom GT has a minimum of 4 events (showcase & TT), and a maximum ~46
 * 3) Koenigsegg One:1 has a minimum of 4 events (showcase & TT), and a maximum ~46
 * 4) etc
 * 5) BL
 * 6)  Hennessey Venom GT has a minimum of 3 events (showcase & TT), and a maximum ~39
 * 7) etc

The data would then need to be added together to create the car data.

2. Yes, that is correct.

I'm seeing all three NASCAR Toyota in the NASCAR All-Star Series, total 12 cars. Click the clock in the top right of the page to force a refresh.

And the penny dropped, I understand now, the Series and Special Events is only showing 10 cars. I've increased the Template to allow a maximum of 18 cars now. Should last a few NASCAR updates ;)

So before re-running the excel sheet, the Series and Special Events needs to be updated and RR3 Wiki:Real Racing 3 Tips and FAQ?

2b. Can we add a periodic QC check Series and Special Events v cars in each series, I'm guessing the same method as the All series database can be used, except the PowerQuery is extracting cars, rather than events. This could be run once a release, once the data has been created to verify.

The most accurate is the series e.g. NASCAR All-Star Series, which is showing the 12 cars, as they are represented in game. Series and Special Events is now displaying all 12 cars, but not in the correct order. If we can run a periodic QC check, to make sure they are in the same order, we can then fix any discrepancies.

3. Manufacturer Navbox.

The purpose would be to automate the creation of the manufacturer navbox. Based on in game data, reflected on the Wiki, there are several sources for the data, Cars, or each manufacturer page NISSAN, I'm not sure about the Series and Special Events, maybe worth a test, it would be the first occurrence of the car in a series, if it works.

e.g. Template:Navbox/Manufacturer/NISSAN

Similar to the series navbox, the order would be:

Manufacturer, Count of cars, Car1, car2, car3, etc.

Example for how the CONCATENATE could work:



Items in red would be from the excel sheet.

As we have the manufacturer name (NISSAN) the model could be a formula Mid (@car2, len(@Manufacturer) , 50) or something along those lines. The AMG cars maybe a problem.

4. Minimum Upgrades for Series.

That sounds allot of calculations! The order would be the cheapest cost in GC, then R$.

You are aware the upgrade calculations vary depending on the upgrade order? Using the Upgrades Wiki data would then need to be verified by actually upgrading the car :/

I hope this answers your questions, and look forward to the next excel sheet :)

RR3 Michael P (talk) 10:32, April 23, 2017 (UTC)