Please upgrade your browser for the best possible experience.

Chrome Firefox Internet Explorer
×

Ranked WZ Tracking Spreadsheet

STAR WARS: The Old Republic > English > PvP
Ranked WZ Tracking Spreadsheet

FAFuse's Avatar


FAFuse
10.03.2012 , 12:20 PM | #1
I kept this mainly for friends and guildmates, but figured it wouldn't hurt to share...

Please be aware that I have some games in there already to show how things are calculated - delete these before plugging in your own data.

10/3 UPDATE:
  • High score amounts for DMG, Healing, Protection, Medals
  • Fixed an incorrect function for TOTAL DMG and TOTAL HEALING for ALL games.
  • Main sheet will highlight duplicate values in each category. I changed this when I had a glicthed game and had to input something so the averages sheet wouldn't be completely thrown off by a zero value. I simply duplicated the previous games info. You can also see in my examply game that since I no longer run a build that produces healing, I copy the most recent game numbers to attempt to keep a general average over the life of my ranked games.

UPDATE:
  • New Fields: Rating, Video Link
  • New Stats: Rating info (Current, Max, Min, Average)

"Main" Sheet: Enter info
Required:
  • "W" or "L" for win or loss.
  • "AD", "HB", "VS", or "NC" for what warzone you played
  • Opponent Guild abbreviation
  • Your DMG, Protection, Healing, and Medal amount

Optional:
  • Date
  • Score
  • Notes
  • DMG, Protection, Healing, or medal amounts that you don't care about. (Either always log a category, or never log it. Inconsistency will generate incorrect numbers)

"Summary" Sheet: Results
-Edit Yellow area with guild names and abbreviations as they appear on the "Main" sheet.

Stats Displayed:
  • Wins/Loss by WZ
    • Totals, and Win Percentage
  • Wins/Loss by Guild
    • Total Games and Win Percentage
  • DMG Stats
    • Totals by WZ, including Ratio of DMG in Wins vs. DMG in Losses
    • DMG Averages by Wins/Loss, including Ratio
  • Healing Stats
    • Totals by WZ, including Ratio of Healing in Wins vs. Healing in Losses
    • Healing Averages by Wins/Loss, including Ratio
  • Medals Stats
    • Totals by WZ, including Ratio of Medals in Wins vs. Medals in Losses
    • Medal Averages by Wins/Loss, including Ratio
  • Ratiings
    • Current
    • Max
    • Min
    • Average
  • Highest Numbers
    • DMG
    • Healing
    • Protection
    • Medals

Abbreviations Sheet:
This is a way to keep track of what your guild abbreviations are. Nothing on this sheet is referenced in the code.


Other Info:
  • On the "Main" sheet you can select the heading items and select only certain rows if you wish. You can change sorting as well.
  • This spreadsheet will support up to 499 games.
  • The sheets are password protected. If there is something wrong, or you'd like to see something added, please let me know and I can update it. I will not give the PW out.
  • Does not support multiple characters. Copy and paste a new file for each character.


---------------

Download:
http://lostlocalhost.com/swtor/WZ_Log.xlsx

Any questions, let me know on PM or email: mxofuse@gmail.com
Ranked Warzone Videos: www.youtube.com/fusedintention

FAFuse's Avatar


FAFuse
11.28.2012 , 02:52 AM | #2
I seem to be the only one who keep track of this stuff?
Ranked Warzone Videos: www.youtube.com/fusedintention

OldRepublicRevan's Avatar


OldRepublicRevan
11.28.2012 , 02:57 AM | #3
Quote: Originally Posted by FAFuse View Post
I seem to be the only one who keep track of this stuff?
Cause noone cares about Ranked anymore. All ranked teams that thought they were good now just make groups of 4 and go unranked b/c they couldn't handle the real teams in Ranked.

Sorry but someone had to break this news to you.....

Z-ToXiN's Avatar


Z-ToXiN
11.28.2012 , 04:29 AM | #4
I used to keep track of all wins losses and scores. I actually used to play back on Jung Ma. Remember Jawa Bunny Ranch and Sleens? How are rateds there now?

But since coming back after a 2 month break I stopped keeping track. Too many games and with queues popping fast I dont have time and forget and stuff.
ADRAAJ
◙ASSASSiN ╚╬╝ THE BASTION ╚╬╝ POWeRTeCH◙
DECEPTiON HYBRID < ♣ > HYBRID SiN TANK
<JAWA BUNNY RANCH> // #GearRequirementForSolos

Wainamoinen's Avatar


Wainamoinen
11.28.2012 , 07:24 AM | #5
Quote: Originally Posted by FAFuse View Post
I seem to be the only one who keep track of this stuff?
There's a fair amount of ranked play on Red Eclipse, seems about eight guilds putting teams in.

I've not joined one (assuming they'd have me) but I'm a stats freak enough that I like your idea. Particularly the
note on game 11. Think you could make guild abbreviations a lookup from the list, and ease off on the protection so it could be modified more easily, but your call. Also, getting #Name errors all over the Summary sheet, though that maybe down to the conversion to the steam-driven version of Excel I have here.

Given all that, I restrict my spreadsheets to trying to improve my own gear/play, and keeping a record of who I owe a ganking to. Interesting to see the difference in KBs/deaths and damage done/taken differences between my dps scoundrel and dps merc.
Somewhere in the darkness, the Scrapper he broke even
Ilmarinen 60 Scoundrel (Red Eclipse)

TheronFett's Avatar


TheronFett
11.28.2012 , 08:33 AM | #6
Not really much ranked on Ebon Hawk either.

Monday & Wednesday are "official" ranked PvP nights, and some of the guilds will queue up, even break apart and form some PUG teams to get people interested. Most of the time though, it's same-faction coordinated groups and win trading.

Ranked matches are never going to be popular until the gear gap is closed and cross-server queues are implemented.

itsmymillertime's Avatar


itsmymillertime
11.28.2012 , 08:38 AM | #7
Ranked is not as popular as you think. Your thoughtfullness is appreciated, but there is not enough interest right now.

Scotland's Avatar


Scotland
11.28.2012 , 08:40 AM | #8
How many responses came from players on a PVE server?
Albā Anaigh
Albå - AlbaGuBra - Albā - Albagų
> Real stars burn out, superstars burn forever. <

TheronFett's Avatar


TheronFett
11.28.2012 , 09:31 AM | #9
Quote: Originally Posted by Scotland View Post
How many responses came from players on a PVE server?
I get sick of this crap.

I'll do ya one better: I'm on a RP server. And ya know what? We have a PvP Records thread going too, and our top numbers are on par with everyone else. Better in some cases. Just because you play on a PvP server doesn't make you better. There are PvPers on our server who would mop the floor with some of you guys.

Scotland's Avatar


Scotland
11.28.2012 , 09:32 AM | #10
Quote: Originally Posted by TheronFett View Post
I get sick of this crap.

I'll do ya one better: I'm on a RP server. And ya know what? We have a PvP Records thread going too, and our top numbers are on par with everyone else. Better in some cases. Just because you play on a PvP server doesn't make you better. There are PvPers on our server who would mop the floor with some of you guys.

Numbers dont mean anything, thanks for proving my point.
Albā Anaigh
Albå - AlbaGuBra - Albā - Albagų
> Real stars burn out, superstars burn forever. <