User Pass
Home Sign Up Contact Log In
Forum > Canadian A Leagues > Canadian A #5 > Spreadsheet Standings Predictions
Page:
 
wooden_bender
offline
Link
 
I'm just happy making the playoffs, if we do that then the season's been a success lol
 
Wandringfool
offline
Link
 
Theres bound to be some massive fluctuations the first few weeks but seeing this spreadsheet in action last season, it calms down soon and has it pretty well nailed
Last edited Apr 30, 2009 20:58:19
 
Absolut Zero
offline
Link
 
#1 team playing the #3 team. Nova Scotia vs New Brunswick. Can't wait.
 
rackhound
offline
Link
 
Originally posted by Wandringfool
Theres bound to be some massive fluctuations the first few weeks but seeing this spreadsheet in action last season, it calms down soon and has it pretty well nailed


usually after about 6-8 games the spreadsheat rankings get it pretty damn close.
 
kfd277
offline
Link
 
After Game 4

Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . RP Thunderbolts . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 1,388 . . ...192
..2 . . Victoria Piranhas . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 2,142 . . ...358
..3 . . Canada Dry . . . . . . . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 1,388 . . ...231
..4 . . Canada Dragons . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,411 . . ...490
..5 . . Grove City Bucks . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 1,047 . . ...544
..6 . . BC Biscuits . . . . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 1,199 . . ...583
..7 . . Red Deer HITMEN . . . . . . . . . ...9 . . ..7 . . 0 . . ..56% . . ...692 . . ...498
..8 . . NS Highlanders . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 1,114 . . ...681
..9 . . Gowboys Grizzlies . . . . . . . . . ...8 . . ..8 . . 0 . . ..50% . . ...557 . . ...514
..10 . . Vancouver Apocalypse . . . . . ..7 . . ..9 . . 0 . . ..44% . . ...701 . . ...535
..11 . . Gander Norsemen . . . . . . . . . ...6 . . 10 . . 0 . . ..38% . . ...810 . . 1,003
..12 . . Piikoi Jellys . . . . . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...673 . . ...868
..13 . . Red Bay Revolution . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . ...569 . . 1,035
..14 . . Houston Vikings . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...285 . . ...909
..15 . . Buffalo Bison . . . . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...768 . . 1,324
..16 . . Ft Mc Mounted Police . . . . . . ..0 . . 16 . . 0 . . ....0% . . .......0 . . 4,769



Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . Nova Scotia Lions . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 2,291 . . ...183
..2 . . Keg River Boozehounds . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 1,244 . . ...271
..3 . . Chicago six . . . . . . . . . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,197 . . ...540
..4 . . New Brunswick Hammers . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,442 . . ...485
..5 . . Mighty M Nighthawks . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,384 . . ...503
..6 . . Saguenay Sturgeon . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 1,087 . . ...487
..7 . . St. Cathy Stompers . . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 1,232 . . ...528
..8 . . V Shinryuji Naga . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 1,350 . . ...719
..9 . . GL Rum Runners . . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . ...984 . . ...592
..10 . . Port Dover Panthers . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 1,072 . . ...657
..11 . . Regina Rams . . . . . . . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . ...897 . . 1,356
..12 . . Ottawa Storm Troopers . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...455 . . ...712
..13 . . Vancouver Vipers . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . ...406 . . ...884
..14 . . Cold Lake FREEZE . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...314 . . ...948
..15 . . Gold Miners C-Park . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . ...505 . . 3,204
..16 . . Carolina Copperheads . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ...393 . . 4,394
 
Absolut Zero
offline
Link
 
Our win last week was shocking. New Brunswick is still #4 even after what happened.
 
kfd277
offline
Link
 
After game 5

Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . Canada Dry . . . . . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 1,281 . . ...193
..2 . . RP Thunderbolts . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 1,362 . . ...175
..3 . . Victoria Piranhas . . . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 1,923 . . ...292
..4 . . Canada Dragons . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,298 . . ...510
..5 . . Grove City Bucks . . . . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,151 . . ...497
..6 . . BC Biscuits . . . . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 1,046 . . ...648
..7 . . Vancouver Apocalypse . . . . . ..9 . . ..7 . . 0 . . ..56% . . ...727 . . ...452
..8 . . Gander Norsemen . . . . . . . . . ...9 . . ..7 . . 0 . . ..56% . . ...804 . . ...643
..9 . . NS Highlanders . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . ...933 . . ...581
..10 . . Gowboys Grizzlies . . . . . . . . . ...8 . . ..8 . . 0 . . ..50% . . ...597 . . ...515
..11 . . Red Deer HITMEN . . . . . . . . . ...6 . . 10 . . 0 . . ..38% . . ...674 . . ...544
..12 . . Piikoi Jellys . . . . . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...599 . . ...905
..13 . . Houston Vikings . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...285 . . ...992
..14 . . Red Bay Revolution . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...433 . . 1,051
..15 . . Buffalo Bison . . . . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...608 . . 1,265
..16 . . Ft Mc Mounted Police . . . . . . ..0 . . 16 . . 0 . . ....0% . . .......0 . . 4,325



Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . Nova Scotia Lions . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 2,161 . . ...133
..2 . . Keg River Boozehounds . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 1,216 . . ...282
..3 . . Chicago six . . . . . . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,183 . . ...532
..4 . . Mighty M Nighthawks . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,291 . . ...397
..5 . . Saguenay Sturgeon . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . ...940 . . ...445
..6 . . New Brunswick Hammers . . . . . . 10 . . ..6 . . 0 . . ..63% . . 1,272 . . ...441
..7 . . Port Dover Panthers . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 1,153 . . ...584
..8 . . GL Rum Runners . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . ...889 . . ...467
..9 . . V Shinryuji Naga . . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 1,164 . . ...582
..10 . . St. Cathy Stompers . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 1,051 . . ...535
..11 . . Ottawa Storm Troopers . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...366 . . ...712
..12 . . Vancouver Vipers . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...514 . . ...790
..13 . . Regina Rams . . . . . . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...764 . . 1,285
..14 . . Cold Lake FREEZE . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...328 . . ...901
..15 . . Gold Miners C-Park . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . ...443 . . 3,180
..16 . . Carolina Copperheads . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ...384 . . 4,068
 
BrickHouse
offline
Link
 
Canada Dry too high.
 
Absolut Zero
offline
Link
 
Found this odd:
..5 . . Saguenay Sturgeon . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . ...940 . . ...445
..6 . . New Brunswick Hammers . . . . . . 10 . . ..6 . . 0 . . ..63% . . 1,272 . . ...441

By the numbers...Hammers should be miles ahead of the Sturgeons.
 
Peebee12
offline
Link
 
actually, i don't think so. PA is points allowed if im not wrong, so it's sort of fine that way.
 
Absolut Zero
offline
Link
 
Originally posted by Peebee12
actually, i don't think so. PA is points allowed if im not wrong, so it's sort of fine that way.


Yeah but they're both even in PA, yet the Hammers score 20 more points per game.
 
Thetian
offline
Link
 
That's a bunch of BCS! LOL

i take all of these ranking spreadsheets with a grain of salt. It does allow us to be shocked by upsets and such though. But if there are flaws in the rankings, maybe they really aren't upsets....Meh.


 
Peebee12
offline
Link
 
oh yeah, i was reading the wrong column.
 
kfd277
offline
Link
 
after Game 6

Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . Canada Dry . . . . . . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 1,365 . . ...166
..2 . . Victoria Piranhas . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 1,660 . . ...258
..3 . . Grove City Bucks . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,221 . . ...421
..4 . . Canada Dragons . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,203 . . ...467
..5 . . RP Thunderbolts . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,196 . . ...233
..6 . . BC Biscuits . . . . . . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . ...987 . . ...578
..7 . . Red Deer HITMEN . . . . . . . . . ...9 . . ..7 . . 0 . . ..56% . . ...696 . . ...520
..8 . . Gander Norsemen . . . . . . . . . ...8 . . ..8 . . 0 . . ..50% . . ...705 . . ...697
..9 . . Gowboys Grizzlies . . . . . . . . . ...8 . . ..8 . . 0 . . ..50% . . ...540 . . ...514
..10 . . Vancouver Apocalypse . . . . . ..7 . . ..9 . . 0 . . ..44% . . ...624 . . ...512
..11 . . Piikoi Jellys . . . . . . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . ...723 . . ...779
..12 . . NS Highlanders . . . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . ...773 . . ...851
..13 . . Houston Vikings . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...262 . . ...931
..14 . . Red Bay Revolution . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...382 . . ...927
..15 . . Buffalo Bison . . . . . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...548 . . 1,228
..16 . . Ft Mc Mounted Police . . . . . . ..0 . . 16 . . 0 . . ....0% . . .......0 . . 3,670



Rk__Team_________________________W__L__T___%____PF____PA__
..1 . . Nova Scotia Lions . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 2,151 . . ...125
..2 . . Keg River Boozehounds . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 1,084 . . ...278
..3 . . Mighty M Nighthawks . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,168 . . ...354
..4 . . Chicago six . . . . . . . . . . . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 1,148 . . ...425
..5 . . New Brunswick Hammers . . . . . . 12 . . ..4 . . 0 . . ..75% . . 1,290 . . ...383
..6 . . Saguenay Sturgeon . . . . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . ...915 . . ...471
..7 . . St. Cathy Stompers . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 1,015 . . ...511
..8 . . V Shinryuji Naga . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 1,062 . . ...533
..9 . . GL Rum Runners . . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . ...813 . . ...492
..10 . . Port Dover Panthers . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . ...902 . . ...614
..11 . . Vancouver Vipers . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...721 . . ...710
..12 . . Regina Rams . . . . . . . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...658 . . 1,236
..13 . . Ottawa Storm Troopers . . . . . . . ..4 . . 12 . . 0 . . ..25% . . ...368 . . ...702
..14 . . Cold Lake FREEZE . . . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . ...329 . . ...842
..15 . . Gold Miners C-Park . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . ...391 . . 3,085
..16 . . Carolina Copperheads . . . . . . . ..0 . . 16 . . 0 . . ....0% . . ...350 . . 3,814
 
Peebee12
offline
Link
 
i don'T get how we end up with 2 losses, but oh well. nova scotia, here we come!
 
Page:
 


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