Warrior General Games

The formula/spreadsheet was created by Satchmo-n-Dizzy..."My Excel 2007 based, Score powered, team ranking spreadsheet is now available."

There is a good chance you might know him, as he GMs about 100 teams. And if you don't...he's a mad scientist.

Anyway, using his spreadsheet here are his Power Index rankings:


Western Conference

Rk Team W L T % PF PA
1 Austin Lumberjacks 15 1 0 94% 626 204
2 Raving Mad Dawgs 15 1 0 94% 417 136
3 Las Vegas Legends 14 2 0 88% 397 158
4 Phoenix Ressurection 13 3 0 81% 376 196
5 San Diego Blaze 12 4 0 75% 759 308
6 Anchorage Maulers 10 6 0 63% 410 241
7 Dallas Strikers 10 6 0 63% 377 222
8 Tucson Nighthawks 10 6 0 63% 276 161
9 H-Town Oilers 7 9 0 44% 381 360
10 Fresno Jaguars 7 9 0 44% 258 220
11 Tallahassee Teabaggers 5 11 0 31% 265 365
12 Chicago Clams 4 12 0 25% 264 421
13 Portland Pimps 4 12 0 25% 189 300
14 Colorado Spring Cougars 2 14 0 13% 123 499
15 Omaha Patriots 1 15 0 6% 108 511
16 Out Of State Orangebloods 0 16 0 0% 123 1,056


Eastern Conference

Rk Team L T % PF PA
1 New Hampshire Hounds 16 0 0 100% 491 161
2 Miami Canes 15 1 0 94% 567 128
3 New Orleans Kangaroos 13 3 0 81% 308 102
4 Horny Huku 11 5 0 69% 318 236
5 San Marcos Rivermen 11 5 0 69% 222 114
6 Charlotte Crows 10 6 0 63% 345 288
7 Key Largo Barracudas 10 6 0 63% 249 215
8 MST Peckerheads 7 9 0 44% 198 250
9 Buffalo Badasses 6 10 0 38% 261 363
10 Collinsville Pirates 6 10 0 38% 201 245
11 San Vascarba J-Hawks 6 10 0 38% 191 224
12 Dirty South Pimps 6 10 0 38% 176 244
13 Pittsburgh Soldiers 5 11 0 31% 241 384
14 AP Warriors 3 13 0 19% 208 396
15 Springfield Rifles 3 13 0 19% 94 290
16 Thettford Mines Rednecks 0 16 0 0% 98 563

Available predictions for this tomorrows games:

Eastern Conference

AP 12 vs. Collinsville 20

Buffalo 16 vs. Dirty South 15

Charlotte 20 vs. Huku 23

Key Largo 14 vs. San Vascarba 10

Miami 16 vs. San Marcos 7

MST 15 vs. Springfield 6

New Hampshire 55 vs. Pittsburgh 10

NO Kangaroos 42 vs. Thetford 3

Western Conference

Anchorage 12 vs. Raving 19

Austin 44 vs. Tallahasse 10

Chicago 9 vs. Tucson 23

Colorado 5 vs. Dallas 40

Fresno 9 vs. Phoenix 16

H-Town 12 vs. Las Vegas 28

Omaha 23 vs. OOS 14

Portland 13 vs. San Diego 43 (This one might be way off, due to SD's last game against OOS)

Nice still puts us atop the East

I'm very interested to see how the projections work out. As I was updating the scores, it would project some of the ones that have already been played. Most were dead on, while there were of course a few suprises.

Also, if anyone is interested, I can post the following info:

Easiest Schedule, to date or future
Toughest Schedule, to date or future
Easiest/Toughest Opponents in Defeat/Victory
Points Projected Allowed/Scored

Originally posted by Bigpump
Also, if anyone is interested, I can post the following info:

Easiest Schedule, to date or future
Toughest Schedule, to date or future
Easiest/Toughest Opponents in Defeat/Victory
Points Projected Allowed/Scored

Please do, I'd love to see that.

Easiest Schedules

To Date

West

Rk Team W L T % PF PA
1 Out Of State Orangebloods 6 14 0 30% 303 371
2 Tallahassee Teabaggers 6 14 0 30% 435 377
3 Phoenix Ressurection 8 12 0 40% 445 370
4 Colorado Spring Cougars 9 11 0 45% 328 418
5 Portland Pimps 9 11 0 45% 363 520
6 Dallas Strikers 9 11 0 45% 384 511
7 Las Vegas Legends 9 11 0 45% 468 344
8 Tucson Nighthawks 10 10 0 50% 349 492
9 Raving Mad Dawgs 10 10 0 50% 549 365
10 Omaha Patriots 11 9 0 55% 317 367
11 Chicago Clams 11 9 0 55% 326 472
12 San Diego Blaze 12 8 0 60% 348 314
13 H-Town Oilers 12 8 0 60% 390 328
14 Fresno Jaguars 12 8 0 60% 393 343
15 Anchorage Maulers 12 8 0 60% 418 351
16 Austin Lumberjacks 14 6 0 70% 429 296

East

Rk Team L T % PF PA
1 San Marcos Rivermen 6 14 0 30% 240 396
2 Horny Huku 7 13 0 35% 216 334
3 San Vascarba J-Hawks 8 12 0 40% 272 345
4 New Hampshire Hounds 8 12 0 40% 300 358
5 Pittsburgh Soldiers 8 12 0 40% 307 355
6 AP Warriors 9 11 0 45% 262 291
7 New Orleans Kangaroos 9 11 0 45% 293 288
8 Buffalo Badasses 10 10 0 50% 257 278
9 Miami Canes 10 10 0 50% 290 345
10 MST Peckerheads 10 10 0 50% 391 349
11 Charlotte Crows 11 9 0 55% 290 260
12 Dirty South Pimps 11 9 0 55% 318 239
13 Key Largo Barracudas 12 8 0 60% 308 288
14 Thettford Mines Rednecks 13 7 0 65% 357 282
15 Collinsville Pirates 14 6 0 70% 363 252
16 Springfield Rifles 14 6 0 70% 452 256

Easiest Schedules

Remaining

West

Rk Team W L T % PF PA
1 San Diego Blaze 23 32 0 42% 915 1,205
2 Austin Lumberjacks 23 32 0 42% 1,142 1,142
3 Anchorage Maulers 25 30 0 45% 1,025 1,086
4 Omaha Patriots 25 30 0 45% 1,143 1,117
5 Raving Mad Dawgs 26 29 0 47% 885 1,174
6 Portland Pimps 26 29 0 47% 1,082 1,027
7 Tucson Nighthawks 26 29 0 47% 1,155 1,028
8 H-Town Oilers 28 27 0 51% 1,057 1,056
9 Dallas Strikers 28 27 0 51% 1,069 964
10 Fresno Jaguars 28 27 0 51% 1,138 1,144
11 Chicago Clams 28 27 0 51% 1,151 969
12 Las Vegas Legends 29 26 0 53% 1,034 1,106
13 Colorado Spring Cougars 29 26 0 53% 1,157 1,076
14 Phoenix Ressurection 31 24 0 56% 1,110 1,095
15 Tallahassee Teabaggers 32 23 0 58% 1,069 1,072
16 Out Of State Orangebloods 33 22 0 60% 1,039 899


East

Rk Team L T % PF PA
1 Springfield Rifles 21 34 0 38% 672 1,015
2 Key Largo Barracudas 24 31 0 44% 828 877
3 Collinsville Pirates 25 30 0 45% 820 886
4 Charlotte Crows 25 30 0 45% 820 884
5 Dirty South Pimps 25 30 0 45% 825 989
6 Thettford Mines Rednecks 26 29 0 47% 848 778
7 MST Peckerheads 28 27 0 51% 783 851
8 Miami Canes 28 27 0 51% 787 717
9 AP Warriors 28 27 0 51% 864 841
10 Pittsburgh Soldiers 29 26 0 53% 783 761
11 New Hampshire Hounds 29 26 0 53% 808 745
12 Buffalo Badasses 29 26 0 53% 895 811
13 Horny Huku 29 26 0 53% 920 853
14 New Orleans Kangaroos 30 25 0 55% 925 879
15 San Vascarba J-Hawks 30 25 0 55% 925 856
16 San Marcos Rivermen 34 21 0 62% 1,016 776

Toughest Opponents in Victories (Teams you beat W-L)

Rk Team W L T % PF PA
1 Austin Lumberjacks 11 5 0 69% 341 236
2 Anchorage Maulers 10 6 0 63% 333 251
3 H-Town Oilers 6 6 0 50% 188 242
4 Las Vegas Legends 9 11 0 45% 468 344
5 Raving Mad Dawgs 7 9 0 44% 413 303
6 Phoenix Ressurection 8 12 0 40% 445 370
7 Dallas Strikers 3 9 0 25% 161 406
8 Fresno Jaguars 2 6 0 25% 100 197
9 Tucson Nighthawks 2 10 0 17% 169 402
10 San Diego Blaze 1 7 0 13% 103 206
11 Chicago Clams 1 7 0 13% 67 332
12 Portland Pimps 0 4 0 0% 30 278
13 Colorado Spring Cougars 0 4 0 0% 23 117
14 Tallahassee Teabaggers 0 4 0 0% 19 102


Rk Team L T % PF PA
1 Collinsville Pirates 4 0 0 100% 80 16
2 San Vascarba J-Hawks 6 2 0 75% 158 98
3 Charlotte Crows 5 3 0 63% 123 104
4 New Orleans Kangaroos 9 7 0 56% 257 222
5 Key Largo Barracudas 6 6 0 50% 170 238
6 Dirty South Pimps 2 2 0 50% 56 48
7 Springfield Rifles 2 2 0 50% 50 44
8 New Hampshire Hounds 8 12 0 40% 300 358
9 Miami Canes 6 10 0 38% 187 319
10 Horny Huku 6 10 0 38% 170 286
11 Buffalo Badasses 4 8 0 33% 103 215
12 San Marcos Rivermen 5 11 0 31% 182 323
13 Pittsburgh Soldiers 3 9 0 25% 117 263
14 AP Warriors 1 3 0 25% 33 63
15 MST Peckerheads 1 7 0 13% 60 220

Toughest in Defeat

Rk Team W L T % PF PA
1 Tucson Nighthawks 8 0 0 100% 180 90
2 San Diego Blaze 11 1 0 92% 245 108
3 Fresno Jaguars 10 2 0 83% 293 146
4 Chicago Clams 10 2 0 83% 259 140
5 Dallas Strikers 6 2 0 75% 223 105
6 H-Town Oilers 6 2 0 75% 202 86
7 Raving Mad Dawgs 3 1 0 75% 136 62
8 Austin Lumberjacks 3 1 0 75% 88 60
9 Portland Pimps 9 7 0 56% 333 242
10 Colorado Spring Cougars 9 7 0 56% 305 301
11 Omaha Patriots 11 9 0 55% 317 367
12 Anchorage Maulers 2 2 0 50% 85 100
13 Tallahassee Teabaggers 6 10 0 38% 416 275
14 Out Of State Orangebloods 6 14 0 30% 303 371


Rk Team L T % PF PA
1 Miami Canes 4 0 0 100% 103 26
2 Springfield Rifles 12 4 0 75% 402 212
3 MST Peckerheads 9 3 0 75% 331 129
4 Buffalo Badasses 6 2 0 75% 154 63
5 Key Largo Barracudas 6 2 0 75% 138 50
6 Thettford Mines Rednecks 13 7 0 65% 357 282
7 Collinsville Pirates 10 6 0 63% 283 236
8 Pittsburgh Soldiers 5 3 0 63% 190 92
9 Dirty South Pimps 9 7 0 56% 262 191
10 AP Warriors 8 8 0 50% 229 228
11 Charlotte Crows 6 6 0 50% 167 156
12 San Marcos Rivermen 1 3 0 25% 58 73
13 Horny Huku 1 3 0 25% 46 48
14 San Vascarba J-Hawks 2 10 0 17% 114 247
15 New Orleans Kangaroos 0 4 0 0% 36 66

Nice, very very interesting.

man, that is awesome.

love it. keep it coming!

Can you give us some detail on the W L scores in the main table. Looks a lot like your getting the average from the last 16 games including friendlies, and not from the early season games, or something similar. Curious how we get to a 10/6 record.

The first one posted is a projection based on this season's games alone. I really couldn't tell you the formula as I didn't design it.

TtD, you're 6 losses are projected to be against:

Raving Mad Dawgs
LV Legends
Phoenix
Tucson
San Diego (they are very favorable after their OOS game)