Home

My 2k8 Ratings Spreadsheet

This is a discussion on My 2k8 Ratings Spreadsheet within the College Hoops 2K Rosters forums.

Go Back   Operation Sports Forums > Basketball > Other Basketball Games > College Hoops 2K > College Hoops 2K Rosters
MLB The Show 24 Review: Another Solid Hit for the Series
New Star GP Review: Old-School Arcade Fun
Where Are Our College Basketball Video Game Rumors?
Reply
 
Thread Tools
Old 01-14-2008, 09:40 PM   #1
Rookie
 
TarHeelsUNC's Arena
 
OVR: 10
Join Date: Jan 2006
Blog Entries: 2
My 2k8 Ratings Spreadsheet

Here is my 2k8 Ratings Spreadsheet Project. Hope it can help some of you.

Quote:
COLLEGE HOOPS 2K8 RATINGS CALCULATOR (based on real stats)

BY: TarHeelsUNC

1. Copy stats from the top table on ESPN.com team stat pages to left part of spreadsheet.
2. Manually input 3PA, OFF (rebound), and DEF (rebound).
3. Input the team's RPI from the source of your choice. The RPI Bonus will be calculated.
4. Input the player's year pro. Go by years on varsity, not actual year in college.
Example: Kenny George is a Junior in college, but this is his 2nd year playing.
5. Your individual attributes and Player Overall will be automatically calcualated.

STL - Steal
AST - Passing
DRB - Defensive Rebound
ORB - Offensive Rebound
3PT - 3 Point Shot Ability
3T - 3 Point Shot Tendency
2PT - Inside Shot Ability (May not always be right for guards)
BH - Ballhandling
OA - Offensive Awareness (Base)
DA - Defensive Awareness (Base)
FT - Free Throw Ability
BLK - Block Ability
OVR - Overall Rating (suggested)

After inputting the individual ratings into the game, adjust various ratings to achieve the desired overall rating. My suggestions of edits are O and D Awareness, O and D Low Post, On Ball D, and Consistency. These adjustments work best for playerss with considerable MPG, but the overall rating usually works for all players.

I hope you all enjoy my rating adjustments. If not, sorry I couldn't help.

PLEASE BACK UP YOUR DATA PRIOR TO USE. I CAN NOT GUARANTEE THAT YOU WILL LIKE THE SAME RATING ADJUSTMENTS I DO. I WILL ACCEPT NO RESPONSIBILITY FOR PERCEIVED POOR GAMEPLAY. NO REFUNDS OR EXCHANGES.
MOST RECENT UPDATE ON PAGE 4!!
Attached Files
File Type: zip 2k8ratingscalc.zip (41.8 KB, 965 views)

Last edited by TarHeelsUNC; 01-18-2008 at 03:04 PM.
TarHeelsUNC is offline  
Reply With Quote
Advertisements - Register to remove
Old 01-15-2008, 01:37 PM   #2
DC
Hall Of Fame
 
OVR: 39
Join Date: Oct 2002
Location: DC
Posts: 17,961
Re: My 2k8 Ratings Spreadsheet

Is there any way I can learn how to do this because it would help me out with my NBA 2K rosters.

Can you help me or direct me to somewhere/someone that can help?

How the hell do I even use it; I can't figure this out man sorry.
__________________
Concrete evidence/videos please

Last edited by DC; 01-15-2008 at 01:39 PM.
DC is offline  
Reply With Quote
Old 01-15-2008, 01:39 PM   #3
ehh
Hall Of Fame
 
ehh's Arena
 
OVR: 44
Join Date: Mar 2003
Posts: 28,857
Blog Entries: 9
Re: My 2k8 Ratings Spreadsheet

Interesting, the ratings for UNC in the Excel file look very similar to a legacy 4-5 years in. And what's up w. the 100+ attributes?
__________________
"You make your name in the regular season, and your fame in the postseason." - Clyde Frazier

"Beware of geeks bearing formulas." - Warren Buffet
ehh is offline  
Reply With Quote
Old 01-15-2008, 05:51 PM   #4
CEO - BSG Network
 
Behindshadows's Arena
 
OVR: 50
Join Date: Nov 2004
Posts: 8,052
Blog Entries: 5
Re: My 2k8 Ratings Spreadsheet

Wow! I just found out, how these work, thats incredible. I might use this system to do my rosters ratings. They would be very accurate....

Thanks for this system man! Thanks alot!
Behindshadows is offline  
Reply With Quote
Old 01-15-2008, 07:05 PM   #5
Banned
 
Bigdmo9999's Arena
 
OVR: 46
Join Date: Jan 2008
Location: Oregon
Re: My 2k8 Ratings Spreadsheet

So wait...we just copy and paste it directly? Or do we have to past the number somewhere in the formula?

This is pretty sweet by the way. It should help people who are doing rosters in place of 2K9
Bigdmo9999 is offline  
Reply With Quote
Advertisements - Register to remove
Old 01-15-2008, 07:40 PM   #6
MVP
 
duke776's Arena
 
OVR: 28
Join Date: Nov 2006
Location: Cincinnati
Posts: 3,055
Blog Entries: 2
Re: My 2k8 Ratings Spreadsheet

I love you...thanks for this, it's amazing.
duke776 is offline  
Reply With Quote
Old 01-15-2008, 09:14 PM   #7
Rookie
 
TarHeelsUNC's Arena
 
OVR: 10
Join Date: Jan 2006
Blog Entries: 2
Re: My 2k8 Ratings Spreadsheet

Version 1.2, just changed some formulas. Glad to see some of you like it!
Attached Files
File Type: zip 2k8ratingv1_2.zip (68.1 KB, 292 views)
TarHeelsUNC is offline  
Reply With Quote
Old 01-15-2008, 09:16 PM   #8
Rookie
 
TarHeelsUNC's Arena
 
OVR: 10
Join Date: Jan 2006
Blog Entries: 2
Re: My 2k8 Ratings Spreadsheet

Quote:
Originally Posted by Bigdmo9999
So wait...we just copy and paste it directly? Or do we have to past the number somewhere in the formula?

This is pretty sweet by the way. It should help people who are doing rosters in place of 2K9
http://sports.espn.go.com/ncb/teams/stats?teamId=153Copy the stats starting with "Tyler Hansbrough" to cell A2. Then type in 3PA, OFF (rebound, and DEF (rebound).
TarHeelsUNC is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Basketball > Other Basketball Games > College Hoops 2K > College Hoops 2K Rosters »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 11:46 AM.
Top -