Jump to content

Tecmo Super Bowl sim code spreadsheet


Recommended Posts

I've been tinkering with a spreadsheet @jstout posted here back in '09 and wanted to share this with whoever can find this helpful. You enter information into any of the yellow shaded cells and any of the blue shaded cells has their information auto generated. I use this to get a base to work with, then edit accordingly depending on playbooks and the results I am aiming to get. Here's a rundown on each page in the spreadsheet, I've used the original Buffalo Bills roster with 1990 statistics as a template so people can see how this works in the file I shared:

 

Page 1: Paste your TSB Tool rosters into the shaded cells, this will auto-populate the roster on all the pages it's used in.

 

spreadsheet1.thumb.png.934e01b24457ea8a7e053fd20dcd7fee.png

 

Page 2: Enter the information required in the shaded cells:

 

screenshot2.png.fbce1b639d481eb532e793d5594dc49f.png

 

Page 3: Enter the stats in the yellow shaded cells (any blue cells auto-populate):

 

screenshot3.thumb.png.81982d0576fb09427c4070e01685cfb4.png

 

 

Page 4: Edit the values in the F column until they total 32 (Thomas averaged out to 7 and Mueller to 2, I adjusted them +1 each to end up with a total of 32)

 

spreadsheet4.png.aedb3758bf74d06c1b486c764ff5b9a6.png

 

Page 5: The final worksheet, the only adjustment to make here is if the defensive value doesn't total 255 

 

screenshot5.thumb.png.44c4543e7f2c7621518f26e283e1bc2f.png

 

TSB_Sim_Spreadsheet.ods

Edited by SBlueman
Link to comment
Share on other sites

There is no such thing as team offense. 

 

It's team run defense,  team pass defense

 

I did a couple tests. A team with 15's (0xF) for pass defense and run defense won 47% of the time even if all skill players were rated 0. 

 

A team with 15's for all skill players on offense and 0's for defense won 74% of the time. 

Link to comment
Share on other sites

ok. I'm having some issues copying and pasting from TSBToolSupreme to the spreadsheet. when I paste it, all the information goes into cell A, and B-O retain the previous data. but you can see all IND 2023 data on cell A. and up top "a.Richardson........" what am I messing up? lol. I  bet it's something easy af.

17143487153421789339200223311916.jpg

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...