Jump to content
Lhopital

Applying SIM data

Recommended Posts

No worries.  I was hoping to see the basic idea behind setting up the formulas because it looks pretty complex, but my main desire was to be able to copy/paste data from TSBtool into excel and back again.  I've gone and devised my own system for sim ratings based on patterns I found in the original rom.  I wouldn't say it's perfect, but it's good enough for me.  The only thing not automated is the defense, because that isn't based on attributes anyway but rather the percentage of sacks/interceptions a player would be expected to get on their team.  I'm still tweaking it, but I'll upload it here for others to mess around with when I'm finished.

Share this post


Link to post
Share on other sites

See the attachment.  Here's how it works:

 

1. "Save Data" in TSB tool from your rom as a .csv file

2. Open the .csv file in Excel and copy everything (easiest just to click on a cell far away from the data, like O6 or something, and Ctrl-A to select all cells)

3. Select cell A1 on the "Paste_Edit Here" sheet of my workbook and paste

4. For players on offense, change only the attributes on the "Paste_Edit Here" page.  It will automatically apply the sim value on the "Output" page

5. Copy rows 25-1003 on "Sheet 2"

6. In TSB tool, highlight everything from the "TEAM = bills..." line to the last line of the falcons roster, and paste over it

7. Apply to rom and you're done

 

I didn't touch the defense ratings because they aren't based on the players' attributes.  You'll have to change these manually to determine the amount of sacks/interceptions players will get relative to others on the team.  Any changes made to the "Paste_Edit Here" page update on the "Output" page, which will in turn update "Sheet 2".  Also, any team ratings need to be changed in TSB tool, and it will only work on rom with 28 teams or fewer.  One cool feature is that duplicate numbers on the same team will highlight red.

 

Lastly, for some reason all the formations are set to 2rb,2wr,1te even though I included data from the original rom.  I'm not sure what's going on with that, but just keep in mind that my forumlas differ for RBs, WRs, and TEs.  You may have to account for this or else you can end up with cells having errors or inaccurate sim ratings if you change the formations.  Fixing it is as simple as a copy/paste, though. 

 

Like I said, it's not necessarily finished or perfect, but you'll get the idea.  The formulas are very simplistic and really account for only one attribute (except for the QBs).  I simmed a few seasons on the original rom and the results seemed relatively close to the original so it's good enough for me.  Feedback is welcome, or you can take it and change it to suit your own needs.

 

Book1.xlsx

Edited by adscl84

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×