Anyone have a spreadsheet with full player ratings?

Talk about NBA 2K12 here.

Anyone have a spreadsheet with full player ratings?

Postby Leftos on Sat Sep 01, 2012 1:56 am

I'm looking for a spreadsheet that has as many 2K12 players with their full ratings (everything from the Skills category in REDitor, for example) and their in-game overall rating. I'm going to use Eureqa on it to determine the formula that calculates the Overall rating in the game.

And I know, "why not build it yourself?". Well I'm not at my PC right now due to exams. Wanna help?
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby Bassman58 on Sat Sep 01, 2012 3:08 am

Maybe this will help. viewtopic.php?f=143&t=82314
User avatar
Bassman58
 
Posts: 419
Joined: Fri Feb 21, 2003 5:18 am

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Sat Sep 01, 2012 3:13 am

Aren't these ratings calculated based on the actual real stats? I'm looking for the ratings 2K gave to the players, not recommended ratings based on real stats.
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby Bassman58 on Sat Sep 01, 2012 5:46 am

I believe you are correct. I've never seen the list you want. Hopefully there is one.
User avatar
Bassman58
 
Posts: 419
Joined: Fri Feb 21, 2003 5:18 am

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Sat Sep 01, 2012 7:23 am

Should be piss-easy to make. You just open 2K's roster in REditor, copy Last_Name, First_Name, Position and all the columns of the Skills category into a spreadsheet, and then manually create a column in which you copy the overall rating of each player from in-game.

I just don't have 2K12 installed on this PC to try it out, and I don't have that much time available.
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby sevin0seven on Sat Sep 01, 2012 4:45 pm

Leftos wrote:Should be piss-easy to make. You just open 2K's roster in REditor, copy Last_Name, First_Name, Position and all the columns of the Skills category into a spreadsheet, and then manually create a column in which you copy the overall rating of each player from in-game.

I just don't have 2K12 installed on this PC to try it out, and I don't have that much time available.


your in luck Leftos, i happened to create one for myself to base my team rating creations: http://www.gamefront.com/files/22192946 ... ate%29.zip :wink:
User avatar
sevin0seven
 
Posts: 444
Joined: Fri Apr 25, 2008 8:00 am
Location: Bay Area, CA

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Sat Sep 01, 2012 9:41 pm

Thanks for that sevin, but I've already done that much, I know how to get the information out of REditor and into a spreadsheet. What I wanted someone to do is grab the overall ratings from inside NBA 2K12 and add them to a separate column in that spreadsheet, as I don't have the game with me to do so.
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Tue Sep 04, 2012 11:48 pm

Quick question. Do Abilities affect Overall? Can someone test this for me?
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby BD1899 on Wed Sep 05, 2012 2:23 am

Abilities do factor into overall in some way. I tested this out with Rondo (85 OVR) and once I maxed out all of his shooting abilities, he jumped up to 87.
Image

Original image by freshcontrast
User avatar
BD1899
 
Posts: 148
Joined: Fri Nov 05, 2010 6:07 pm

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Wed Sep 05, 2012 2:28 am

'kay. This pretty much screws up any chance I have of decoding the Overall function, since the variables are nearly 50. I would need a computing farm to be able to pull this off without burning my CPU out. Pfff.
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA

Re: Anyone have a spreadsheet with full player ratings?

Postby clarisha on Wed Oct 03, 2012 9:16 pm

What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
________________________________
market samurai ~ marketsamurai ~ marketsamurai.com
Last edited by clarisha on Sat Oct 06, 2012 5:11 pm, edited 1 time in total.
clarisha
 
Posts: 1
Joined: Tue Oct 02, 2012 7:13 pm

Re: Anyone have a spreadsheet with full player ratings?

Postby Leftos on Wed Oct 03, 2012 9:35 pm

Although this is completely off-topic, the formula you typed seems fine, clarisha.
Eleftherios "Leftos" Aslanoglou
NBA 2K AI Software Engineer
Visual Concepts Entertainment / 2K Sports

Used to be "That Tools Guy" around here during the good ol' days. Although you probably remember me as your favorite Podcast host.
User avatar
Leftos
I'm The Pipeline, The Pipeline Is Me
NBA 2K Developer
 
Posts: 5141
Joined: Sun Jun 07, 2009 7:44 am
Location: Novato, CA, USA


Return to NBA 2K12

Who is online

Users browsing this forum: No registered users and 1 guest