View Single Post
Old 10-27-2018, 12:53 PM   #38
Brock
MVP
 
OVR: 9
Join Date: Apr 2008
Location: Places Unknown, SC
Re: NCAA Football '12: 2016-2017 Roster Conversion/Update (PS3)

I was just reading thru the last posts, and redownloaded my ncaa config folder, and it was pretty nostalgic and made me remember some stuff.

I believe what I did in the csv file is I selected the top of the skin tones column "PGHE" and selected the whole spreedsheet, then I went to the data tab and clicked on sort and I did it from big to little, but i don't believe it matters entirely, just how I did it. And what I did was select the whole column and copy and pasted it into another sheet and just substracted from it.

I.e.

in '12 the highest light face is 57 and in '14 it's 99. So that'd be 42. So when I got down to the 99's I'd just put -42 and just go down from there. Once I've done that for all of the numbers, I select them all the active rows/columns and autosum them. I'll provide a screenshot.

Then I copied and paste them back into the original "PGHE" tab. And since you've sorted them, every thing will be in it's correct order, so then you'd just go back to the "PGID" tab and select the whole spreedsheet and do the sort option (but using the smaller to big option) and everything should work.

P.S. I did the same thing with the dreads, but most of the players with dreads were corrected without changing much. I also added random values to randomize the faces as well.

Spoiler
Brock is offline  
Reply With Quote