User Pass
Home Sign Up Contact Log In
Forum > Southeast Asia A Leagues > Southeast Asia A #3 > SEA A#3 Spreadsheet Standings and Game 10 Predictions
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 14 of the 16 games based on prior scores alone.

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 9)

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons. . . . . . . . . . . 9 . . 0 . . 0 . . 100% . . 308 . . ..72
..2 . . Shanghai Assassins. . . . . . 9 . . 0 . . 0 . . 100% . . 298 . . 106
..3 . . Augusta Black Knights . . . . 8 . . 1 . . 0 . . ..89% . . 384 . . 110
..4 . . Jakarta Underdogz. . . . . . . . 8 . . 1 . . 0 . . ..89% . . 332 . . 129
..5 . . Phuket Alls. . . . . . . . . . . . . . . 7 . . 2 . . 0 . . ..78% . . 311 . . 146
..6 . . Guangzhou Fight Club. . . . . 6 . . 3 . . 0 . . ..67% . . 225 . . 133
..7 . . Dakota Thunderheads. . . . . 6 . . 3 . . 0 . . ..67% . . 242 . . 115
..8 . . Haiphong Dragons . . . . . . . 5 . . 4 . . 0 . . ..56% . . 225 . . 168
..9 . . Karachi Kings . . . . . . . . . . . . 4 . . 5 . . 0 . . ..44% . . 241 . . 200
10 . . Concordia TME. . . . . . . . . . . 3 . . 6 . . 0 . . ..33% . . 204 . . 280
11 . . Buffalo Braves. . . . . . . . . . . . 3 . . 6 . . 0 . . ..33% . . 264 . . 286
12 . . Jakarta Rhinos . . . . . . . . . . . 3 . . 6 . . 0 . . ..33% . . 213 . . 317
13 . . Kuala Lumpur Coyotes. . . . 1 . . 8 . . 0 . . ..11% . . ..81 . . 274
14 . . Singapore Scorpions. . . . . . 0 . . 9 . . 0 . . ....0% . . ..86 . . 303
15 . . Phnom Penh Vultures. . . . . 0 . . 9 . . 0 . . ....0% . . ..71 . . 550
16 . . AU Nation Tigers . . . . . . . . . 0 . . 9 . . 0 . . ....0% . . ..61 . . 357

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Easter Island Terror. . . . . . . 8 . . 1 . . 0 . . 89% . . 347 . . 141
..2 . . Bangkok Strikers. . . . . . . . . . 8 . . 1 . . 0 . . 89% . . 289 . . 137
..3 . . ITAT Tigers. . . . . . . . . . . . . . . 7 . . 2 . . 0 . . 78% . . 244 . . 126
..4 . . Singapore Canes. . . . . . . . . 7 . . 2 . . 0 . . 78% . . 320 . . 118
..5 . . PCE PubCrawlers. . . . . . . . . 7 . . 2 . . 0 . . 78% . . 277 . . 176
..6 . . Skaro Daleks. . . . . . . . . . . . . 7 . . 2 . . 0 . . 78% . . 347 . . ..93
..7 . . Good Morning Vietnam . . . . 6 . . 3 . . 0 . . 67% . . 264 . . 163
..8 . . Hong Kong Vipers. . . . . . . . . 5 . . 4 . . 0 . . 56% . . 270 . . 201
..9 . . Aracaju Ninfos. . . . . . . . . . . . 5 . . 4 . . 0 . . 56% . . 335 . . 252
10 . . Orchard Code Red. . . . . . . . 4 . . 5 . . 0 . . 44% . . 266 . . 207
11 . . Guelph Phoenix. . . . . . . . . . . 3 . . 6 . . 0 . . 33% . . 235 . . 302
12 . . NW Arkansas Laser Cats. . . 2 . . 7 . . 0 . . 22% . . 201 . . 361
13 . . Medan Marlins. . . . . . . . . . . .1 . . 8 . . 0 . . 11% . . 134 . . 376
14 . . Harrisburg Heat. . . . . . . . . . . 1 . . 8 . . 0 . . 11% . . 118 . . 405
15 . . Buffalo Billz . . . . . . . . . . . . . . . 1 . . 8 . . 0 . . 11% . . 110 . . 303
16 . . Yokohama Samurai. . . . . . . . 0 . . 9 . . 0 . . ..0% . . ..47 . . 443
 
Groucho
offline
Link
 
Projected Standings

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Taipei Dragons. . . . . . . . . . . 16 . . ..0 . . 0 . . 100% . . 465 . . 146
..2 . . Shanghai Assassins. . . . . . 15 . . ..1 . . 0 . . ..94% . . 595 . . 200
..3 . . Augusta Black Knights . . . . 14 . . ..2 . . 0 . . ..88% . . 617 . . 233
..4 . . Haiphong Dragons . . . . . . . 12 . . ..4 . . 0 . . ..75% . . 493 . . 255
..5 . . Jakarta Underdogz. . . . . . . . 11 . . ..5 . . 0 . . ..69% . . 511 . . 295
..6 . . Guangzhou Fight Club. . . . . 11 . . ..5 . . 0 . . ..69% . . 475 . . 218
..7 . . Dakota Thunderheads. . . . . 11 . . ..5 . . 0 . . ..69% . . 452 . . 216
..8 . . Phuket Alls. . . . . . . . . . . . . . . ..8 . . ..8 . . 0 . . ..50% . . 458 . . 318
..9 . . Karachi Kings . . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 393 . . 347
10 . . Concordia TME. . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 447 . . 469
11 . . Buffalo Braves. . . . . . . . . . . . ..6 . . 10 . . 0 . . ..38% . . 441 . . 541
12 . . Jakarta Rhinos . . . . . . . . . . . ..5 . . 11 . . 0 . . ..31% . . 381 . . 546
13 . . Singapore Scorpions. . . . . . ..4 . . 12 . . 0 . . ..25% . . 232 . . 450
14 . . Kuala Lumpur Coyotes. . . . ..2 . . 14 . . 0 . . ..13% . . 142 . . 462
15 . . AU Nation Tigers . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 140 . . 558
16 . . Phnom Penh Vultures. . . . . ..0 . . 16 . . 0 . . ....0% . . 122 . . 932


Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 623 . . 221
..2 . . Easter Island Terror. . . . . . . 14 . . ..2 . . 0 . . 88% . . 589 . . 254
..3 . . Skaro Daleks. . . . . . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 573 . . 171
..4 . . Singapore Canes. . . . . . . . . 13 . . ..3 . . 0 . . 81% . . 576 . . 219
..5 . . PCE PubCrawlers. . . . . . . . . 12 . . ..4 . . 0 . . 75% . . 513 . . 319
..6 . . Good Morning Vietnam . . . . 12 . . ..4 . . 0 . . 75% . . 553 . . 263
..7 . . ITAT Tigers. . . . . . . . . . . . . . . 11 . . ..5 . . 0 . . 69% . . 405 . . 250
..8 . . Hong Kong Vipers. . . . . . . . . 10 . . ..6 . . 0 . . 63% . . 558 . . 331
..9 . . Aracaju Ninfos. . . . . . . . . . . . ..8 . . ..8 . . 0 . . 50% . . 559 . . 455
10 . . Orchard Code Red. . . . . . . . ..6 . . 10 . . 0 . . 38% . . 445 . . 401
11 . . Guelph Phoenix. . . . . . . . . . . ..4 . . 12 . . 0 . . 25% . . 372 . . 575
12 . . NW Arkansas Laser Cats. . . ..4 . . 12 . . 0 . . 25% . . 339 . . 634
13 . . Medan Marlins. . . . . . . . . . . ...3 . . 13 . . 0 . . 19% . . 296 . . 627
14 . . Buffalo Billz . . . . . . . . . . . . . . . ..3 . . 13 . . 0 . . 19% . . 232 . . 503
15 . . Harrisburg Heat. . . . . . . . . . . ..1 . . 15 . . 0 . . ..6% . . 193 . . 725
16 . . Yokohama Samurai. . . . . . . . ..0 . . 16 . . 0 . . ..0% . . ..83 . . 786
Last edited Aug 19, 2008 21:57:53
 
Groucho
offline
Link
 
Game 10 Predictions with Point Spread

(Predicted winners are in bold)

Alpha Conference
Dakota Thunderheads vs Phnom Penh Vultures (103-4) Spread: 99
Jakarta Underdogz vs Karachi Kings (29-20) Spread: 9
Shanghai Assassins vs Jakarta Rhinos (52-13) Spread: 39
Singapore Scorpions vs AU Nation Tigers (20-10) Spread: 10
Haiphong Dragons vs Concordia TME (39-17) Spread: 22
Taipei Dragons vs Phuket Alls (25-12) Spread: 13
Guangzhou Fight Club vs Kuala Lumpur Coyotes (31-5) Spread: 26
Augusta Black Knights vs Buffalo Braves (63-18) Spread: 45

Zeta Conference
Bangkok Strikers vs Singapore Canes (19-19) Spread: 0
Skaro Daleks vs Orchard Code Red (38-11) Spread: 27
Buffalo Billz vs Harrisburg Heat (35-16) Spread: 19
Guelph Phoenix vs Medan Marlins (39-24) Spread: 15
ITAT Tigers vs NW Arkansas Laser Cats (39-13) Spread: 26
PCE PubCrawlers vs Yokohama Samurai (61-5) Spread: 56
Good Morning Vietnam vs Hong Kong Vipers (26-23) Spread: 3
Easter Island Terror vs Aracaju Ninfos (44-21) Spread: 23
Last edited Aug 19, 2008 19:40:15
 
eagleblood18
offline
Link
 
thats right dakota thunderheads win again.

and y is the current and projected standing the same? i see no change.
 
Groucho
offline
Link
 
Originally posted by eagleblood18
and y is the current and projected standing the same? i see no change.


Whoops! Fixed.

 
eagleblood18
offline
Link
 
thanks. just keeping you on your toes! lol
 
mat5592
it's here
offline
Link
 
wow its gonna be hard to gameplan vs. the underdogz. They're not really weak at any position..
 
Caledric
offline
Link
 
After losing last week in a game where the sim completely ignored my AI vs a team I should have beat... I'm gonna keep low expectations this week... Still depressed over that loss. I've been over the game 1000 times now, and looked at my players compared to theirs probably 2000... There is no reason I should have lost that game. The only reason I can find is that the sim had me passing when my AI said to run.
 
Ts-Rock
offline
Link
 
I went back over my OC's gameplan and found that on all 1st down and 2nd and short plays we had the ball spot to "any spot" to "own 5"

The only thing I can think of is when the AI didn't match up anything it defaulted back to the basics which in turn selected more passing plays since we were losing.

Human error on our parts.

I am upset that our perfect season is over with, but I am not upset about losing to a great team like Taipei! Plus, we will hopefully get a chance to see them again in the playoffs.
 
Thrashing
offline
Link
 
GLB blocked at work now...im effin depressed.

also Fantasy League started with $65 buy in

times are tough for GLB owners esp if u spend money on GLB
 
Ts-Rock
offline
Link
 
Originally posted by Thrashing

times are tough for GLB owners esp if u spend money on GLB


you talking about at work or in general?
 
Groucho
offline
Link
 
Once again, I present the game(s) the spreadsheet got wrong:

Zeta Conference
Bangkok Strikers vs Singapore Canes (19-19) Spread: 0
-----> Actual score: 59-24, Singapore wins

15/16 right this time, and it was predicted to be a close one anyway.
Last edited Aug 21, 2008 19:43:03
 
Caledric
offline
Link
 
Finally got a win and we whooped on the spread woot! Feels good after a disappointing lost last week.
 
Ts-Rock
offline
Link
 
Agreed, not a stat padding win, but a good win!
 
Page:
 


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