|
whoops, noticed a mistake in the equation above, the max on the GAP was missing a zero (it doesn't matter for most players, because most players have a gap of at least 50). At any rate, it should be:
=(0.3*MAX(J20-50;0)+0.15*MAX(I20-50;0)+0.45*MAX(G20-50;0)+0.1*MAX(H20-50;0))-0.9*MAX(0;50-G20)-0.14*MAX(0;50-J20)-0.09*MAX(0;50-I20)-0.15*MAX(0;50-H20)
|