Coach who needs help

[neumania]

I am an assistant coach for a small college. I have really started to use advanced stats to help our team. I understand the basic concepts and formulas. I am not a programmer by any means so it takes me a LONG time to calculate what I want to know. I was wondering if anyone had or could create a simple spreadsheet where I could plug in my numbers and get the data I am looking for. I know it seems lazy but with a small staff not being able to afford SYNERGY--I have a lot of duties and film to break down so gathering all of this data is time consuming! I try to keep a running total for every team in our league as well. Our team really appreciates the effort--and I would like to continue giving us any edge we can find. Thanks for your help!

[EvanZ]

What do you want to calculate? What stats are you keeping track of?

[neumania]

I do possessions, ppp, the 4 factors, tsp, and ft rate. I am looking for easy formulas for INDIVIDUAL players--like usage and efficiency stats for individuals. Also--something like Hollingers individual ratings that I can just plug box-score stats into.

[DSMok1]

Somebody on this board needs to make some generic Excel worksheets for all the coaches that come here looking for assistance!

[EvanZ]

I was thinking a Google Spreadsheet?

[Crow]

Game Score (the simple version of Hollinger's PER)= PTS + 0.4 * FGM – 0.7 * FGA – 0.4*(FTA – FTM) + 0.7 * ORB + 0.3 * DRB + STL + 0.7 * AST + 0.7 * BLK – 0.4 * PF – TO

If you want to compare to Berri's WinScore:

revised Win Score = PTS + STL + ORB + 0.5*DRB + 0.5*AST + 0.5*BLK – TOV – FGA
– 0.5*FTA – 0.5*PF

Or you could blend them, say 50/50 if you don't have a strong preference for either one.

I loaded these formulas into a spreadsheet.



Just download the file to your computer then load these boxscore stats into it for players (by game or for the season) and it will compute the two formulas and an equal blend of them for you.

[neumania]

Thanks! That will really be helpful! Feel free to create some more spreadsheets like that for team stuff

[neumania]

Are there any average numbers? Like Hollinger says the average score is 15 for an NBA player?

[Crow]

I think Game Score / Minutes per game played * 48 minutes in the NBA game = roughly PER

Game Score of 10 in 32 minutes (or GS 5 in 16 minutes, etc.) * 48 minutes in NBA = 15 PER approximation (PER 15 = average NBA performance (not median player PER).


It is too late for me to be 100% sure on all that or to wrestle with a rule of thumb for WinScore.

[DSMok1]

The best simple linear weights metric, as found by Neil Paine, is Alternate Win Score (Berri's Win Score adjusted by Lewin and Rosenbaum). It is set out in their research article.

The full equation is:

Code: Select all

AWS = PTS + STL - TO + 0.5*AST + 0.5*BLK - 0.5*PF + 0.7*ORB - 0.7*FGA + 0.3*DRB - 0.3*FGM - 0.35*FTA - 0.15*FTM

I would recommend you use AWS/minute to see player's rates of contribution.

[neumania]

Could you put that formula into a spreadsheet for me?

[Crow]

Okay,



but this is something you should be able to learn to do. Maybe look into a excel online tutorial or check a book out of the library.

[neumania]

Thanks so much!!! I am definitely learning to plug the formulas myself now that our season is over!

Last question--would you devide AWS by minutes played per game and then multiply by 40 (college game) for a way to equally measure each players contribution?

[Crow]

sure.

try to make the adjustment.