Board Thread:General Discussion/@comment-25956839-20160203231030

Summary
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 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.

Example
There are three parts to the upgradesPR template, the headings, the data and the total:

Nissan Skyline GT-R V-Spec (R34)

Nissan Skyline GT-R V-Spec (R34)

PR Data
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 can not 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.

QC Check
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.

E.G.

Check:
 * 2 Drivetrain Race-Spec Lightweight Differential 1 hour 15 minutes R$17,400 v R$17,100

The upgrades on the car article is R$17,400, but on the upgrades section the same upgrade had R$17,100, one of them will need to be corrected.

Heading
The heading takes no data, it formats the table headings and configures the columns for sorting.

Upgrade Data
In this example :
 * 1) 1 = The first upgrade of the engine
 * 2) Engine = The component being upgraded, either Engine, Drivetrain, Body, Suspension, Exhaust, Brakes or Tires & Wheels
 * 3) Basic Engine Tuning = upgrade description
 * 4) 2 minutes = The length of time the upgrade will take (empty for Gold only upgrades)
 * 5) 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)
 * 6) 1 = Upgrade cost in
 * 7) 1.1 = PR value for the upgrade

Total
In this example :
 * 1) 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 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) 2.5 = Base PR (from the car article page)
 * 3) 14.3 = PR if the car is upgraded fully with R$ only (no spend) (from the car article page)
 * 4) 15.4 = PR for the car when fully upgraded (from the car article page)

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: It is very time consuming!
 * 1) Cloud save
 * 2) Capture and complete one upgrade at a time, from base
 * 3) Pay gold to complete any R$ purchases
 * 4) Check the data and compete the next upgrade, one at a time
 * 5) Capture & complete all R$ upgrades before starting  upgrades
 * 6) Double check the data captured actually equals the R$ upgrade data (Base PR + R$ upgrade data = Max PR w/ R$)
 * 7) Capture the car data for PR Max cash, (PR, Top Speed, Acc., Braking, Cornering, Cost, Parts) - change the devices 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.
 * 8) Continue to capture the remaining data, as before, one at a time, pay gold to complete R$ upgrades
 * 9) 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)
 * 10) Once the car is fully upgraded, capture the car data for Max PR w/, (PR, Top Speed, Acc., Braking, Cornering, Cost, Parts) - change the devices 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.
 * 11) Cloud restore (to get all the gold back)

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, correcting it and pasting the corrected data back to the pages
 * 1) To help create the car upgrade information visually, this google sheet can be used: Google Sheet Car data
 * 2) 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.
 * 3) Anyone can edit the above sheet, even without a Google account.

History
This is the fifth template to be created as part of the project to automatically add totals to data.

Credits
Many thanks to RomGuyony for confirming the PR data for all the cars, allowing the PR calculation.

Comments
Any comments, please feel free to post below or on my message wall. Thank you for your support. 