User Pass
Home Sign Up Contact Log In
Forum > Europe West AAA League > Europe West AAA #1 > Season 7 ALPHA Pro Bowl Voting
Page:
 
carnitastaco
offline
Link
 
:heart: semisober changing stats and making all Oslo players look awesome

is there a way to sort conference stats by position that I am unaware of? or failing that an easy way to import into excel?
Last edited Feb 2, 2009 14:32:10
 
semisober
offline
Link
 
I applied the following methodology to all rushers with over 1000 yards.

1) Strip out all games played against gutted teams.
2) Calculate new per game averages for each player.
3) Assume they had exactly those averages for their game against the gutted player.
4) Add these substitute stats for the gutted games to their cleaned totals.

This comes up with the following stats:

Adjusted Stats
Rush Rush/G Yds Avg Yds/G TD
Harald Bluetooth 426 26.6 2694.5 6.3 168.4 34
Iowa Jones 426 26.6 2966 7 185.4 28
Griff Oberwald 406 25.4 2514 6.2 157.1 41
Jaquan-Juan Tomba 282 17.6 2042 7.3 127.6 38
Walter. Sobchak 421 26.3 1777.5 4.2 111.1 21
Emmitt Sanders 262 16.4 1013 3.9 63.3 4
Major Mayhem 251 15.7 1481.5 5.9 92.6 18
The Smoke 251 15.7 1200.5 4.8 75 9
Dozer Rush 194 12.1 1326 6.8 82.9 16
Cy Q. Out 207 12.9 805.5 3.9 50.4 7
Qwik Feet 201 12.5 994.5 5 62.2 9
James Smythe 255 15.9 1018.5 4 63.6 21
Billy Armstrong 262 16.4 990.5 3.8 61.9 11
Svend Jackson 150 9.4 810 5.4 50.6 22
Cerwin Vega 81 5.1 353.5 4.4 22.1 9
 
carnitastaco
offline
Link
 
posting as an open google spreadsheet could be awesome...
 
Luke Pass
offline
Link
 
HB Iowa Jones looks like one of the tops on this list, too bad we shared Goalline TD's with our backups to keep them happy
 
Mavooo
offline
Link
 
did you also strip the first game since it was a game vs Zeta. And not everyone played the same level of competition.

Not trying to give you more to do then you already have or anything, lol
 
semisober
offline
Link
 
As an example:

For Harald Bluetooth, he lost 3 games totaling 62 rushes for 1489.5 yards and 40 TDs.

Removing these, Harald averaged 26.6 rushes per game, 168.4 yards per game, and 2 TDs per game.

I replaced the stats from the 3 gutted games with 80 rushes for 505 yards and 6 TDs to come out with his new "projected" season stats.
 
Mavooo
offline
Link
 
ok i see what ur saying
 
semisober
offline
Link
 
It is obviously not ideal, but I think it is pretty close and I am having a hard time coming up with anything more "fair".
 
carnitastaco
offline
Link
 
can you specify which games you took out? Zeta/Manchester/Rotterdam?
 
semisober
offline
Link
 
Those were the 3 that were in contention to be removed. I have the spreadsheet and will post it once I can connect to Google Docs.
 
semisober
offline
Link
 
I am doing QBs now.
 
Mavooo
offline
Link
 
But are you taking them off only the teams that they need to be taken off. Like the teams that played Rocherster and Rotterdam before the changeover.

 
semisober
offline
Link
 
Yds Comp Att Pct Att/G Yds/G Yds/Att Yds/Comp TD Int
Firestorm 5292.5 489 788 62.1 49.3 330.8 6.7 10.8 50 16
Powers 4574 425 674 63.1 42.1 285.9 6.8 10.8 44 16
Walker 4514.5 479 773 62 48.3 282.2 5.8 9.4 27 13
Hotrod 4177.5 460 623 73.8 38.9 261.1 6.7 9.1 37 13
Taylor 4483 438 656 66.8 41 280.2 6.8 10.2 18 11
George 4052 444 649 68.4 40.6 253.3 6.2 9.1 31 12
Carroll 3136 321 535 60 33.4 196 5.9 9.8 22 11
Magic 2748 265 419 63.2 26.2 171.8 6.6 10.4 17 9
Partov 3007 347 587 59.1 36.7 187.9 5.1 8.7 17 17
Lassiter 2971 319 720 44.3 45 185.7 4.1 9.3 18 16
Bee 2845 242 423 57.2 26.4 177.8 6.7 11.8 19 10
Horeshack 2649 284 400 71 25 165.6 6.6 9.3 16 6
 
semisober
offline
Link
 
Only teams that played them when they were gutted are having the stats removed.
 
semisober
offline
Link
 
Firestorm played 0 gutted teams.. even more impressive that.
 
Page:
 


You are not logged in. Please log in if you want to post a reply.