|
Post by trefilov22 on Jul 5, 2019 1:34:37 GMT
Okay ladies and gents, here is a question for you. We use a formula based system for doing our rerates, and we have some players whose leadership or experience has gone beyond 99. The rerates are done in an excel spreadsheet.
My question is this, will the sim accept ratings imported that are greater than 99 when we convert this xls file back to a file the sim will recognize, or will this cause an import error?
It is going to be a royal pain in the ass to go through each player and find those whose ratings are over 100... Does anyone know of a formula that can be used to convert anything in a column over 99 to be changed to 99, while leaving the rest of the column values the same?
Thank you in advance for your time.
|
|
|
Post by eleclerc on Jul 5, 2019 10:26:33 GMT
The sim can take over 100 when merging DB. I tried it this morning.
|
|
|
Post by New Era Sim Hockey on Jul 5, 2019 19:02:01 GMT
Okay ladies and gents, here is a question for you. We use a formula based system for doing our rerates, and we have some players whose leadership or experience has gone beyond 99. The rerates are done in an excel spreadsheet. My question is this, will the sim accept ratings imported that are greater than 99 when we convert this xls file back to a file the sim will recognize, or will this cause an import error? It is going to be a royal pain in the ass to go through each player and find those whose ratings are over 100... Does anyone know of a formula that can be used to convert anything in a column over 99 to be changed to 99, while leaving the rest of the column values the same? Thank you in advance for your time. Easiest way, when you have the players open in excel, sort by LD, then just change anything over 100 to 99. Repeat for EX. The sim doesn't care if you sort the players. There are excel formula's to cap ratings but I'd be scared of using one if it corrupts the excel file in the sim.
|
|