I have been asked to create a system where that can rate colleagues with colours
the colours are as follows starting with the highest first
Gold
Silver
Bronze
Blue
Orange
Black
the colleagues all will start on Orange.
now the tricky part.
If the colleague sells a quantity of 4 a week and had 0 or 1 rejects then he goes up to Blue and so on
But if the colleague sells a quatity of 4 and had 2 rejects then he stays on that colour
if the colleague gets up to silver they need to sell 6 and have 0 rejects to get up to gold.
but if they get any rejects they go back to silver.
ANYONE WITH ANY IDEAS HOW TO DO THIS would be gratefully helpful.
Thanks.
Andy.