Jump to content
Sign in to follow this  
Bodom

TSB Roster Spreadsheet

Recommended Posts

I think that trying to SIM-rate all NFL players together is tough.

Maybe better to SIM-rate individuals relative to their team.

[attachment=0]scaling example.JPG[/attachment]

but, this is just to show how you can automatically scale things in excel.

basically, it's just making a percentage and multiplying by the max number possible, this is not "interpolation"....

the column "insert catches" could be any number you want to use to determine a SIM stat (like some previous calculation or total or whatever, here it's "catches")

the code line in cell D2 just shows what's actually written in cell C2.

the code beneath 301 and 32 just shows what's written in cell B13 and C13.

(BO does a version of this in his REC spreadsheet.)

Hey, I just realized that your formula does the exact same thing as mine. Due to rounding, the total is not always what you want it to be. I thought your formula somehow adjusted for that and that's why you did it that way. but it doesn't. For example, if you want your total to be 45, and you end up with nine at 4.9 and one at 0.9, when those numbers are rounded you get nine at 5 and one at 1, which totals 46. Is there any way to automatically correct for this?

Share this post


Link to post
Share on other sites
Bo, I can think of two ways. "ceiling" and "floor" could be utilized - or use a lookup table that goes and grabs a whole number.

I've never done either of those things. Could you revise your table to do this and post an example? I know it only makes teams off by a couple of points and the actual simming is probably not affected that much, but if it doesn't take too much time I like to make things perfect.

EDIT: well, ROUND at least gives you the real total. I read up on CEILING/FLOOR and I'm still not sure how you would get the numbers you want using that. LOOKUP seems like it would take even more time.

Share this post


Link to post
Share on other sites

here's a (.xls) spreadsheet to help automate team PLAYBOOK input for a 32-team ROM - see bottom of this post...(the "stock" TOOL entry method is a pain in the ass, IMO)

you enter 1-8 (like in TSB TOOL Supreme) for each play slot (run1-run4, pass1-pass4) in the orange and light blue cells.

the spreadsheet generates two relevant columns of data

(they are redundant, but each have their own purposed implementation) -

1. something you can copy directly into TSB TOOL Supreme (along with each team's data)

2. SET commands that (when used properly in TSB TOOL Supreme) will write the playbooks directly to ROM.

*only enter numbers in the 'orange' and 'light blue' cells. it should be self-evident as to wtf is going on.

post-3789-13413728301441_thumb.jpg

+enjoy+

tsb 32 team playbook SETter.zip

Share this post


Link to post
Share on other sites

I have been working more on this spreadsheet recently - had a few additional ideas to make rom editing much easier, including a team uniform page. Also going to look into adding the stuff that buck and Bo posted. Hoping to have a rough draft ready by Sunday.

Share this post


Link to post
Share on other sites

For those of you who edit roms - would having something like this in a spreadsheet be useful? It copies your uniform choice directly into TSBToolSup so you won't have to toggle back and forth between teams...everything will be on 1 spreadsheet and easy to change.

post-6125-13413728677904_thumb.png

Share this post


Link to post
Share on other sites
For those of you who edit roms - would having something like this in a spreadsheet be useful? It copies your uniform choice directly into TSBToolSup so you won't have to toggle back and forth between teams...everything will be on 1 spreadsheet and easy to change.

so the little figures' colors get updated as you change the colors? if so, it would be nice to have little pictures of all the team uniform colors on one "page". especially for non-NFL roms.

oh - and maybe you can add this page to your spreadsheet: a COM juice SETter for each category of each level.

TSB COM Juice Setter.xls

by the way - do you have some spreadsheets that generate SIM stats based on player attributes?

Share this post


Link to post
Share on other sites
so the little figures' colors get updated as you change the colors? if so, it would be nice to have little pictures of all the team uniform colors on one "page". especially for non-NFL roms.

Yeah, I basically drew the player in excel and did a conditional format for each of the cells so as you change the cells in yellow for pants, jersey and skin...the player will also change. I was going to put everything on 1 page, with the teams in order just going down the page...and have the top portion with the TSBTool colors freeze framed. I'll try to finish up the team colors tab tonight and post it up to see what everyone thinks.

The only think people will have to update separately in TSBTool is when to use the alternate jerseys.

by the way - do you have some spreadsheets that generate SIM stats based on player attributes?

Not at the moment, but a good idea. I'll look into creating something like this.

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

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×