The GT7 Livery Editor Competition Leaderboard

[MatskiMonk]

The GT7 Livery Editor Competition Leaderboard
by Nuschel01

​

Welcome to the unofficial official Leaderboard for the ongoing GT7 Livery Editor Competitions!

After the winner of the most current competition is declared, all the votes are tallied, and a ranking then applied. Principally, there's the points tally, this works on the current FIA Formula 1 championship points allocation of 25, 18, 15, 12, 10, 8, 6, 4, 2, 1, for first to tenth positions respectively. Allied to that, the ranking is sorted by an entrants highest performance, and how many times they've achieved that peak level. Every LEC entrant is now fighting for an overall position in the standings!

Other stats are shown for each member that has competed in a LEC including; how many LEC's they contested, the average number of votes received, and their average finishing position. Additionally, stats for car types and brands are also available, along with overall Livery Editor Competition stats, and a round up of themes, so be sure to check the additional tabs on the sheet below!

The Current Standings...

​

---

All the effort for this, including compiling the data and generating the statistics was done by @Nuschel01. If you think there's a mistake or error, please PM @Nuschel01 or @MatskiMonk, and we'll give it a look. Constructive feedback welcome.
Thanks to @syntex123 (and @Nuschel01) for organising the LEC threads and polls, and please checkout @Raphaele's HALL OF FAME thread to remind yourself how good the entries are!

Spoiler: Calling all LEC entrants!

@508920 @996rick @Aachenboy @Adam Barber @Aerocoupe @akira3d @Andredi @cderekw19 @Cedrift62 @Chevy Heavy @ChilledGemi99 @cpl_richie @Cytoria @daan @danhighway @darkracer99 @dizco @djdest @Drex124 @Driver6573829 @EOG @feedmerch @gaphiko @Gingerale @Goofyah @GordonS @GR3GOR__B @grisko1 @grp__kta @GTvsForza @Hasnain282 @Hayden @huff @ikon_313 @im2fst4u @Islaygaz @jamesaflee @JarredJackson @jhuizinz @JohnnyMac @Kita Kangaroo @krisduv @lauriebeamont @Lorre @Lost Sheltie @MatskiMonk @Miancomasa @MidnightRun85 @Mires @MisterWaffles @moxjkar @Mr_Mellifluo @MultiplaFan @Nearlander @Nerazzurri @Nessy @Nico_Ble99 @Noisy @Nuschel01 @olympiquemarc @opelman @p78 @Panoz @pinakaguwaping @PLDSR @Racerx_34 @Raphaele @RealJaySee @ro_har_ @sanrensho @ScottPye20 @Seattle @Sian @sinner @Sinyster @Skython @SouperK @Speedy Samurai @svenhjs666 @syntex123 @TeamCZRRacing @The_It_Jojo @The359 @TheMethod @TiMcF1 @tinker @tomoca_1 @tonystarks131 @Touring Mars @Tuning_Maniac @UnkaD @UrbanGorilla @wagnerFAM98 @WJHMH @wowbaggerBR @ziggedzag

 

[krisduv]

Great effort
can't wait to see how the car/entry stats look like in a year or two (very nice idea!)

 

[MidnightRun85]

This is amazing work! My inner geek is foaming at the mouth at the intensity of this ranking chart. Love it!

 

[danhighway]

Lucky 13th

 

[MatskiMonk]

Lucky 13th

Once we get to stats for 4 LECS, the table should start to diverge a bit.

 

[Nuschel01]

It should be added that this shouldn't be taken too serious in terms of any kind of competition. After all the goal should be to encourage people to make a bunch of great liveries matching a set theme without anyone going full tryharding sweatlord and not voting for entries they'd vote for but they were made by somebody ahead in the ranking.

Thanks for putting this post together, Matt

If anyone has any ideas what else might be interesting to cover, please step forward

 

[Nearlander]

I could have sworn I was in 42nd place the last time I looked here. But 43? I mean, what even is that? This changes everything. I’m gonna have to go home and rethink my whole identity.

 

[MidnightRun85]

I could have sworn I was in 42nd place the last time I looked here. But 43? I mean, what even is that? This changes everything. I’m gonna have to go home and rethink my whole identity.

It's one whole place ahead of me and @Nuschel01. Of the three of us, you win.

 

[huff]

I could have sworn I was in 42nd place the last time I looked here. But 43? I mean, what even is that? This changes everything. I’m gonna have to go home and rethink my whole identity.

Don’t panic. You just need to try harder, but not too hard or you’ll end in 41st; then what will you do.

 

[Nuschel01]

I could have sworn I was in 42nd place the last time I looked here.

I found a few errors in my results gathering, so maybe that changed results a little, because I know for sure @MidnightRun85 and I were in P43 previously

 

[MidnightRun85]

@Nuschel01 what makes the difference in the rankings for the Car Type and Brand? If they all have 1 win a piece, are they not tied? Or does it then come down to the number of seconds and thirds, and so on??

 

[Nuschel01]

You mean that they constantly swap their order? It's because there is an RNG behind it that adds a new number whenever something in the sheet is updated.
Because if you do a vlookup on a ranked list where there are multiple entries with the same rank it'll only return the first one. So without a random number it'd look like this:

P1	Audi - 1 Win
P2	Audi - 1 Win
P3	Audi - 1 Win

With the random number added to it in theory it looks like this:

P1	Audi - 1.17373921 Win
P2	Toyota - 1.37392983 Win
P3	BMW - 1.73186036 Win

Since Excel/Google Sheets refreshed random values all the time there is a little bit of fluctuation going on with the positions.

 

[MidnightRun85]

You mean that they constantly swap their order? It's because there is an RNG behind it that adds a new number whenever something in the sheet is updated.
Because if you do a vlookup on a ranked list where there are multiple entries with the same rank it'll only return the first one. So without a random number it'd look like this:

P1	Audi - 1 Win
P2	Audi - 1 Win
P3	Audi - 1 Win

With the random number added to it in theory it looks like this:

P1	Audi - 1.17373921 Win
P2	Toyota - 1.37392983 Win
P3	BMW - 1.73186036 Win

Since Excel/Google Sheets refreshed random values all the time there is a little bit of fluctuation going on with the positions.

Not sure what that all means... But I guess as the competitions continue the order will start to align itself better once there's more wins for a brand, etc. ?

EDIT: @Nuschel01 I guess my reason for asking is if we have 10 competitions and a different car and/or brand wins each time, won't the rank just never change unless your spreadsheet is taking into account the finishing positions for those cars/brands across the whole competition as well?

 

[Nuschel01]

But I guess as the competitions continue the order will start to align itself better once there's more wins for a brand, etc. ?

Exactly.
Here's how the positions are set currently:

The left values are taken from another table where I enter what car/brand won + the random number. Breaking down the formula visible on top it esentially searches the largest value in the left table and matches the type/brand to it. The second part basically does the same just that this time it matches the rounded down number to it. It's kinda hard to explain, but yeah.

1. Find the biggest value in the table → 1.712934145
2. Find the row in the (flipped around) table (because vlookup only goes left to right) with that value and return the 2nd column → VGT
3. Add - to the cell → VGT -
4. Repeat step one
5. Repeat step two but now return the 1st column and round the found value down → 1.712934145 →
   1

Since we had three LECs so far with 3 different cars and brands winning there is no way for the sheet to rank everything themselves (except for if I made something that determines who got x wins first, but I think that's a bit unnecessary really. If for example BMW wins the current LEC their value will go to 2.xxxxxxxx and thus be higher than 1.xxxxxxxx, so they'll be put in P1 with the other two still jumping around in P2 and P3.

EDIT:

EDIT: @Nuschel01 I guess my reason for asking is if we have 10 competitions and a different car and/or brand wins each time, won't the rank just never change unless your spreadsheet is taking into account the finishing positions for those cars/brands across the whole competition as well?

Yes, that's how it'd be. The brands and types in that table you initially highlighted would change all the time. I probably could hand out points to types and brands as well, but that'd involve quite a bit of overhauling and at least in my eyes seems a bit unnecessary, because at the moment the types/brand ranking is totally independent from the entrants ranking.
Basically what I do when a new entry is posted is that I assign the entry number (from the poll) to the user, ...

... and then manually adjust the counter for types and brands in these tables:



Once the poll is over I just type down the number of votes every entry got and let the sheet do its magic:


For the types and brands I then check the top three highest finishing ones and manually enter them:


For example you can see that in LEC 01 Toyota got P1, P2 and P3 with Honda in P4 and Mitsubishi in P5. I only check the top three brands and their finishing position tho. Considering I only really need the winning types/brands that's already a bit redundand The "Total" column counts all cells in the type's/brand's row with a 1, which is then processed into the helper table shown at the very beginning of this post.

 

[MidnightRun85]

Exactly.
Here's how the positions are set currently:
View attachment 1164621

The left values are taken from another table where I enter what car/brand won + the random number. Breaking down the formula visible on top it esentially searches the largest value in the left table and matches the type/brand to it. The second part basically does the same just that this time it matches the rounded down number to it. It's kinda hard to explain, but yeah.

1. Find the biggest value in the table → 1.712934145
2. Find the row in the (flipped around) table (because vlookup only goes left to right) with that value and return the 2nd column → VGT
3. Add - to the cell → VGT -
4. Repeat step one
5. Repeat step two but now return the 1st column and round the found value down → 1.712934145 →
   1

Since we had three LECs so far with 3 different cars and brands winning there is no way for the sheet to rank everything themselves (except for if I made something that determines who got x wins first, but I think that's a bit unnecessary really. If for example BMW wins the current LEC their value will go to 2.xxxxxxxx and thus be higher than 1.xxxxxxxx, so they'll be put in P1 with the other two still jumping around in P2 and P3.

Does the random number represent anything or is it purely a random number to get a ranking difference? I'm assuming it's the latter because Abarth and Autobianchi are showing in your list but I'm fairly sure I've never seen either of those make an appearance.

Is all of that bit manual? I guess if you wanted to sink more time into it you could have a table where you add the make/type plus finishing position into an entry list break-down which then feeds to the main chart, giving you an accurate result of how many times a brand or type has shown up and the ranking based on finishing positions where there's a tie (much like the main ranking chart). But then maybe that's all getting a bit onerous and unnecessary...

 

[Nuschel01]

Does the random number represent anything or is it purely a random number to get a ranking difference?

It represents nothing, just the regular =rand() Excel and Google Sheets offer.

Is all of that bit manual?

I've edited the post above, I think that explains everything?

EDIT: Thinking about it again half of what I explained isn't even needed to answer your question The part prior to the voting only affects the tables you didn't highlight

 

[MidnightRun85]

It represents nothing, just the regular =rand() Excel and Google Sheets offer.


I've edited the post above, I think that explains everything?

EDIT: Thinking about it again half of what I explained isn't even needed to answer your question The part prior to the voting only affects the tables you didn't highlight

Yep, understood. Appreciate the explanation, and all the effort that goes into all this! Me being me, I'd have made a monster of a spreadsheet where there's an entry result breakdown (eg. LEC 01, including the finishing position of each entrant, car type, make, vote number), a summary tab which pulls results from each LEC (giving you the top 3 for each LEC at a glance), then a tab pulling results from the full entry breakdown extracting the make / car type, and finally a tab giving the full ranking of every entrant. But I'm a stickler for over-complicating my spreadsheets and using conditional formatting and vlookups unnecessarily, so yeah, ignore me!

 

[Nuschel01]

But I'm a stickler for over-complicating my spreadsheets

We'll better not talk about that

I might've done something similar with actually putting down who entered what car had I started this after LEC 01 and updated it every other day during running competitions. Backtracking 3 LECs with over 150 entries however kept me away from that
If you want I can give you editing rights for this sheet too, in case you wanna dive down deep or find any errors

EDIT: I'd also love to have a look at your stuff Are there any differences between our results anyway?

 

[MidnightRun85]

EDIT: I'd also love to have a look at your stuff Are there any differences between our results anyway?

I haven't been game enough to build a spreadsheet to return any results, so I've not got an answer there. If I can find some time between my projects, my GT missions and entertaining my toddler I'll have a crack and let you know!

 

[Nuschel01]

Results for LEC 04 are now in

EDIT: I changed the way points are handed out, for example previously if there were two people tied for P5 the next person would've been in P7; now they're in P6.

Fun fact: This means everyone who participated in LEC 03 got points now

 

[Nuschel01]

Results for LEC 05 are now in, @MatskiMonk runs away with a healthy 18 points lead over @krisduv in 2nd. BMW also takes its second win with Mazda, Nissan and Lamborghini stepping on the podium for the first time.
In total 116 people made 291 of 348 possible votes, which means that again quite a few people didn't hand out all their three votes.

Additionally, here's a small up/down ranking of the leaderboard compared to LEC 04.

Place	Entrant	Points	Up/Down
1	MatskiMonk	62	←
2	krisduv	44	↑ 3
3	996rick	39	↑ 7
4	Nerazzurri	38	↓ 2
5	Raphaele	35	↑ 2
6	grp__kta	34	↓ 3
7	JarredJackson	32	↑ 8
8	RealJaySee	31	←
9	Nuschel01	31	↑ 3
10	wowbaggerBR	30	↓ 6
11	ziggedzag	28	↓ 5
12	Touring Mars	25	↓ 3
13	MisterWaffles	18	↓ 2
14	gaphiko	14	↓ 1
15	SouperK	14	↓ 1

 

[MatskiMonk]

@MatskiMonk runs away with a healthy 18 points lead

Lol.. me right now...

 

[p78]

Soo apparently, i made 6th position one time. So close but yet so far .

 

[Nuschel01]

Soo apparently, i made 6th position one time. So close but yet so far .

LEC 03 you came 6th and scored 8 points, LEC 04 you came 8th and scored another 4 points.

 

[Nerazzurri]

Results for LEC 05 are now in, @MatskiMonk runs away with a healthy 18 points lead over @krisduv in 2nd. BMW also takes its second win with Mazda, Nissan and Lamborghini stepping on the podium for the first time.
In total 116 people made 291 of 348 possible votes, which means that again quite a few people didn't hand out all their three votes.

Additionally, here's a small up/down ranking of the leaderboard compared to LEC 04.

Place	Entrant	Points	Up/Down
1	MatskiMonk	62	←
2	krisduv	44	↑ 3
3	996rick	39	↑ 7
4	Nerazzurri	38	↓ 2
5	Raphaele	35	↑ 2
6	grp__kta	34	↓ 3
7	JarredJackson	32	↑ 8
8	RealJaySee	31	←
9	Nuschel01	31	↑ 3
10	wowbaggerBR	30	↓ 6
11	ziggedzag	28	↓ 5
12	Touring Mars	25	↓ 3
13	MisterWaffles	18	↓ 2
14	gaphiko	14	↓ 1
15	SouperK	14	↓ 1

Note to self- must try harder!

 

[Nuschel01]

Results are in, quite a few changes in the leaderboard this time

Place​	Entrant​	Points​	Up/Down​
1	MatskiMonk	62	←
2	996rick	57	↑ 1
3	ziggedzag	53	↑ 8
4	Nuschel01	46	↑ 5
5	krisduv	44	↓ 3
6	Nerazzurri	38	↓ 2
7	Raphaele	35	↓ 2
8	grp__kta	34	↓ 2
	JarredJackson	34	↓ 1
10	RealJaySee	31	↓ 2
11	wowbaggerBR	30	↓ 1
12	Gingerale	26	↑ 4
13	Touring Mars	25	↓ 1
14	lauriebeamont	20	↑ 19
15	MisterWaffles	18	↓ 2

 

[MatskiMonk]

Guess I might need to step up my game

 

[p78]

@MatskiMonk Uhm no!

 

[MatskiMonk]

@MatskiMonk Uhm no!

Don't worry, I said 'need to', not 'will'

 

[Nuschel01]

We have a new leader

Place​	Entrant​	Points​	Up/Down​
1	996Rick	82	↑ 2
2	MatskiMonk	72	↓ 1
3	ziggedzag	71	↓ 1
4	Nuschel01	46	←
5	krisduv	44	←
6	JarredJackson	40	↑ 3
7	Nerazzurri	38	↓ 1
8	Raphaele	37	↓ 1
9	grp__kta	34	↓ 1
10	RealJaySee	32	←
11	huff	30	↑ 10
12	wowbaggerBR	30	↓ 1
13	p78	27	↑ 10
14	Gingerale	26	↓ 2
15	Touring Mars	25	↓ 2