by vetmin on Fri Mar 11, 2022 1:36 am
I've attached an Excel workbook with 2K Tools templates for both Attributes and Tendencies. When you open it, it will look broken, because there are #REF's everywhere, but that's because the template is trying to pull from a non-existent datasheet of Attribute and Tendency values, so you need to make one and edit each cell of the template so that it points to the right place in your datasheet. (I could've created a datasheet template as well, but the datasheet could be organized however one wishes, and everybody is going to have different preferences, so IMO that's better left to the user.)
In the Attribute cells, the bit you'll be replacing is the one that looks like (#REF!-25)*3. You'll change #REF! to something like Attributes!A1, so it'll say something like (Attributes!A1-25)*3. Each cell has 2K Tools' descriptor for what the attribute is, so you just look at what it says and point the cell at the corresponding spot in your datasheet.
In the Tendency cells, it's a little simpler, since you just have to replace #REF! with something like Tendencies!A1. There is no subtracting of 25 and multiplying by 3. The only complicating factor is that when I stripped this template apart from its original datasheet, the target cell values (i.e., rendered as #REF!) became stuck to the ampersand preceding it (i.e., &#REF!). In reality, it needs to be rendered like "blah blah blah...& Tendencies!A1 &...blah blah blah"; that is, you need to be sure to add a space between that initial ampersand and your datasheet cell value (e.g., "& Tendencies!A1" = good; "&Tendencies!A1" = bad).
Note as well that, particularly in terms of tendencies, in some cases there is no #REF! block, but instead just a static number. That's because for some tendencies I like them to be the same throughout the league; for instance Drive-R tendency is set to 50, because I prefer for the CPU AI to take whatever I give them defensively and not be afraid to drive on either side. Also, I prefer for all shot location tendencies to be at 0, for similar reasons. If you want to have them be actual cell values in your datasheet rather than static values, then just change any of my static numbers to instead point to the proper cell in your datasheet (i.e., following the correct format above: #REF! for tendencies and (#REF!-25)*3 for attributes). By the same token you can replace any of the datasheet cell pointers to instead just be static numbers (note that for attributes, 25 <-> 99 in game is 0 <-> 222 in 2K Tools' scaling), like if you want everyone in your league to have Triple Threat Idle Tendency at 0 (or you could just make them uniform in the datasheet; that would actually be better practice IMO).
Once it looks good in Excel, if you want to paste any of these into 2K Tools, what you would do is first select the entire row, copy it to the clipboard, and paste into a text editor (I use Notepad++). You'll see when you do this that, when pasted, each of the pasted cells in the row are now separated by a tab character (a big giant single-character space). Copy one of those tab characters to the clipboard, then open up your editor's Find / Replace interface. Use that interface to replace each tab character with a single comma (no spaces around the comma; replace tab character with comma character). Once you do that, it's in 2K Tools format and you can just copy and paste it right in. Be sure, of course, to not copy any extraneous data you may have had in your spreadsheet for organizational purposes. Like, for instance, if you added 4 columns before the template begins and entered the player's season, team, last name, and first name, then you might end up with something like this in your text editor:
1965,LAKERS,Baylor,Elgin,[{"module":"PLAYER","tab":"ATTRIBUTES" ... "POTENTIAL":"190"}}]
When pasting into 2K Tools you only want to select whatever is within the brackets. That's the actual data; the other stuff is just your own personal metadata.
Please let me know if this all makes sense or if you have any questions. And pro-tip: The best thing to do is paste your entire roster into your text editor at once and replace tabs with commas throughout the entire roster text in one go. Then just save the text file somewhere and pull it up whenever you need to paste something. I recommend having extra columns like I did above with Elgin Baylor so that when you're transferring the data into 2K Tools and you want, say, Seth Curry, you can just search "Curry,Se" and he'll come right up.
You do not have the required permissions to view the files attached to this post.