" it is more or less impossible to write a formula that evaluates better than the eye test, so don't worry. i could see writing an extensive set of logic for player evaluation that could get there, but even ridiculously complex single formulas can't touch the eye test."
didn't sashi brown try this with the cleveland browns in 2016?..it only worked so so then..john dorsey's "eye test" system seems to be working fine today for the browns..

Posted by franklynne on 8/15/2019 11:57:00 AM (view original):
" it is more or less impossible to write a formula that evaluates better than the eye test, so don't worry. i could see writing an extensive set of logic for player evaluation that could get there, but even ridiculously complex single formulas can't touch the eye test."
didn't sashi brown try this with the cleveland browns in 2016?..it only worked so so then..john dorsey's "eye test" system seems to be working fine today for the browns..

Without Sasha Brown’s accumulation of picks, Dorsey wouldn’t have been able to do what he’s done.

Just jumping in to say awesome stuff!

Posted by Sportsbulls on 8/15/2019 1:25:00 PM (view original):

Posted by franklynne on 8/15/2019 11:57:00 AM (view original):
" it is more or less impossible to write a formula that evaluates better than the eye test, so don't worry. i could see writing an extensive set of logic for player evaluation that could get there, but even ridiculously complex single formulas can't touch the eye test."
didn't sashi brown try this with the cleveland browns in 2016?..it only worked so so then..john dorsey's "eye test" system seems to be working fine today for the browns..

Without Sasha Brown’s accumulation of picks, Dorsey wouldn’t have been able to do what he’s done.

Tremendous point by franklynne....the rebuttal to that is, had sashi brown not gone 0-16 the year before, Dorsey wouldn’t have needed to do the picking. Plus, Brown would have drafted Rosen number 1 and traded the 4th pick for an established right guard because “they’ve been historically undervalued in the NFL.”

But let’s not hold up sashi brown as the paragon of effective analytics usage. Maybe whoever popularized the defensive shift or Daryl Morey would be better examples. I don’t buy the Billy Beane hype. Lightning struck once, and it was probably Depodesta’s lightning. Speaking of which, see: Cleveland Browns 0-16.

Just looked up DePodesta on wiki. Fun fact: he served on the board of Sears.

Posted by franklynne on 8/15/2019 11:57:00 AM (view original):
" it is more or less impossible to write a formula that evaluates better than the eye test, so don't worry. i could see writing an extensive set of logic for player evaluation that could get there, but even ridiculously complex single formulas can't touch the eye test."
didn't sashi brown try this with the cleveland browns in 2016?..it only worked so so then..john dorsey's "eye test" system seems to be working fine today for the browns..

Frank I have bad news. WIS is not real. There are formulas out there, they are just far more complex than this. However, it is technically possible to write a perfect program for WIS.

Posted by marl_karx on 8/15/2019 11:57:00 AM (view original):
I may have accidentally messed up a formula somehow. What I will do is just grab new copy of your original file and confirm that it works. If I still have a problem with it I will follow up with you.

Thanks for sharing this!

You did not! I accidentally put an extra $ sign in there that locked the row of the cell I was referring to. Fixed!

On the recruiting sheet, it would only take 1 second to make it so you could put name and ratings on the actual tab where you see the Overall results. That way you could just ignore the other sheets and it would be even more streamlined.

Here is the link for how I did it

https://docs.google.com/spreadsheets/d/1jpi-cBNkI0LCipAXlc4tX-xF23DZ__Iy_D6ci3e-Xfg/edit?usp=sharing

PS I also have a spreadsheet that lets you paste recruits' starting stats and generate projections of how they will end up. The only problem is that it is in Excel and uses custom functions to pull the colors of the ratings. I'm not sure how to port that over to Google Sheets off hand but I may try if that would be of value to anyone.

I made a chrome extension that does this on the recruits page with a click of a button.

https://www.whatifsports.com/forums/Posts.aspx?topicID=511285&TopicsPage=0

Posted by Basketts on 8/15/2019 11:34:00 PM (view original):
I made a chrome extension that does this on the recruits page with a click of a button.

https://www.whatifsports.com/forums/Posts.aspx?topicID=511285&TopicsPage=0

Thanks, I actually use your extension and really like it! If you know a way to spit out the results in pastable text that would be perfect.

That's a good idea. Let me see what I can do.

hey cubcub113..i'm not knocking your work..it's fantastic..i'm just saying i like the fantasy of recruiting my "fake" ball players without spreadsheets..i will play with yours when\if i have time

Posted by Basketts on 8/16/2019 11:00:00 AM (view original):
That's a good idea. Let me see what I can do.

The one advantage to my spreadsheet is that you can copy/paste all of your Level 4s at once and instantly spit out hundreds of projections. But I think I can figure out how to get a column of data from your extension and then take the transpose for the spreadsheet

Couple recommendations for the StatSheet page:

1. Instead of placing a bottom border after the 10th cell for each team, use conditional formatting on the sheet to turn the Totals and Opp. Totals rows to a light grey. This way, no matter how many players get pulled in by google sheets, those rows will always be grey. Right now, if a team gets pulled in that doesn't include walk-ons, it throws off the formatting.

The formula for the custom code on conditional formatting is: =OR($A4 = "Totals", $A4 = "Opp. Totals")

2. Because of the same issue, the usage rate calculation can break if it doesn't align with the totals row. You can fix it so that it looks up the number no matter where the totals row gets imported.

The usage formula for your team's first player is: =(H4+(L4/2)+P4)/(((VLOOKUP("Totals", A1:T20, 8, FALSE)+(VLOOKUP("Totals", A1:T20, 12, FALSE)/2)+VLOOKUP("Totals", A1:T20, 16, FALSE))*V4)/40)*100

The usage formula for opp team's first player is: =(H25+(L25/2)+P25)/(((VLOOKUP("Totals", A22:T40, 8, FALSE)+(VLOOKUP("Totals", A22:T40, 12, FALSE)/2)+VLOOKUP("Totals", A22:T40, 16, FALSE))*V25)/40)*100

You'd adjust accordingly for the rest of the players.