The spreadsheet formulas are as follows, if anyone is interested in the nitty gritty details (all data is per 100 possessions):
Code: Select all
INSIDE=2*(IF(INSATT<28.5,INSATT,28.5)*(0.628-INSEFF)+IF(INSATT>28.5,(0.488-INSEFF),(0.488-0.628))*(INSATT-28.5))
MID-RANGE=2*IF(MIDATT<40,MIDATT*(0.386-MIDEFF),40*(0.386-MIDEFF))+2*IF(MIDATT>40,(MIDATT-40)*(0.624-MIDEFF),(40-MIDATT)*(0.386-0.624))
3-PT=2*(IF(FG3ATT<19.53,FG3ATT,19.53)*(0.54-FG3EFF)+IF(FG3ATT>19.53,(0.527-FG3EFF),(0.54-0.527))*(FG3ATT-19.53))
FT=2*(FTPOSS-11.62)*(0.498-0.76)

What I like about this is that you can see in a nutshell the strengths of weaknesses of a team defense (well, everything except for the ability to cause turnovers, which is obviously important). I will do the same thing for offense when I get a chance.