bfbcards

I've been working on this spreadsheet on and off for a while now. It's not quite finished but it helps take a bunch of the nit picky data entry stuff out of the equation. I have a lot of columns in there for notes and such but basically here's what you need to know to use the final sheet, Paste Config. playbook sheet - column C, F, and H, J, L, N, P, R, T, and V are all used to build this section: TEAM = bills SimData=0xab0, OFFENSIVE_FORMATION = 2RB_2WR_1TE PLAYBOOK R1215, P7131 I haven't worked out yet how the numbers in the playbook match up, most likely just the digit corresponds to the play in order. schedule sheet - this sheet is incomplete pending the 2015 schedule release. We know the opponents each team is facing, just not in what order aside from the London games. Starting at cell A37 I planned on using a an Excel formula to do the heavy lifting. QB/RB/WR/TE/OLINE/KICK/PUNT/DEF sheets - this is where the fun happens. Conf/Div/Team columns are there just for sorting purposes. Player names need to be changed in the firstname LASTNAME format. Face and Jersey can be inputted along with all player stats. Note the backups for positions traverse right just to make it easier for me to paste formulas. For RB/WR I also left in notes for kick/punt returners. Any highlighting indicates pro bowl or all pro which helped me determine stats. sim data sheet - the magic starts coming together here. Columns D, E, and F are for team sim stats and data entry from the above position sheets wind up here. Columns after each player stat are for sim data as desired. Note I have the original TSB Bills there just for my reference. Rows 38 and on are just my notes. Paste config sheet - this is what you'll need to build your rosters. Heavy use of the concatenate command along with some copy/pasting helped make this happen. Delete rows 22 through 55 as that was only a sample for me. Reading this thread I see there's a uniform section now, I'll need to work that in too. I hope this helps folks looking to make their own rosters and find data entry the most daunting part. Playbook.xlsx

What formula/decision was used to figure out player's abilities?

Well, this is as done as I want to make it. KR and PR people have been corrected inasmuch as possible (eg, no Ray Buchanan for the Colts). As a teaser, here's a low res cover sticker for the rom.

I wouldn't call it common since only a few teams with fast guys can do it and it would require that guy to get passed all the defenders. When I did it, Woodson just blew right through a weak hitting guy to get there.

Don't know if it's a quirk, but just a few weeks ago I was the Steelers playing the Colts with an excellent Woodson. I just angled a full power kick up and managed to bang in 7 safeties. It wound up being my highest scoring game in my 15 years (give or take) of playing this game.

The Right Guard (or the guy right below the center) is a good addition to the team. Anyone who hasn't played Bionic Commando has had a deprived childhood.

I was joking around staking of one's life about the numbers thing since it's hard to quantify how those skills are valuable. I would definately agree with the importance of ball control though.

This is my second revision to the ROM and likely the last one I'll make to the gameplay. All that's left now is the cosmetics, mainly the player pictures. TSB95b.zip

Using that formula... PC = 63.33% PS = 31.67% AB = 5.00% Are you willing to stake your life on those exact numbers? By the way, I love MS Excel a lot!

Dude, you didn't know that? It's totally true.

It's fun Week 4 to have him return punts and kicks.... and run and catch too.

I use a program called ulead photoimpact. Not as powerful as photoshop, but I can use it quicker.

necropostage Ronnie Lott in the secondary and either Gary Reasons or Seth Joyner otherwise. For some reason it amuses me to get lots of picks with a guy who isn't a DBack.

As Rod stated above, the best way to block kicks is using the top linebacker and gunning it through the gap in the blocking. Use the guy selected Run in in a straight line through the blocking. With the slower guys, sometimes you need to tap up just a bit. At this point you definately want to be angled towards the kicker. Hopefully the illustration helps despite it's terrible quality.

Ball Sacked - When Jerry Ball makes a QB sack. Shoe String Tackle - When tackled by a diving opponent and he continues to slide. CPU Cheating - Also known as the 4th quarter A few others that I won't post since they are largely insensitive in nature.