if you guys care to share what is the holly line?
holly uses the below calc withing the complete data base
=(IF(ISERROR(CF3),0,IF(CF3>=60%,1,0)+(IF(ISERROR(CG3),0,IF(CG3>=60%,1,0)+(IF(ISERROR(CH3),0,IF(CH3>=60%,1,0)+(IF(ISERROR(CI3),0,IF(CI3>=60%,1,0)+(IF(ISERROR(CJ3),0,IF(CJ3>=60%,1,0)+(IF(ISERROR(CK3),0,IF(CK3>=60%,1,0)+(IF(ISERROR(CL3),0,IF(CL3>=60%,1,0)))+(IF(ISERROR(CM3),0,IF(CM3>=60%,1,0)))+(IF(ISERROR(CN3),0,IF(CN3>=60%,1,0)))))))))))))))+(IF(ISERROR(CF3),0,IF(CF3<=40%,-1,0)+(IF(ISERROR(CG3),0,IF(CG3<=40%,-1,0)+(IF(ISERROR(CH3),0,IF(CH3<=40%,-1,0)+(IF(ISERROR(CI3),0,IF(CI3<=40%,-1,0)+(IF(ISERROR(CJ3),0,IF(CJ3<=40%,-1,0)+(IF(ISERROR(CK3),0,IF(CK3<=40%,-1,0)+(IF(ISERROR(CL3),0,IF(CL3<=40%,-1,0)))+(IF(ISERROR(CM3),0,IF(CM3<=40%,-1,0)))+(IF(ISERROR(CN3),0,IF(CN3<=40%,-1,0)))))))))))))))
what the basically does is sum all the 9 key factors withing the data base and puts a plus 1 for each over 60 net of the minus 40 values. no value is assigned to any items which is not above or below that range. those factors are in the 1st col after Last 15 day visitor score avg and ends right before Holly which are the plus and minus totals max would be +9 or -9 of which i believe we've only had 2 near the top of each