# Spreadsheet: Top 100 Leaderboard Players (May/June)

**URL:** <https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811>\
**Category:** Community Guides\
**Created:** [June 1, 2016, 9:16pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811 "2016-06-01T21:16:48Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 1, 2016, 9:16pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/1 "2016-06-01T21:16:49Z")

</div>

**June 13, 2016 Leaderboard** (Before Reset)  
[GoW Leaderboard Spreadsheet](https://docs.google.com/spreadsheets/d/1mDc19hI-I107j3KnplvvnL22ybk2thLN5CO3sDTm1HQ/edit?usp=sharing)

* * *

I have transferred the leaderboard information to a spreadsheet for easy reading. Since defense wins/losses aren’t reliable because of various bugs from the first week of PVP 2.0, I won’t bother calculating any metrics for that week.

However, next week, I’d like to make a couple of charts:  
Top 10 Guilds With Players in Top 100  
Top 10 Invade Win Ratios  
Top 10 Defense Win Ratios

As I mentioned in another thread, I might do a chart of defense troop frequency.

Thanks to yonizaf for the idea for this project.

---

<div class="post-metadata">

**Author:** ![Tacet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/tacet/32/35_2.png) [@Tacet](https://community.gemsofwar.com/u/Tacet)\
**Post date:** [June 1, 2016, 9:18pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/2 "2016-06-01T21:18:15Z")

</div>

Thanks for doing this. 🙂

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 1, 2016, 9:21pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/3 "2016-06-01T21:21:57Z")

</div>

Welcome 🙂

---

<div class="post-metadata">

**Author:** ![en9nhcet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/en9nhcet/32/1673_2.png) [@en9nhcet](https://community.gemsofwar.com/u/en9nhcet)\
**Post date:** [June 1, 2016, 9:47pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/4 "2016-06-01T21:47:24Z")

</div>

i have the cutiest patootie 😊

[![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/3/1/31de32025acb3ca6e88a486d3a777eee835f8769.jpeg "Drunken Slurring Dwarf sings 'Cutie Patootie'") ](https://www.youtube.com/watch?v=woi_2Ay0Y-U)

---

<div class="post-metadata">

**Author:** ![Malkav](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/malkav/32/3562_2.png) [@Malkav](https://community.gemsofwar.com/u/Malkav)\
**Post date:** [June 1, 2016, 10:22pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/5 "2016-06-01T22:22:41Z")

</div>

Thank you, Ashasekayi. Very neat!

And as a member of the top 100 (barely got a toe in the water) I approve this message.

![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/3/3096f811bd035944a84667af5ce6149f2799107d.gif)

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 1, 2016, 11:13pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/6 "2016-06-01T23:13:04Z")

</div>

Congrats on making it to the leaderboard. 😸

---

<div class="post-metadata">

**Author:** ![actreal](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/actreal/32/1945_2.png) [@actreal](https://community.gemsofwar.com/u/actreal)\
**Post date:** [June 2, 2016, 1:44am UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/7 "2016-06-02T01:44:11Z")

</div>

Kudos on taking on this project. I’m grateful to have this data to cross reference given I won’t be able to collate it myself.

I’ve assigned this thread to the Community Guides category as that is where all the regularly updated stats threads end up (including mine).

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 2, 2016, 1:47am UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/8 "2016-06-02T01:47:26Z")

</div>

Thanks for moving it to the right place. I wasn’t sure if it should go in guides or community content.

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 7, 2016, 1:56pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/9 "2016-06-07T13:56:23Z")

</div>

## June 6, 2016 Spreadsheet Update

This week’s spreadsheet represents the first full week of PVP 2.0. The leaderboard data in the spreadsheet was captured at 6 minutes before reset. Despite the defense data still being corrupted by bugs, I went ahead and setup some interesting charts. I did not include charts that compare last week with this week since last week wasn’t a full week of matches.

**Note:** There are three tabs that represent the leaderboard, visual charts and corresponding calculated data. Look in the first post for the spreadsheet.

**Included Charts:**  
Frequency of Players By Guild  
Frequency of Players By Level  
Top 10 Players By Invade Win Ratio  
Top 10 Players By Defense Win Ratio  
Top 10 Players By Total Win Ratio  
Defense Troop Frequency (Top 15)

> ## **Some Interesting Stats:**

> **Players With Best By Invade Win Ratio:** inspecterjesus and lignum5  
> **Player With Best By Defense Win Ratio:** inspecterjesus  
> **Player With Best By Total Win Ratio:** inspecterjesus  
> **Minimum PVP Points on Leaderboard:** 11,931  
> **Maximum PVP Points on Leaderboard:** 70,507  
> **Minimum Games Played on Leaderboard:** 286  
> **Maximum Games Played on Leaderboard:** 2615  
> **Guild With Most Players on Leaderboard:** Match Masters

> ## Fun Fact:

> **Last Minute Sprint:** In the 24 minutes before reset, @dhjl and Sister continued to fight it out for the top spot. In that time, dhjl played 6 games and earned 78 PVP points; Sister played 6 games and earned 182 PVP points.

**Disclaimer:**  
Like Santa, I make the list and check it twice. However, if you find an error, feel free to PM me with a correction.

## To Do List:

Top 20 Defense Teams

---

<div class="post-metadata">

**Author:** ![Koolbiird](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/koolbiird/32/5099_2.png) [@Koolbiird](https://community.gemsofwar.com/u/Koolbiird)\
**Post date:** [June 7, 2016, 2:20pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/10 "2016-06-07T14:20:19Z")

</div>

Great resource! Very glad you’re doing this.

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 7, 2016, 2:23pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/11 "2016-06-07T14:23:17Z")

</div>

Thank you 😸

By the way, if anyone has suggestions for other metrics to follow based on leaderboard stats, let me know.

---

<div class="post-metadata">

**Author:** ![xuyuu89](https://avatars.discourse-cdn.com/v4/letter/x/91b2a8/32.png) [@xuyuu89](https://community.gemsofwar.com/u/xuyuu89)\
**Post date:** [June 7, 2016, 5:53pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/12 "2016-06-07T17:53:43Z")

</div>

awesome! im ranked 24!!! go Vn4ever!!! and congrats on guild mate Krammaster for #8!!!

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 7, 2016, 5:56pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/13 "2016-06-07T17:56:18Z")

</div>

Congrats on your ranking. 😸

---

<div class="post-metadata">

**Author:** ![jncreed2000](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@jncreed2000](https://community.gemsofwar.com/u/jncreed2000)\
**Post date:** [June 7, 2016, 7:57pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/14 "2016-06-07T19:57:23Z")

</div>

I ended at 49, so I jumped 2 spots in the last 6 minutes 🙂

---

<div class="post-metadata">

**Author:** ![Edu-M](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/edu-m/32/35070_2.png) [@Edu-M](https://community.gemsofwar.com/u/Edu-M)\
**Post date:** [June 7, 2016, 8:44pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/15 "2016-06-07T20:44:41Z")

</div>

Great work @Ashasekayi 🙂

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 7, 2016, 11:40pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/16 "2016-06-07T23:40:58Z")

</div>

Thanks much 😸

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 14, 2016, 1:56pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/17 "2016-06-14T13:56:51Z")

</div>

## **(June 13, 2016)**

[GoW Leaderboard Spreadsheet](https://docs.google.com/spreadsheets/d/1mDc19hI-I107j3KnplvvnL22ybk2thLN5CO3sDTm1HQ/edit?usp=sharing)

Once again this week, dhjl is the champion of the leaderboard. Maximum games played went up from 2,615 to 2,723. However, there was a massive spike in maximum PVP points from 70,507 to 101,140. I would assume this occurred because the game developers gave high level players a 25% point boost for hard matches.

After looking at the stats for last week, it would seem that the climb to reach the Top 100 is getting even steeper. In the previous event week, you needed to at least play 286 games (or 11,931 points) to reach the leaderboard. However, you needed to play at least 341 games (or 13,593 points) to make it on to the board last week.

Queen Mab has dethroned Infernal King and The Great Maw on the most frequently used troop list. In the previous event week, there were 19 Queen Mab troops used. Yet, last week, there were 46 Queen Mab’s on defense across levels. It’s worth noting that there was a Queen Mab in every top scoring defense team by level sans one.

Other troops that saw increased usage were Valkyrie, Soothsayer and the recently buffed Crimson Bat. However, Bone Dragon dropped from 13 troops to 7. In the previous event week, the most used weapon was Morthani’s Scythe. Surprisingly, the offensive weapon, Prismatic Orb, rose to the top.

Levels 0 - 200 still have the most diversity in defense troops used. However, that diversity declined last week. In the previous week, Mab and/or Maw teams comprised 25% of teams at that level. However, the amount increased to 36% last week. Higher levels had from 46% to 66% Mab and/or Maw defense teams.

> ## Some Interesting Stats:

> **Number 1 Player on Leaderboard:** @dhjl  
> **Players With Best Invade Win Ratio:** lignum5 and @AutumnRose  
> **Player With Best Defense Win Ratio:** @Justakid  
> **Player With Best Total Win Ratio:** fisheepxxz  
> **Minimum PVP Points on Leaderboard:** 13,593  
> **Maximum PVP Points on Leaderboard:** 101,140  
> **Minimum Games Played on Leaderboard:** 341  
> **Maximum Games Played on Leaderboard:** 2,723  
> **Guilds With Most Players on Leaderboard:** Anonymous and Match Masters  
> **Most Used Troop:** Queen Mab  
> **Most Used Weapon:** Prismatic Orb

> 

## Top Defense Teams By Level Range:

> **0 - 200:** [55.42%] Soothsayer | Queen Mab | Valkyrie | Queen Mab  
> **201 - 400:** [44.33%] Morthani’s Scythe |Queen Mab | Valkyrie | Soothsayer  
> **401 - 600:** [41.18%] Soothsayer | Queen Mab | Valkyrie | Queen Mab  
> **601 - 800:** [41.46%] The Great Maw | Mercy | Infernal King | Sheggra  
> **800+:** [36.17%] Mountain Crusher | Valkyrie | Queen Mab | Queen Mab

> [Note: You can see all defense teams listed by win ratio and level in the spreadsheet.]

> 

## Mab and Maw Usage By Level Range:

> **0 - 200:** Mab: 28%; Maw: 8%; Both: 0%  
> **201 - 400:** Mab: 15%; Maw: 26%; Both: 5%  
> **401 - 600:** Mab: 20%; Maw: 20%; Both: 20%  
> **601 - 800:** Mab: 33%; Maw: 33%: Both: 0%  
> **800+:** Mab: 28%; Maw: 15%; Both: 12%

## Defense Troop Frequency (Top 20) Image

 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/c/c500b14b659bd8418c0dd0b2b554ad80144347e6.PNG)

* * *

**Charts in Spreadsheet:**  
Frequency of Players By Guild  
Frequency of Players By Level  
Top 10 Players By Invade Win Ratio  
Top 10 Players By Defense Win Ratio  
Top 10 Players By Total Win Ratio  
Defense Troop Frequency (Top 20)

**Disclaimer:**  
Like Santa, I make the list and check it twice. However, if you find an error, feel free to PM me with a correction.

---

<div class="post-metadata">

**Author:** ![TaliaParks](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/taliaparks/32/11738_2.png) [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)\
**Post date:** [June 14, 2016, 2:53pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/18 "2016-06-14T14:53:31Z")

</div>

You people better get your Queen Mab counters rolling, because until they tweak her, her frequency numbers are only going to rise.

---

<div class="post-metadata">

**Author:** ![Larohar](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/larohar/32/2685_2.png) [@Larohar](https://community.gemsofwar.com/u/Larohar)\
**Post date:** [June 14, 2016, 3:56pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/19 "2016-06-14T15:56:45Z")

</div>

Awesome work, thanks a lot!  
You should copy the link to the spreadsheet into your weekly post.

---

<div class="post-metadata">

**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\
**Post date:** [June 14, 2016, 4:01pm UTC](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811/20 "2016-06-14T16:01:28Z")

</div>

> [@Larohar](#):
>
> You should copy the link to the spreadsheet into your weekly post.

That’s a good point. 😸 I added the link to the weekly post.

[Next page](https://community.gemsofwar.com/t/spreadsheet-top-100-leaderboard-players-may-june/7811.md?page=2)
