User Pass
Home Sign Up Contact Log In
Forum > South America A Leagues > South America A #2 > Chiefy's League 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 13
======

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

Alpha

... 02 ...... 02 ..... 01 / 01 / 13 ......... 05 / 04 / 05 .... United States Border Patrol
... 05 ...... 06 ..... 05 / 06 / 05 ......... 03 / 05 / 03 .... Mato Grosso Onslaught
... 06 ...... 05 ..... 06 / 04 / 11 ......... 04 / 06 / 02 .... San Juan Diseased Monkeys
... 07 ...... 07 ..... 09 / 12 / 12 ......... 08 / 11 / 07 .... La Plata Annihilators
... 09 ...... 09 ..... 10 / 24 / 03 ......... 06 / 02 / 08 .... Curitiba Hitmen
... 11 ...... 11 ..... 14 / 23 / 08 ......... 14 / 18 / 11 .... Brooklyn Ballers
... 12 ...... 12 ..... 07 / 03 / 14 ......... 12 / 17 / 13 .... Rio de Janeiro Smut Peddlers
... 15 ...... 13 ..... 13 / 07 / 15 ......... 13 / 20 / 09 .... Aruba Chupacabras
... 16 ...... 16 ..... 17 / 10 / 16 ......... 19 / 16 / 19 .... Machu Picchu Beatchu
... 20 ...... 20 ..... 20 / 16 / 21 ......... 21 / 23 / 18 .... Costa Rica Jaguars
... 21 ...... 21 ..... 23 / 25 / 19 ......... 18 / 10 / 21 .... Santiago Bears
... 23 ...... 23 ..... 21 / 18 / 20 ......... 23 / 27 / 22 .... Santa Cruz Magicians
... 24 ...... 24 ..... 25 / 17 / 27 ......... 24 / 28 / 25 .... Yoshi's Pals
... 26 ...... 26 ..... 27 / 31 / 24 ......... 27 / 30 / 24 .... Carolina Wildcats
... 30 ...... 30 ..... 29 / 27 / 28 ......... 30 / 25 / 29 .... Fortaleza Mountain Goats
... 31 ...... 31 ..... 30 / 30 / 31 ......... 25 / 29 / 26 .... Bogota Snowmen

Zeta

... 01 ...... 01 ..... 02 / 11 / 01 ......... 01 / 01 / 01 .... Yucatan Dirtyleg
... 03 ...... 03 ..... 04 / 05 / 02 ......... 02 / 03 / 06 .... South Texas Death Squad
... 04 ...... 04 ..... 03 / 02 / 06 ......... 07 / 08 / 04 .... Dayton Who Dey Bengals
... 08 ...... 08 ..... 11 / 21 / 04 ......... 09 / 12 / 12 .... Cali Wave
... 10 ...... 10 ..... 08 / 13 / 07 ......... 10 / 15 / 14 .... Chile Cheese Dogs
... 13 ...... 14 ..... 12 / 15 / 10 ......... 17 / 22 / 15 .... LARS ULRICH'S GROUP
... 14 ...... 15 ..... 15 / 19 / 09 ......... 15 / 21 / 10 .... Bogota Pushers
... 17 ...... 17 ..... 16 / 08 / 18 ......... 16 / 14 / 17 .... Walburg Zion Dragons
... 18 ...... 18 ..... 19 / 14 / 23 ......... 11 / 09 / 16 .... BLS Mafia
... 19 ...... 19 ..... 18 / 09 / 17 ......... 22 / 19 / 20 .... Chicago Monsters of the Midway
... 22 ...... 22 ..... 22 / 22 / 22 ......... 20 / 07 / 23 .... Midwest Bowhunters
... 25 ...... 25 ..... 26 / 28 / 25 ......... 28 / 26 / 27 .... Amazon Anacondas
... 27 ...... 27 ..... 24 / 20 / 26 ......... 29 / 24 / 28 .... Almaty Titans
... 28 ...... 28 ..... 31 / 32 / 30 ......... 31 / 31 / 30 .... NoVa Warriors
... 29 ...... 29 ..... 28 / 26 / 29 ......... 32 / 32 / 32 .... Washington D.C. Homeless
... 32 ...... 32 ..... 32 / 29 / 32 ......... 26 / 13 / 31 .... Portsmouth Virginians

======
Week 14
======

No Rankings

======
Week 15
======

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

Alpha

... 02 ...... N/A ..... 02 / 01 / 13 ......... 05 / 06 / 05 .... United States Border Patrol
... 05 ...... N/A ..... 05 / 04 / 11 ......... 03 / 05 / 02 .... San Juan Diseased Monkeys
... 06 ...... N/A ..... 06 / 07 / 05 ......... 04 / 04 / 06 .... Mato Grosso Onslaught
... 07 ...... N/A ..... 11 / 26 / 02 ......... 07 / 03 / 07 .... Curitiba Hitmen
... 09 ...... N/A ..... 12 / 12 / 12 ......... 08 / 09 / 08 .... La Plata Annihilators
... 11 ...... N/A ..... 13 / 22 / 06 ......... 14 / 21 / 10 .... Brooklyn Ballers
... 12 ...... N/A ..... 07 / 03 / 14 ......... 12 / 17 / 13 .... Rio de Janeiro Smut Peddlers
... 15 ...... N/A ..... 16 / 10 / 15 ......... 13 / 19 / 09 .... Aruba Chupacabras
... 16 ...... N/A ..... 17 / 11 / 16 ......... 18 / 15 / 20 .... Machu Picchu Beatchu
... 20 ...... N/A ..... 19 / 14 / 20 ......... 22 / 24 / 18 .... Costa Rica Jaguars
... 21 ...... N/A ..... 23 / 25 / 18 ......... 20 / 13 / 23 .... Santiago Bears
... 22 ...... N/A ..... 20 / 17 / 21 ......... 23 / 23 / 21 .... Santa Cruz Magicians
... 24 ...... N/A ..... 24 / 18 / 27 ......... 24 / 27 / 25 .... Yoshi's Pals
... 26 ...... N/A ..... 27 / 30 / 25 ......... 27 / 30 / 24 .... Carolina Wildcats
... 29 ...... N/A ..... 30 / 29 / 29 ......... 26 / 29 / 26 .... Bogota Snowmen
... 31 ...... N/A ..... 29 / 27 / 28 ......... 30 / 26 / 28 .... Fortaleza Mountain Goats

Zeta

... 01 ...... N/A ..... 01 / 09 / 01 ......... 01 / 01 / 01 .... Yucatan Dirtyleg
... 03 ...... N/A ..... 04 / 05 / 03 ......... 02 / 02 / 03 .... South Texas Death Squad
... 04 ...... N/A ..... 03 / 02 / 10 ......... 06 / 07 / 04 .... Dayton Who Dey Bengals
... 08 ...... N/A ..... 10 / 21 / 04 ......... 09 / 12 / 11 .... Cali Wave
... 10 ...... N/A ..... 08 / 13 / 07 ......... 10 / 16 / 12 .... Chile Cheese Dogs
... 13 ...... N/A ..... 09 / 15 / 08 ......... 17 / 22 / 15 .... LARS ULRICH'S GROUP
... 14 ...... N/A ..... 15 / 19 / 09 ......... 15 / 18 / 14 .... Bogota Pushers
... 17 ...... N/A ..... 18 / 08 / 19 ......... 16 / 11 / 17 .... Walburg Zion Dragons
... 18 ...... N/A ..... 14 / 06 / 17 ......... 21 / 20 / 19 .... Chicago Monsters of the Midway
... 19 ...... N/A ..... 21 / 16 / 23 ......... 11 / 08 / 16 .... BLS Mafia
... 23 ...... N/A ..... 22 / 20 / 22 ......... 19 / 14 / 22 .... Midwest Bowhunters
... 25 ...... N/A ..... 25 / 28 / 24 ......... 29 / 28 / 27 .... Amazon Anacondas
... 27 ...... N/A ..... 26 / 24 / 26 ......... 28 / 25 / 29 .... Almaty Titans
... 28 ...... N/A ..... 31 / 32 / 30 ......... 31 / 31 / 30 .... NoVa Warriors
... 30 ...... N/A ..... 28 / 23 / 31 ......... 32 / 32 / 32 .... Washington D.C. Homeless
... 32 ...... N/A ..... 32 / 31 / 32 ......... 25 / 10 / 31 .... Portsmouth Virginians
Last edited Dec 9, 2008 10:26:39
 
Hoates
offline
Link
 
This is awesome

thanks!
 
dhannon1881
offline
Link
 
i think you mixed up who's in alpha and who's in zeta
 
chiefy27
offline
Link
 
Originally posted by dhannon1881
i think you mixed up who's in alpha and who's in zeta


I totally messed up the whole thing. Fixing it right now.
 
headsplint
offline
Link
 
I want to see..... I want to see!!!!!!!
 
chiefy27
offline
Link
 
Updated. Hope its right this time .
 
SenorPoppy
offline
Link
 
wow you are an asshole awesome post!
+100
 
chiefy27
offline
Link
 
Originally posted by SenorPoppy
wow you are an asshole awesome post!
+100


How am I an asshole?
 
headsplint
offline
Link
 
Great job man! Thanks for doing this.
 
Ksera
offline
Link
 
chiefy27, he is a troll, ignore him. gj!
 
Hoates
offline
Link
 
Question - so it says that USBP has only the 27th top offense ? - I think that is wrong
 
chiefy27
offline
Link
 
Originally posted by Hoates
Question - so it says that USBP has only the 27th top offense ? - I think that is wrong


Good catch. Updated.
 
headsplint
offline
Link
 
Originally posted by Hoates
Question - so it says that USBP has only the 27th top offense ? - I think that is wrong


Yeah kind of how the Almaty Titans are ranked #1 overall and in passing.
 
headsplint
offline
Link
 
Ah I see, looks right now across the board
 
Hoates
offline
Link
 
Originally posted by headsplint
Ah I see, looks right now across the board


Yep -looks right to me
 
Page:
 


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