Jump to content
Blue Purple Red Orange Gold Green Teal Chocolate Charcoal
Blue Purple Red Orange Gold Green Teal Chocolate Charcoal
WithAuthority

Classic 2K Rosters

Recommended Posts

SUB: Excel files to Auto-Generate Ratings

Here's some newer excel files with the basic layout in place. It's getting closer to being "usable".

They are not finished but this gives you an idea of what I'm doing and to see if anyone has any comments or suggestions, or has any interest in these excel files.

A few notes:

1) You will need REDitorII to use these excel files to put the ratings into the game (copy and paste method).

2) You will have to do some other "copying and pasting"; the stats are in a format generated from FanGraphs. If you want other stats than the ones in the files you will need to generate csv files from FanGraphs and copy and paste them into the excel files. The excel files aren't "marked" clearly as far as where to put them but I will do that with more instructions later.

3) 95% of the ratings are auto-generated as of now.

4) The formulas are close but not done; eg there are some errors in them still, but I will fix those.

5) You can browse through them all you want and change them if you like, suggest anything etc.

 

Hope this can help generate some rosters, etc.

MLB2K12 Batter Ratings Calculator v4.xlsx

MLB2K12 Pitcher Ratings Calculator v4.xlsx

MLB2K12 Fielder Ratings Calculator v4.xlsx

MLB2K12 Staff Ratings Calculator v4.xlsx

Share this post


Link to post
Share on other sites

So basically, with this, you plug in stats to formulate uniform player ratings? If so, sounds like a really useful tool.  Keep up the good work

Edited by christiano

Share this post


Link to post
Share on other sites

1) The formulas are updated and are at least playable in game with some copy and paste into reditor.

2) Cleaned up some garbage in the files.

3) Importing of raw stats into the files needs more work as some more formula tweaking.

4) Might pursue using database,etc to import stats.

 

MLB2K12 Fielder Ratings Calculator v43.xlsx

MLB2K12 Pitcher Ratings Calculator v43.xlsx

MLB2K12 Batter Ratings Calculator v43.xlsx

Share this post


Link to post
Share on other sites
 

1) The formulas are updated and are at least playable in game with some copy and paste into reditor.

2) Cleaned up some garbage in the files.

3) Importing of raw stats into the files needs more work as some more formula tweaking.

4) Might pursue using database,etc to import stats.

 

MLB2K12 Fielder Ratings Calculator v43.xlsx

MLB2K12 Pitcher Ratings Calculator v43.xlsx

MLB2K12 Batter Ratings Calculator v43.xlsx

Good work, jack... keep pluggin away

Share this post


Link to post
Share on other sites

Latest update:

I've redesigned the method for importing stats into the excel file. I will clean up the "process" as time goes on.

1) I created a modified version of the lahman database to use for importing stats into the excel file, which in turn will create a file to import into REDitorII and a game file.

2) That will make importing stats for any year and converting to a MLB2k12 ratings scale, a fairly quick process. To do this you will need Access (at least Access 2007 I think), Excel (at least Office 2007 i think), and REDitorII.

3) I'm not ready yet to create a "test" file  for the game but I am getting closer. Need to clean up the database , the excel file and the "template" roster file.

5) Attached is the file in its present state. Ongoing rating tweaks included. I did not attach the database file as it is 1.2 GB currently.

6) Thinking of a method for adding new stats into the database. This would be for adding new players, teams, leagues, etc.

Any comments welcome.

MLB2K12 Ratings Calculator v12.xlsx

Share this post


Link to post
Share on other sites
 

Latest update:

I've redesigned the method for importing stats into the excel file. I will clean up the "process" as time goes on.

1) I created a modified version of the lahman database to use for importing stats into the excel file, which in turn will create a file to import into REDitorII and a game file.

2) That will make importing stats for any year and converting to a MLB2k12 ratings scale, a fairly quick process. To do this you will need Access (at least Access 2007 I think), Excel (at least Office 2007 i think), and REDitorII.

3) I'm not ready yet to create a "test" file  for the game but I am getting closer. Need to clean up the database , the excel file and the "template" roster file.

5) Attached is the file in its present state. Ongoing rating tweaks included. I did not attach the database file as it is 1.2 GB currently.

6) Thinking of a method for adding new stats into the database. This would be for adding new players, teams, leagues, etc.

Any comments welcome.

MLB2K12 Ratings Calculator v12.xlsx

Man, this could really be helpful. With accurate ratings imported, it could seriously open the door for everyone to create classic teams based on a neutral playing field. Many of the throwback uniforms have already been created. Would mostly just require cyberfaces. Keep up the good work Jack

Share this post


Link to post
Share on other sites

It makes it easy to make any roster! Thanks. I hope soon we will see new rosters with updated ratings! :D Nice work, jack. I love seeing new modders getting involved.

Share this post


Link to post
Share on other sites

Latest update:

1) Latest file with some notes. Will update them as I go on.

2) This file contains 2015 stats from my modified Lahman access file. Importing from the Lahman file to this excel file has basically been accomplished but will require more refinement.

3) Getting ready to generate a test file for the game. Not sure how soon but ASAP.

4) Will have to figure out how to post the the modified Lahman access file as that will be needed. Might create a web page later for general access to it.

 

MLB2K12 Ratings Calculator v20.xlsx

Share this post


Link to post
Share on other sites

another update for the nite:

1) Creating the blank roster file. In progress, not completely ready to use yet. If you load this in-game now it will crash and is not playable, just the start of a "template" to use for importing.

 

MLB2K12 Ratings Calculator v22.xlsx

Roster1BLANKV3.ROS

this is the zipped modified lahman file.

there is a query called "MLB2k12 Output by year" that i created to use for exporting to the excel file. you have to type in the year 3 times for the time being until i fix it.

you need to run the query and export the file as a workbook. then open that up and copy it into the ratings calculator where it is says "paste here" etc.

lahman2015 MLB2K12 v2.rar

Share this post


Link to post
Share on other sites

Update:

1) Latest Blank Template Roster file. Will write some instructions/notes about this file later.

2) Global IDs, Appearance IDS, team rosters and lineups have been made blank.

3) All regular players are set as "existing create-a-players"; you can now create a head-shape and face for all players. Portraits and cyberfaces are not required.

4) I'm not sure of the number, but some of the skin-tones are set "in-stone" for slots that had real-life players. You can't change skin-tones in-game for those players; you need to use REDitorII or Ty's editor.

More to come as far as assigning players to teams, etc. etc.

Roster1BLANKV31.ROS

Share this post


Link to post
Share on other sites

we all do thanks

 

no updated files today. working primarily on a method for importing new stats into the database (current stats, minor leagues, etc.)

Share this post


Link to post
Share on other sites

Wow, I cant believe this thread actually turned into something all this time later!

Thanks for your work Jack!

The ratings are the EASIEST aspect of a classic roster. Time  consuming, but easy. Although some kind of generator or spreadsheet definitely helps! The real obstacle to it is the total lack of retro stadium or cyberface work done for 2K baseball.

We reaalllyyy need a CF maker who would be willing to do this. I know one who is really talented, but he is busy working on another project ATM.

If we work together---we could do this :)

Edited by bdolan33

Share this post


Link to post
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.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  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...