619 K2

The QQ Mercs Competitive Toolbox

, , ,  

Being able to coordinate a drop with 12 friends against an equally competent opponent is a very different experience to dropping a random one man or even 4-man PUG drop – lack of communication with the other players leads to huge amounts of frustration, and the variable skill level means it is often left up to you as a minority to “carry” the match – pressuring you into dropping with nothing but meta optimized builds if you actually want to win. Competitive MWO, while still requiring “meta” builds for top tier play, allows more flexibility and control over the experience, while removing the “we lost because of PUGs” excuse we all use. If you lose in 12s it probably means you can do something better as a team – in loadout, strategy or communication.

While extremely rewarding, 12 man play often requires a certain amount of organisation, the sheer logistics of organizing 12-24 players is intimidating and getting (or keeping) your group in the competitive scene can seem like a huge undertaking.

As an established and active competitive group, the QQ Mercs have developed various tools to aid with the organisation of our teams. We’re providing these tools to the community to mitigate the difficulties a competitive player / drop commander faces and to aid in keeping the competitive scene as diverse as possible.

                                                                                                                                                      

Mech Loadout Calculator – By Valder

Tracking who’s dropping in what Mech is tricky enough, without the added hassle of adhering to specific tonnage limitations. A drop commander is also required to take into account role balancing: DPS, tanking, scouting, light killing, support etc. and may want to design a drop before a team gets together or demonstrate a drop plan through allowing players to see the types of Mechs being asked for.

By using some spreadsheet wizardry, we can select Mech chassis from a drop down list and produce the relevant tonnage in a separate cell.

Instructions for using this Google Document:

  1. Open the link, select file, either make a copy, or download as relevant spreadsheet type.
  2. Duplicate / copy the master sheet complete with new name.
  3. In the sheet, write player names in the boxes next to the Mech selection drop down menus and select a Mech for each player

Note: Tonnages are currently setup for last season’s Run Hot or Die tonnage limits. Simply alter the template should you wish to work with a different tonnage limit.

                                                                                                                                                      

Practice Match Tracker – By Karpundir

A sheet for the really masochistic / stats hungry Drop Commander. This sheet allows you to track your team’s performance over a practice session – which loadouts and strategies work, which don’t, who performed well, opponent players to lookout for and more. Using this Tracking spreadsheet will vastly improve your recollection of what went down in your drops, as well as prepare you for match-ups with your opponents in league play.

Note: This sheet does require work to keep relevant – encourage other players to help or feel free to only track what you’re interested in!

Instructions for using this Google Document:

  1. Open the link, select file, either make a copy, or download as relevant spreadsheet type.
  2. Duplicate / copy the master sheet complete with new name.
  3. Fill relevant cells when data is available – Drop roster changes can be logged below, quantitative data can be inputted by taking a screen capture at the end of each match and inputting results (kills, deaths etc.), qualitative data in the relevant cells (e.g. strategy employed).

                                                                                                                                                      

Mech Statistic Comparison Tool – By Kin3ticx and Noober

This tool was designed as an easy way of evaluating which Mech(s) each player excels in. It can be used by each pilot individually to better evaluate their own performance or by a drop commander to inform pilot/Mech combinations. Kill/Death ratio or Win loss ratio alone do not properly show a mech’s potential to contribute to a match, the combination of KDR, WLR and Damage per match per ton is an attempt at combining factors that contribute to the ability in each chassis.

***Important Disclaimers***

These are statistics and should not be treated as an infallible performance metric, it is particularly important to note that statistics make certain assumptions, and these assumptions are often false! Just because a Mech works in PUGs doesn’t mean it will work in competitive.

The Overall Mech Contribution Rating is purely multiplicative, the calculation is not moderated and as such, the rating exponentially snowballs with good results – a Mech with a rating of 20 is not 4 times better than one with 5!

Again – take the metric(s) with a pinch of salt – they are useful for their intended purpose (comparing pilot skill for preferred Mech), but don’t take them too seriously. The aim was not to design the perfect skill metric, but to give a clue to which Mechs work for which player.

Instructions for using this Google Document:

  1. Open the link, select file, either make a copy, or download as relevant spreadsheet type.
  2. Duplicate / copy the master sheet complete with new name.
  3. Go to https://mwomercs.com/login and log in, then from the menu at the top of the screen select Profile > Stats > Mech Stats.
  4. Drag select all Mech stats, copy and paste into the sheet.
  5. Sort by number of matches by using the “Sort Range…” option under the Data menu. Make sure to click the option to indicate that there is a header row.
  6. Delete those of low statistical significance (<50 matches for example).
  7. Sort by Overall Mech Contribution Rating using Step 5 above.

 

Have your say