User Pass
Home Sign Up Contact Log In
Forum > Canadian AA Leagues > Canada AA #3 > League Projector - great excel file, AA#3 needs a volunteer
Page:
 
TurboBoxer
offline
Link
 
http://goallineblitz.com/game/forum_thread.pl?thread_id=470138

its a great excel file they have. Only thing it requires a lot of data entry, all league team names THEN all team schedules (not that hard, only enter a number, theres even a pattern that comes up), then all teh scores for the previous played games....for both conferences btw.

i would do it but i did it for my own league, not going through that again
 
Kyndig
offline
Link
 
I would do it but sadly I don't have excel on this dumb computer
 
CTGuyton
offline
Link
 
i did it. We'll see how well it works out.

Tommorow's predictions based on this formula:

West:

West Coast Fire
11
Miami Phantoms
8

Nanaimo Islanders
34
Richmond Rabid Goats
12

Kelowna Ninjas
25
Gillett Tigers
4

San Francisco Sucka Free's
50
Westside Thuganomics
7

Saskatoon Lizards
34
Charlotte Lynx
13

Montreal Mayhem
29
Washington Typhoons
8

Shogun Vikings
63
innipeg Hitmen
5

North American Colt .45s
13
Rock Island Riverhawks
2



East:

Scarlet Starlets
17
Montreal Mustangs
4

St. Clair Explosive Nudists
34
Vancouver Hurricanes
14

Saguenay Sturgeon
27
Newfoundland Hustlers
12

Nova Scotia Aftershocks
87
Montana Hannahs
0

Toronto St. Pats
35
The Crushing Fuamatu-ma'afala's
9

Charlottetown Predators
18
Calgary Stampede
6

Flin Flon Blaze
33
St. John's Terror
23

Pompano Beach Basset Hounds
30
Auburn War Eagles
8



this really doesn't take anything into account but scores so I think its flawed in that sense. but we'll see how it does. once its set up its pretty easy to maintain.
Last edited Jun 27, 2008 04:34:03
 
hostyle
offline
Link
 
Hmm the stangs are going to have such a good D that they get 2 safeties, but still allow 17 points. Interesting.
 
Kyndig
offline
Link
 
interested to see how this matches up
 
Link
 
Originally posted by CTGuyton
i did it. We'll see how well it works out.

Tommorow's predictions based on this formula:

West:

West Coast Fire
11
Miami Phantoms
8


this really doesn't take anything into account but scores so I think its flawed in that sense. but we'll see how it does. once its set up its pretty easy to maintain.


Here's is the first flaw Good luck today Fire.
 
TurboBoxer
offline
Link
 
yup huge flaw right the, not even close to the actually score....



but good game phantoms, thought it would be closer, but finally winning one against you guys was tough
 
CTGuyton
offline
Link
 
I added the actual results in bold with the difference between the predicted and actual scores.


West:

West Coast Fire
11 42(+31)
Miami Phantoms
8 0(-8)
winner predicted correctly

Nanaimo Islanders
34 20(-14)
Richmond Rabid Goats
12 6(-6)
winner predicted correctly

Kelowna Ninjas
25 40(+15)
Gillett Tigers
4 3(-1)
winner predicted correctly

San Francisco Sucka Free's
50 38(-12)
Westside Thuganomics
7 9(+2)
winner predicted correctly

Saskatoon Lizards
34 7(-27)
Charlotte Lynx
13 17(+4)
winner was not predicted correctly

Montreal Mayhem
29 24(-5)
Washington Typhoons
817(+9)
winner predicted correctly

Shogun Vikings
63 43(-20)
Winnipeg Hitmen
5 0(-5)
winner predicted correctly

North American Colt .45s
13 23(+10)
Rock Island Riverhawks
2 28(+26)
winner was not predicted correctly



East:

Scarlet Starlets
17 10(-7)
Montreal Mustangs
4 20(+16)
winner was not predicted correctly

St. Clair Explosive Nudists
34 16(-18)
Vancouver Hurricanes
14 19(+5)
winner was not predicted correctly

Saguenay Sturgeon
27 26(-1)
Newfoundland Hustlers
12 24(+12)
winner predicted correctly

Nova Scotia Aftershocks
87 79(-8)
Montana Hannahs
0 0
winner predicted correctly

Toronto St. Pats
35 34(-1)
The Crushing Fuamatu-ma'afala's
9 3(-6)
winner predicted correctly

Charlottetown Predators
18 14(-4)
Calgary Stampede
6 19(+13)
winner was not predicted correctly

Flin Flon Blaze
33 9(-24)
St. John's Terror
23 6(-17)
winner predicted correctly

Pompano Beach Basset Hounds
30 19(-11)
Auburn War Eagles
8 10(+2)
winner predicted correctly

It predicted the winners in 11/16 games but it did even come close on a lot of the scores. I'm going to work on the formula and see if I can add in a factor with the ratings I normally do and see if we can get it a lil more accurate rather than the better record is expected to win like it is now.
Last edited Jun 28, 2008 19:58:29
 
Exodus82
offline
Link
 
Just goes to show you how upsets rarely happen in this game. Probably the worst part about GLB, not enough upsets.
 
Kyndig
offline
Link
 
How common are upsets in real life? Not trying to be an ass but I have never followed football in my life so I really don't know...
 
CTGuyton
offline
Link
 
Originally posted by Kyndig
How common are upsets in real life? Not trying to be an ass but I have never followed football in my life so I really don't know...


not very. They happen but are still pretty rare. They usually are a result of an injury or just a breakdown of a gameplan. a few boosts to you momentum and your set.
i just don't think the better team always has the better record. especially in GLB. Take the Stampede for example. I'd consider most their losses this season to be upsets based on their talent but based on their record their wins would be. I think their needs to be a formula that takes these both into consideration
Last edited Jun 28, 2008 01:12:23
 
backstop
offline
Link
 
Originally posted by CTGuyton
I added the actual results in bold with the difference between the predicted and actual scores.


West:

West Coast Fire
11 42(+31)
Miami Phantoms
8 0(-8)
winner predicted correctly

Nanaimo Islanders
34 20(-14)
Richmond Rabid Goats
12 6(-6)
winner predicted correctly

Kelowna Ninjas
25 40(+15)
Gillett Tigers
4 3(-1)
winner predicted correctly

San Francisco Sucka Free's
50 38(-12)
Westside Thuganomics
7 9(+2)
winner predicted correctly

Saskatoon Lizards
34 7(-27)
Charlotte Lynx
13 17(+4)
winner was not predicted correctly

Montreal Mayhem
29 24(-5)
Washington Typhoons
817(+9)
winner predicted correctly

Shogun Vikings
63 43(-20)
Winnipeg Hitmen
5 0(-5)
winner predicted correctly

North American Colt .45s
13 23(+10)
Rock Island Riverhawks
2 28(+26)
winner was not predicted correctly



East:

Scarlet Starlets
17 20(+3)
Montreal Mustangs
4 10(+6)
winner predicted correctly

St. Clair Explosive Nudists
34 16(-18)
Vancouver Hurricanes
14 19(+5)
winner was not predicted correctly

Saguenay Sturgeon
27 26(-1)
Newfoundland Hustlers
12 24(+12)
winner predicted correctly

Nova Scotia Aftershocks
87 79(-8)
Montana Hannahs
0 0
winner predicted correctly

Toronto St. Pats
35 34(-1)
The Crushing Fuamatu-ma'afala's
9 3(-6)
winner predicted correctly

Charlottetown Predators
18 14(-4)
Calgary Stampede
6 19(+13)
winner was not predicted correctly

Flin Flon Blaze
33 9(-24)
St. John's Terror
23 6(-17)
winner predicted correctly

Pompano Beach Basset Hounds
30 19(-11)
Auburn War Eagles
8 10(+2)
winner predicted correctly

It predicted the winners in 12/16 games but it did even come close on a lot of the scores. I'm going to work on the formula and see if I can add in a factor with the ratings I normally do and see if we can get it a lil more accurate rather than the better record is expected to win like it is now.


You're backwards we (Mustangs) won. So at best it was 11/16, still not too bad.
Last edited Jun 28, 2008 19:54:34
 
CTGuyton
offline
Link
 
Week 9 predictions via formula



West:

West Coast Fire
10
Kelowna Ninjas
7


Miami Phantoms
17
Nanaimo Islanders
13


Charlotte Lynx
53
Rock Island Riverhawks
5


Shogun Vikings
14
San Francisco Sucka Free's
12


Saskatoon Lizards
25
Gillett Tigers
6


Montreal Mayhem
27
Winnipeg Hitmen
6


Richmond Rabid Goats
19
Westside Thuganomics
18


Washington Typhoons
35
North American Colt .45s
13




East:

Saguenay Sturgeon
16
Scarlet Starlets
9


Newfoundland Hustlers
23
St. Clair Explosive Nudists
17


Montreal Mustangs
59
St. John's Terror
10


Nova Scotia Aftershocks
17
Toronto St. Pats
10


Calgary Stampede
98
Montana Hannahs
0


Charlottetown Predators
25
Flin Flon Blaze
4


Auburn War Eagles
39
The Crushing Fuamatu-ma'afala's
8


Pompano Beach Basset Hounds
56
Vancouver Hurricanes
5
 
CTGuyton
offline
Link
 
final rankings according to the current formula


Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . West Coast Fire. . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 499 . . ..77
..2 . . Shogun Vikings . . . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 440 . . ..97
..3 . . Kelowna Ninjas. . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 399 . . ..91
..4 . . San Francisco Sucka Free's. . . 13 . . ..3 . . 0 . . ..81% . . 458 . . 136
..5 . . Miami Phantoms . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 345 . . 171
..6 . . Saskatoon Lizards. . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 317 . . 186
..7 . . Nanaimo Islanders . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 357 . . 204
..8 . . Montreal Mayhem. . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 293 . . 185
..9 . . Charlotte Lynx . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 367 . . 304
10 . . Gillett Tigers . . . . . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 179 . . 298
11 . . Richmond Rabid Goats . . . . . . ..6 . . 10 . . 0 . . ..38% . . 184 . . 339
12 . . Westside Thuganomics. . . . . ..4 . . 12 . . 0 . . ..25% . . 232 . . 417
13 . . Washington Typhoons . . . . . ..3 . . 13 . . 0 . . ..19% . . 218 . . 462
14 . . Winnipeg Hitmen . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . 180 . . 420
15 . . Rock Island Riverhawks. . . . . ..1 . . 15 . . 0 . . ....6% . . ..68 . . 668
16 . . North American Colt .45s . . . . ..0 . . 16 . . 0 . . ....0% . . 124 . . 607



Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Saquenay Sturgeon. . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 700 . . ...134
..2 . . Pompano Beach Basset Hounds. 15 . . ..1 . . 0 . . ..94% . . 734 . . .....91
..3 . . Nova Scotia Aftershocks. . . . . 14 . . ..2 . . 0 . . ..88% . . 374 . . ...140
..4 . . Auburn War Eagles . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 486 . . ...184
..5 . . Scarlet Starlets . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 301 . . ...151
..6 . . Charlottetown Predators. . . . . 10 . . ..6 . . 0 . . ..63% . . 289 . . ...156
..7 . . Newfoundland Hustlers. . . . . . 10 . . ..6 . . 0 . . ..63% . . 434 . . ...258
..8 . . Toronto St. Pats. . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 476 . . ...260
..9 . . Calgary Stampede. . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 328 . . ...240
10 . . St. Clair Explsive Nudists. . . . ..7 . . ..9 . . 0 . . ..44% . . 385 . . ...231
11 . . Montreal Mustangs. . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 327 . . ...233
12 . . Vancouver Hurricanes. . . . . . ..6 . . 10 . . 0 . . ..38% . . 342 . . ...388
13 . . Flin Flon Blaze . . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . 143 . . ...407
14 . . The Crushing Fuamatu-ma'afala's. ..2 . . 14 . . 0 . . ..13% . . 184 . . ...458
15 . . St. John's Terror. . . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 204 . . ...968
16 . . Montana Hannahs . . . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ....7 . . 1,510
Last edited Jun 28, 2008 20:38:30
 
backstop
offline
Link
 
Originally posted by CTGuyton
final rankings according to the current formula


Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . West Coast Fire. . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 499 . . ..77
..2 . . Shogun Vikings . . . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 440 . . ..97
..3 . . Kelowna Ninjas. . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 399 . . ..91
..4 . . San Francisco Sucka Free's. . . 13 . . ..3 . . 0 . . ..81% . . 458 . . 136
..5 . . Miami Phantoms . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 345 . . 171
..6 . . Saskatoon Lizards. . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 317 . . 186
..7 . . Nanaimo Islanders . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 357 . . 204
..8 . . Montreal Mayhem. . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 293 . . 185
..9 . . Charlotte Lynx . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 367 . . 304
10 . . Gillett Tigers . . . . . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 179 . . 298
11 . . Richmond Rabid Goats . . . . . . ..6 . . 10 . . 0 . . ..38% . . 184 . . 339
12 . . Westside Thuganomics. . . . . ..4 . . 12 . . 0 . . ..25% . . 232 . . 417
13 . . Washington Typhoons . . . . . ..3 . . 13 . . 0 . . ..19% . . 218 . . 462
14 . . Winnipeg Hitmen . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . 180 . . 420
15 . . Rock Island Riverhawks. . . . . ..1 . . 15 . . 0 . . ....6% . . ..68 . . 668
16 . . North American Colt .45s . . . . ..0 . . 16 . . 0 . . ....0% . . 124 . . 607



Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Saquenay Sturgeon. . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 700 . . ...134
..2 . . Pompano Beach Basset Hounds. 15 . . ..1 . . 0 . . ..94% . . 734 . . .....91
..3 . . Nova Scotia Aftershocks. . . . . 14 . . ..2 . . 0 . . ..88% . . 374 . . ...140
..4 . . Auburn War Eagles . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 486 . . ...184
..5 . . Scarlet Starlets . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 301 . . ...151
..6 . . Charlottetown Predators. . . . . 10 . . ..6 . . 0 . . ..63% . . 289 . . ...156
..7 . . Newfoundland Hustlers. . . . . . 10 . . ..6 . . 0 . . ..63% . . 434 . . ...258
..8 . . Toronto St. Pats. . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 476 . . ...260
..9 . . Calgary Stampede. . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 328 . . ...240
10 . . St. Clair Explsive Nudists. . . . ..7 . . ..9 . . 0 . . ..44% . . 385 . . ...231
11 . . Montreal Mustangs. . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 327 . . ...233
12 . . Vancouver Hurricanes. . . . . . ..6 . . 10 . . 0 . . ..38% . . 342 . . ...388
13 . . Flin Flon Blaze . . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . 143 . . ...407
14 . . The Crushing Fuamatu-ma'afala's. ..2 . . 14 . . 0 . . ..13% . . 184 . . ...458
15 . . St. John's Terror. . . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 204 . . ...968
16 . . Montana Hannahs . . . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ....7 . . 1,510


At worst our record should be reversed! We've beaten 2 of the 3 directly ahead of us and another in the top 5. But I'm a little biased.
 
Page:
 


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