User Pass
Home Sign Up Contact Log In
Forum > Southeast Asia A Leagues > Southeast Asia A #3 > SEA A#3 Spreadsheet Standings and Game 9 Predictions (now includes spreads!)
Page:
 
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.

As a general rule, it's gotten more and more accurate after each game. Last week, the spreadsheet correctly predicted 15 of the 16 games based on prior scores alone. After game 8 or so, this method is supposedly very accurate. So, starting this week I'm posting projected scores for the next game as well.

More information on the spreadsheet can be found here: http://goallineblitz.com/game/forum_thread.pl?thread_id=470138
Last edited Aug 17, 2008 21:19:40
 
Groucho
offline
Link
 
Current Standings (after Game 8)

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Augusta Black Knights . . . . 8 . . 0 . . 0 . . 100% . . 370 . . ..91
..2 . . Taipei Dragons. . . . . . . . . . . 8 . . 0 . . 0 . . 100% . . 289 . . ..58
..3 . . Shanghai Assassins. . . . . . 8 . . 0 . . 0 . . 100% . . 256 . . 106
..4 . . Jakarta Underdogz. . . . . . . . 7 . . 1 . . 0 . . ..88% . . 269 . . 119
..5 . . Guangzhou Fight Club. . . . . 6 . . 2 . . 0 . . ..75% . . 205 . . 112
..6 . . Phuket Alls. . . . . . . . . . . . . . . 6 . . 2 . . 0 . . ..75% . . 280 . . 117
..7 . . Dakota Thunderheads. . . . . 5 . . 3 . . 0 . . ..63% . . 205 . . 108
..8 . . Haiphong Dragons . . . . . . . 4 . . 4 . . 0 . . ..50% . . 204 . . 148
..9 . . Karachi Kings . . . . . . . . . . . . 4 . . 4 . . 0 . . ..50% . . 212 . . 169
10 . . Jakarta Rhinos . . . . . . . . . . . 3 . . 5 . . 0 . . ..38% . . 206 . . 280
11 . . Concordia TME. . . . . . . . . . . 2 . . 6 . . 0 . . ..25% . . 183 . . 270
12 . . Buffalo Braves. . . . . . . . . . . . 2 . . 6 . . 0 . . ..25% . . 223 . . 265
13 . . Kuala Lumpur Coyotes. . . . 1 . . 7 . . 0 . . ..13% . . ..81 . . 232
14 . . Singapore Scorpions. . . . . . 0 . . 8 . . 0 . . ....0% . . ..76 . . 282
15 . . Phnom Penh Vultures. . . . . 0 . . 8 . . 0 . . ....0% . . ..61 . . 487
16 . . AU Nation Tigers . . . . . . . . . 0 . . 8 . . 0 . . ....0% . . ..40 . . 316

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Easter Island Terror. . . . . . . 7 . . 1 . . 0 . . 88% . . 292 . . 116
..2 . . Bangkok Strikers. . . . . . . . . . 7 . . 1 . . 0 . . 88% . . 273 . . 123
..3 . . PCE PubCrawlers. . . . . . . . . 6 . . 2 . . 0 . . 75% . . 216 . . 169
..4 . . ITAT Tigers. . . . . . . . . . . . . . . 6 . . 2 . . 0 . . 75% . . 210 . . 112
..5 . . Skaro Daleks. . . . . . . . . . . . . 6 . . 2 . . 0 . . 75% . . 289 . . ..93
..6 . . Singapore Canes. . . . . . . . . 6 . . 2 . . 0 . . 75% . . 276 . . 118
..7 . . Good Morning Vietnam . . . . 6 . . 2 . . 0 . . 75% . . 250 . . 147
..8 . . Hong Kong Vipers. . . . . . . . . 5 . . 3 . . 0 . . 63% . . 256 . . 167
..9 . . Aracaju Ninfos. . . . . . . . . . . . 4 . . 4 . . 0 . . 50% . . 314 . . 239
10 . . Orchard Code Red. . . . . . . . 4 . . 4 . . 0 . . 50% . . 253 . . 186
11 . . Guelph Phoenix. . . . . . . . . . . 3 . . 5 . . 0 . . 38% . . 222 . . 271
12 . . NW Arkansas Laser Cats. . . 2 . . 6 . . 0 . . 25% . . 176 . . 306
13 . . Medan Marlins. . . . . . . . . . . .1 . . 7 . . 0 . . 13% . . 134 . . 332
14 . . Harrisburg Heat. . . . . . . . . . . 1 . . 7 . . 0 . . 13% . . 111 . . 344
15 . . Buffalo Billz . . . . . . . . . . . . . . . 0 . . 8 . . 0 . . ..0% . . ..79 . . 290
16 . . Yokohama Samurai. . . . . . . . 0 . . 8 . . 0 . . ..0% . . ..47 . . 385
 
Groucho
offline
Link
 
Projected Standings

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons. . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 477 . . 152
..2 . . Augusta Black Knights . . . . 15 . . ..1 . . 0 . . ..94% . . 627 . . 237
..3 . . Shanghai Assassins. . . . . . 14 . . ..2 . . 0 . . ..88% . . 574 . . 226
..4 . . Haiphong Dragons . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 496 . . 249
..5 . . Jakarta Underdogz. . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 555 . . 296
..6 . . Guangzhou Fight Club. . . . . 11 . . ..5 . . 0 . . ..69% . . 462 . . 212
..7 . . Dakota Thunderheads. . . . . 10 . . ..6 . . 0 . . ..63% . . 435 . . 231
..8 . . Phuket Alls. . . . . . . . . . . . . . . ..9 . . ..7 . . 0 . . ..56% . . 452 . . 295
..9 . . Karachi Kings . . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 381 . . 330
10 . . Concordia TME. . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 463 . . 501
11 . . Buffalo Braves. . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 438 . . 514
12 . . Jakarta Rhinos . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 419 . . 544
13 . . Singapore Scorpions. . . . . . ..4 . . 12 . . 0 . . ..25% . . 247 . . 473
14 . . Kuala Lumpur Coyotes. . . . ..2 . . 14 . . 0 . . ..13% . . 156 . . 460
15 . . AU Nation Tigers . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 114 . . 567
16 . . Phnom Penh Vultures. . . . . ..0 . . 16 . . 0 . . ....0% . . 117 . . 954

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 629 . . 230
..2 . . Easter Island Terror. . . . . . . 14 . . ..2 . . 0 . . 88% . . 596 . . 225
..3 . . Skaro Daleks. . . . . . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 571 . . 179
..4 . . Singapore Canes. . . . . . . . . 13 . . ..3 . . 0 . . 81% . . 570 . . 247
..5 . . PCE PubCrawlers. . . . . . . . . 12 . . ..4 . . 0 . . 75% . . 506 . . 329
..6 . . Good Morning Vietnam . . . . 12 . . ..4 . . 0 . . 75% . . 558 . . 282
..7 . . Hong Kong Vipers. . . . . . . . . 11 . . ..5 . . 0 . . 69% . . 569 . . 318
..8 . . ITAT Tigers. . . . . . . . . . . . . . . 10 . . ..6 . . 0 . . 63% . . 381 . . 254
..9 . . Aracaju Ninfos. . . . . . . . . . . . ..8 . . ..8 . . 0 . . 50% . . 589 . . 474
10 . . Orchard Code Red. . . . . . . . ..6 . . 10 . . 0 . . 38% . . 490 . . 422
11 . . Guelph Phoenix. . . . . . . . . . . ..5 . . 11 . . 0 . . 31% . . 408 . . 546
12 . . NW Arkansas Laser Cats. . . ..4 . . 12 . . 0 . . 25% . . 321 . . 616
13 . . Medan Marlins. . . . . . . . . . . ...3 . . 13 . . 0 . . 19% . . 313 . . 655
14 . . Harrisburg Heat. . . . . . . . . . . ..2 . . 14 . . 0 . . 13% . . 204 . . 701
15 . . Buffalo Billz . . . . . . . . . . . . . . . ..2 . . 14 . . 0 . . 13% . . 190 . . 545
16 . . Yokohama Samurai. . . . . . . . ..0 . . 16 . . 0 . . ..0% . . ..90 . . 798
 
Groucho
offline
Link
 
Game 9 Predictions and Point Spread

(Predicted winners are bolded)

Alpha Conference
Dakota Thunderheads vs Jakarta Rhinos (36-17) Spread: 19
Jakarta Underdogz vs Phnom Penh Vultures (122-6) Spread: 116
Phuket Alls vs Karachi Kings (24-19) Spread: 5
Buffalo Braves vs AU Nation Tigers (43-10) Spread: 33
Shanghai Assassins vs Kuala Lumpur Coyotes (41-6) Spread: 35
Concordia TME vs Singapore Scorpions (36-19) Spread: 17
Haiphong Dragons vs Guangzhou Fight Club (17-16) Spread: 1
Taipei Dragons vs Augusta Black Knights (21-17) Spread: 4

Zeta Conference
Bangkok Strikers vs Good Morning Vietnam (27-19) Spread: 8
Skaro Daleks vs Yokohama Samurai (67-3) Spread: 64
Aracaju Ninfos vs Orchard Code Red (40-36) Spread: 4
Guelph Phoenix vs Buffalo Billz (35-13) Spread: 22
Hong Kong Vipers vs ITAT Tigers (20-20) Spread: 0
Singapore Canes vs Medan Marlins (56-11) Spread: 45
PCE PubCrawlers vs Harrisburg Heat (73-11) Spread: 62
Easter Island Terror vs NW Arkansas Laser Cats (56-11) Spread: 45
 
Caledric
offline
Link
 
Well I see at least one wrong prediction for next week.
 
-Lil-Dro-
offline
Link
 
yeh u better believe it!

vipers showin what they can do
 
Caledric
offline
Link
 
I wonder if the spread sheet takes into account a front loaded schedule... My offense has played the toughest teams all one right after another already. I expect an offensive explosion here in the 2nd half of the season. My defense has also played well all season, they have just been way out leveled.
Last edited Aug 17, 2008 21:31:48
 
mat5592
it's here
offline
Link
 
Lol @ 122-6
 
Groucho
offline
Link
 
Originally posted by Caledric
I wonder if the spread sheet takes into account a front loaded schedule...

It does:

Toughest Schedule So Far

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Singapore Scorpions. . . . . . 44 . . 12 . . 0 . . 79% . . 1,804 . . ...804
..2 . . Haiphong Dragons . . . . . . . 42 . . 14 . . 0 . . 75% . . 1,794 . . 1,051
..3 . . AU Nation Tigers . . . . . . . . . 42 . . 14 . . 0 . . 75% . . 1,741 . . ...941
..4 . . Concordia TME. . . . . . . . . . . 36 . . 20 . . 0 . . 64% . . 1,578 . . 1,051
..5 . . Kuala Lumpur Coyotes. . . . 34 . . 22 . . 0 . . 61% . . 1,660 . . 1,348
..6 . . Jakarta Rhinos . . . . . . . . . . . 31 . . 25 . . 0 . . 55% . . 1,505 . . 1,332
..7 . . Buffalo Braves. . . . . . . . . . . . 30 . . 26 . . 0 . . 54% . . 1,352 . . 1,367
..8 . . Guangzhou Fight Club. . . . . 28 . . 28 . . 0 . . 50% . . 1,420 . . 1,378
..9 . . Phnom Penh Vultures. . . . . 28 . . 28 . . 0 . . 50% . . 1,378 . . 1,299
10 . . Shanghai Assassins. . . . . . 26 . . 30 . . 0 . . 46% . . 1,299 . . 1,364
11 . . Jakarta Underdogz. . . . . . . . 23 . . 33 . . 0 . . 41% . . 1,132 . . 1,477
12 . . Karachi Kings . . . . . . . . . . . . 22 . . 34 . . 0 . . 39% . . 1,341 . . 1,631
13 . . Dakota Thunderheads. . . . . 20 . . 36 . . 0 . . 36% . . 1,160 . . 1,526
14 . . Taipei Dragons. . . . . . . . . . . 14 . . 42 . . 0 . . 25% . . 1,045 . . 1,890
15 . . Augusta Black Knights . . . . 14 . . 42 . . 0 . . 25% . . ...972 . . 1,814
16 . . Phuket Alls. . . . . . . . . . . . . . . 14 . . 42 . . 0 . . 25% . . ...939 . . 1,847

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Buffalo Billz . . . . . . . . . . . . . . . 35 . . 21 . . 0 . . 63% . . 1,614 . . 1,182
..2 . . Medan Marlins. . . . . . . . . . . .33 . . 23 . . 0 . . 59% . . 1,555 . . 1,206
..3 . . PCE PubCrawlers. . . . . . . . . 32 . . 24 . . 0 . . 57% . . 1,531 . . 1,344
..4 . . Hong Kong Vipers. . . . . . . . . 30 . . 26 . . 0 . . 54% . . 1,606 . . 1,412
..5 . . Easter Island Terror. . . . . . . 30 . . 26 . . 0 . . 54% . . 1,509 . . 1,438
..6 . . Bangkok Strikers. . . . . . . . . . 29 . . 27 . . 0 . . 52% . . 1,551 . . 1,435
..7 . . Good Morning Vietnam . . . . 28 . . 28 . . 0 . . 50% . . 1,606 . . 1,481
..8 . . Singapore Canes. . . . . . . . . 27 . . 29 . . 0 . . 48% . . 1,548 . . 1,508
..9 . . Skaro Daleks. . . . . . . . . . . . . 27 . . 29 . . 0 . . 48% . . 1,508 . . 1,503
10 . . Orchard Code Red. . . . . . . . 27 . . 29 . . 0 . . 48% . . 1,398 . . 1,546
11 . . NW Arkansas Laser Cats. . . 26 . . 30 . . 0 . . 46% . . 1,382 . . 1,565
12 . . Yokohama Samurai. . . . . . . . 25 . . 31 . . 0 . . 45% . . 1,469 . . 1,645
13 . . Harrisburg Heat. . . . . . . . . . . 25 . . 31 . . 0 . . 45% . . 1,459 . . 1,597
14 . . Guelph Phoenix. . . . . . . . . . . 25 . . 31 . . 0 . . 45% . . 1,427 . . 1,616
15 . . Aracaju Ninfos. . . . . . . . . . . . 25 . . 31 . . 0 . . 45% . . 1,330 . . 1,573
16 . . ITAT Tigers. . . . . . . . . . . . . . . 24 . . 32 . . 0 . . 43% . . 1,293 . . 1,735
Last edited Aug 17, 2008 21:39:36
 
mat5592
it's here
offline
Link
 
I think all the Alpha scores are about right. Singapore game might be a little different though
 
Legatus
offline
Link
 
Originally posted by Caledric
I wonder if the spread sheet takes into account a front loaded schedule... My offense has played the toughest teams all one right after another already. I expect an offensive explosion here in the 2nd half of the season. My defense has also played well all season, they have just been way out leveled.


It does. You're just doing it wrong; Concordia has kept it closer against the same teams and it DOES take that into account.
 
Groucho
offline
Link
 
The spreadsheet predicted the w/l on the following games incorrectly:

Zeta Conference
Guelph Phoenix vs Buffalo Billz (35-13) Spread: 22 -- actual 31-13 in favor of the Billz!
Hong Kong Vipers vs ITAT Tigers (20-20) Spread: 0 -- actual 34-14 in favor of the Tigers

 
mat5592
it's here
offline
Link
 
Dand we lost by 2...
 
mat5592
it's here
offline
Link
 
There were quite a few good games this week
 
KtOwnsYou
offline
Link
 
we underestimated team and didnt gameplan
 
Page:
 


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