PDA

View Full Version : GoW Stats thru 7/1/08



pcramrod
07-16-2008, 08:24 PM
Here is an update to some of those stats I had mentioned the other day:

Top 5 sorted by Kills/Round


<table style="border-collapse: collapse; width: 538pt;" border="0" cellpadding="0" cellspacing="0" width="717"><col style="width: 78pt;" width="104">
<col style="width: 68pt;" width="91">
<col style="width: 48pt;" width="64">
<col style="width: 76pt;" width="101">
<col style="width: 9pt;" width="12">
<col style="width: 62pt;" width="83">
<col style="width: 88pt;" width="117">
<col style="width: 9pt;" width="12">
<col style="width: 7pt;" width="9">
<col style="width: 93pt;" width="124">
<tbody><tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt; width: 78pt;" height="20" width="104">Player</td>
<td class="xl65" style="width: 68pt;" width="91">Total Kills</td>
<td class="xl65" style="width: 48pt;" width="64">Rounds</td>
<td class="xl67" style="width: 76pt;" width="101">Kills Per Round</td>
<td class="xl65" style="width: 9pt;" width="12">
</td>
<td class="xl65" style="width: 62pt;" width="83">Total Downs</td>
<td class="xl67" style="width: 88pt;" width="117">Downs Per Round</td>
<td class="xl65" style="width: 9pt;" width="12">
</td>
<td class="xl65" style="width: 7pt;" width="9">
</td>
<td class="xl70" style="width: 93pt;" width="124">Standard Dev. By Match</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl66" style="height: 15pt;" height="20">vcize</td>
<td align="right">456</td>
<td align="right">375</td>
<td class="xl68" align="right">1.2160</td>
<td>
</td>
<td align="right">155</td>
<td class="xl68" align="right">0.4133</td>
<td>
</td>
<td>
</td>
<td class="xl71">1.1684</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl66" style="height: 15pt;" height="20">ender1986</td>
<td align="right">43</td>
<td align="right">43</td>
<td class="xl68" align="right">1.0000</td>
<td>
</td>
<td align="right">28</td>
<td class="xl68" align="right">0.6512</td>
<td>
</td>
<td>
</td>
<td class="xl71">1.6118</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl66" style="height: 15pt;" height="20">wigglycoot</td>
<td align="right">78</td>
<td align="right">94</td>
<td class="xl68" align="right">0.8298</td>
<td>
</td>
<td align="right">82</td>
<td class="xl68" align="right">0.8723</td>
<td>
</td>
<td>
</td>
<td class="xl71">1.0341</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl66" style="height: 15pt;" height="20">pcramrod</td>
<td align="right">186</td>
<td align="right">233</td>
<td class="xl68" align="right">0.7983</td>
<td>
</td>
<td align="right">93</td>
<td class="xl68" align="right">0.3991</td>
<td>
</td>
<td>
</td>
<td class="xl71">1.0909</td>
</tr>
<tr style="height: 15pt;" height="20">
<td style="height: 15pt;" height="20">have at you</td>
<td align="right">47</td>
<td align="right">60</td>
<td class="xl68" align="right">0.7833</td>
<td>
</td>
<td align="right">20</td>
<td class="xl68" align="right">0.3333</td>
<td>
</td>
<td>
</td>
<td class="xl71">0.9243</td>
</tr>
</tbody></table>

pcramrod
07-16-2008, 08:27 PM
Top 5 W-L record( minimum 10 matches played)


<table style="border-collapse: collapse; width: 635pt;" border="0" cellpadding="0" cellspacing="0" width="846"><col style="width: 78pt;" width="104">
<col style="width: 86pt;" width="115">
<col style="width: 65pt;" width="87">
<col style="width: 128pt;" width="170">
<col style="width: 8pt;" width="11">
<col style="width: 71pt;" width="94">
<col style="width: 71pt;" width="95">
<col style="width: 128pt;" width="170">
<tbody><tr style="height: 15pt;" height="20">
<td class="xl69" style="height: 15pt; width: 78pt;" height="20" width="104">
<table style="border-collapse: collapse; width: 591pt;" border="0" cellpadding="0" cellspacing="0" width="788"><col style="width: 78pt;" width="104">
<col style="width: 86pt;" width="115">
<col style="width: 65pt;" width="87">
<col style="width: 84pt;" width="112">
<col style="width: 8pt;" width="11">
<col style="width: 71pt;" width="94">
<col style="width: 71pt;" width="95">
<col style="width: 128pt;" width="170">
<tbody><tr style="height: 15pt;" height="20">
<td class="xl69" style="height: 15pt; width: 78pt;" height="20" width="104">Player</td>
<td class="xl69" style="width: 86pt;" width="115">Rounds Won</td>
<td class="xl69" style="width: 65pt;" width="87">Total Rounds</td>
<td class="xl67" style="width: 84pt;" width="112">Win % by Round</td>
<td class="xl69" style="width: 8pt;" width="11">
</td>
<td class="xl69" style="width: 71pt;" width="94">Matches Won</td>
<td class="xl69" style="width: 71pt;" width="95">Total Matches</td>
<td class="xl67" style="width: 128pt;" width="170">Win % by Match</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">vcize</td>
<td class="xl65">214</td>
<td class="xl65">375</td>
<td class="xl68">0.5707</td>
<td class="xl65">
</td>
<td class="xl65">43</td>
<td class="xl65">64</td>
<td class="xl68">0.6719</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">dsmrider</td>
<td class="xl65">103</td>
<td class="xl65">188</td>
<td class="xl68">0.5479</td>
<td class="xl65">
</td>
<td class="xl65">20</td>
<td class="xl65">31</td>
<td class="xl68">0.6452</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">killbot2600</td>
<td class="xl65">144</td>
<td class="xl65">269</td>
<td class="xl68">0.5353</td>
<td class="xl65">
</td>
<td class="xl65">27</td>
<td class="xl65">45</td>
<td class="xl68">0.6000</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">quasarsquirrel</td>
<td class="xl65">45</td>
<td class="xl65">93</td>
<td class="xl68">0.4839</td>
<td class="xl65">
</td>
<td class="xl65">9</td>
<td class="xl65">17</td>
<td class="xl68">0.5294</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">furrypan</td>
<td class="xl65">187</td>
<td class="xl65">375</td>
<td class="xl68">0.4987</td>
<td class="xl65">
</td>
<td class="xl65">33</td>
<td class="xl65">64</td>
<td class="xl68">0.5156</td>
</tr>
</tbody></table></td>
<td class="xl69" style="width: 86pt;" width="115">
</td>
<td class="xl69" style="width: 65pt;" width="87">
</td>
<td class="xl67" style="width: 128pt;" width="170">
</td>
<td class="xl69" style="width: 8pt;" width="11">
</td>
<td class="xl69" style="width: 71pt;" width="94">
</td>
<td class="xl69" style="width: 71pt;" width="95">
</td>
<td class="xl67" style="width: 128pt;" width="170">
</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">
</td>
<td class="xl65">
</td>
<td class="xl65">
</td>
<td class="xl68">
</td>
<td class="xl65">
</td>
<td class="xl65">
</td>
<td class="xl65">
</td>
<td cla

pcramrod
07-16-2008, 08:31 PM
Highest Kill to Down Ratio



<table x:str="" style="border-collapse: collapse; width: 486pt;" border="0" cellpadding="0" cellspacing="0" width="648"><col style="width: 78pt;" width="104">
<col style="width: 57pt;" width="76">
<col style="width: 68pt;" width="91">
<col style="width: 48pt;" width="64">
<col style="width: 76pt;" width="101">
<col style="width: 9pt;" width="12">
<col style="width: 62pt;" width="83">
<col style="width: 88pt;" width="117">
<tbody><tr style="height: 15pt;" height="20">
<td class="xl67" style="height: 15pt; width: 78pt;" height="20" width="104">Player</td>
<td class="xl68" style="width: 57pt;" width="76">K/D Ratio</td>
<td class="xl67" style="width: 68pt;" width="91">Total Kills</td>
<td class="xl67" style="width: 48pt;" width="64">Rounds</td>
<td class="xl68" style="width: 76pt;" width="101">Kills Per Round</td>
<td class="xl67" style="width: 9pt;" width="12">
</td>
<td class="xl67" style="width: 62pt;" width="83">Total Downs</td>
<td class="xl68" style="width: 88pt;" width="117">Downs Per Round</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">dsmrider</td>
<td class="xl66" x:num="" x:fmla="=C2/G2">6.1500</td>
<td class="xl65" x:num="">123</td>
<td class="xl65" x:num="">188</td>
<td class="xl66" x:num="0.6542553191489362">0.6543</td>
<td class="xl65">
</td>
<td class="xl65" x:num="">20</td>
<td class="xl66" x:num="0.10638297872340426">0.1064</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">furrypan</td>
<td class="xl66" x:num="5.9523809523809526" x:fmla="=C3/G3">5.9524</td>
<td class="xl65" x:num="">125</td>
<td class="xl65" x:num="">382</td>
<td class="xl66" x:num="0.32722513089005234">0.3272</td>
<td class="xl65">
</td>
<td class="xl65" x:num="">21</td>
<td class="xl66" x:num="5.4973821989528798E-2">0.0550</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">tazmanak</td>
<td class="xl66" x:num="" x:fmla="=C4/G4">4.0000</td>
<td class="xl65" x:num="">12</td>
<td class="xl65" x:num="">19</td>
<td class="xl66" x:num="0.63157894736842102">0.6316</td>
<td class="xl65">
</td>
<td class="xl65" x:num="">3</td>
<td class="xl66" x:num="0.15789473684210525">0.1579</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">smok1ngun</td>
<td class="xl66" x:num="3.625" x:fmla="=C5/G5">3.6250</td>
<td class="xl65" x:num="">29</td>
<td class="xl65" x:num="">44</td>
<td class="xl66" x:num="0.65909090909090906">0.6591</td>
<td class="xl65">
</td>
<td class="xl65" x:num="">8</td>
<td class="xl66" x:num="0.18181818181818182">0.1818</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">dvdvampire</td>
<td class="xl66" x:num="3.0416666666666665" x:fmla="=C6/G6">3.0417</td>
<td class="xl65" x:num="">73</td>
<td class="xl65" x:num="">101</td>
<td class="xl66" x:num="0.72277227722772275">0.7228</td>
<td class="xl65">
</td>
<td class="xl65" x:num="">24</td>
<td class="xl66" x:num="0.23762376237623761">0.2376</td>
</tr>
</tbody></table>

pcramrod
07-16-2008, 08:35 PM
Lowest Kill to Down Ratio

<table style="border-collapse: collapse; width: 507pt;" border="0" cellpadding="0" cellspacing="0" width="676"><col style="width: 78pt;" span="2" width="104">
<col style="width: 68pt;" width="91">
<col style="width: 48pt;" width="64">
<col style="width: 76pt;" width="101">
<col style="width: 9pt;" width="12">
<col style="width: 62pt;" width="83">
<col style="width: 88pt;" width="117">
<tbody><tr style="height: 15pt;" height="20">
<td class="xl68" style="height: 15pt; width: 78pt;" height="20" width="104">Player</td>
<td class="xl68" style="width: 78pt;" width="104">K/D Ratio</td>
<td class="xl68" style="width: 68pt;" width="91">Total Kills</td>
<td class="xl68" style="width: 48pt;" width="64">Rounds</td>
<td class="xl66" style="width: 76pt;" width="101">Kills Per Round</td>
<td class="xl68" style="width: 9pt;" width="12">
</td>
<td class="xl68" style="width: 62pt;" width="83">Total Downs</td>
<td class="xl66" style="width: 88pt;" width="117">Downs Per Round</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">wigglycoot</td>
<td class="xl65">0.951219512</td>
<td class="xl65">78</td>
<td class="xl65">94</td>
<td class="xl67">0.8298</td>
<td class="xl65">
</td>
<td class="xl65">82</td>
<td class="xl67">0.8723</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">rakswp</td>
<td class="xl65">1.08</td>
<td class="xl65">27</td>
<td class="xl65">41</td>
<td class="xl67">0.6585</td>
<td class="xl65">
</td>
<td class="xl65">25</td>
<td class="xl67">0.6098</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">darthsn</td>
<td class="xl65">1.230769231</td>
<td class="xl65">16</td>
<td class="xl65">33</td>
<td class="xl67">0.4848</td>
<td class="xl65">
</td>
<td class="xl65">13</td>
<td class="xl67">0.3939</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">kenshiro 26</td>
<td class="xl65">1.263157895</td>
<td class="xl65">24</td>
<td class="xl65">33</td>
<td class="xl67">0.7273</td>
<td class="xl65">
</td>
<td class="xl65">19</td>
<td class="xl67">0.5758</td>
</tr>
<tr style="height: 15pt;" height="20">
<td class="xl65" style="height: 15pt;" height="20">raider x</td>
<td class="xl65">1.285714286</td>
<td class="xl65">9</td>
<td class="xl65">25</td>
<td class="xl67">0.3600</td>
<td class="xl65">
</td>
<td class="xl65">7</td>
<td class="xl67">0.2800</td>
</tr>
</tbody></table>



NOTE: Unsurprisingly, wiggly is the only player thus far to have more downs than kills. Sacks don't get much more bare than that folks.

pcramrod
07-16-2008, 08:44 PM
Finally, here is the spreadsheet I have all the data/results in. The "By Map" and "By Player" workbooks will summarize the data as you would expect. All you have to do is fill in the name of the player or map in the blue-shaded cell. The only catch is that I used a formula to generate this sheets that is found in Excel 2007 only, so older versions of Excel won't work...

If you would like to do any sorting on the tables, you're going to want to do this in the Summary Link-Out or W-L Link-Out pages. You can't sort on formulas, so any sorts on the Summary or Win-Loss workbooks will turn out junk.


Download (http://grove.ufl.edu/%7Ehonors/GoW.xlsx)

QuasarSquirrel
07-16-2008, 09:06 PM
At least I wasn't featured in "most smoke tags recieved" or anything embarassing like that. This seems like a lot of work, nice job there Ramrod [Y]

HolyVVater
07-17-2008, 05:15 AM
dang i need to get in on some games with the stat tracking. work has really got me by the bawls lately.

Bourbon
07-17-2008, 05:49 AM
<P mce_keep="true">
NOTE: <U>Unsurprisingly</U>, wiggly is the only player thus far to have more downs than kills. Sacks don't get much more bare than that folks. LOL! No doubts there.

DarthSN
07-17-2008, 06:19 AM
dang i need to get in on some games with the stat tracking. work has really got me by the bawls lately.

hah, I'm the exact opposite! I need to stay the hell out of those games and the bottom 5 list[:S]

There should be a beer to kill/death ratio as well...

pcramrod
07-17-2008, 06:25 AM
dang i need to get in on some games with the stat tracking. work has really got me by the bawls lately.

hah, I'm the exact opposite! I need to stay the hell out of those games and the bottom 5 listhttp://adultgamingenthusiasts.com/emoticons/emotion-7.gif

There should be a beer to kill/death ratio as well...




Sorry, I mistyped that up there. That's Kill/Down ratio. So it's not necessarily a good or bad thing...

DarthSN
07-17-2008, 06:29 AM
Sorry, I mistyped that up there. That's Kill/Down ratio. So it's not necessarily a good or bad thing...



Oh thank god... I didn't think I was going to be able to join a game again without feeling ashamed .

vcize
07-17-2008, 06:44 AM
It's kind of funny to see how different everyone's round win % compares to their match win %. It seems like the round win % stays a lot closer to the middle (50%).

I wish Gears kept track of teamkills so we could see Bourbon's name in big, bright letters.

pcramrod
07-17-2008, 06:48 AM
It's kind of funny to see how different everyone's round win % compares to their match win %. It seems like the round win % stays a lot closer to the middle (50%).



Yeah... I noticed the same thing for my record on the GoW leaderboard also.

vcize
07-17-2008, 06:57 AM
Haha, dangit, I downloaded the '07 Excel viewer for the by map and by player results, but I can't type into the map/player fields using that. Guess I'll need to pick up a full version of office '07 real quick...

Figures it would pull up Raven Down by default, lol.

pcramrod
07-17-2008, 07:00 AM
Haha, dangit, I downloaded the '07 Excel viewer for the by map and by player results, but I can't type into the map/player fields using that. Guess I'll need to pick up a full version of office '07 real quick...

Figures it would pull up Raven Down by default, lol.



Noob. You should be able to type in the map name in Excel 03, then open it with the viewer, I would think.

vcize
07-17-2008, 05:11 PM
Lol, you can tell which maps I like and which I don't.

Kills per round on Rooftops: 2.033
Kills per round on Raven Down: 0.697

Bourbon
07-17-2008, 05:16 PM
<P mce_keep="true">



Lol, you can tell which maps I like and which I don't.


Kills per round on Rooftops: 2.033
Kills per round on Raven Down: 0.697


It's always easy to tell the noob maps. Noobs just don't like Rooftops, they like Raven Down, which clearly favors the noob.

DslRider
07-17-2008, 05:23 PM
Downing is for noobs. [bx]

fooburger
07-18-2008, 08:01 AM
Lol, you can tell which maps I like and which I don't.


Kills per round on Rooftops: 2.033
Kills per round on Raven Down: 0.697


It's always easy to tell the noob maps. Noobs just don't like Rooftops, they like Raven Down, which clearly favors the noob.



I knew I was a total nub, I hate Rooftops and love Raven Down.

munds3
07-21-2008, 11:07 AM
<P mce_keep="true">PCramrod, sorry if I'm noob lost here, but is this from a tourney, specific folks,or everyone? I'm at work so I can't look at till I get home.
<P mce_keep="true">

pcramrod
07-21-2008, 11:31 AM
PCramrod, sorry if I'm noob lost here, but is this from a tourney, specific folks,or everyone? I'm at work so I can't look at till I get home.






This isn't from anything specific. I think I have some game data with you in it, but I'm not sure if I have inputted it yet...

munds3
07-21-2008, 11:33 AM
<P mce_keep="true">







PCramrod, sorry if I'm noob lost here, but is this from a tourney, specific folks,or everyone? I'm at work so I can't look at till I get home.
<P mce_keep="true">





This isn't from anything specific. I think I have some game data with you in it, but I'm not sure if I have inputted it yet...






If you get a moment please do, I'm double curios what the numbers look like! Thanks!

btcs41
07-21-2008, 11:37 AM
<P mce_keep="true">i think i got those numbers munds.
<P mce_keep="true">
<P mce_keep="true">number of shots fired at opponents: 17,000
<P mce_keep="true">
<P mce_keep="true">number hit: 0
<P mce_keep="true">
<P mce_keep="true">accuracy: 0%
<P mce_keep="true">
<P mce_keep="true">number of opponent armor layers: 3
<P mce_keep="true">
<P mce_keep="true">Percent you were killed by lag: 100
<P mce_keep="true">
<P mce_keep="true">Theres more, I just need to get back to work.

munds3
07-21-2008, 11:40 AM
<P mce_keep="true">



i think i got those numbers munds.
<P mce_keep="true">


number of shots fired at opponents: 17,000
<P mce_keep="true">


number hit: 0
<P mce_keep="true">


accuracy: 0%
<P mce_keep="true">


number of opponent armor layers: 3
<P mce_keep="true">


Percent you were killed by lag: 100
<P mce_keep="true">


Theres more, I just need to get back to work.





[ro] but I think I'd like to see pcrammrod's numbers too!
<P mce_keep="true">


P.S. I think 17,000 is too many as I tend to die in the first 5 seconds of many rounds and don't get to shoot!

WideNine
07-21-2008, 12:23 PM
i think i got those numbers munds.





number of shots fired at opponents: 17,000





number hit: 0





accuracy: 0%





number of opponent armor layers: 3





Percent you were killed by lag: 100





Theres more, I just need to get back to work.



That was quite funny. You forgot number of phantom grenade kills.

munds3
07-21-2008, 01:44 PM
<P mce_keep="true">







i think i got those numbers munds.
<P mce_keep="true">


number of shots fired at opponents: 17,000
<P mce_keep="true">


number hit: 0
<P mce_keep="true">


accuracy: 0%
<P mce_keep="true">


number of opponent armor layers: 3
<P mce_keep="true">


Percent you were killed by lag: 100
<P mce_keep="true">


Theres more, I just need to get back to work.





That was quite funny. You forgot number of phantom grenade kills.
<P mce_keep="true">
<P mce_keep="true">





Widenine (in 3 quarters time) ref my reply to Btcs41, I'm sure my early deaths are from your snipers or phatom grenades! [:D]

munds3
07-30-2008, 04:35 PM
PCramrod, sorry if I'm noob lost here, but is this from a tourney, specific folks,or everyone? I'm at work so I can't look at till I get home.






This isn't from anything specific. I think I have some game data with you in it, but I'm not sure if I have inputted it yet...






PCramrod, finally got the spreadsheet open. did you still have data on me to input? I'm still curious. Thanks!

Downsideup
08-02-2008, 12:40 AM
What are these stats recorded from? A tourney?

vcize
08-02-2008, 01:27 AM
What are these stats recorded from? A tourney?



Just regular nights of Gears.

VDub2174
08-12-2008, 04:00 PM
<P mce_keep="true">I don't seem to be on a list for most deaths in record time.