User Pass
Home Sign Up Contact Log In
Forum > Canadian AAA Leagues > Canada AAA #1 > Chiefy's Power Rankings
Page:
 
chiefy27
offline
Link
 
First off, all the team stats are copy/pasted into a spreadsheet and sorted. Then I fill out a matrix to identify which teams have played one another and which team won. Then all this is passed to the first set of matrices which calculates various things about your opponents and basically creates a bunch of averages. This is where I figure out how good your opponents are.

The data from these matrices are passed to a common sheet for all the data I am interested in. A few more things are calculated here (percentages). After this, data is passed to the second set of matrices which simulate out various parts of the season. Things like how many yards you would gain or points allowed. The setup is based on this league projector: http://goallineblitz.com/game/forum_thread.pl?thread_id=447611

The third set of matrices brings everything together and does a comparative analysis to determine who would win a head to head matchup if everyone played all 31 other teams. It then reports to a matrix similar to the one I use to input who won or lost. I then have this matrix dump the wins, losses, and ties into the common sheet. The team with the most wins gets the highest power rank and so on down.

What is taken into account in the determination of who won or lost is this:
-predicted points scored and allowed
-how likely you are to win based on record quality (i.e. who is more likely to beat good teams and not lose to bad ones)
-predicted yards gained and allowed
-predicted amount of turnovers for and against

This is the formula so far

Your points = League average points per game*percent chance of win based on record + the points you are predicted to score + predicted yards / league average yards per point + predicted turnover ratio x 3
Your opponent gets the same formula. The team with the higher number of points wins that game.

I also put offense and defense ranks on there. Right now they are based on the predicted number of yards.

O=Overall
P=Pass
R=Rush

If you are interested in using this spreadsheet head here:
http://goallineblitz.com/game/forum_thread.pl?thread_id=791249
=================================================================================================

======
Week 10
======

Rank ..... Prv …… Offense ............. Defense ....... Team
................................ O/P/R .................. O/P/R

East

... 01 ...... N/A ..... 04 / 07 / 08 ......... 05 / 07 / 07 .... Oshawa Ice Fighters
... 02 ...... N/A ..... 02 / 03 / 07 ......... 03 / 13 / 02 .... Bedford Rats
... 05 ...... N/A ..... 10 / 10 / 11 ......... 13 / 18 / 06 .... Jetnation Dream Team
... 06 ...... N/A ..... 16 / 32 / 01 ......... 12 / 16 / 09 .... Kingston Poopsters
... 07 ...... N/A ..... 01 / 11 / 03 ......... 01 / 05 / 01 .... Thunder Bay Blue Jays
... 08 ...... N/A ..... 08 / 09 / 10 ......... 06 / 03 / 11 .... Memphis Rage
... 15 ...... N/A ..... 15 / 12 / 17 ......... 17 / 17 / 16 .... Springfield Spiderpigs
... 16 ...... N/A ..... 20 / 19 / 18 ......... 19 / 12 / 22 .... Springfield Atoms
... 18 ...... N/A ..... 13 / 04 / 19 ......... 20 / 19 / 20 .... Rebel Outpost Actuarials
... 21 ...... N/A ..... 21 / 16 / 23 ......... 21 / 21 / 21 .... Kamloops Caribou
... 22 ...... N/A ..... 24 / 06 / 32 ......... 28 / 27 / 27 .... Montreal Royale
... 24 ...... N/A ..... 23 / 17 / 26 ......... 24 / 24 / 24 .... NLS High Rollers
... 25 ...... N/A ..... 25 / 31 / 20 ......... 23 / 22 / 25 .... Barrie Baycats
... 28 ...... N/A ..... 27 / 25 / 27 ......... 25 / 23 / 26 .... Miami Energy
... 29 ...... N/A ..... 28 / 30 / 24 ......... 29 / 28 / 30 .... Geneseo Mean Machine
... 31 ...... N/A ..... 30 / 23 / 29 ......... 31 / 30 / 32 .... Shadow Lions

West

... 03 ...... N/A ..... 03 / 01 / 14 ......... 09 / 10 / 10 .... Kansas City Double Deuce
... 04 ...... N/A ..... 09 / 20 / 05 ......... 08 / 14 / 05 .... Pittsburgh Iron Men
... 09 ...... N/A ..... 06 / 08 / 09 ......... 02 / 01 / 03 .... Nanaimo 9ers
... 10 ...... N/A ..... 05 / 14 / 04 ......... 07 / 11 / 04 .... Ajax Odyssey
... 11 ...... N/A ..... 11 / 29 / 02 ......... 04 / 02 / 08 .... London Angels
... 12 ...... N/A ..... 14 / 15 / 15 ......... 11 / 09 / 12 .... Spokane Angry Pirates......ARRRGH
... 13 ...... N/A ..... 07 / 05 / 12 ......... 14 / 08 / 15 .... St. Catharines Storm
... 14 ...... N/A ..... 19 / 18 / 16 ......... 15 / 06 / 18 .... Crotch Lake Prairie Oysters
... 17 ...... N/A ..... 17 / 02 / 21 ......... 10 / 04 / 14 .... Chilliwack Sabres
... 19 ...... N/A ..... 12 / 13 / 13 ......... 16 / 15 / 17 .... Vancouver Lions
... 20 ...... N/A ..... 18 / 22 / 06 ......... 18 / 20 / 13 .... Port Moody Privateers
... 23 ...... N/A ..... 22 / 21 / 22 ......... 22 / 25 / 19 .... Manitoba Maniacs
... 26 ...... N/A ..... 26 / 28 / 25 ......... 26 / 29 / 23 .... Manitoba Direwolves
... 27 ...... N/A ..... 32 / 27 / 31 ......... 30 / 32 / 29 .... North Delta Grizzlies
... 30 ...... N/A ..... 29 / 24 / 28 ......... 27 / 26 / 28 .... Indigenous Warriors
... 32 ...... N/A ..... 31 / 26 / 30 ......... 32 / 31 / 31 .... Regina Renegades

======
Week 11
======

Rank ..... Prv …… Offense ............. Defense ....... Team
................................ O/P/R .................. O/P/R

East

... 01 ...... 01 ..... 04 / 06 / 08 ......... 04 / 06 / 04 .... Oshawa Ice Fighters
... 03 ...... 05 ..... 08 / 08 / 10 ......... 13 / 18 / 08 .... Jetnation Dream Team
... 05 ...... 06 ..... 11 / 32 / 01 ......... 10 / 14 / 09 .... Kingston Poopsters
... 06 ...... 02 ..... 02 / 05 / 06 ......... 05 / 13 / 02 .... Bedford Rats
... 07 ...... 08 ..... 09 / 10 / 11 ......... 03 / 02 / 07 .... Memphis Rage
... 08 ...... 07 ..... 01 / 11 / 03 ......... 01 / 04 / 01 .... Thunder Bay Blue Jays
... 15 ...... 16 ..... 20 / 19 / 18 ......... 18 / 09 / 21 .... Springfield Atoms
... 16 ...... 15 ..... 15 / 12 / 16 ......... 16 / 17 / 16 .... Springfield Spiderpigs
... 18 ...... 18 ..... 16 / 03 / 19 ......... 20 / 20 / 20 .... Rebel Outpost Actuarials
... 20 ...... 21 ..... 21 / 15 / 23 ......... 22 / 22 / 22 .... Kamloops Caribou
... 23 ...... 22 ..... 24 / 07 / 32 ......... 28 / 27 / 28 .... Montreal Royale
... 24 ...... 24 ..... 23 / 18 / 26 ......... 24 / 25 / 25 .... NLS High Rollers
... 25 ...... 25 ..... 25 / 31 / 21 ......... 23 / 21 / 24 .... Barrie Baycats
... 28 ...... 28 ..... 27 / 22 / 27 ......... 25 / 24 / 26 .... Miami Energy
... 29 ...... 29 ..... 28 / 29 / 24 ......... 29 / 28 / 30 .... Geneseo Mean Machine
... 31 ...... 31 ..... 30 / 27 / 29 ......... 31 / 30 / 32 .... Shadow Lions

West

... 02 ...... 03 ..... 03 / 01 / 15 ......... 09 / 12 / 10 .... Kansas City Double Deuce
... 04 ...... 04 ..... 10 / 21 / 04 ......... 08 / 16 / 05 .... Pittsburgh Iron Men
... 09 ...... 09 ..... 07 / 09 / 09 ......... 02 / 01 / 03 .... Nanaimo 9ers
... 10 ...... 10 ..... 05 / 14 / 05 ......... 07 / 15 / 06 .... Ajax Odyssey
... 11 ...... 11 ..... 12 / 30 / 02 ......... 06 / 03 / 11 .... London Angels
... 12 ...... 12 ..... 17 / 16 / 14 ......... 11 / 10 / 12 .... Spokane Angry Pirates......ARRRGH
... 13 ...... 14 ..... 18 / 17 / 17 ......... 15 / 05 / 19 .... Crotch Lake Prairie Oysters
... 14 ...... 13 ..... 06 / 04 / 13 ......... 14 / 08 / 15 .... St. Catharines Storm
... 17 ...... 17 ..... 14 / 02 / 22 ......... 12 / 07 / 13 .... Chilliwack Sabres
... 19 ...... 19 ..... 13 / 13 / 12 ......... 17 / 11 / 17 .... Vancouver Lions
... 21 ...... 20 ..... 19 / 24 / 07 ......... 19 / 19 / 14 .... Port Moody Privateers
... 22 ...... 23 ..... 22 / 20 / 20 ......... 21 / 23 / 18 .... Manitoba Maniacs
... 26 ...... 26 ..... 26 / 25 / 25 ......... 26 / 29 / 23 .... Manitoba Direwolves
... 27 ...... 27 ..... 31 / 28 / 30 ......... 30 / 32 / 29 .... North Delta Grizzlies
... 30 ...... 30 ..... 29 / 23 / 28 ......... 27 / 26 / 27 .... Indigenous Warriors
... 32 ...... 32 ..... 32 / 26 / 31 ......... 32 / 31 / 31 .... Regina Renegades
Last edited Dec 1, 2008 14:18:15
 
TrevJo
offline
Link
 
I like the formatting. What do the different columns mean?
 
chiefy27
offline
Link
 
Originally posted by TrevJo
I like the formatting. What do the different columns mean?


Oops. I forgot the headings.

Updated.
 
Unspoken
offline
Link
 
Oh geez chiefy why do you go and do this to yourself. You know Wolf will tear you a new one.
 
chiefy27
offline
Link
 
Originally posted by Unspoken
Oh geez chiefy why do you go and do this to yourself. You know Wolf will tear you a new one.


LOL. I missed the good ol' days.
 
Unspoken
offline
Link
 
haha, geez I think we should have a pool on how long his rant is going to be. And the guy is a big part of my team to boot. haha
 
chiefy27
offline
Link
 
I show you guys as the #2 team in the league and #1 in the East. Can he really be that pissed about it?

I think I know the answer.
 
Unspoken
offline
Link
 
He will say that because we beat you guys twice last year that we should be ranked about you guys. Personally I think we belong about 5th or 6th in the east. We are only ranked there cause of our relaxed schedule so far.
 
Sik Wit It
offline
Link
 
Nice rankings. Thanks for doing these.
 
The Wolf
offline
Link
 
.
 
Sihtric
offline
Link
 
Originally posted by The Wolf
.


LMAO
 
Unspoken
offline
Link
 
Originally posted by The Wolf
.


haha to funny.

Come on I know you better then that, its eating at you. Say something. haha
Last edited Nov 18, 2008 15:58:46
 
The Wolf
offline
Link
 
 
The Wolf
offline
Link
 
But seriously. This ranking reflects on what has happened (for this seasons only and includes no history of the teams)and has nothing to do with what will happen. Play some tough games you are penalized, play some CPU gutted teams and it makes you out to be a god.
Last edited Nov 18, 2008 16:05:32
 
The Wolf
offline
Link
 
And thanks Chiefy, you gave me a good laugh tonight.
 
Page:
 


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