C
Chartswife
I'm trying (without success) to write a formula to use in a table to figure
the NFL quarterbacks passer rating. Here are the components, and I believe my
errors are the maximum and minimum and not knowing how to use them in the
formula:
C= Comp/Att*100-30/20
Y= YDS/Att-3*.25
T= TD/Att*20
I= 2.375-INT/Att*25
The four components are then added and divided by 6 and multiplied by 100,
so the formula for passer rating is given as:
(max(min(C,2.375),0)+max(min(Y,2.375),0)+max(min(T,2.375),0)+max(min(I,2.375),0)*100/6
I have played for 3 days with this monster formula and have not figured it
out. Can anyone help?
the NFL quarterbacks passer rating. Here are the components, and I believe my
errors are the maximum and minimum and not knowing how to use them in the
formula:
C= Comp/Att*100-30/20
Y= YDS/Att-3*.25
T= TD/Att*20
I= 2.375-INT/Att*25
The four components are then added and divided by 6 and multiplied by 100,
so the formula for passer rating is given as:
(max(min(C,2.375),0)+max(min(Y,2.375),0)+max(min(T,2.375),0)+max(min(I,2.375),0)*100/6
I have played for 3 days with this monster formula and have not figured it
out. Can anyone help?