User Pass
Home Sign Up Contact Log In
Forum > Oceania A Leagues > Oceania A #6 > Oceania A6 Power Rankings, Offense, Defense, etc.
Page:
 
tfk413
offline
Link
 
I decided to try this very in-depth spreadsheet someone gave me, and it looks promising.
It shows everything.. Offensive ranking, and defensive ranking.

Rank ..... Prv …… Offense ............ Defense ...... Team
................................ O/P/R .................. O/P/R
Alpha
... 01 ...... 27 ..... 03 / 15 / 01 ......... 01 / 03 / 03 .... Gotham Dark Knights
... 03 ...... 25 ..... 05 / 04 / 06 ......... 03 / 02 / 05 .... Fiji Tigers
... 04 ...... 22 ..... 01 / 01 / 03 ......... 05 / 10 / 02 .... Navy Snipes
... 06 ...... 01 ..... 02 / 03 / 04 ......... 02 / 01 / 04 .... Suva Tsunami
... 11 ...... 24 ..... 06 / 02 / 15 ......... 07 / 04 / 14 .... Jedi Knights
... 15 ...... 05 ..... 14 / 12 / 13 ......... 14 / 12 / 15 .... Ohlone Warriors
... 18 ...... 29 ..... 16 / 07 / 25 ......... 18 / 22 / 19 .... New York Tigers
... 19 ...... 07 ..... 18 / 13 / 21 ......... 16 / 17 / 16 .... Amishlongs Wrecking Crew
... 20 ...... 09 ..... 22 / 20 / 22 ......... 21 / 07 / 28 .... Newtown Jets
... 21 ...... 15 ..... 20 / 09 / 24 ......... 22 / 19 / 21 .... Pink Punters
... 23 ...... 10 ..... 23 / 18 / 27 ......... 23 / 14 / 25 .... Sydney Sharks
... 23 ...... 23 ..... 29 / 25 / 32 ......... 26 / 28 / 23 .... Orlando Gators
... 25 ...... 06 ..... 25 / 24 / 20 ......... 20 / 11 / 22 .... Guam Turkeys
... 26 ...... 16 ..... 21 / 10 / 26 ......... 25 / 25 / 24 .... Orlando Ninja Pirates
... 28 ...... 20 ..... 24 / 27 / 16 ......... 24 / 16 / 26 .... Padre Sand Crabs
... 31 ...... 28 ..... 27 / 28 / 23 ......... 29 / 27 / 31 .... Compton Skillets
Zeta
... 02 ...... 19 ..... 04 / 06 / 02 ......... 06 / 05 / 10 .... Flipmode Squad (G Unit)
... 05 ...... 13 ..... 09 / 17 / 07 ......... 09 / 06 / 17 .... Somerset Scrumpers
... 06 ...... 14 ..... 13 / 22 / 11 ......... 08 / 09 / 13 .... Los Miami Dominators
... 06 ...... 21 ..... 08 / 08 / 09 ......... 12 / 23 / 07 .... Big Rappa Moai
... 09 ...... 04 ..... 07 / 05 / 10 ......... 04 / 08 / 01 .... My L33tLe Pwnies
... 10 ...... 03 ..... 10 / 19 / 08 ......... 10 / 15 / 06 .... Katrineholm Stallions
... 12 ...... 12 ..... 12 / 26 / 05 ......... 11 / 13 / 11 .... Easter Island Sand Lions
... 13 ...... 08 ..... 11 / 14 / 12 ......... 13 / 24 / 09 .... Nauru Tiger Sharks
... 14 ...... 30 ..... 15 / 11 / 14 ......... 17 / 26 / 08 .... Okinawa Flamethrowers
... 16 ...... 31 ..... 17 / 16 / 17 ......... 15 / 20 / 12 .... Suva Storm
... 17 ...... 32 ..... 19 / 21 / 18 ......... 19 / 21 / 20 .... Papeete Slugs
... 22 ...... 26 ..... 26 / 29 / 19 ......... 27 / 31 / 18 .... Jame's Miracle Workers
... 26 ...... 11 ..... 31 / 32 / 29 ......... 31 / 30 / 29 .... Darwin Lunatics
... 29 ...... 17 ..... 28 / 23 / 31 ......... 32 / 32 / 30 .... Guam Bombers
... 30 ...... 18 ..... 30 / 31 / 28 ......... 28 / 29 / 27 .... Barossa Grapestompers
... 32 ...... 02 ..... 32 / 30 / 30 ......... 30 / 18 / 32 .... Hattrick Srbija


I will update this every game.
Last edited Feb 25, 2009 23:51:53
 
DeviantWolf
offline
Link
 
Interesting. Between the power rankings I am using and these it will be neat to see how things work out/matchup.



 
tfk413
offline
Link
 
Originally posted by DeviantWolf
Interesting. Between the power rankings I am using and these it will be neat to see how things work out/matchup.





yeah for sure.. do yours use actual stats? This had me copy and paste every stat GLB saves.. Passing, Rushing, Blocking, Receiving etc.
Took about an hour 1/2 to do, hopefully the next ones don't take that long, since I know how it's done now

I am not trying to out do yours, just thought this one looked very good
 
DeviantWolf
offline
Link
 
No the one I used was all about the scores only. The power ranking itself actually goes and looks at the teams you beat and who they beat and so on.

IT's found here http://www.glbwiki.com/index.php?title=Power_Ranking_Spreadsheet

And this is the definition of how it's seeded.

Equation

Strength of Record = (Total number of wins of opponents you have defeated) - (Total number of losses of opponents that have beaten you)

Definition

This is measure of how good a team is. It rewards beating good teams and punishes for losing to bad teams.


You don't happen to have a link to the spreadsheet you are using? I wouldn't mind keeping track of that too. I also have the RPI which was posted last year I will be posting, it needs at least two games worth of data though I believe since I am not getting any results right now with just one game, but other parts of it such as projected standings are 'working'

 
DeviantWolf
offline
Link
 
Interesting that the top 6 in Alpha are exactly as they are on the current standings page.
 
tfk413
offline
Link
 
Originally posted by DeviantWolf
Interesting that the top 6 in Alpha are exactly as they are on the current standings page.


Yeah, that is weird... hmm


http://www.garrettdfoster.com/files
it is the .20 version.. the other one was weird, didn't get it
 
DeviantWolf
offline
Link
 
Originally posted by tfk413
Originally posted by DeviantWolf

Interesting that the top 6 in Alpha are exactly as they are on the current standings page.


Yeah, that is weird... hmm


http://www.garrettdfoster.com/files
it is the .20 version.. the other one was weird, didn't get it


Ahh, see what I am using is the 1.0 version of that. Essentially it's the newer version.
 
tfk413
offline
Link
 
Originally posted by DeviantWolf
Originally posted by tfk413

Originally posted by DeviantWolf


Interesting that the top 6 in Alpha are exactly as they are on the current standings page.


Yeah, that is weird... hmm


http://www.garrettdfoster.com/files
it is the .20 version.. the other one was weird, didn't get it


Ahh, see what I am using is the 1.0 version of that. Essentially it's the newer version.


it doesn't show stats and stuff.. not as fluent.. i dunno
 
DeviantWolf
offline
Link
 
Well remember stats aren't everything. It's the win that counts. Who you beat and where they rank that decides how good you are. If you beat good teams you are good, if you loose to bad teams then you aren't that good. Stats can be inflated. Hell you can get a lot of stats without getting the win.

*shrugs*

I think that's why they changed it from stat based to record based.
 
tfk413
offline
Link
 
Originally posted by DeviantWolf
Well remember stats aren't everything. It's the win that counts. Who you beat and where they rank that decides how good you are. If you beat good teams you are good, if you loose to bad teams then you aren't that good. Stats can be inflated. Hell you can get a lot of stats without getting the win.

*shrugs*

I think that's why they changed it from stat based to record based.


this one also is win based.. Does wins, and stats.. of course it wouldn't be just stats..

a team that blows out good teams is obviously not equal to a team that beats them, but barely.
 
Riddler08
offline
Link
 
Hey I feel like an idiot...how do you read this? o/p/r?
 
tfk413
offline
Link
 
Originally posted by Riddler08
Hey I feel like an idiot...how do you read this? o/p/r?


O=Overall
P=Passing
R=Rushing
 
supersonics
offline
Link
 
i cant believe the guam turkeys are higher then the sand crabs!! wtf lol
 
BeanCounter
offline
Link
 
We will see where things shake out this week. We get a good measuring stick game this week vs. one of the better teams in the conference.
 
tfk413
offline
Link
 
Originally posted by BeanCounter
We will see where things shake out this week. We get a good measuring stick game this week vs. one of the better teams in the conference.


yes us too.. we play the 11th ranked team in the league, or 5th in the conference.. they will test our pass defense for sure
 
Page:
 


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