Hi
I managed to do the formula for the points using this but still need help calculating it over the 13 weeks and adding it into the summary section as well as setting up the full 13 week season.
assign ("v", n + nr)
assign ("percent", switch (r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05, 0))
assign ("points", 0)
if ( (v >=8) && (v <=9), assign ("points", (v * 200 * percent+4) + if (r < 9, v, 76)))
Thanks
Chas
points
After testing the above formula It was not working properly so I have adjusted it to the one below
assign ("v", n)
assign ("percent", switch (r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05, 0))
assign ("points", 0)
if ( (r>=8), assign ("points", (v * 200 * percent-v+30) + if (r < 9, v, 80-4)))
I have had to add -4 to the end as it seems to add this to my 80, have no idea why but this seems to work for me if there is a better way then please let me know.
I still however need help on the other stuff, great program
Thanks