|
if the players are all from teh same year, or maybe per team the same year, you can quickly change them with a spreadsheet and an export of players.
if the same year by team, subtract X from the dob column in an unused space. copy and "paste special" numbers/text only and it's fixed. delete the "-x"column after you paste.
1) type "=" in an empty extra column, (inserting 1 works too)
2) click first row of dob column (this adds cell location after '=')
3) then type "-x" <enter> -- x=years difference current year-year player was imported from - will be the same for all players imported form same year.
1 cell is all you need to setup per team or entire league.
highlight that one cell, move mouse to lower right corner of highlighted cell and cursor becomes a "+" shape, click and drag down and it autoincrements what's necessary. entire column or entire team(or league) is done. rinse repeat for next team.
if you inserted the row for ease, make sure to remove that row, not just 'delete' it. otherwise just make sure no extra columns exist beyond what was originally exported.. with your new dob column values, of course.
import players back into league.
this is somethign that they can easily fix with minimal lines of code. this is one of this things like not being able to sort certain screens, lol.
|