QuickNick

Nick's Stuff

Feel free to download/use anything you find here.
Please contact me if you have any questions, suggestions or feedback.
If you think you've found a mistake on one of my pages, please don't edit it, a lot of the data is generated so the error might be re-created the next time I generate the data! Send me a message and I will make the necessary changes. Thank you.

Work(s) in Progress

• Update v7.6 Main Page
• -----------
• PQ-generated calendar
• Cars All Data. To be able to generate data for Cars list pages e.g. Cars
  • User:QuickNick/CarsAllData ... Sample page
  • User:QuickNick/R/CarsAllData ... Row template for it. More examples.
  • User:QuickNick/R/CarsAllData2 ... Similar to above but to go on the car's page, so no Make-Logo or Car-Image column.
  • User:QuickNick/R/CarsAllData2a ... Similar to v2 but without the Base, R$ Upgraded and Fully Upgraded info as it's already in the Characteristics' section of the car's page. Example page
• -----------
• User:QuickNick/R/Tracks ... LIVE! See the Circuits page.
• -----------
• User:QuickNick/FormatNumDP3 ... LIVE! See the FormatNumDP template.
• -----------
• User:QuickNick/CarImageText2
• User:QuickNick/CarImageText3
• -----------
• User:QuickNick/Parser Names
• User blog:QuickNick/Hi-Res Images

Power Query

• Power Query forum
• Example Cars page PQ script
• Extracting the New Series Tables
• See my Spreadsheets page which includes a download of my Cars spreadsheet which uses PQ to retrieve the cars and upgrades from the Wiki. It's a bit old (please excuse my early code!) but still works.

If you need any help with (or have any suggestions regarding) PQ, feel free to contact me.

WTTT (History)

This is now LIVE! on the Tournaments page.

The following table is now a template ... WTTTcurrent
It can be included in your Profile/Article page by adding

{{WTTTcurrent}}

and will be automatically updated.

WTTT Tracks and Cars for 18-Feb-2020 to 25-Feb-2020
Event Info	Cars
Autodromo Nazionale Monza Road Course 18-Feb-2020 to 25-Feb-2020	FERRARI 360 MODENA	PORSCHE CARRERA GT	LAMBORGHINI DIABLO SV
See the WTTT page for Car usage (including Best Cars), Track usage and WTTT History.

Visit the WTTT page which shows ...

• The Current WTTT Events.
• All Cars and their usage.
• All Tracks and their usage.
• (Nearly) All of the WTTT Historical Events.

Best-Paying Events

Visit my Best-Paying Events page.

Series Rewards

Visit my Series Rewards page.

Upgrade Strategy

Visit my Upgrade Strategy page.

Levels, Fame and Gold

Visit my Levels, the Fame Required and the Gold Rewards page.
Note: FM have now supplied the Level-Fame-Gold info, see Fame Chart, which shows how accurate Filippo’s formula was!

Wiki Badges

Visit my Wiki Achievement Badges page to see the badges and points you can earn for editing the Wiki.
Thanks to Michael for (help with) compiling this data, I just added the images and made it look pretty!

Sandbox Pages

Section	Link	Description
	User:QuickNick/Sandbox01	A copy of the Sandbox editing page! Also see the (other) test templates. {{User:QuickNick/R/Sandbox|R=1|Career Page LIVE!|User:QuickNick/Career3|Generated career page! User:QuickNick/Series and Special Events
All Events. LIVE!	User:QuickNick/Sandbox02base	Base page, no data. Use this to re-create the All Events page.
	User:QuickNick/Sandbox02	First pass. To be deleted.
	User:QuickNick/Sandbox02t	TEST. 500 rows using a template.
	User:QuickNick/Sandbox02a	OK. Created using RR3 Wiki Exporter.
	User:QuickNick/Sandbox02b	OK. Extended Race Info. Is page too large?
	User:QuickNick/Sandbox02d	Base page for below, no data. Use this to re-create the new All Events page.
	User:QuickNick/Sandbox02e	New All Events page! Includes Group and Index Series moved to the left Extended Race Info
	User:QuickNick/Sandbox02f	Base page for below, no data. Use this to re-create the new All Events page.
	User:QuickNick/Sandbox02g	New All Events page! Includes Career Group Series moved to the left Extended Race Info qWikiCcAllEvents4
	User:QuickNick/Sandbox02j	Base page for below, no data. Use this to re-create the Test All Events page.
	User:QuickNick/Sandbox02k	Test All Events page! Includes Group abbreviation and name Series Index Race Info split into separate columns qWikiCcAllEvents5
	User:QuickNick/Sandbox02l	Base page for below, no data. Use this to re-create the Test All Events page.
	User:QuickNick/Sandbox02m	Test All Events page! Testing what fits. Group name removed again! Decimal place(s) removed from Battery and PR. Changed Time-of-Day to shortened versions ... Dawn, Morn, Aft, Eve, Nite. Some column-headings reduced e.g. Battery --> Bat, Rolling Start --> RS That said, I think the remit of this page should be to include all relevant information, and so what if it exceeds the page limits!
Enhanced Manufacturers page. LIVE!	User:QuickNick/Sandbox04	First pass. Needs car ALT names in italics.
	User:QuickNick/Sandbox04a	Second pass. Car ALT names in italics.
	User:QuickNick/Sandbox04b	OK. As above but coded workaround for #loop: issue.
	User:QuickNick/Sandbox04c	OK. As above but without Continent column.
	User:QuickNick/Sandbox04d	OK. Using modified template.
	User:QuickNick/Sandbox04e	LIVE! Vertical model list.
Cars. Available Races. LIVE!	User:QuickNick/Sandbox05	First pass. Using original template.
	User:QuickNick/Sandbox05a	LIVE! New template. Extended ALT car names.
	User:QuickNick/R/CarAvRace3	New template. Includes link to all events for car.
	User:QuickNick/Sandbox05b	LIVE! Using above template.
Best-Paying Event(s) per Series. LIVE!	User:QuickNick/Sandbox06	First pass. Two tables, one for Fame, one for R$. They're not the same!
	User:QuickNick/Sandbox06a	Second pass. Using "proper" Wiki-standard template.
	User:QuickNick/Sandbox06b	LIVE!. Modified template to use RowCount to sort Index.
Top-100 Best-Paying Events	User:QuickNick/Sandbox07	First pass. Two tables, one for Fame, one for R$. They're not the same!
	User:QuickNick/Sandbox07a	Second pass. Using "proper" Wiki-standard template.
	User:QuickNick/Sandbox07b	Third pass. Using same (live) template as Sandbox06b.
Car Navboxes for Makes & Series. LIVE!	User:QuickNick/Sandbox08	First pass.
	User:QuickNick/Sandbox08a	Second pass.
	User:QuickNick/Sandbox08b	LIVE! As above but Series title doesn't have number of cars.
Most Profitable Races	Not going to happen, needed community input, disappointing response.
	User:QuickNick/Sandbox09	First pass.
	User:QuickNick/R/ProfitRaces2	Modified layout. Using all current data.
	User:QuickNick/R/ProfitRaces2a	Modified template: R$/min and Fame/min calculated in template.
	User:QuickNick/R/ProfitRaces2b	Modified template: Rearranged data so TIME is last template field.
	User:QuickNick/R/ProfitRaces3	Modified layout. Using all current data.
	User:QuickNick/R/ProfitRaces3a	Modified template: R$/min and Fame/min calculated in template.
	User:QuickNick/R/ProfitRaces3b	Modified template: Rearranged data so TIME is last template field.
	User:QuickNick/Sandbox10	Second pass.
Car-Series Minimum-Upgrades	User:QuickNick/Sandbox11	First pass. No templates. To be deleted.
	User:QuickNick/Sandbox12	Second pass. Using templates. To be deleted.
	User:QuickNick/Sandbox12a	Third pass. Playing with ALT names. To be deleted.
	User:QuickNick/Sandbox12b	OK. Created using RR3 Wiki Exporter.
	User:QuickNick/Sandbox12c	OK. Updated so that (series-) cars are in "proper" Wiki order.
	User:QuickNick/Sandbox12d	OK. New template. Same car-name structure as Cars Available Races.
Upgrade Strategy	User:QuickNick/Sandbox14	Cars-Series, Upgrade Progression.
	User:QuickNick/Sandbox14e	Upgrade Strategy. Mandatory and Best Upgrades.
	User:QuickNick/Sandbox14g	Full Upgrade Strategy. Mandatory, Best and Optional Upgrades.
	User:QuickNick/Sandbox14h	As Sandbox14g but allows for cars appearing in subsequent series.
	User:QuickNick/Sandbox14i	Fixed the bug which occcasionally caused an unnecessary upgrade when the car was already partially upgraded! Changed "best" and complementary selection calculation.
	User:QuickNick/Sandbox14j	As Sandbox14i with subsequent-series-for-the-car column. This affects the "best" entry calculation and could explain why a more costly entry has been selected.
	User:QuickNick/Sandbox14k	As Sandbox14j with subsequent-series-for-the-car column moved next to the car column.
	User:QuickNick/Sandbox14l	As Sandbox14k with Career Group header rows and Series Reward now includes Series-Completion and Sponsorship rewards.
	User:QuickNick/Sandbox14m	As Sandbox14l with section headers and Table of Contents. Note: TOC only auto-generated for 3 or more headers!
	User:QuickNick/Sandbox14n	As Sandbox14m but the Series column on the car-event line now shows all Series for the car allowing you to jump to the previous/next entry for the car.
	User:QuickNick/Sandbox14o	Included the event rewards in the total series rewards, converted Fame to Gold, makes a difference.
	User:QuickNick/Sandbox14p	Upgrades now done in Series PR order which fixes the issue with subsequent series with lower PRs.
All Events by Car for each Make. LIVE!	User:QuickNick/Sandbox15	LIVE!
	User:QuickNick/Sandbox15b	Modified table headers and car links.
WTTT (History) LIVE!	User:QuickNick/Sandbox16	Version 1.
	User:QuickNick/WTTT	LIVE! Includes lots of templates and revisions User:QuickNick/H/WTTTcurrent User:QuickNick/R/WTTTcurrent User:QuickNick/T/WTTTcurrent User:QuickNick/H/WTTThistory(-4) User:QuickNick/R/WTTThistory(-4) User:QuickNick/T/WTTThistory(-4) User:QuickNick/H/WTTTcars(-4) User:QuickNick/R/WTTTcars(-4) User:QuickNick/T/WTTTcars(-4) User:QuickNick/H/WTTTtracks(-4) User:QuickNick/R/WTTTtracks(-4) User:QuickNick/T/WTTTtracks(-4)
	User:QuickNick/WTTThistory	LIVE!
Car Gallery LIVE!	User:QuickNick/CarGallery	LIVE! Template:CarsGallery
All Car Database	User:QuickNick/Sandbox21	Just an idea I had! Work-in-Progress.

Car Gallery

LIVE!

I included this here as a reminder just in case I ever want to use it!

I duplicated the {{CarsGallery}} template using Power Query and created a Car Gallery template page.

• Template: {{CarsGallery}}
• Location: Template:CarsGallery

Useful Stuff

• Series & Abbreviations
• {{User:QuickNick/GoldSmall}}. A smaller
• {{User:QuickNick/R$Small}}. A smaller
• {{CarImageText}}. See Template:CarImageText documentation for how to use.
• {{Quote}}. Add a quote. See template for instructions. I modified it so that no attribution text is required!
• Special:WhatLinksHere ... followed by the page/template name to find which pages reference it
  • e.g. Special:WhatLinksHere/WTTTcurrent

My Spreadsheets

Descriptions and links on my Spreadsheets page.

• Wiki-based Cars/Upgrades
• Non-Wiki-based Cars/Upgrades ... Discontinued, use the Wiki-based spreadsheet

Wiki Editing

I created the following template for User:RusTORK but think it might be useful to others as a starting point for creating templates ... User:QuickNick/R/Garage

A list of useful/helpful articles for editing the Wiki ...

• List all parser functions on a Wiki
• .
• Wikitext Cheatsheet
• Help on Templates
• Conditional Tables
• String Functions
• .
• Help:Magic Words
• Help:Magic Words - MediaWiki
• Help:Parser functions
• Help:Extension:ParserFunctions
• Images
• Gallery
• Help:Links
• Help:Switch parser function
• Extension:Loops
• Advanced table formatting
• Table Sorting

And ...

• Power Query M Function Reference

And ...

• Special:Insights

Images


rr3.fandom.com/wiki/File:Showcase [wiki car name].jpg
rr3.fandom.com/wiki/File:Series [wiki series name].png
rr3.fandom.com/wiki/File:Category [wiki category/group name].png
rr3.fandom.com/wiki/File:Circuit [circuit name].png

The car images generally use a 1.777 ratio

• 1280x720
• 1920x1080
• 2048x1153 (if copied from the VM's 2048x1536 screen)

If a car name includes a / the image file will have to use something else e.g. -

and a REDIRECT page created from the original image file name e.g.

• Showcase PORSCHE 936/77 SPYDER.jpg

... REDIRECTS to ...

• Showcase PORSCHE 936-77 SPYDER.jpg

Navbox Templates

rr3.fandom.com/wiki/Template:Manufacturer/[wiki make name] rr3.fandom.com/wiki/Template:Series/[wiki series name]
IMPORTANT: Remove non-alphanumeric characters e.g. ( - / + : etc

EMPTY pages

EMPTY pages are in the EMPTY folder ...

• User:QuickNick/EMPTY/All_Series
• User:QuickNick/EMPTY/Cars_and_Circuits

and are used to re-create the project pages as it's easier to just CTRL-A cut the whole lot and then copy the EMPTY pages rather than trying to cut out the rest of the data.

Other Stuff

This is for my reference but might also be of interest to others ...

• Missing the clock? Check out Michael's How To Add The Clock blog.
• Want some tips on customization? Check out Topcon's excellent Customization blog.
  • Even better, check out Tommy299’s fantastic Vinyl Designs by the Layer blog.
• Want to use an Android Emulator. Check out Michael's interesting Blue Stacks for Android blog.
• Check out Sirebel's comprehensive Gold, Gold and More Gold page.
• Perpetual Endurance Races which is a work-in-progress.

WTTT Results Table

Copied from Dave (Sirebel)’s page.

Track	Car	PR Upgrades	Group Time	Split Group Global	Position Group Global	% Group Global	Margin Total
Circuit de Spa-Francorchamps	PORSCHE 918 SPYDER WEISSACH PACKAGE	89.4 (7453333)	B 01:46:589	0.424s 4.377s	673 1,919	13.5% 1.54%	4,311 124,600
Circuit de Catalunya GP Circuit	ASTON MARTIN VULCAN	88.7 (7453333)	A 01:18.232	4.065s 4.065s	915 915	83.79% 0.84%	177 109,200
Nürburgring Grand Prix Circuit	BUGATTI VEYRON 16.4 GRAND SPORT VITESSE	86.8 (7464333)	B 01:28.806	1.199s 4.970s	1,088 1,792	38.64% 2.55%	1,728 70,400
Mazda Raceway Laguna Seca	FERRARI FXX K	96.3 (6434344)	B 00.59.837	0.136s 2.785s	325 1,835	5.38% 1.22%	5,715 151,000
Overall			B	10.993s 16.197s	892 958	27.58% 1.45%	2,342 66,000

• The template has been updated to WTTT19 which is easier to understand as, thanks to Michael, it now uses named parsers.
• I have made further amendments to the template, see the documentation.
• I am now using it on my WTTT Results page.

Users

Other users who are doing (or have done) interesting stuff ...

• User:RR3_Michael_P
• User:Sirebel
• User:Chriscar2
• User:Amrosa
• User:RusTORK

New Pages

A list of what's new on the Wiki using the {{Newpages}} template ...