User Pass
Home Sign Up Contact Log In
Forum > Southeast Asia A Leagues > Southeast Asia A #3 > SEA A#3 Season 5 Spreadsheet: Standings and Game 15 Predictions
Page:
 
Groucho
offline
Link
 
Introduction

Legendary forum member "Satchmo-n-Dizzy" has put together a league projector spreadsheet. The basic concept is that it takes the points scored by your team, and against your team, and uses that to project the rest of the season.

As a general rule, it gets more and more accurate after each game. Last week, the spreadsheet called 14/16 games correctly...based only on prior scores. However, upsets happen often, so if your team is projected to lose this week, step up your game!

More information on the spreadsheet can be found here: http://goallineblitz.com/game/forum_thread.pl?thread_id=470138
 
Groucho
offline
Link
 
Current standings (after 14 games)

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons . . . . . . . . . . . 14 . . ..0 . . 0 . . 100% . . 593 . . ...175
..2 . . Haiphong Red Dragons. . . . 13 . . ..1 . . 0 . . ..93% . . 877 . . ...129
..3 . . Guangzhou Fight Club . . . . . 12 . . ..2 . . 0 . . ..86% . . 549 . . ...144
..4 . . Augusta Black Knights . . . . . 11 . . ..3 . . 0 . . ..79% . . 872 . . ...277
..5 . . Jakarta Underdogz . . . . . . . . 10 . . ..4 . . 0 . . ..71% . . 496 . . ...276
..6 . . Singapore Scorpions . . . . . . ..9 . . ..5 . . 0 . . ..64% . . 678 . . ...262
..7 . . Malaysia Hurricanes. . . . . . . ..8 . . ..6 . . 0 . . ..57% . . 474 . . ...224
..8 . . Chiang Mai Talkers. . . . . . . . ..8 . . ..6 . . 0 . . ..57% . . 565 . . ...333
..9 . . Dakota Thunderheads. . . . . ..7 . . ..7 . . 0 . . ..50% . . 312 . . ...416
10 . . Karachi Kings . . . . . . . . . . . . ..6 . . ..8 . . 0 . . ..43% . . 480 . . ...463
11 . . Phuket Alls . . . . . . . . . . . . . . . ..5 . . ..9 . . 0 . . ..36% . . 495 . . ...456
12 . . Jakarta Rhinos. . . . . . . . . . . . ..4 . . 10 . . 0 . . ..29% . . 308 . . ...460
13 . . Buffalo Braves . . . . . . . . . . . . ..3 . . 11 . . 0 . . ..21% . . 180 . . ...536
14 . . St Marys Broncos . . . . . . . . . ..2 . . 12 . . 0 . . ..14% . . 232 . . ...968
15 . . Le Thor Devil Bats. . . . . . . . . ..0 . . 14 . . 0 . . ....0% . . 162 . . ...951
16 . . Phnom Penh Vultures. . . . . . ..0 . . 14 . . 0 . . ....0% . . ..47 . . 1,250

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Singapore Canes . . . . . . . . . 14 . . ..0 . . 0 . . 100% . . 826 . . ...155
..2 . . Skaro Daleks . . . . . . . . . . . . . 13 . . ..1 . . 0 . . ..93% . . 874 . . ...163
..3 . . Easter Island Terror . . . . . . . 12 . . ..2 . . 0 . . ..86% . . 613 . . ...240
..4 . . PCE PubCrawlers. . . . . . . . . 11 . . ..3 . . 0 . . ..79% . . 557 . . ...228
..5 . . Yokohama Samurai. . . . . . . ..9 . . ..5 . . 0 . . ..64% . . 420 . . ...215
..6 . . Buffalo Billz . . . . . . . . . . . . . . ..9 . . ..5 . . 0 . . ..64% . . 370 . . ...351
..7 . . NW Arkansas Laser Cats . . ..8 . . ..6 . . 0 . . ..57% . . 500 . . ...383
..8 . . Hong Kong Vipers. . . . . . . . . ..7 . . ..7 . . 0 . . ..50% . . 487 . . ...375
..9 . . Bangkok Strikers. . . . . . . . . . ..7 . . ..7 . . 0 . . ..50% . . 437 . . ...384
10 . . Las Vegas Losers . . . . . . . . ..6 . . ..8 . . 0 . . ..43% . . 378 . . ...410
11 . . ITAT Tigers. . . . . . . . . . . . . . . ..5 . . ..9 . . 0 . . ..36% . . 329 . . ...400
12 . . Manila Gorillaz. . . . . . . . . . . . ..3 . . 10 . . 1 . . ..25% . . 321 . . ...442
13 . . Harrisburg Heat . . . . . . . . . . ..3 . . 11 . . 0 . . ..21% . . 405 . . ...610
14 . . Kung Pow Chickens. . . . . . . . . . . ...2 . . 11 . . 1 . . ..18% . . 218 . . ...474
15 . . Seoul Hodori. . . . . . . . . . . . . ..1 . . 13 . . 0 . . ....7% . . ..88 . . 1,110
16 . . Gotham Comets. . . . . . . . . . ..1 . . 13 . . 0 . . ....7% . . 179 . . 1,062
 
Groucho
offline
Link
 
Projected Standings

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons . . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 677 . . ...185
..2 . . Haiphong Red Dragons. . . . 15 . . ..1 . . 0 . . ..94% . . 981 . . ...144
..3 . . Guangzhou Fight Club . . . . . 14 . . ..2 . . 0 . . ..88% . . 620 . . ...158
..4 . . Augusta Black Knights . . . . . 12 . . ..4 . . 0 . . ..75% . . 957 . . ...314
..5 . . Singapore Scorpions . . . . . . 11 . . ..5 . . 0 . . ..69% . . 721 . . ...296
..6 . . Jakarta Underdogz . . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 537 . . ...318
..7 . . Malaysia Hurricanes. . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 493 . . ...264
..8 . . Chiang Mai Talkers. . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 593 . . ...379
..9 . . Dakota Thunderheads. . . . . ..8 . . ..8 . . 0 . . ..50% . . 348 . . ...456
10 . . Karachi Kings . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 607 . . ...496
11 . . Phuket Alls . . . . . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 544 . . ...501
12 . . Jakarta Rhinos. . . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . 343 . . ...543
13 . . Buffalo Braves . . . . . . . . . . . . ..3 . . 13 . . 0 . . ..19% . . 187 . . ...620
14 . . St Marys Broncos . . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . 254 . . 1,167
15 . . Le Thor Devil Bats. . . . . . . . . ..2 . . 14 . . 0 . . ..13% . . 216 . . ...964
16 . . Phnom Penh Vultures. . . . . . ..0 . . 16 . . 0 . . ....0% . . ..56 . . 1,319

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Singapore Canes . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 919 . . ...168
..2 . . Skaro Daleks . . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 941 . . ...185
..3 . . Easter Island Terror . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 671 . . ...268
..4 . . PCE PubCrawlers. . . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 628 . . ...264
..5 . . Yokohama Samurai. . . . . . . 11 . . ..5 . . 0 . . ..69% . . 466 . . ...230
..6 . . NW Arkansas Laser Cats . . 10 . . ..6 . . 0 . . ..63% . . 553 . . ...413
..7 . . Buffalo Billz . . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 399 . . ...393
..8 . . Bangkok Strikers. . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 548 . . ...418
..9 . . Hong Kong Vipers. . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 520 . . ...434
10 . . Las Vegas Losers . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 397 . . ...488
11 . . ITAT Tigers. . . . . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 410 . . ...420
12 . . Harrisburg Heat . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . 507 . . ...652
13 . . Manila Gorillaz. . . . . . . . . . . . ..3 . . 12 . . 1 . . ..22% . . 350 . . ...507
14 . . Kung Pow Chickens. . . . . . . . . . . ...2 . . 13 . . 1 . . ..16% . . 229 . . ...542
15 . . Gotham Comets. . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 201 . . 1,247
16 . . Seoul Hodori. . . . . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 100 . . 1,189
 
Groucho
offline
Link
 
Game 15 Predictions

(projected winner is bolded)

Alpha Conference
Phuket Alls vs Dakota Thunderheads (34-21) Spread: 13
Karachi Kings vs St Marys Broncos (100-17) Spread: 83
Le Thor Devil Bats vs Phnom Penh Vultures (35-7) Spread: 28
Singapore Scorpions vs Jakarta Underdogz (29-21) Spread: 8
Haiphong Red Dragons vs Malaysia Hurricanes (86-9) Spread: 77
Taipei Dragons vs Buffalo Braves (56-5) Spread: 51
Guangzhou Fight Club vs Chiang Mai Talkers (29-11) Spread: 18
Augusta Black Knights vs Jakarta Rhinos (71-14) Spread: 57

Zeta Conference
Bangkok Strikers vs Manila Gorillaz (85-21) Spread: 64
Skaro Daleks vs PCE PubCrawlers (32-16) Spread: 16
Harrisburg Heat vs Gotham Comets (84-19) Spread: 65
ITAT Tigers vs Seoul Hodori (67-5) Spread: 62
Singapore Canes vs Las Vegas Losers (61-8) Spread: 53
NW Arkansas Laser Cats vs Buffalo Billz (30-21) Spread: 9
Yokohama Samurai vs Kung Pow Chickens (32-7) Spread: 25
Easter Island Terror vs Hong Kong Vipers (38-19) Spread: 19
 
Narrator
offline
Link
 
Originally posted by Groucho
Game 15 Predictions

(projected winner is bolded)

Haiphong Red Dragons vs Malaysia Hurricanes (86-9) Spread: 77


Damn I hope we don't lose by 77
 
Narrator
offline
Link
 
Originally posted by Groucho
Projected Standings

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Haiphong Red Dragons. . . . 15 . . ..1 . . 0 . . ..94% . . 981 . . ...144
..7 . . Malaysia Hurricanes. . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 493 . . ...264

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Skaro Daleks . . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 941 . . ...185


The projections can't work this way. It has us going 1-1 the last two games and Haiphong and Skaro both 2-0. Those two are our last two games.
 
jay4roch
offline
Link
 
Originally posted by mikeyw77
Originally posted by Groucho

Projected Standings

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Haiphong Red Dragons. . . . 15 . . ..1 . . 0 . . ..94% . . 981 . . ...144
..7 . . Malaysia Hurricanes. . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 493 . . ...264

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Skaro Daleks . . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 941 . . ...185


The projections can't work this way. It has us going 1-1 the last two games and Haiphong and Skaro both 2-0. Those two are our last two games.


As I recall, the spread sheet has always had problems with predictions for the last game of the season. I haven't heard about a fix for it, yet. I would just chalk it up to that.
 
Linker2596
offline
Link
 
Originally posted by mikeyw77
Originally posted by Groucho

Projected Standings

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Haiphong Red Dragons. . . . 15 . . ..1 . . 0 . . ..94% . . 981 . . ...144
..7 . . Malaysia Hurricanes. . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 493 . . ...264

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Skaro Daleks . . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 941 . . ...185


The projections can't work this way. It has us going 1-1 the last two games and Haiphong and Skaro both 2-0. Those two are our last two games.


No problem just remember that you'll lose your final two games
 
topper29
offline
Link
 
Originally posted by mikeyw77
Originally posted by Groucho

Game 15 Predictions

(projected winner is bolded)

Haiphong Red Dragons vs Malaysia Hurricanes (86-9) Spread: 77


Damn I hope we don't lose by 77


I doubt you will. You guys have been much better the second half of the season.
 
Caledric
offline
Link
 
Originally posted by Linker2596
Originally posted by mikeyw77

Originally posted by Groucho


Projected Standings

Alpha
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Haiphong Red Dragons. . . . 15 . . ..1 . . 0 . . ..94% . . 981 . . ...144
..7 . . Malaysia Hurricanes. . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 493 . . ...264

Zeta
Rk__Team_________________W___L___T____%_____PF____PA__
..2 . . Skaro Daleks . . . . . . . . . . . . . 15 . . ..1 . . 0 . . ..94% . . 941 . . ...185


The projections can't work this way. It has us going 1-1 the last two games and Haiphong and Skaro both 2-0. Those two are our last two games.


No problem just remember that you'll lose your final two games


That just means its got Skaro wrong... Malaysia will go 1-1 and so will Skaro

 
Groucho
offline
Link
 
Originally posted by mikeyw77
The projections can't work this way. It has us going 1-1 the last two games and Haiphong and Skaro both 2-0. Those two are our last two games.


The projections are at the conference level. There aren't enough data points to accurately predict the final game. On the Alpha spreadsheet, Malaysia beats Skaro 10-9. On the Zeta spreadsheet, Skaro beats Malaysia 35-6.

In other words, the projection for the final game is meaningless. Which is why I don't do scores for that game. So, no week 16 predictions, but I will be back for the first three rounds of the playoffs.

Last edited Oct 19, 2008 08:50:42
 
matta
offline
Link
 
Originally posted by Groucho
The projections are at the conference level. There aren't enough data points to accurately predict the final game. On the Alpha spreadsheet, Malaysia beats Skaro 10-9. On the Zeta spreadsheet, Skaro beats Malaysia 35-6.


Yeah, I've noticed that bug as well. If only we could unlock the equations...
 
Caledric
offline
Link
 
Its not the equations... its the fact that its done on 2 different sheets.

If he would have used one sheet for it and designated certain ranges for each conference it might be able to better predict the score. But also, it uses your scores vs like opps to determine who will win a game.
 
matta
offline
Link
 
The calculations run between the sheets based on opposition records.
 
wallyopd
offline
Link
 
Originally posted by matta
Originally posted by Groucho

The projections are at the conference level. There aren't enough data points to accurately predict the final game. On the Alpha spreadsheet, Malaysia beats Skaro 10-9. On the Zeta spreadsheet, Skaro beats Malaysia 35-6.


Yeah, I've noticed that bug as well. If only we could unlock the equations...


Even with a locked spreadsheet can't you just copy+paste the sheets into a new workbook and have unlocked access to them?
 
Page:
 


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