Marks of Excellence Data - A new metric has been born (22.03.17) | Moecare > Trumpcare

[Aimdrol 84]

I wanted to get the data of all players with 3 Marks of Excellence (MoE) and some related info, I couldn't really find any existing stuff so I wrote a program and spammed the WG API with about 3 million request and put the data in a nice spreadsheet. I already posted this on the EU WoT forums but Nightmare_Luna suggested that I also post it here for all the statlovers.

 

► SPREADSHEET EU Tanks◄► SPREADSHEET EU Players & Clans◄► SPREADSHEET CHANGES EU #13 → #14◄

► SPREADSHEET RU Tanks◄ ► SPREADSHEET RU Players & Clans◄► SPREADSHEET CHANGES RU #1 → #2◄

 

► SPREADSHEET NA◄► SPREADSHEET CHANGES NA #9 → #10◄ 

► SPREADSHEET ASIA◄► SPREADSHEET CHANGES ASIA #7 → #8◄

 

The spreadsheets for EU and RU are split into 2 parts (one with only Marks on Tanks and the other one with the rest). In addition to that, I cannot have a hyperlink for every player in the first spreadsheet  because of spreadsheet limitations.

Old Versions

Spoiler

► SPREADSHEET EU #1 ◄

► SPREADSHEET CHANGES EU #1 → #2◄

► SPREADSHEET EU #2◄

► SPREADSHEET CHANGES EU #2 → #3◄
► SPREADSHEET EU #3◄

► SPREADSHEET CHANGES EU #3 → #4◄

► SPREADSHEET EU Tanks #4◄ ► SPREADSHEET EU Players & Clans #4◄
► SPREADSHEET CHANGES EU #4 → #5◄
► SPREADSHEET EU Tanks #5◄ ► SPREADSHEET EU Players & Clans #5◄

► SPREADSHEET CHANGES EU #5 → #6◄

► SPREADSHEET EU Tanks #6◄ ► SPREADSHEET EU Players & Clans #6◄

► SPREADSHEET CHANGES EU #6 → #7◄
► SPREADSHEET EU Tanks #7◄ ► SPREADSHEET EU Players & Clans #7◄
► SPREADSHEET CHANGES EU #7 → #8◄

► SPREADSHEET EU Tanks #8◄ ► SPREADSHEET EU Players & Clans #8◄
► SPREADSHEET CHANGES EU #8 → #9◄
► SPREADSHEET EU Tanks #9◄ ► SPREADSHEET EU Players & Clans #9◄
► SPREADSHEET CHANGES EU #9 → #10◄
► SPREADSHEET EU Tanks #10◄ ► SPREADSHEET EU Players & Clans #10◄
► SPREADSHEET CHANGES EU #10 → #11◄
► SPREADSHEET EU Tanks #11◄ ► SPREADSHEET EU Players #11◄► SPREADSHEET EU Clans #11◄
► SPREADSHEET CHANGES EU #11 → #12◄
► SPREADSHEET EU #12◄
► SPREADSHEET CHANGES EU #12 → #13◄
► SPREADSHEET EU #13◄

 

► SPREADSHEET NA  #1◄
► SPREADSHEET CHANGES NA #1 → #2◄
► SPREADSHEET NA #2◄

► SPREADSHEET CHANGES NA #2 → #3◄

► SPREADSHEET NA #3◄
► SPREADSHEET CHANGES NA #3 → #4◄
► SPREADSHEET NA #4◄
► SPREADSHEET CHANGES NA #4 → #5◄ 
► SPREADSHEET NA #5◄

► SPREADSHEET CHANGES NA #5 → #6◄ 

► SPREADSHEET NA #6◄
► SPREADSHEET CHANGES NA #6 → #7◄ 
► SPREADSHEET NA #7◄
► SPREADSHEET CHANGES NA #7 → #8◄ 
► SPREADSHEET NA #8◄
► SPREADSHEET CHANGES NA #8 → #9◄ 
► SPREADSHEET NA #9◄

 

► SPREADSHEET ASIA #1◄
► SPREADSHEET CHANGES ASIA #1 → #2◄
► SPREADSHEET ASIA #2◄

► SPREADSHEET CHANGES ASIA #2 → #3◄

► SPREADSHEET ASIA #3◄
► SPREADSHEET CHANGES ASIA #3 → #4◄
► SPREADSHEET ASIA #4◄
► SPREADSHEET CHANGES ASIA #4 → #5◄
► SPREADSHEET ASIA #5◄
► SPREADSHEET CHANGES ASIA #5 → #6◄
► SPREADSHEET ASIA #6◄
► SPREADSHEET CHANGES ASIA #6 → #7◄
► SPREADSHEET ASIA #7◄


► SPREADSHEET RU Tanks #1◄

► SPREADSHEET RU Players & Clans #1

 

Last Updates

EU: #14: 11.03.2017

RU: #2 11.11.2016

NA: #10: 22.03.2017

ASIA: #8: 20.10.2016

 

Spoiler

EU

• #13: 19.01.2017
• #12: 25.12.2016
• #11: 23.11.2016
• #10: 12.10.2016
• #9: 11.09.2016
• #8: 16.08.2016
• #7: 14.07.2016
• #6: 17.05.2016
• #5: 15.04.2016
• #4: 05.01.2016
• #3: 29.11.2015
• #2: 05.10.2015
• #1: 30.08.2015

 

NA

• #9: 10.12.2016
• #8: 16.10.2016
• #7: 01.09.2016
• #6: 23.07.2016
• #5: 15.05.2016
• #4: 06.04.2016
• #3: 29.01.2016
• #2: 19.10.2015
• #1: 17.09.2015

 

ASIA

• #7: 07.09.2016
• #6: 28.07.2016
• #5: 15.05.2016
• #4: 06.04.2016
• #3: 29.01.2016
• #2: 09.11.2015
• #1: 03.10.2015

 

RU

• #1: 01.05.2016

 

You can filter or sort the data using the following button:

 

If you want to edit the spreadsheets and/or work more comfortably with them, you can download the files via File > Download as > Microsoft Excel (.xlsx)

THE RATING

Each 3 MoE on a tank is worth a certain amount of points depending on the tier and tank type of the tank and the amount of players with 3 MoE on it (indicator for the difficulty). The rating of a player is the sum of points for each tank he 3-marked, rounded down to the nearest integer. The rating of a clan is the sum of the rating of its players. 

Keep in mind that this (currently) just me playing around with some numbers because it seemed like a fun thing to do.

 

Formulas:

Tank & Type %

This is the ratio of all generally available tanks (no premium or reward tanks, still researchable, at least 1 player with 3 MoE on it) per tier or tank type to the maximum possible amount. The latter is listed in the MoE Distribution spreadsheet.

Conclusions so far

1. I'm too lazy to update these all the time.
2. DEAL has once again been confirmed as subklanu of S3AL, they don't even have 60% of our amount of MoE 
3. There are actually 3 guys with 3 MoE on the CGC. 

I don't know enough about the NA or ASIA server to be able to give such spot on conclusions

Want to check your current MoE status and don't want to wait for the next update?

You can use my WN8 Changes Tool. In addition to showing changes in WN8 ratings due to expected values changes, it also shows you how many 3/2/1 Marks of Excellence you have.

A couple of notes regarding the data

• I got the initial IDs from xvm dev seriych upon my request.
• As I now have access to a server, I'm checking each possible ID of a server for a valid account (played at least one battle after the introduction of the MoE), so every accounts gets checked.
• I do have some data for 2 MoE as well, but "you basically get them for playing 100 games on a tank"¹ so I decided to not publish them
• I did not collect the data for 1 MoE
• For the spreadsheet to be viewable in google docs I had to dismiss any player or clan with less than a certain amount of MoE (marked by (X+) in the worksheet names). I do have a complete spreadsheet with them that I can upload if anyone is interested. I also cannot list every player with 3 MoE on a tank for each server due to limitations of google drive.
• It takes a long time to completely update the data due to restraints of the WG API
• I'm currently thinking about how to update the data about once a week in an effective manner

 

Sources/References

• WG API
• seriych (xvm dev, player IDs)
• pun_xD (for Quote 1)

[13endix 44]

Now i won't have to roam the official forums anymore to find it, Fenks <3 

Great work man. 

[_Assad 3,538]

o7 old S3AL Klannumates!  nice work

[Bohan 61]

I would love to see a spreadsheet for the Asia server, though I guess the result will probably be very similar to NA results... 

<3 your work

 

[Rexxie 10,576]

A bit off topic, but are you the guy who does the amazing replay analyzer? If so, I love you.

[Kolni 69,670,173]

A bit off topic, but are you the guy who does the amazing replay analyzer? If so, I love you.

He is. Also the MLG mod creator

best guy

 

Comparing these.. I think KT has the highest 3MoE/game ratio on both servers

Edited September 28, 2015 by Kolni

[Aimdrol 84]

I would love to see a spreadsheet for the Asia server, though I guess the result will probably be very similar to NA results... 

<3 your work

 

I got 340.000 IDs from the xvm team for the ASIA server, so it should be possible to check them relatively fast. I have to create an account on the server though for the developer program. 

A bit off topic, but are you the guy who does the amazing replay analyzer? If so, I love you.

He is. Also the MLG mod creator

best guy

Guys, you're making me blush. 

 

Does anyone know a good up-to-date API for overall/recent WN8? I'd really like to use it for some charts on MoE distribution on WN8 classes and stuff.

Edited September 28, 2015 by Aimdrol

[Lord_Of_Honesty 16]

I have had  3 MoEs on the O-I exp for a week now. yet its says the only player that has 3 MoEs on it is SchnitzelTruck.

Also the O-I exp. isnt even listed on the VbAddict website's MoE calculator.

 

Still, Love this spreadsheet, good work

 

[Nuttydave1234 116]

I have had  3 MoEs on the O-I exp for a week now. yet its says the only player that has 3 MoEs on it is SchnitzelTruck.

Also the O-I exp. isnt even listed on the VbAddict website's MoE calculator.

 

Still, Love this spreadsheet, good work

 

 

• I gathered the data from 27.08 - 30.08, so it is already outdated quite a bit

Anyways, quite the cool spreadsheet! One of 4 CGC 3 MOEs. (Churchill Gun Carrier)

[13endix 44]

ffs if only i was faster at quoting Kappa

Edited September 28, 2015 by 13endix
To late, lol

[Aimdrol 84]

I have had  3 MoEs on the O-I exp for a week now. yet its says the only player that has 3 MoEs on it is SchnitzelTruck.

Also the O-I exp. isnt even listed on the VbAddict website's MoE calculator.

 

Still, Love this spreadsheet, good work

 

I just checked and the last request was done on 17.09. Using 28.09 as the date of the last update was missleading because I only created the uploaded spreadsheet on this day. I fixed this mistake in the OP. After gathering the data I was kinda busy with a project for my Clan, updating the Replay Analyzer and some RL stuff, which caused this delay.

[Nuttydave1234 116]

Quick note, I am unable to find T95E2 on the NA Spreadsheet

[Lord_Of_Honesty 16]

I just checked and the last request was done on 17.09. Using 28.09 as the date of the last update was missleading because I only created the uploaded spreadsheet on this day. I fixed this mistake in the OP. After gathering the data I was kinda busy with a project for my Clan, updating the Replay Analyzer and some RL stuff, which caused this delay.

Ok good to know

[RollerCoaster47 757]

A couple questions, is there a formula or any particular order the tanks are listed in?  And are the names to the right of the tanks the only people on the server to have those particular tanks triple marked, or are they the best players in those tanks?

Edit:  Nevermind, I see how the tanks are listed now, just needed to scroll over to the right more.

Edited September 28, 2015 by RollerCoaster47

[Fabunil 1,596]

Ok time to pad the MOEs I guess.

Also one of 3 people with 3 MOEs on the IS-5, I guess only scrub klanus got access to it and I am not even in a clan ( ͡° ͜ʖ ͡°)

How regulary will you update it if you plan to do so?

 

[_Dia 2,082]

Tazilon lol what 

[Rexxie 10,576]

113: So bad, even Tazilon gets marks.

[UnusualMedic 1,472]

Negga you da MVP

 

+15

[AngelofAwe 16]

You forgot EU > NA confirmed.

[Hudstr22 54]

Tazilon lol what 

that is keiwi, he changed his name to Tazi(I)on, with the (I) just being an uppercase "i". I saw him in battle a while ago and at first thought it was the vk 2801 guy, but after his top keks and epeen-ness, I was educated in my mistake

Edited September 28, 2015 by Hudstr22

[_Dia 2,082]

that is keiwi, he changed his name to Tazi(I)on, with the (I) just being an uppercase "i". I saw him in battle a while ago and at first thought it was the vk 2801 guy, but after his top keks and epeen-ness, I was educated in my mistake

Oh ok. I guess that has to be it since the real one would probably never be able to get 3. 

[Cunicularius 4,542]

That any of you believed it for a moment.

[Sergeant_Fgt 479]

Was curious about that Tazilon thing, looked him up and saw


Is this a bug or a srs addiction to the VK 2801 ? I mean, I am bored of most tanks after not even playing them for 100 games.

Btw. 1.7k battles in last 30 days ? Fuck me sideways

Edited September 28, 2015 by Sergeant_Fgt
30d stat

[Rexxie 10,576]

Was curious about that Tazilon thing, looked him up and saw


Is this a bug or a srs addiction to the VK 2801 ? I mean, I am bored of most tanks after not even playing them for 100 games.

Btw. 1.7k battles in last 30 days ? Fuck me sideways

Yeah, that's basically entirely what he's known for. Srs thing.

[Luna 3,440]

Eyy, awesome. Thanks so much for doing this. :)))