Manipulating OSA Scouting and Head Scout Ratings Independently

richallen44 · 03-19-2017, 01:35 AM

If I wanted to create a list with the restraints "OSA has potential rating below 35, Head Scout has potential rating above 50" or something like that, is there any way to do that in-game? Or do I have to use excel or an external manipulator? If so, how would I go about doing that?

NoOne · 03-20-2017, 03:23 PM

as far as i know, you cannot display both at the same time in the game.

i just replied to someone else with an answer that would help... copy/paste the text and pick the delimiter that works best to organize the data.

if you plan to do this often, don't just reformat it to look good... recreate the format you want by linking to the data from another worksheet... this way each time you copy/paste, it gets updated and you don't have to repeat that nonsense busy-work each time. just make sure to paste and choose the same delimiter each time...

you only have to link 1 row of data... highlight, and fill down for # of players. it won't be time intensive if you do it the smart way.

if # of players change, look into how to use the "fill" function and only add rows within the table, not at the end or beginning row. fill down from above where you added rows to the end of the table... pow! new rows all set up and ready to go. (in this case yo won't ever want to remove rows except for asthetics.. but same concept if you come across somethign similar elsewhere - delete rows within table, fill down from above the removed rows)

this does assume that the copy paste you did, while not pretty, does repeat a specific pattern for the data - even if multiple rows, that's not too big of a problem but try to pick a delimiter that puts stuff 1 row at a time or else you will have to do tricky things in order to use the fill function i hav mentioned above....

03-19-2017, 01:35 AM	#1
richallen44 Bat Boy Join Date: Mar 2017 Posts: 1	Manipulating OSA Scouting and Head Scout Ratings Independently If I wanted to create a list with the restraints "OSA has potential rating below 35, Head Scout has potential rating above 50" or something like that, is there any way to do that in-game? Or do I have to use excel or an external manipulator? If so, how would I go about doing that?

03-20-2017, 03:23 PM	#2
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,227	as far as i know, you cannot display both at the same time in the game. i just replied to someone else with an answer that would help... copy/paste the text and pick the delimiter that works best to organize the data. if you plan to do this often, don't just reformat it to look good... recreate the format you want by linking to the data from another worksheet... this way each time you copy/paste, it gets updated and you don't have to repeat that nonsense busy-work each time. just make sure to paste and choose the same delimiter each time... you only have to link 1 row of data... highlight, and fill down for # of players. it won't be time intensive if you do it the smart way. if # of players change, look into how to use the "fill" function and only add rows within the table, not at the end or beginning row. fill down from above where you added rows to the end of the table... pow! new rows all set up and ready to go. (in this case yo won't ever want to remove rows except for asthetics.. but same concept if you come across somethign similar elsewhere - delete rows within table, fill down from above the removed rows) this does assume that the copy paste you did, while not pretty, does repeat a specific pattern for the data - even if multiple rows, that's not too big of a problem but try to pick a delimiter that puts stuff 1 row at a time or else you will have to do tricky things in order to use the fill function i hav mentioned above.... Last edited by NoOne; 03-20-2017 at 03:25 PM.