Jump to content
Tundrayeti311

The 2nd TSB Book of Armaments

Recommended Posts

Hello,

 

I wrote a script* to look at a .csv output file produced by a TSB rom roster/attribute extractor ("Roster Extractor", nice tool, thanks!), and produce the spreadsheet attached here which includes a bunch of sheets listing TSB players and attributes by team, position, etc. and providing some analysis based on my own attribute weights*.

 

The file includes ratings, ranks, scores (an attempt at normalized ratings across positions), and attribute stats (e.g min,min,mean,mode of - e.g. RS, MS, RP, INT - at bottom of sheet) based on position (including KR, PR), ranking OL, DL, O, D, teams, as well as a suggested "best"* lineup. It also colors the min and max value for a particular attribute (per position), and provides some highlighting to draw attention to better players and attributes.

 

Each team has two sheets: the first being a "raw" roster, and the second breaks it down a bit further, separates by position, and provides a suggested starting lineup.

 

This file is based off of "The TSB Book of Armaments" (couldn't find the thread again on this site btw), which a few years ago when I started getting "serious" about playing Tecmo was a valuable resource (although it did have some issues and limitations).

 

While the file here is not much beyond what you would find at tecmogeek.com or the tecmosuperapp (awesome resources!), perhaps the value would be in generating a reference for a custom rom such as for HSTL or TSB'18, etc or possibly having a reference when you don't have the internet and/or your smartphone. Additionally, the script could be re-run (takes seconds) to re-generate if you want to alter the stat weights in the source code (2).

 

This was a project I made from the curiosity and challenge of being able to create a custom spreadsheet reference for myself, but hopefully others may find it helpful as well.

 

1. If this post is in the wrong spot, apologies, and fee free to re-thread

2. The script is in Perl, happy to share if anyone is interested -- or even regenerate spreadsheet and post if you send me request with rom and/or stat weights

3. These are generated through a very simple algorithm and are intended to provide a suggestion for initial lineup subs (no WR/TE allowed at RB1 btw). The team rankings are more an indication of total stat allocation across entire roster than actually being "better" e.g. PIT is not the 4th best team, but scores high for BC on O, and of course D and a bit for S/T.

5. The only other name I could think of was "TSB Grimoire" (any guitar players out there?), but it isn't nearly that expansive

6. "Roster Extractor" was found here: http://www.tecmosb.com/Downloads/Editors/Roster Extractor.zip

 

The 2nd TSB Book of Armaments.xlsx

Edited by Tundrayeti311
for clarity

Share this post


Link to post
Share on other sites
On 10/13/2017 at 12:42 PM, Tundrayeti311 said:

@Tecmonster I used "Roster Extractor", and yes it should work on 32-team rosters too.

OK, thanks.  When you said "stat extractor" though, I didn't realize you were referring to roster/attribute extractor (vs. stats from season play).

 

I've been looking for a program that would extract season stats from a 32-team rom.

Share this post


Link to post
Share on other sites
On 10/14/2017 at 5:44 PM, Tecmonster said:

OK, thanks.  When you said "stat extractor" though, I didn't realize you were referring to roster/attribute extractor (vs. stats from season play).

 

I've been looking for a program that would extract season stats from a 32-team rom.

 

@Tecmonster, sorry for confusion, this might be of help: http://tecmobowl.org/forums/topic/12809-tecmobowltools-stat-extractor/

Edited by Tundrayeti311

Share this post


Link to post
Share on other sites
On 10/14/2017 at 10:05 AM, gojiphen malor said:

 

When I open a 32 team rom with Roster Extractor, the program crashes  :(

 

@gojiphen malor me too - for a 32-team rom, you could generate a .csv roster extract (different format than Roster Extractor) from this tool - http://tecmobowl.org/forums/topic/11106-tsb-editor-tsbtool-supreme-season-generator/

 

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


  • Recently Browsing   0 members

    No registered users viewing this page.

×