hi!
What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...
Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....
But, the problem i have is that, their is 10 Teams in the league, therefore
the formuilas need to check the Teams average on the teams page and then
assign the correct Handicap to each team in the master sheets...
Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850
Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap
Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have
240pins handicap and so on...
Basically, the Highest average Team, gives Handicap to other teams....This
can change weekly, Team or Handicap..
Thx you!