Re: Every NBA2K Rating
What jk31 said, except it also applies to 2K23 (as the creator of 2K Tools continued improving the program over the course of 2K24, he also implemented those improvements in the 2K23 version of the program).
AFAIK for all versions of 2K Tools back to 2K20, it is possible to copy roster data to your clipboard, which you can then paste elsewhere. You just click in the bottom right corner of the open window and either copy the whole item's data or just the active tab (see Exhibit C below). One of the major improvements to 2K23/24 Tools is batch-editing functionality, so you can just Ctrl+A an entire list of things and Copy to Clipboard, rather than going item by item (e.g., player by player). You could actually Ctrl+A the entire roster, but I would recommend going team by team (as I do with the 76ers in Exhibit A) and then doing the free agent pool, since the entire roster is 4000+ players and includes all the historic teams, all-time teams, etc.
Once you paste your data into a text tool (Notepad++ recommended), it'll be a huge clump of data in one line (Exhibit B). Ultimately the simplest way to get a big chunk of data like this into Excel is to import it as a CSV, in which case it'd be more convenient for each player to be on his own line, and if we look at how the data is formatted, we see that square brackets enclose each player's data block, so if we Find & Replace ],[ with \r\n (and Extended mode selected; see Exhibit D), then it'll replace all instances of ],[ with a line break. You may also want to Find & Replace all " marks with nothing and all colons with commas, so that you have clean values in their own columns. Then just save with the extension .csv, open in Excel (or a different spreadsheet program), and it'll look like Exhibit E. To convert the 2K Tools format of Attributes to the normal in-game values, divide by 3 and add 25. Tendencies don't require any conversion. Badge values are numerical in 2K Tools, but you can just Find & Replace each number with its badge value.
Bottom line is that the important thing is just getting all the data out of the game in a systematic manner. You have to use your own ingenuity to decide a plan for mass-parsing the data, but it's worth the effort because you can knock out an entire game at once.
What jk31 said, except it also applies to 2K23 (as the creator of 2K Tools continued improving the program over the course of 2K24, he also implemented those improvements in the 2K23 version of the program).
AFAIK for all versions of 2K Tools back to 2K20, it is possible to copy roster data to your clipboard, which you can then paste elsewhere. You just click in the bottom right corner of the open window and either copy the whole item's data or just the active tab (see Exhibit C below). One of the major improvements to 2K23/24 Tools is batch-editing functionality, so you can just Ctrl+A an entire list of things and Copy to Clipboard, rather than going item by item (e.g., player by player). You could actually Ctrl+A the entire roster, but I would recommend going team by team (as I do with the 76ers in Exhibit A) and then doing the free agent pool, since the entire roster is 4000+ players and includes all the historic teams, all-time teams, etc.
Once you paste your data into a text tool (Notepad++ recommended), it'll be a huge clump of data in one line (Exhibit B). Ultimately the simplest way to get a big chunk of data like this into Excel is to import it as a CSV, in which case it'd be more convenient for each player to be on his own line, and if we look at how the data is formatted, we see that square brackets enclose each player's data block, so if we Find & Replace ],[ with \r\n (and Extended mode selected; see Exhibit D), then it'll replace all instances of ],[ with a line break. You may also want to Find & Replace all " marks with nothing and all colons with commas, so that you have clean values in their own columns. Then just save with the extension .csv, open in Excel (or a different spreadsheet program), and it'll look like Exhibit E. To convert the 2K Tools format of Attributes to the normal in-game values, divide by 3 and add 25. Tendencies don't require any conversion. Badge values are numerical in 2K Tools, but you can just Find & Replace each number with its badge value.
Bottom line is that the important thing is just getting all the data out of the game in a systematic manner. You have to use your own ingenuity to decide a plan for mass-parsing the data, but it's worth the effort because you can knock out an entire game at once.
Comment