User Pass
Home Sign Up Contact Log In
Forum > Southeast Asia A Leagues > Southeast Asia A #3 > SEA A#3 Spreadsheet Standings and Game 6 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.

I have noticed that it's gotten more and more accurate after each game. Last week, the spreadsheet correcly predicted 15 of the 16 games...based on prior scores alone! After game 8 or so is when this method is supposedly very accurate. At that point, I'll probably post projected scores as well.
 
Groucho
offline
Link
 
Current Standings (after Game 5)

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Augusta Black Knights . . . . 5 . . 0 . . 0 . . 100% . . 193 . . ..54
..2 . . Taipei Dragons. . . . . . . . . . . 5 . . 0 . . 0 . . 100% . . 150 . . ..41
..3 . . Shanghai Assassins. . . . . . 5 . . 0 . . 0 . . 100% . . 150 . . ..68
..4 . . Jakarta Underdogz. . . . . . . . 4 . . 1 . . 0 . . ..80% . . 172 . . ..82
..5 . . Haiphong Dragons . . . . . . . 3 . . 2 . . 0 . . ..60% . . 142 . . ..83
..6 . . Guangzhou Fight Club. . . . . 3 . . 2 . . 0 . . ..60% . . ..82 . . ..85
..7 . . Jakarta Rhinos . . . . . . . . . . . 3 . . 2 . . 0 . . ..60% . . 159 . . 145
..8 . . Dakota Thunderheads. . . . . 3 . . 2 . . 0 . . ..60% . . 126 . . ..77
..9 . . Karachi Kings . . . . . . . . . . . . 3 . . 2 . . 0 . . ..60% . . 140 . . ..63
10 . . Phuket Alls. . . . . . . . . . . . . . . 3 . . 2 . . 0 . . ..60% . . 134 . . ..80
11 . . Buffalo Braves. . . . . . . . . . . . 2 . . 3 . . 0 . . ..40% . . 168 . . 152
12 . . Kuala Lumpur Coyotes. . . . 1 . . 4 . . 0 . . ..20% . . ..61 . . 125
13 . . Concordia TME. . . . . . . . . . . 0 . . 5 . . 0 . . ....0% . . ..86 . . 201
14 . . Singapore Scorpions. . . . . . 0 . . 5 . . 0 . . ....0% . . ..66 . . 188
15 . . Phnom Penh Vultures. . . . . 0 . . 5 . . 0 . . ....0% . . ..44 . . 268
16 . . AU Nation Tigers . . . . . . . . . 0 . . 5 . . 0 . . ....0% . . ..23 . . 184

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 5 . . 0 . . 0 . . 100% . . 210 . . ..83
..2 . . ITAT Tigers. . . . . . . . . . . . . . . 5 . . 0 . . 0 . . 100% . . 166 . . ..49
..3 . . Skaro Daleks. . . . . . . . . . . . . 4 . . 1 . . 0 . . ..80% . . 189 . . ..64
..4 . . Easter Island Terror. . . . . . . 4 . . 1 . . 0 . . ..80% . . 186 . . ..99
..5 . . Good Morning Vietnam . . . . 4 . . 1 . . 0 . . ..80% . . 158 . . ..96
..6 . . Singapore Canes. . . . . . . . . 4 . . 1 . . 0 . . ..80% . . 212 . . ..81
..7 . . Orchard Code Red. . . . . . . . 3 . . 2 . . 0 . . ..60% . . 171 . . 103
..8 . . PCE PubCrawlers. . . . . . . . . 3 . . 2 . . 0 . . ..60% . . 126 . . 132
..9 . . Guelph Phoenix. . . . . . . . . . . 3 . . 2 . . 0 . . ..60% . . 165 . . 132
10 . . Hong Kong Vipers. . . . . . . . . 2 . . 3 . . 0 . . ..40% . . 153 . . 130
11 . . Aracaju Ninfos. . . . . . . . . . . . 1 . . 4 . . 0 . . ..20% . . 151 . . 191
12 . . Harrisburg Heat. . . . . . . . . . . 1 . . 4 . . 0 . . ..20% . . ..81 . . 213
13 . . Medan Marlins. . . . . . . . . . . .1 . . 4 . . 0 . . ..20% . . 114 . . 220
14 . . NW Arkansas Laser Cats. . . 0 . . 5 . . 0 . . ....0% . . ..89 . . 249
15 . . Yokohama Samurai. . . . . . . . 0 . . 5 . . 0 . . ....0% . . ..44 . . 231
16 . . Buffalo Billz . . . . . . . . . . . . . . . 0 . . 5 . . 0 . . ....0% . . ..42 . . 184
 
Groucho
offline
Link
 
Projected Standings

Alpha Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Augusta Black Knights . . . . 16 . . ..0 . . 0 . . 100% . . 654 . . 233
..2 . . Shanghai Assassins. . . . . . 15 . . ..1 . . 0 . . ..94% . . 529 . . 197
..3 . . Taipei Dragons. . . . . . . . . . . 14 . . ..2 . . 0 . . ..88% . . 462 . . 177
..4 . . Haiphong Dragons . . . . . . . 13 . . ..3 . . 0 . . ..81% . . 548 . . 238
..5 . . Karachi Kings . . . . . . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 365 . . 208
..6 . . Jakarta Underdogz. . . . . . . . 10 . . ..6 . . 0 . . ..63% . . 517 . . 365
..7 . . Guangzhou Fight Club. . . . . 10 . . ..6 . . 0 . . ..63% . . 323 . . 238
..8 . . Dakota Thunderheads. . . . . ..9 . . ..7 . . 0 . . ..56% . . 383 . . 273
..9 . . Phuket Alls. . . . . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 385 . . 313
10 . . Buffalo Braves. . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 507 . . 525
11 . . Jakarta Rhinos . . . . . . . . . . . ..7 . . ..9 . . 0 . . ..44% . . 554 . . 521
12 . . Concordia TME. . . . . . . . . . . ..4 . . 12 . . 0 . . ..25% . . 372 . . 592
13 . . Singapore Scorpions. . . . . . ..4 . . 12 . . 0 . . ..25% . . 320 . . 526
14 . . Kuala Lumpur Coyotes. . . . ..2 . . 14 . . 0 . . ..13% . . 175 . . 418
15 . . AU Nation Tigers . . . . . . . . . ..1 . . 15 . . 0 . . ....6% . . 105 . . 553
16 . . Phnom Penh Vultures. . . . . ..0 . . 16 . . 0 . . ....0% . . 120 . . 951

Zeta Conference
Rk__Team_________________W___L___T____%_____PF____PA__
..1 . . Bangkok Strikers. . . . . . . . . . 15 . . ..1 . . 0 . . 94% . . 731 . . 272
..2 . . Skaro Daleks. . . . . . . . . . . . . 15 . . ..1 . . 0 . . 94% . . 645 . . 187
..3 . . Singapore Canes. . . . . . . . . 14 . . ..2 . . 0 . . 88% . . 665 . . 263
..4 . . ITAT Tigers. . . . . . . . . . . . . . . 13 . . ..3 . . 0 . . 81% . . 433 . . 205
..5 . . Good Morning Vietnam . . . . 12 . . ..4 . . 0 . . 75% . . 585 . . 278
..6 . . Easter Island Terror. . . . . . . 12 . . ..4 . . 0 . . 75% . . 700 . . 294
..7 . . Orchard Code Red. . . . . . . . 10 . . ..6 . . 0 . . 63% . . 559 . . 378
..8 . . PCE PubCrawlers. . . . . . . . . ..9 . . ..7 . . 0 . . 56% . . 456 . . 425
..9 . . Hong Kong Vipers. . . . . . . . . ..7 . . ..9 . . 0 . . 44% . . 508 . . 404
10 . . Aracaju Ninfos. . . . . . . . . . . . ..7 . . ..9 . . 0 . . 44% . . 564 . . 534
11 . . Guelph Phoenix. . . . . . . . . . . ..5 . . 11 . . 0 . . 31% . . 455 . . 501
12 . . Medan Marlins. . . . . . . . . . . ...4 . . 12 . . 0 . . 25% . . 407 . . 969
13 . . NW Arkansas Laser Cats. . . ..3 . . 13 . . 0 . . 19% . . 329 . . 751
14 . . Harrisburg Heat. . . . . . . . . . . ..2 . . 14 . . 0 . . 13% . . 274 . . 711
15 . . Yokohama Samurai. . . . . . . . ..1 . . 15 . . 0 . . ..6% . . 163 . . 794
16 . . Buffalo Billz . . . . . . . . . . . . . . . ..0 . . 16 . . 0 . . ..0% . . 134 . . 581
 
Groucho
offline
Link
 
Game 6 Predictions

(Predicted winners are bolded)

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

Zeta Conference
Bangkok Strikers vs Medan Marlins
Skaro Daleks vs Singapore Canes
Aracaju Ninfos vs Guelph Phoenix
Hong Kong Vipers vs Buffalo Billz
ITAT Tigers vs Orchard Code Red
NW Arkansas Laser Cats vs Harrisburg Heat
Good Morning Vietnam vs PCE PubCrawlers
Easter Island Terror vs Yokohama Samurai
 
mat5592
it's here
offline
Link
 
Looks about right
 
Thrashing
offline
Link
 
back to the drawing board for PCE's tactics
 
Rockemsockem
offline
Link
 
Bangkok w00t!
 
Rockemsockem
offline
Link
 
I also want to know who is supposed to beat us.
 
eagleblood18
offline
Link
 
damn you good i love it! Go thunderheads!
 
Caledric
offline
Link
 
I don't even know if its worth doing tactics anymore... My tactics against Jakarta were 95% run, 5% pass... the game ran 31 runs, 34 passes... So much for settings, not even close to what I had set.
 
Legatus
offline
Link
 
Originally posted by Caledric
I don't even know if its worth doing tactics anymore... My tactics against Jakarta were 95% run, 5% pass... the game ran 31 runs, 34 passes... So much for settings, not even close to what I had set.


It's a lot easier for your tactics to be followed if you do them specifically in the advanced AI page instead of the basics.
 
Bomber085
offline
Link
 
Care to share your spreadsheet?
 
matta
offline
Link
 
Originally posted by Bomber085
Care to share your spreadsheet?


It's available here:

http://goallineblitz.com/game/forum_thread.pl?thread_id=470138

It is being run for a variety of leagues and looks to work extremely well.
 
mat5592
it's here
offline
Link
 
I dont think theres a point in doing predictions with this thing here lol
 
Groucho
offline
Link
 
There's always a point. I personally prefer well-written commentary to boring numbers and stats.
 
Page:
 


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