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:
 
Savage Smurf
offline
Link
 
I hope these rankings will be right.
 
Dees
offline
Link
 
So do I!

Go Vikings!!
 
CTGuyton
offline
Link
 
Originally posted by backstop
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.


well as I've mentioned before I'm not a big fan of the way these rankings work. They take the points you've scored vs the average points allowed by you opponents then compare it to the points allowed by your upcoming opponents(same with points against) and that's how it predicts the winner. The more the season goes on the better it will be but it still has its flaws.
 
CTGuyton
offline
Link
 
week 9 results


West:

West Coast Fire
10 26(+16)
Kelowna Ninjas
7 13(+6)
winner predicted correctly

Miami Phantoms
17 16(-1)
Nanaimo Islanders
13 12(-1)
winner predicted correctly


Charlotte Lynx
53 26(-27)
Rock Island Riverhawks
5 0(-5)
winner predicted correctly

Shogun Vikings
14 7 (-7)
San Francisco Sucka Free's
12 48 (+36)
winner predicted incorrectly

Saskatoon Lizards
25 13 (-9)
Gillett Tigers
6 19 (+13)
winner predicted incorrectly

Montreal Mayhem
27 32(+5)
Winnipeg Hitmen
6 6
winner predicted correctly

Richmond Rabid Goats
19 40 (+21)
Westside Thuganomics
18 20 (+2)
winner predicted correctly

Washington Typhoons
35 38(+3)
North American Colt .45s
13 17(+4)
winner predicted correctly





East:


Saguenay Sturgeon
16 25(+9)
Scarlet Starlets
9 3(-6)
winner predicted correctly

Newfoundland Hustlers
23 19(-4)
St. Clair Explosive Nudists
17 16(-1)
winner predicted correctly

Montreal Mustangs
59 27(-32)
St. John's Terror
10 24(+14)
winner predicted correctly

Nova Scotia Aftershocks
17 17
Toronto St. Pats
10 16(+6)
winner predicted correctly

Calgary Stampede
98 122(+24)
Montana Hannahs
0 0
winner predicted correctly

Charlottetown Predators
25 29(+4)
Flin Flon Blaze
4 3(-1)
winner predicted correctly

Auburn War Eagles
39 55(+16)
The Crushing Fuamatu-ma'afala's
8 3(-5)
winner predicted correctly

Pompano Beach Basset Hounds
56 63(+7)
Vancouver Hurricanes
5 7(+2)
winner predicted correctly



it got all the games in the east right but missed 2 in the west. some of the scores were way off but some were almost dead on.

new rankings:

Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . West Coast Fire. . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 542 . . ..84
..2 . . San Francisco Sucka Free's. . . 15 . . ..1 . . 0 . . ..94% . . 538 . . 125
..3 . . Miami Phantoms . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 323 . . 172
..4 . . Shogun Vikings . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 403 . . 161
..5 . . Kelowna Ninjas. . . . . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 409 . . 120
..6 . . Nanaimo Islanders . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 356 . . 197
..7 . . Montreal Mayhem. . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 304 . . 181
..8 . . Charlotte Lynx . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 337 . . 282
..9 . . Saskatoon Lizards. . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 296 . . 213
10 . . Gillett Tigers . . . . . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 208 . . 278
11 . . Richmond Rabid Goats . . . . . . ..6 . . 10 . . 0 . . ..38% . . 218 . . 340
12 . . Washington Typhoons . . . . . ..4 . . 12 . . 0 . . ..25% . . 231 . . 471
13 . . Westside Thuganomics. . . . . ..3 . . 13 . . 0 . . ..19% . . 235 . . 445
14 . . Winnipeg Hitmen . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . 178 . . 433
15 . . Rock Island Riverhawks. . . . . ..1 . . 15 . . 0 . . ....6% . . ..59 . . 622
16 . . North American Colt .45s . . . . ..0 . . 16 . . 0 . . ....0% . . 129 . . 637



Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Saquenay Sturgeon. . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 708 . . ...128
..2 . . Pompano Beach Basset Hounds. 15 . . ..1 . . 0 . . ..94% . . 754 . . .....95
..3 . . Auburn War Eagles . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 533 . . ...171
..4 . . Nova Scotia Aftershocks. . . . . 13 . . ..3 . . 0 . . ..81% . . 373 . . ...151
..5 . . Charlottetown Predators. . . . . 11 . . ..5 . . 0 . . ..69% . . 298 . . ...144
..6 . . Scarlet Starlets . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 285 . . ...170
..7 . . Newfoundland Hustlers. . . . . . 10 . . ..6 . . 0 . . ..63% . . 430 . . ...252
..8 . . Calgary Stampede. . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 390 . . ...225
..9 . . Toronto St. Pats. . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 492 . . ...255
10 . . Montreal Mustangs. . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 298 . . ...257
11 . . Vancouver Hurricanes. . . . . . ..6 . . 10 . . 0 . . ..38% . . 339 . . ...405
12 . . St. Clair Explsive Nudists. . . . ..6 . . 10 . . 0 . . ..38% . . 380 . . ...231
13 . . Flin Flon Blaze . . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . 137 . . ...419
14 . . The Crushing Fuamatu-ma'afala's. ..2 . . 14 . . 0 . . ..13% . . 172 . . ...505
15 . . St. John's Terror. . . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 225 . . ...960
16 . . Montana Hannahs . . . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ....7 . . 1,558
Last edited Jun 29, 2008 09:31:05
 
TurboBoxer
offline
Link
 
good stuff CT, program has its flaws, but i dont think anything like that will work perfectly.
 
CTGuyton
offline
Link
 
any word on why the team in the top right has a different predicted score yet? it seems to be just the points against that are off compared to the points for on the opposing team.
 
nancywhiskey
offline
Link
 
The east is so predictable.
 
TurboBoxer
offline
Link
 
Originally posted by CTGuyton
any word on why the team in the top right has a different predicted score yet? it seems to be just the points against that are off compared to the points for on the opposing team.


i talked to the creator of the program about this, because i had the same problem (different predicted scores) and heres what he told me....



"It is a little unusual to have this large a disparity (8 pts) in projected scores this far into the season, but the algorithm is working. While the math is simple, the number of iterations run through can make it seem very complicated. The issue here is that both teams have played the exact same schedule to date with one exception. That exception represents a significant difference in quality of the opponent. That disparity changes the confidence factor for each team.

It should be understood that while the projected scores are often close to reality, that isn't the intent. Taken as a whole over the course of a season, one may correctly consider them a point total. But individually the projected score is more accurately a measure of confidence in the outcome rather than a prediction of the actual game score. "
 
CTGuyton
offline
Link
 
Originally posted by TurboBoxer
But individually the projected score is more accurately a measure of confidence in the outcome rather than a prediction of the actual game score. "


makes sense. thats all I really use it for anyways
 
CTGuyton
offline
Link
 
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . West Coast Fire. . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 476 . . ..65
..2 . . Miami Phantoms . . . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 345 . . 171
..3 . . San Francisco Sucka Free's. . . 13 . . ..3 . . 0 . . ..81% . . 509 . . 172
..4 . . Shogun Vikings . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 381 . . 160
..5 . . Kelowna Ninjas. . . . . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 418 . . 152
..6 . . Nanaimo Islanders . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 347 . . 199
..7 . . Montreal Mayhem. . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 309 . . 213
..8 . . Charlotte Lynx . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 314 . . 249
..9 . . Richmond Rabid Goats . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 279 . . 306
10 . . Gillett Tigers . . . . . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 194 . . 263
11 . . Saskatoon Lizards. . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 260 . . 236
12 . . Winnipeg Hitmen . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . 174 . . 335
13 . . Westside Thuganomics. . . . . ..4 . . 12 . . 0 . . ..25% . . 238 . . 411
14 . . Washington Typhoons . . . . . ..3 . . 13 . . 0 . . ..19% . . 187 . . 495
15 . . Rock Island Riverhawks. . . . . ..1 . . 15 . . 0 . . ....6% . . ..51 . . 655
16 . . North American Colt .45s . . . . ..0 . . 16 . . 0 . . ....0% . . 124 . . 520



Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Saquenay Sturgeon. . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 616 . . ...136
..2 . . Pompano Beach Basset Hounds. 14 . . ..2 . . 0 . . ..88% . . 597 . . ...117
..3 . . Auburn War Eagles . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 535 . . ...165
..4 . . Scarlet Starlets . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 333 . . ...164
..5 . . Newfoundland Hustlers. . . . . . 10 . . ..6 . . 0 . . ..63% . . 388 . . ...243
..6 . . Charlottetown Predators. . . . . 10 . . ..6 . . 0 . . ..63% . . 322 . . ...144
..7 . . Nova Scotia Aftershocks. . . . . 10 . . ..6 . . 0 . . ..63% . . 314 . . ...200
..8 . . Montreal Mustangs. . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 298 . . ...249
..9 . . Toronto St. Pats. . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 409 . . ...275
10 . . Calgary Stampede. . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 406 . . ...219
11 . . Vancouver Hurricanes. . . . . . ..5 . . 11 . . 0 . . ..31% . . 238 . . ...387
12 . . St. Clair Explsive Nudists. . . . ..5 . . 11 . . 0 . . ..31% . . 319 . . ...297
13 . . Flin Flon Blaze . . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . 153 . . ...423
14 . . The Crushing Fuamatu-ma'afala's. ..3 . . 13 . . 0 . . ..19% . . 160 . . ...461
15 . . St. John's Terror. . . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 214 . . ...458
16 . . Montana Hannahs . . . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ..23 . . 1,413



these are the projected rankings as of right now(wk 14) Its not very simple to post the next 2 weeks since I hafta pull the info out for each team individually but if you wanna know what the program expects for the rest of your season(if you can't figue it out from above) then post here or PM me and I'll be happy to share!

Info also available. hardest and easiest schedules remaining, also projected points for/against. also toughest/easiest opponents in defeats/victories.


edit: i appearently didn't save earlier so the numbers were wk 13 numbers. fixed now
Last edited Jul 10, 2008 01:37:55
 
TurboBoxer
offline
Link
 
thanks CT, can't look at mine right now, but does it have predicted scores for the playoffs?
 
CTGuyton
offline
Link
 
no. he hasn't updated it for that yet
 
Page:
 


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