Warrior General Games

I don't know how many of you have seen this thread, but I downloaded it and entered all the info for the season through game 11. Pretty neat, but I'm really hoping it's mostly bullshit since it's picking my Cards to lose the rest of their games.

Link to Excel files:
http://www.filefactory.com/file/583093/n/LeagueProjector_WestEuroA2_xlsx (for MS Excel 2007)
http://www.filefactory.com/file/51a39c/n/LeagueProjector_WestEuroA2_xls (for earlier versions of Excel)

EDIT: Sheets fixed with correct score for Rome-Downey game.

I downloaded it and entered the data also. It shows the Knights making the playoffs but I am hoping we can get an extra game or so for better seeding.

Did you notice where it reports who has the toughest schedule remaining? That is why it shows the Cardinals losing the rest of their games. Anyway good luck for the rest of the season...but not enough to bump us Knights.

Yeah I noticed you had an extremely tough schedule down the stretch. Good luck. How do you get one for alpha?

I posted links to the one I had already filled the data in for. Click on the tab at the bottom that says "Alpha"

You miss typed an entry for the Rome Bulls - Downey Vikings game (under the Bulls entry)...it should be 48-6 and you entered 49-6. Not a big deal but the way I think it works it could throw off your projected scores later in the season. I was comparing your to mine to see if we came up with the same projections when I noticed it. Everything else in zeta looks spot on.

Thanks. I'll correct it. I can't imagine one point throwing off much. Probably changes the score predictions. Maybe if we can pull off the "upset" today against Rome, the thing will give us a little more credit down the stretch. I use the term "upset" loosely since I think we match up well with Rome despite the edge in levels they have.

Once again, thanks for the great work!

Thanks, I missed that tab at the bottom. I hope its wrong. I think we have a shot to run the board.

I think the Fire and Harbourmasters are pretty evenly matched. Should be one of the better games in week 13.

I agree. I'm looking forward to it. I wonder where the numbers on the matchup screen come from because I feel the teams are fairly close and the matchup shows us as pretty big favorites. Is it levels and depth average or statistics? I can't make heads or tales.

It's by player ratings, taking into account all the players in your depth chart (the bars at the top of the screen on the player profile). At least, I'm pretty sure that's what it uses. The only real edge I see here is the O Line of the Fire is quite a bit higher than that of the Harbourmasters. Everything else is relatively close.

Our game 16 matchup vs. the Scousers has them with a distinct edge that I really don't see in the depth charts. Of course so did Rome, who we lost to in overtime, as did Rockaway who we beat two games ago. The numbers are interesting to look at it, but you have to account for some margin of error.

yeah, the O-Line for the Fire is higher, my boy Freight Train and Rammer Jammer are the two highest level O-linemen of the team.

Originally posted by CaliGaucho
It's by player ratings, taking into account all the players in your depth chart (the bars at the top of the screen on the player profile). At least, I'm pretty sure that's what it uses. The only real edge I see here is the O Line of the Fire is quite a bit higher than that of the Harbourmasters. Everything else is relatively close.

Our game 16 matchup vs. the Scousers has them with a distinct edge that I really don't see in the depth charts. Of course so did Rome, who we lost to in overtime, as did Rockaway who we beat two games ago. The numbers are interesting to look at it, but you have to account for some margin of error.

That's kind of what I thought, but I think I disagree with those bars from time-to-time. They should definitely be taken with a grain of salt. I think they had the Harbourmasters too low in some categories, or us too high.

Originally posted by CaliGaucho
It's by player ratings, taking into account all the players in your depth chart (the bars at the top of the screen on the player profile). At least, I'm pretty sure that's what it uses. The only real edge I see here is the O Line of the Fire is quite a bit higher than that of the Harbourmasters. Everything else is relatively close.

Our game 16 matchup vs. the Scousers has them with a distinct edge that I really don't see in the depth charts. Of course so did Rome, who we lost to in overtime, as did Rockaway who we beat two games ago. The numbers are interesting to look at it, but you have to account for some margin of error.

Nope it is a straight algorithm of points for and points against based on teams played. It gets more accurate as the season progresses. It does not take player levels or depth into account at all.

I disagree. I've seen it change by changing the depth chart. I'm actually now of the opinion it's more closely related to the scouting bar numbers of each player.