User Pass
Home Sign Up Contact Log In
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 15
======

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

Alpha

... 01 ...... 01 ..... 06 / 17 / 04 ......... 01 / 01 / 03 .... Singapore J.B. Lions
... 04 ...... 04 ..... 10 / 22 / 05 ......... 04 / 03 / 07 .... Subic Bay Admirals
... 05 ...... 07 ..... 01 / 05 / 03 ......... 05 / 13 / 02 .... Sumatra Sting
... 06 ...... 08 ..... 05 / 21 / 02 ......... 08 / 11 / 08 .... Hakone Heroes
... 11 ...... 12 ..... 20 / 15 / 17 ......... 09 / 02 / 13 .... Burma Black Dragons
... 12 ...... 11 ..... 19 / 23 / 10 ......... 12 / 12 / 15 .... Seoul Snatchers
... 13 ...... 13 ..... 13 / 02 / 22 ......... 15 / 17 / 12 .... Surabaya Poison Dart Frogs
... 17 ...... 17 ..... 22 / 10 / 24 ......... 13 / 04 / 20 .... Asbury Park Rat Pack
... 18 ...... 18 ..... 18 / 12 / 19 ......... 22 / 21 / 25 .... Panay Phoenix
... 21 ...... 20 ..... 24 / 19 / 21 ......... 16 / 09 / 21 .... Manheim Magic
... 22 ...... 23 ..... 25 / 30 / 18 ......... 17 / 14 / 19 .... Hong Kong Triads
... 25 ...... 25 ..... 23 / 14 / 23 ......... 26 / 32 / 18 .... Singapore Stallions
... 26 ...... 26 ..... 26 / 16 / 26 ......... 23 / 20 / 26 .... Phnom Penh Samurai
... 28 ...... 28 ..... 29 / 27 / 30 ......... 30 / 28 / 29 .... Rancho Cucamonga Killaz
... 29 ...... 29 ..... 30 / 32 / 27 ......... 27 / 22 / 27 .... Bangar PEACEING PUNISHINGMENTS
... 32 ...... 32 ..... 28 / 18 / 31 ......... 28 / 19 / 28 .... Phuket Paupers

Zeta

... 02 ...... 04 ..... 02 / 04 / 09 ......... 06 / 07 / 06 .... Shanghai Cheetahs
... 03 ...... 03 ..... 07 / 11 / 08 ......... 03 / 05 / 04 .... Lea Lea Furniture
... 07 ...... 04 ..... 04 / 26 / 01 ......... 02 / 08 / 01 .... Georgetown United
... 08 ...... 02 ..... 14 / 24 / 06 ......... 11 / 25 / 05 .... Palembang Tigers
... 09 ...... 09 ..... 15 / 25 / 07 ......... 07 / 06 / 09 .... Brutal Deluxe
... 10 ...... 10 ..... 03 / 01 / 14 ......... 21 / 27 / 17 .... Jakarta Wolves
... 14 ...... 15 ..... 09 / 08 / 15 ......... 14 / 18 / 11 .... Manila Gorillas
... 15 ...... 14 ..... 08 / 09 / 12 ......... 10 / 10 / 10 .... Taipei Yonghe soybean milk
... 16 ...... 16 ..... 12 / 07 / 16 ......... 18 / 24 / 16 .... Maldives Munching Moles
... 19 ...... 19 ..... 21 / 28 / 13 ......... 19 / 26 / 14 .... Beijing Drifters
... 20 ...... 21 ..... 11 / 03 / 20 ......... 20 / 23 / 23 .... Chiang Mai chiefs
... 23 ...... 22 ..... 17 / 20 / 11 ......... 24 / 31 / 22 .... Taipei Thunder
... 24 ...... 24 ..... 16 / 06 / 25 ......... 25 / 29 / 24 .... Laos Chaos
... 27 ...... 27 ..... 27 / 13 / 28 ......... 29 / 16 / 30 .... Los Angeles Kryptonite
... 30 ...... 31 ..... 32 / 31 / 29 ......... 32 / 15 / 32 .... The Zoolander School For Kids Who Can't Read Good
... 31 ...... 30 ..... 31 / 29 / 32 ......... 31 / 30 / 31 .... Seoul Patrol

======
Week 16
======

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

Alpha

... 01 ...... 01 ..... 06 / 19 / 03 ......... 01 / 01 / 03 .... Singapore J.B. Lions
... 02 ...... 04 ..... 09 / 21 / 05 ......... 05 / 04 / 06 .... Subic Bay Admirals
... 03 ...... 05 ..... 01 / 07 / 04 ......... 03 / 13 / 02 .... Sumatra Sting
... 04 ...... 06 ..... 04 / 23 / 01 ......... 07 / 12 / 08 .... Hakone Heroes
... 10 ...... 11 ..... 20 / 14 / 17 ......... 09 / 02 / 14 .... Burma Black Dragons
... 11 ...... 12 ..... 16 / 22 / 10 ......... 13 / 11 / 13 .... Seoul Snatchers
... 12 ...... 13 ..... 13 / 02 / 22 ......... 12 / 15 / 11 .... Surabaya Poison Dart Frogs
... 16 ...... 17 ..... 22 / 12 / 24 ......... 14 / 03 / 20 .... Asbury Park Rat Pack
... 18 ...... 18 ..... 19 / 13 / 19 ......... 22 / 21 / 24 .... Panay Phoenix
... 19 ...... 21 ..... 24 / 20 / 20 ......... 16 / 09 / 19 .... Manheim Magic
... 22 ...... 25 ..... 23 / 15 / 23 ......... 24 / 31 / 18 .... Singapore Stallions
... 23 ...... 22 ..... 25 / 30 / 16 ......... 17 / 14 / 21 .... Hong Kong Triads
... 25 ...... 26 ..... 26 / 16 / 26 ......... 23 / 19 / 26 .... Phnom Penh Samurai
... 28 ...... 28 ..... 29 / 28 / 29 ......... 30 / 27 / 29 .... Rancho Cucamonga Killaz
... 29 ...... 29 ..... 30 / 32 / 27 ......... 26 / 20 / 27 .... Bangar PEACEING PUNISHINGMENTS
... 32 ...... 32 ..... 28 / 18 / 31 ......... 28 / 25 / 28 .... Phuket Paupers

Zeta

... 05 ...... 02 ..... 02 / 05 / 09 ......... 06 / 06 / 07 .... Shanghai Cheetahs
... 06 ...... 03 ..... 07 / 10 / 08 ......... 04 / 07 / 04 .... Lea Lea Furniture
... 07 ...... 07 ..... 05 / 26 / 02 ......... 02 / 05 / 01 .... Georgetown United
... 08 ...... 08 ..... 14 / 24 / 06 ......... 11 / 22 / 05 .... Palembang Tigers
... 09 ...... 09 ..... 15 / 27 / 07 ......... 08 / 08 / 09 .... Brutal Deluxe
... 13 ...... 10 ..... 03 / 01 / 12 ......... 21 / 28 / 17 .... Jakarta Wolves
... 14 ...... 14 ..... 11 / 08 / 15 ......... 15 / 16 / 12 .... Manila Gorillas
... 15 ...... 15 ..... 10 / 09 / 11 ......... 10 / 10 / 10 .... Taipei Yonghe soybean milk
... 17 ...... 16 ..... 08 / 04 / 18 ......... 18 / 23 / 15 .... Maldives Munching Moles
... 20 ...... 19 ..... 21 / 25 / 14 ......... 19 / 26 / 16 .... Beijing Drifters
... 21 ...... 20 ..... 12 / 03 / 21 ......... 20 / 24 / 22 .... Chiang Mai chiefs
... 24 ...... 23 ..... 18 / 17 / 13 ......... 27 / 32 / 23 .... Taipei Thunder
... 26 ...... 24 ..... 17 / 06 / 25 ......... 25 / 29 / 25 .... Laos Chaos
... 27 ...... 27 ..... 27 / 11 / 28 ......... 29 / 18 / 30 .... Los Angeles Kryptonite
... 30 ...... 30 ..... 32 / 31 / 30 ......... 32 / 17 / 32 .... The Zoolander School For Kids Who Can't Read Good
... 31 ...... 31 ..... 31 / 29 / 32 ......... 31 / 30 / 31 .... Seoul Patrol
Last edited Oct 23, 2008 15:50:03
 
marshks
offline
Link
 
Nice work. Thanks for posting.
 
Club America
offline
Link
 
that dude is really good at getting stuff to line up.
 
viperz2k5
offline
Link
 
Seems like you got some teams in zeta mixed up with alpha.
 
chiefy27
offline
Link
 
Originally posted by viperz2k5
Seems like you got some teams in zeta mixed up with alpha.


Nice catch.


Updated
 
oilspill29
offline
Link
 
the way i read that, is it the top 5 teams there are all in zeta?
 
lVlellovv
offline
Link
 
hmm..
 
jasonp25
offline
Link
 
Originally posted by oilspill29
the way i read that, is it the top 5 teams there are all in zeta?


Actually since the rankings are based on statistics only, this tells us that the 5 worst teams are in Zeta.
 
jasonp25
offline
Link
 
And GREAT work! This league has been missing an unbiased ranking system.
 
Sigmaforce
offline
Link
 
Originally posted by jasonp25
Originally posted by oilspill29

the way i read that, is it the top 5 teams there are all in zeta?


Actually since the rankings are based on statistics only, this tells us that the 5 worst teams are in Zeta.


Very true
 
thefloppy1
offline
Link
 
Originally posted by jasonp25
Originally posted by oilspill29

the way i read that, is it the top 5 teams there are all in zeta?


Actually since the rankings are based on statistics only, this tells us that the 5 worst teams are in Zeta.


Well that depends on how you want to look at the statistics. it also depends on what question you ask your self when you look at them.

The problem with Statistics is that they can be twisted any way a person feels.

I could look at them and say the outcomes are flawed by the lack of data. We had a huge game against the cheaters, and strangely they ended up 6th in zeta, we ended up 6th bottom, while this is not true for all teams, chiefs played kids who can't read.
it is a little telling of size of the data group.

but then I can also look at it say man wolves have a tough 1st half of draw. 2nd half not so bad.

so we can all twist it to any way we feel, but I think as the size of the data gets bigger we will start to see some real changes, as things start to settle down.

and a big thanks to chiefy27 for doing this, I know the story will be pretty clear after the first couple of weeks, and hopefully there will be no twisting around of statistics
 
oilspill29
offline
Link
 
the first game must have skewed it a little bit or something because i (as the owner) don't even believe a 3rd place finish is possible for Laos...i would love it, but we would have to play our asses off to accomplish that.
 
budbowlallpro
offline
Link
 
Yeah I don't think right now we are the 5th best team in Alpha. Plus until we beat Sumtra, who kicked our ass last year, I will still consider them a better team. I will consider us the 8th best team until we can prove that we can beat the teams that beat us last year. Then we can move up the rankings.
 
chiefy27
offline
Link
 
After reading through the thread, I want to point out a few things already said and hopefully clarify some things.

-The data used has only 1 week in it. I did this last season, and it took the guys there a long time to figure this out.

-As the weeks go by and the data becomes more abundant, the rankings will become more true.

-This is not "Official" by any means. I wanted a way to do rankings in the most objective way I could.

Hope this helps and if anyone has any questions or would like the link to the spreadsheet to do the rankings in another, just PM me.
 
jasonp25
offline
Link
 
Originally posted by chiefy27
After reading through the thread, I want to point out a few things already said and hopefully clarify some things.

-The data used has only 1 week in it. I did this last season, and it took the guys there a long time to figure this out.

-As the weeks go by and the data becomes more abundant, the rankings will become more true.

-This is not "Official" by any means. I wanted a way to do rankings in the most objective way I could.

Hope this helps and if anyone has any questions or would like the link to the spreadsheet to do the rankings in another, just PM me.


It's good work, based on the only impartial thing we can go on. I won't be thinking highly of my team after the first two weeks, even though we will likely be on top. Doesn't mean much when we face the easiest part of our schedule. The NFL ranks on yardage as well and it has always been flawed.

The only superbly put together ranking system out their is the Aikman Efficiency Ratings. Those rock, and take into account opponent strength, scoring, 3rd down efficiency... lot's of goodies there.

We need a GLB spreadsheet using those settings!
Last edited Sep 24, 2008 08:07:14
 
Page:
 


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