2
« on: January 01, 2007, 02:55:24 PM »
I would also like to thank everyone in here for the formula answers, but I still have a couple of questions. Our league has been using this software for about a year pretty much just for the clock feature. This next year we're planning on using the program to keep track of points, bust outs and other features that I just haven't used yet. I have two questions that if anyone has an idea for it would be greatly appreciated. First, I need a formula for our league points. We work on a point basis that there will be 10 points given to first, 9 to second and so on down to 10th which will get 1 point. If we have more than 10 people 11th and below also get 1 point, so that any one who plays gets at least one point. If we have less than 10 people (say 9 people) 9th will get 2 points and no one will receive the 1 point. If anyone has an idea for a formula it would be a huge help. The second thing is on the Stats page this year (2006) we only counted or top 6 point finishes of our 12 tournament, in case some on couldn't make a couple of games it wouldn't count against them. This year we will be having 14 tournament with your top 9 finishes counting. Is there any way to add in a column that can adjust for this? I have been using MS Excel for this and have a formula (=SUM(LARGE(C5:C16, {1,2,3,4,5,6}))) for that but i don't know how to make a column and formula for the Stats page. Can any one help with this problem as well? Thank you very much in advance. - Eric