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

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.

I have noticed that it's gotten more and more accurate after each game. Last week, the spreadsheet correctly predicted 13 of the 16 games based on prior scores alone. After game 8 or so, this method is supposedly very accurate. At that point, I'll probably post projected scores as well.

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 Game 6)

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Augusta Black Knights . . . . 6 . . 0 . . 0 . . 100% . . 245 . . ..64
..2 . . Taipei Dragons. . . . . . . . . . . 6 . . 0 . . 0 . . 100% . . 215 . . ..41
..3 . . Shanghai Assassins. . . . . . 6 . . 0 . . 0 . . 100% . . 194 . . ..75
..4 . . Jakarta Underdogz. . . . . . . . 5 . . 1 . . 0 . . ..83% . . 196 . . ..99
..5 . . Guangzhou Fight Club. . . . . 4 . . 2 . . 0 . . ..67% . . 120 . . 109
..6 . . Karachi Kings . . . . . . . . . . . . 4 . . 2 . . 0 . . ..67% . . 185 . . ..87
..7 . . Phuket Alls. . . . . . . . . . . . . . . 4 . . 2 . . 0 . . ..67% . . 165 . . ..87
..8 . . Dakota Thunderheads. . . . . 4 . . 2 . . 0 . . ..67% . . 150 . . ..77
..9 . . Jakarta Rhinos . . . . . . . . . . . 3 . . 3 . . 0 . . ..50% . . 169 . . 197
10 . . Haiphong Dragons . . . . . . . 3 . . 3 . . 0 . . ..50% . . 159 . . 107
11 . . Buffalo Braves. . . . . . . . . . . . 2 . . 4 . . 0 . . ..33% . . 192 . . 197
12 . . Kuala Lumpur Coyotes. . . . 1 . . 5 . . 0 . . ..17% . . ..68 . . 156
13 . . Concordia TME. . . . . . . . . . . 0 . . 6 . . 0 . . ....0% . . 110 . . 239
14 . . Singapore Scorpions. . . . . . 0 . . 6 . . 0 . . ....0% . . ..66 . . 212
15 . . Phnom Penh Vultures. . . . . 0 . . 6 . . 0 . . ....0% . . ..44 . . 333
16 . . AU Nation Tigers . . . . . . . . . 0 . . 6 . . 0 . . ....0% . . ..30 . . 228

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 6 . . 0 . . 0 . . 100% . . 237 . . ..86
..2 . . ITAT Tigers. . . . . . . . . . . . . . . 6 . . 0 . . 0 . . 100% . . 197 . . ..77
..3 . . Easter Island Terror. . . . . . . 5 . . 1 . . 0 . . ..83% . . 238 . . ..99
..4 . . Singapore Canes. . . . . . . . . 5 . . 1 . . 0 . . ..83% . . 225 . . ..87
..5 . . Skaro Daleks. . . . . . . . . . . . . 4 . . 2 . . 0 . . ..67% . . 195 . . ..77
..6 . . PCE PubCrawlers. . . . . . . . . 4 . . 2 . . 0 . . ..67% . . 150 . . 146
..7 . . Good Morning Vietnam . . . . 4 . . 2 . . 0 . . ..67% . . 172 . . 120
..8 . . Orchard Code Red. . . . . . . . 3 . . 3 . . 0 . . ..50% . . 199 . . 134
..9 . . Hong Kong Vipers. . . . . . . . . 3 . . 3 . . 0 . . ..50% . . 187 . . 147
10 . . Guelph Phoenix. . . . . . . . . . . 3 . . 3 . . 0 . . ..50% . . 196 . . 177
11 . . Aracaju Ninfos. . . . . . . . . . . . 2 . . 4 . . 0 . . ..33% . . 196 . . 222
12 . . NW Arkansas Laser Cats. . . 1 . . 5 . . 0 . . ..17% . . 122 . . 259
13 . . Medan Marlins. . . . . . . . . . . .1 . . 5 . . 0 . . ..17% . . 117 . . 247
14 . . Harrisburg Heat. . . . . . . . . . . 1 . . 5 . . 0 . . ..17% . . ..91 . . 246
15 . . Buffalo Billz . . . . . . . . . . . . . . . 0 . . 6 . . 0 . . ....0% . . ..59 . . 218
16 . . Yokohama Samurai. . . . . . . . 0 . . 6 . . 0 . . ....0% . . ..44 . . 283
Last edited Aug 13, 2008 21:29:15
 
Groucho
offline
Link
 
Projected Standings

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons. . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 474 . . 155
..2 . . Augusta Black Knights . . . . 15 . . ..1 . . 0 . . ..94% . . 641 . . 217
..3 . . Shanghai Assassins. . . . . . 14 . . ..2 . . 0 . . ..88% . . 545 . . 213
..4 . . Haiphong Dragons . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 512 . . 245
..5 . . Karachi Kings . . . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 393 . . 243
..6 . . Jakarta Underdogz. . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 527 . . 334
..7 . . Dakota Thunderheads. . . . . 10 . . ..6 . . 0 . . ..63% . . 377 . . 216
..8 . . Guangzhou Fight Club. . . . . 10 . . ..6 . . 0 . . ..63% . . 372 . . 261
..9 . . Phuket Alls. . . . . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 409 . . 289
10 . . Buffalo Braves. . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 507 . . 537
11 . . Jakarta Rhinos . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 484 . . 537
12 . . Concordia TME. . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . 417 . . 595
13 . . Singapore Scorpions. . . . . . ..4 . . 12 . . 0 . . ..25% . . 285 . . 489
14 . . Kuala Lumpur Coyotes. . . . ..2 . . 14 . . 0 . . ..13% . . 167 . . 442
15 . . AU Nation Tigers . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 125 . . 547
16 . . Phnom Penh Vultures. . . . . ..0 . . 16 . . 0 . . ....0% . . 101 . . 942

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 15 . . ..1 . . 0 . . 94% . . 645 . . 231
..2 . . Easter Island Terror. . . . . . . 14 . . ..2 . . 0 . . 88% . . 656 . . 259
..3 . . Singapore Canes. . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 611 . . 228
..4 . . Skaro Daleks. . . . . . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 580 . . 189
..5 . . ITAT Tigers. . . . . . . . . . . . . . . 12 . . ..4 . . 0 . . 75% . . 449 . . 252
..6 . . Good Morning Vietnam . . . . 11 . . ..5 . . 0 . . 69% . . 538 . . 284
..7 . . Orchard Code Red. . . . . . . . 10 . . ..6 . . 0 . . 63% . . 571 . . 408
..8 . . PCE PubCrawlers. . . . . . . . . 10 . . ..6 . . 0 . . 63% . . 455 . . 387
..9 . . Hong Kong Vipers. . . . . . . . . ..7 . . ..9 . . 0 . . 44% . . 513 . . 413
10 . . Aracaju Ninfos. . . . . . . . . . . . ..7 . . ..9 . . 0 . . 44% . . 609 . . 530
11 . . Guelph Phoenix. . . . . . . . . . . ..5 . . 11 . . 0 . . 31% . . 438 . . 507
12 . . NW Arkansas Laser Cats. . . ..4 . . 12 . . 0 . . 25% . . 328 . . 682
13 . . Medan Marlins. . . . . . . . . . . ...3 . . 13 . . 0 . . 19% . . 342 . . 732
14 . . Harrisburg Heat. . . . . . . . . . . ..2 . . 14 . . 0 . . 13% . . 223 . . 695
15 . . Buffalo Billz . . . . . . . . . . . . . . . ..1 . . 15 . . 0 . . ..6% . . 167 . . 584
16 . . Yokohama Samurai. . . . . . . . ..0 . . 16 . . 0 . . ..0% . . 128 . . 766
 
Groucho
offline
Link
 
Game 7 Predictions

(Predicted winners are bolded)

Alpha Conference
Jakarta Underdogz vs Kuala Lumpur Coyotes
Phuket Alls vs Jakarta Rhinos
Buffalo Braves vs Concordia TME
Shanghai Assassins vs Singapore Scorpions
Haiphong Dragons vs Dakota Thunderheads
Taipei Dragons vs Karachi Kings
Guangzhou Fight Club vs AU Nation Tigers
Augusta Black Knights vs Phnom Penh Vultures

Zeta Conference
Bangkok Strikers vs ITAT Tigers
Skaro Daleks vs Guelph Phoenix
Aracaju Ninfos vs Harrisburg Heat
Hong Kong Vipers vs Medan Marlins
Singapore Canes vs PCE PubCrawlers
NW Arkansas Laser Cats vs Yokohama Samurai
Good Morning Vietnam vs Buffalo Billz
Easter Island Terror vs Orchard Code Red
 
Caledric
offline
Link
 
Still hoping to prove those projected rankings wrong... Singapore will upset Shanghai... I won't say how, but lets just say we have a lot of chloroform.
 
mat5592
it's here
offline
Link
 
Lol good luck with that. I figured it would have us losing.
 
Groucho
offline
Link
 
Here are the games the spreadsheet got wrong:

Originally posted by Groucho

Alpha Conference
Buffalo Braves vs Concordia TME

Zeta Conference
Singapore Canes vs PCE PubCrawlers


14/16 is a slight improvement from last week. Congrats to Concordia and PCE on the upsets!
 


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