I created a rating sheet that takes the minimum growth of a recruit and gives you a visual representation of where they should end minimally. I figure for newer players this could make it easier to project where players will end up. Any feedback is welcome. As long as you go through the link below you will be able to edit the document. Created 2 separate spots to work in in case multiple people are in the sheet at once.

If anyone would like other sheets made I can definitely look into it.

https://docs.google.com/spreadsheets/d/1FaXjb6hHrx-zepeRXFhiRvBLKxeS29vQ3qSoNWC2A6I/edit?usp=sharing

This is very cool. Thanks for putting this together and, more importantly, thanks for sharing.

Very helpful. Thank you

No problem everyone! I want this game to be competitive and great again! It sucks to see players with 30 seasons under there belt and they continue to put up 10-16 or worse seasons. Anything to help i'm here.

Thank you!!
Amazing work!!!

Thanks man, how hard would it be to put a range of final values in addition to minimum?

If I cut and pasted the formula into a second column and changed the values to maximum values that would work right?

I modified the charts so they have a title and the vertical axis has labels.

One thing to figure out is to set a max of 100. I'm sure there is a way to set the formula up but I don't know off the top of my head.

Posted by Benis on 4/28/2017 11:35:00 AM (view original):
I modified the charts so they have a title and the vertical axis has labels.

One thing to figure out is to set a max of 100. I'm sure there is a way to set the formula up but I don't know off the top of my head.

Thank you Benis! I couldn't figure out how to do that. I however fixed your issue and added bounds so the graph will only show 0-100 and wont change based off the values.

Posted by Trentonjoe on 4/28/2017 11:14:00 AM (view original):
Thanks man, how hard would it be to put a range of final values in addition to minimum?

If I cut and pasted the formula into a second column and changed the values to maximum values that would work right?

Yes it would work, I can work on this today and make a 3rd column. The only issue is the "very high" but you could essentially just change the value to 100.

Posted by bagger288 on 4/28/2017 11:40:00 AM (view original):

Posted by Benis on 4/28/2017 11:35:00 AM (view original):
I modified the charts so they have a title and the vertical axis has labels.

One thing to figure out is to set a max of 100. I'm sure there is a way to set the formula up but I don't know off the top of my head.

Thank you Benis! I couldn't figure out how to do that. I however fixed your issue and added bounds so the graph will only show 0-100 and wont change based off the values.

No prob.

Right click on the chart and go to advanced edit.

Working on the max final rating the only issue I am running into is for the "High" potential putting the max rating over 100. Very high was easy as I just changed the cell to = 100. I have copied this formula to the lines and if someone has a fix for the data being over 100 for any potential being high or lower let me know.

I have found a way to fix the maximum high rating going over 100 for anything except very high. I need to implement it for "Average" as well but just don't have the time right this minute. I will be doing this shortly later or tomorrow.

That's a great resource!

If(condition,min(100,cell+value),if(....should do it

Edit: Min not Max

Not at a comp now but that should solve the >100 issue