The RR3 Wiki:Upgrades Section (Classic Version) page has been upgraded, with a new template, using the same automatic calculation method used on every car article page, with the addition of PR being added and a comparison with the actual PR data for the car.
The new template is almost identical to the one used on the car article page, only the PR data is extra, making it easily portable from car article page to upgrade section page, only the PR will need to be added and the template name changed from upgrades to upgradesPR, the total will need the PR information for base PR, PR w/R$ upgrades and Max PR added.
The old Upgrades Section page had all cars in individual tables, the page was massive, in wiki terms, topping out at 429,514 bytes, This made the page very unfriendly for mobiles.
One of the problems with the old table was the calculation for the total was completed when the table was created. Any changes made to the table data would mean the total would need to be manually changed. It was also difficult to verify the accuracy of the data.
There are three parts to the upgradesPR template, the headings, the data and the total:
TOTAL: 11 R$-Only Upgrades. 10 (3300022) All Upgrades. 11 (4300022)
11.8 +1.1 +0.0 =12.9
52,300 +0 =52,300
3 / 15
There is a long-standing problem with PR data for cars differing, depending on the order of the upgrades, this is the reason the data cannot be included in the car article.E.G. If a player upgrades the engine level 1, then engine level 2 the PR value of the drivetrain level 1 may change!
There are three known fixed points, regardless of the upgrade order, the car will still upgrade to the same PR:
Base PR, the PR of the car with 0 upgrades.
PR w/R$, PR with R$ upgrades only (no upgrades)
PR Max, PR with the car fully upgraded
It is therefore now possible, using a calculation, to verify the accuracy of the PR data, at these points. The known PR values are shown under the total, then the calculated PR values, based on the Base PR + the upgrade PR data. The difference (+/-) from these values is calculated and displayed.
While creating the new template, the car data and classic upgraded data were compared, any differences in R$ or
are listed under the new template, as text, any variation will automatically calculate, once corrected, if the car article data is incorrect the cars characteristics data will need to be manually corrected too.
Engine = The component being upgraded, either Engine, Drivetrain, Body, Suspension, Exhaust, Brakes or Tires & Wheels
Basic Engine Tuning = upgrade description
2 minutes = The length of time the upgrade will take (empty for Gold only upgrades)
4100 = R$ upgrade cost, this should be in a value format, either 13500 or 13,500, if the comma separator isn’t entered, it will automatically be added (empty for Gold only upgrades)
1 = Upgrade cost in
1.1 = PR value for the upgrade
In this example :
17 minutes = The total upgrade time refers to the time it would take if each upgrade was done as the last one finished, meaning most of the time, only the Engine needs to be considered, as all other upgrades would be done before that tree. It is free text, the total needs to be manually calculated and entered if empty the total will be blank.
2.5 = Base PR (from the car article page)
14.3 = PR if the car is upgraded fully with R$ only (no spend) (from the car article page)
15.4 = PR for the car when fully upgraded (from the car article page)
Upgrade descriptions are checked against previously used descriptions. If the description hasn't been used before, it will display in red, this is to catch typos and spelling mistakes. Double check any red descriptions, if they are correct, add them to this template:
Add descriptions to the second to last line, in the format | lower case description = Proper Case Description e.g.:
| race prototype intake manifold = Race Prototype Engine Tuning
Method to correct the data
The next step is to correct the car data, for any cars with PR data that does not total.
If anyone has the time, the following is a known good method:
Capture and complete one upgrade at a time, from base
Pay gold to complete any purchases
Check the data and complete the next upgrade, one at a time
Capture & complete all upgrades before starting upgrades
Double check the data captured actually equals the R$ upgrade data (Base PR + R$ upgrade data = Max PR w/ R$)
Capture the car data for PR Max cash, (PR, Top Speed, Acc., Braking, Cornering, Cost, Parts) - change the device's settings between imperial and metric (Settings > Display > Display Speed: MPH | KPH) for top speed MPH/KPH and braking ft/m, do not use a calculation.
Continue to capture the remaining data, as before, one at a time, pay gold to complete R$ upgrades
Once all data has been captured double check the data captured actually equals the fully upgraded car data (Base PR + upgrade data = PR Fully upgraded)
Once the car is fully upgraded, capture the car data for Max PR w/ , (PR, Top Speed, Acc., Braking, Cornering, Cost, Parts) - change the device's settings between imperial and metric (Settings > Display > Display Speed: MPH | KPH) for top speed MPH/KPH and braking ft/m, do not use a calculation.
Cloud restore (to get all the gold back)
It is very time-consuming!
The following Google Sheet be used to help create the data and automatically format the template, although this g.sheet is primarily for creating the car data for new cars, it is possible to copy in existing data, correct it and past the corrected data back to the pages:
To help create the car upgrade information visually, this google sheet can be used: Google Sheet Car data
As anyone can edit the above sheet, to avoid conflicts, if you have a Google Drive, I would recommend you save a copy (File > Make a copy...), which will save the Google sheet to your own Google Drive, for your own personal use.
Anyone can edit the above sheet, even without a Google account.
This is the fifth template to be created as part of the project to automatically add totals to data.
Many thanks to RomGuyony for confirming the PR data for all the cars, allowing the PR calculation.
Any comments, please feel free to post below or on my message wall. Thank you for your support.
Edit: 3-Dec-2017 Added quality check and minor corrections.
Awesome guys! Why hasn't this template been applied to the latest car(s)?....Like I don't remember seeing this on the Sesto. In fact I suggested this very thing and you guys already had it developed. Cheers!
This is fantastic! I was just searching the Forum to ask if this kind of info could be added to the wiki. Will it eventually be added to the individual car pages? For now can we add links from the car article pages to the car's upgrade page?
One other thing I'd love to see in this template (and the one on the car article page) is visual differentiation between engine, drivetrain, etc., to make it easier to tell where one ends and the next begins. I know the table can be sorted by columns, though, so that makes it a bit more difficult to implement. (I'm not sure why you would want to sort upgrades by price or time, though, since you can only progress through them in a fixed order.)
Mlieberman wrote: Will it eventually be added to the individual car pages?
OK, I see from the linked blog post, I guess it was originally on the car article pages and removed? I'm not sure I understand the reason but I'm sure there was a good one.
Update: I just read through all the comments on User blog:Kuzz/The Pulse - Week 4/2015#Performance ratings My take-away is that Kuzz didn't like it but almost everyone else wanted it to stay. The reason behind removing it was that 1) the numbers may vary by +/- 0.1, and 2) people were constantly editing the PR numbers based on what they saw in the game. IMO, a very dumb reason to remove it (and it seems like most people agreed). Simply mark the column with a footnote that states values may vary +/- 0.1 depending on the order of upgrades purchased.
Anyway, I guess this new page was born out of the desire to have the information available, which is great. And I do hope it eventually makes its way to the car article pages, because I never would have found the RR3 Wiki:Upgrades Section (Classic Version) page if I hadn't been searching the forum and come across this article. (But site navigation is a topic for another time.)