View Single Post
Old 01-30-2017, 03:51 PM   #3
NoOne
Banned
 
Join Date: Apr 2015
Posts: 7,273
Infractions: 0/1 (3)
you can fix this by hand if you want., but it would take a lot of effort - especially if the players aren't organized well (e.g. all the players from 1963 are lumped together.)

so, it realyl depends on that stuff as far as how viable this option is for you.

when i've imported players to a legaue that had a different year, it was easy for me to adjust this with a simple "=YoB - 30" formula in a spreadsheet... those players all were 30 years too old (or whatver #). use worksheet2, keept it separate and easier than scrolling 50 columns right and left. "=sheet1:a1 - 30" or there abouts - if a1 was the first value for YoB (show column headers when you export, but this one should stand out as a 4-digit number you will recognize either way)

your situation is different. you may need to go by team or whatever to adjust age (if that's how the player ages are lumped, like the '68 mets team, not a mets all-star all-time team). sort by columns if necessary, re-sort as it was when you first exported though, just in case that matters - it should not, but... not everything is made as it should be. i prefer not to make another trial and error if avoidable... you're welcome to see if the game cares about how it's sorted for re-import... a dB shouldn't care, though - it should handle it properly regardless.

so, export players, load into a spreadsheet. if my team and specific year - you need to make a formula to change the YoB column to an appropriate value. then fill down for the # of players that fit that formula... rinse and repeat as you go per team .. once finished, copy that "new" column you just mad over the YoB column (paste special - values only!!).

delete that formula column after you have transposed the values over the YoB column... the file should be back to the same format as when you exported it, except with new values in teh YoB column. import back to the game, and your player ages are now fixed.


nothing to do for the coaches' ages, i believe... unless they have their own export with a YoB column.

Last edited by NoOne; 01-30-2017 at 03:56 PM.
NoOne is offline   Reply With Quote