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

**Aimdrol** · September 28, 2015

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

I'm too lazy to update these all the time.
DEAL has once again been confirmed as subklanu of S3AL, they don't even have 60% of our amount of MoE
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** · September 28, 2015

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

Great work man.

**_Assad** · September 28, 2015

o7 old S3AL Klannumates! nice work

**Bohan** · September 28, 2015

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** · September 28, 2015

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

**kolni** · September 28, 2015

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** · September 28, 2015

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. :fat:

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** · September 28, 2015

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** · September 28, 2015

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** · September 28, 2015

ffs if only i was faster at quoting Kappa

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

**Aimdrol** · September 28, 2015

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** · September 28, 2015

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

**Lord_Of_Honesty** · September 28, 2015

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** · September 28, 2015

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** · September 28, 2015

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** · September 28, 2015

Tazilon lol what

**Rexxie** · September 28, 2015

113: So bad, even Tazilon gets marks.

**UnusualMedic** · September 28, 2015

Negga you da MVP

+15

**AngelofAwe** · September 28, 2015

You forgot EU > NA confirmed. :disco:

**Hudstr22** · September 28, 2015

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** · September 28, 2015

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** · September 28, 2015

That any of you believed it for a moment.

**Sergeant_Fgt** · September 28, 2015

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** · September 28, 2015

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** · September 28, 2015

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

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

Recommended Posts

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Link to post

Share on other sites

Join the conversation

Recently Browsing 0 members

Latest Articles

Topics

Recent Status Updates