User Pass
Home Sign Up Contact Log In
Page:
 
GarrettFoster
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 6 (Version 0.20 used)

Rank ..... Prv …… Offense ............ Defense ...... Team
................................ O/P/R .................. O/P/R
Alpha
... 02 ...... 04 ..... 05 / 31 / 01 ......... 01 / 04 / 04 .... Ack Attack
... 03 ...... 02 ..... 03 / 21 / 03 ......... 08 / 26 / 06 .... Billiton Bullets
... 05 ...... 03 ..... 06 / 02 / 21 ......... 09 / 17 / 10 .... Nagasaki Rage
... 06 ...... 07 ..... 04 / 27 / 04 ......... 14 / 21 / 13 .... Jakarta Vipers
... 10 ...... 06 ..... 08 / 16 / 07 ......... 06 / 09 / 08 .... Macau Gamblers
... 15 ...... 16 ..... 23 / 32 / 08 ......... 12 / 05 / 15 .... Bali Insurrection
... 16 ...... 17 ..... 16 / 12 / 17 ......... 27 / 32 / 20 .... Kathmandu Mountaineers
... 18 ...... 15 ..... 20 / 23 / 15 ......... 15 / 15 / 14 .... Ho Chi Minh City Horned Rhinos
... 19 ...... 21 ..... 12 / 03 / 23 ......... 19 / 18 / 17 .... American Patriots
... 21 ...... 24 ..... 13 / 24 / 09 ......... 20 / 01 / 26 .... Johor Bahru Flames
... 22 ...... 19 ..... 22 / 14 / 19 ......... 22 / 03 / 25 .... Vanuatu Headhunters
... 23 ...... 20 ..... 24 / 10 / 25 ......... 17 / 02 / 21 .... Vietnam Dragon Clan
... 26 ...... 28 ..... 26 / 25 / 26 ......... 25 / 22 / 23 .... Karumai Yűrei
... 28 ...... 26 ..... 30 / 19 / 28 ......... 23 / 07 / 27 .... Chiang Mai Weis
... 29 ...... 29 ..... 27 / 13 / 29 ......... 24 / 16 / 22 .... Manila Thrillers
... 31 ...... 32 ..... 29 / 18 / 27 ......... 32 / 27 / 31 .... Mongolian Horde
Zeta
... 01 ...... 01 ..... 10 / 11 / 13 ......... 02 / 28 / 02 .... Surabaya Tsunami
... 04 ...... 05 ..... 01 / 05 / 06 ......... 03 / 31 / 01 .... Rangoon Flying Tigers
... 07 ...... 08 ..... 02 / 22 / 02 ......... 04 / 23 / 03 .... Phnom Penh Knights
... 08 ...... 10 ..... 07 / 26 / 05 ......... 18 / 14 / 19 .... Shanghai Pirates
... 09 ...... 13 ..... 09 / 07 / 14 ......... 13 / 30 / 09 .... Sapporo Samurai
... 11 ...... 09 ..... 11 / 15 / 10 ......... 10 / 08 / 11 .... Hanoi Hitmen
... 12 ...... 11 ..... 14 / 01 / 30 ......... 16 / 10 / 18 .... Manila Gangsters
... 13 ...... 12 ..... 18 / 17 / 16 ......... 07 / 24 / 05 .... Hong Kong Phooeys
... 14 ...... 18 ..... 15 / 28 / 12 ......... 11 / 11 / 12 .... Kung Pow Chickens
... 17 ...... 14 ..... 17 / 09 / 18 ......... 21 / 29 / 16 .... Mt. Union Eagles
... 20 ...... 22 ..... 19 / 29 / 11 ......... 05 / 19 / 07 .... Koror Hammerheads
... 24 ...... 25 ..... 21 / 08 / 24 ......... 29 / 20 / 29 .... Bangkok Yellow Dragons
... 25 ...... 30 ..... 25 / 20 / 22 ......... 26 / 25 / 24 .... Davao City Nighthawks
... 27 ...... 23 ..... 28 / 30 / 20 ......... 28 / 06 / 28 .... New Guinea Iggles
... 30 ...... 27 ..... 31 / 06 / 31 ......... 31 / 12 / 32 .... Taipei Giant Pandas
... 32 ...... 31 ..... 32 / 04 / 32 ......... 30 / 13 / 30 .... Semarang Maulers
Last edited Aug 14, 2008 06:29:33
 
Mindwarp
offline
Link
 
avg lvl of player?
 
Soul31
offline
Link
 
Some way to differentiate points scored vs the quality of opponent.

For instance scoring 80 points vs a cupcake should not count the same as scoring 80 points vs a contender.

Soul
Rangoon Flying Tigers
 
GarrettFoster
offline
Link
 
Avg player will be hard to keep updated, otherwise a great idea.
My goal is to make the spreadsheet something I can do in less than 30 minutes.

As far as the score thing this is what I currently have implemented.
And its easy to keep updated.

Your Total Points For - The Sum of the Average Points Against for all your opponents = some measure of the points you scored vs the quality of opponent
 
mhviper1
offline
Link
 
I am not sure how accurate it is, but what about using the matchup numbers to determine a multiplier? It should give you an approximate gauge of team level in the matchup.
 
Panicinaz
offline
Link
 
Does it take into account the coolness of a team's logo?
 
GarrettFoster
offline
Link
 
Originally posted by mhviper1
I am not sure how accurate it is, but what about using the matchup numbers to determine a multiplier? It should give you an approximate gauge of team level in the matchup.


Do you mean the pre-scouting report? Normally I base most of it on stats on not levels. As I can pull stats a lot faster. Copy past done

Originally posted by Panicinaz
Does it take into account the coolness of a team's logo?


how bout 1 point out of 1,000?
 
coltsfanpg
offline
Link
 
Originally posted by GarrettFoster
For another league that I am in, I run a spreadsheet. This spreadsheet is ready to run some power rankings as well as some other statistical rankings stuff. I would be willing do to it here. What I need though is some input as to what the power ranking formula should look like.

Currently it takes into account:
-Quality of opponent
-Record
-Points
-Yards


Sounds good to me.
 
Dj Asian
offline
Link
 
Originally posted by Panicinaz
Does it take into account the coolness of a team's logo?


My logo is cooler!
 
bossjayroc
offline
Link
 
I like this idea
 
iamhiphop
offline
Link
 
Originally posted by GarrettFoster
For another league that I am in, I run a spreadsheet. This spreadsheet is ready to run some power rankings as well as some other statistical rankings stuff. I would be willing do to it here. What I need though is some input as to what the power ranking formula should look like.

Currently it takes into account:
-Quality of opponent
-Record
-Points
-Yards


Yards and points will be on both sides of the ball correct?
 
Panicinaz
offline
Link
 
Originally posted by Dj-Asian
Originally posted by Panicinaz

Does it take into account the coolness of a team's logo?


My logo is cooler!


not possible
 
Dj Asian
offline
Link
 
Originally posted by Panicinaz
Originally posted by Dj-Asian

Originally posted by Panicinaz


Does it take into account the coolness of a team's logo?


My logo is cooler!


not possible


Yes possible..
 
Link
 
sounds good to me.... Kathmandu Mountaineers are down for such a system!
 
typheous
offline
Link
 
Let's get these rankings goin! I was hopin for some preseason ranks, but I guess that was asking for too much
 
Page:
 


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