Player Rating & Tendency Spreadsheet (1951-2014)

[retromanas]

Fifedawg, Good job, i really hope you fully finish your 1951-1999 (i think you could called this spreadsheet 1951-2000, because hope you include and 1999-2000 seasons players too) spreadsheet and when we could download just one spreadsheet which could include all the players for all seasons from 1951 till 2014 like it was back then in 2k12.

[dmx_133]

Hello
Have you advanced for the season before 2000 ?

[retromanas]

Hello
Have you advanced for the season before 2000 ?

I agree, it is interesting to me too.

[atlplayboy23]

Any update to this really looking for the 80s and 90s players and the coaching profiles

[retromanas]

Any update to this really looking for the 80s and 90s players and the coaching profiles

Don't worry Fifedawg still working on this spreadsheet, i asked him in other thread and he said, that he will work till it will be done

[Fifedawg]

Yeah it's a LOT of work. Still in progress..

[retromanas]

Yeah it's a LOT of work. Still in progress..

Yes of course i believe that it takes a Lot of work and time to do that. I believe in you and i'll will waiting when you complete the full spreadsheet with the 80's, 90's and early 2000's all players ratings

[retromanas]

Fifedawg, How is going your progress with the spreadsheet?

[dmx_133]

The project is dead ?

[Fifedawg]

No it's not dead. I have alot of players created and still working on it. retromanas, I got your PM and i'm still working on it. Lots of work to do..

[Culture Games]

How is "Emotion" and "Hard Fouls" CalculateD?

[Kevin]

How is "Emotion" and "Hard Fouls" CalculateD?

They arent.

[Kevin]

Fifedawg, I would appreciate it if I can apply it to my roster someday.

[Culture Games]

I always assumed Emotion came from Technical Fouls

[Fifedawg]

Yeah Emotion is just how a player reacts to a foul call or after a good play. It's not calculated on the spreadsheet, you just have to edit it yourself.

Fifedawg, I would appreciate it if I can apply it to my roster someday.

What roster are you working on?

[retromanas]

No it's not dead. I have alot of players created and still working on it. retromanas, I got your PM and i'm still working on it. Lots of work to do..

Thanks for respond and keeping us updated, because i really glad that you still working on this spreadsheet I think some times that kind of news/updates could be nice thing and we could know how is going the progress

[dmx_133]

No it's not dead. I have alot of players created and still working on it. retromanas, I got your PM and i'm still working on it. Lots of work to do..

great

[Kevin]

Yeah Emotion is just how a player reacts to a foul call or after a good play. It's not calculated on the spreadsheet, you just have to edit it yourself.

Fifedawg, I would appreciate it if I can apply it to my roster someday.

What roster are you working on?

It's based on Alby's roster. viewtopic.php?f=153&t=97470

[Fifedawg]

Cool. I'm gonna check that out

[dmx_133]

Fifedawg, have you do some new season spreadsheet ?

[Fifedawg]

Not yet. I usually wait til the end of the season.

[dmx_133]

Hello Fifedawg,

Where are the project are ?

Can you give me the rating scale how can use to edit the tendencies of the player of the ninetie's ?
Because i use the UBR roster and it's great roster ... but too many player score a lot of point in season mod ... the tendency shoot are too high

Thanks for your help

[mo2thewillyo]

Will there be an update for 2015?

Looking for Andrew Wiggins Ratings

[Fifedawg]

Will there be an update for 2015?

Looking for Andrew Wiggins Ratings

Took me a little bit but it's done. You can download here.

https://www.sendspace.com/file/c46dmt

If you not sure how to use this spreadsheet i'll explain.

1. First you must have a copy of Reditor.
2. Open the spreadsheet and find the player you would like to copy from (Players are listed in alphabetical order).
3. Click on Cell BR (Low Post Shot) on that particular player.
4. While holding for left click mouse button, highlight that whole role of numbers until you get to the Player ID (Do not highlight the Player ID).
5. Hold Ctrl and Press the letter C to copy the entire line.
6. Open the Reditor and open the roster you want to copy the players ratings too.
7. Find the player to want to copy the ratings to and use the bottom bar to slide over to the cell listed as "SShtCls" in the Players Tab (This is the Low Post Shot Rating).
8. Hold Ctrl and Press the letter V to paste the entire line and your done copying the ratings.

Very Simple! Remember that this spreadsheet is best used for players that where in seasons 2000-2001 thru 2001-2015. Shot Distances numbers where not kept for seasons prior to 2000 so those players don't have complete ratings. If you want info on how to edit those guys as well, let me know.

Now you have to update a few "cosmetic" things of course which are not edited in the spreadsheet because there was no way to rate them, so load the roster back up in the game and find that player. You have to edit the Dunk Rating and Standing Dunk Rating on Tendencies you will need to edit the Dunk Rating listed under Inside Shot and Alley-Oops listed right below that.

Note: This spreadsheet only gives you a base rating for a player based on there statistics, if the overall rating of the players is not like you think it should be then update there ratings to get them where you think they should be but do not edit the shot ratings! Editing the shot ratings will throw the players off of what there FG% will be when simulate games.

Also I would recommend when editing players that you edit there Play Types. This is very important in getting a player to behave how they should when you watch them. You can do this by looking at the players shot tendencies and find what shots they tend to shoot the most. There rating for that particular tendency will be 35 and over. Anything less than a 35 rating means the most times the player will pass on that shot from that particular distance. So lets say i'm editing Blake Griffin. Griffin has a 78 inside shot tendency, 56 close shot tendency, 50 mid range shot tendency and 6 three point shoot tendency. So looking at that Griffin will need a inside shot play type as his first play (because his inside shot tendency is the highest), a close shot tendency play type and a mid range shot tendency play type in that order. I would also give all PF and C's the Pick & Roll Man and all PG's the Pick & Roll Ball Handler play type.

Point Guard's with a qualifying Inside Shot Tendency should use "Isolation or P&R Ball Handler" and for qualifying Close Shot Tendency use "Isolation or P&R Ball Handler"
Shooting Guard's with a qualifying Inside Shot Tendency should use "Isolation, P&R Ball Handler, Cutter or Shot Low Post" and for qualifying Close Shot Tendency should use "Isolation, P&R Ball Handler, Cutter or Shot High Post"
Small Forward's with a qualifying Inside Shot Tendency should use "Isolation, P&R Ball Handler, Cutter or Shot Low Post" and for qualifying Close Shot Tendency should use "Isolation, P&R Ball Handler, Cutter or Shot High Post"
Power Forward's with a qualifying Inside Shot Tendency should use "Low Post or P&R Roll Man" and for qualifying Close Shot Tendency should use "High Post or P&R Roll Man"
Center's with a qualifying Inside Shot Tendency should use "Low Post or P&R Roll Man" and for qualifying Close Shot Tendency should use "High Post or P&R Roll Man"

Now I also have included a list of players I edited for seasons 1951-1999. You can download that below.

https://www.sendspace.com/file/lmjrwt

There are currently 694 players on this list and I will be adding more. I have only done one season per player, so you will see Larry Bird in the spreadsheet but only his 1984-85 season ratings listed.

Enjoy!

[truefaith0826]

Ok i understand
For the old roster like 1998 have you a formula for the rating and tendencies ?
And for the coach profile ?

thanks

I do but it takes some hand work for seasons from 1999 season and older so what I have been doing is just creating some great older players and posting them to the first post in the thread which by the way needs updating. I'll be doing this sometime later this week. As for Coaching profiles here is the link on a formula on how to make Coach Profiles for any season

http://www.sendspace.com/file/12ccxz

This is great stuff and lots of hardwork! Thank you for sharing fifedawg. I clicked the Coaching profiles link but is says "Sorry, the file you requested is not available", was there an update?