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
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






























