31
Suggestions / Re: Prize breakdown problem I ran into the other night.
« on: April 01, 2006, 01:19:00 AM »
A point that MP made at first, but might not have been clear enough. If you did nothing else to your prizes except adding the 7th place $75 fixed prize in your example you would have gotten:
name,Recipient,Award,Amount,Points,Awarded To
1st Place,Rank 1,40.00%,$468.00 ,
2nd Place,Rank 2,23.00%,$269.00 ,
3rd Place,Rank 3,13.00%,$152.00 ,
4th Place,Rank 4,10.00%,$118.00 ,
5th Place,Rank 5,8.00%,$94.00 ,
6th Place,Rank 6,6.00%,$70.00 ,
7th Place,Rank 7, $75,$75
Which adds up to $1246 (I assumed rounding to nearest dollar on each prize)
So you just needed to add the right value of 7th place prize, and the computer would have done the rest for you without you changing anything. (It's a good feature once I figured out how it worked)
name,Recipient,Award,Amount,Points,Awarded To
1st Place,Rank 1,40.00%,$468.00 ,
2nd Place,Rank 2,23.00%,$269.00 ,
3rd Place,Rank 3,13.00%,$152.00 ,
4th Place,Rank 4,10.00%,$118.00 ,
5th Place,Rank 5,8.00%,$94.00 ,
6th Place,Rank 6,6.00%,$70.00 ,
7th Place,Rank 7, $75,$75
Which adds up to $1246 (I assumed rounding to nearest dollar on each prize)
So you just needed to add the right value of 7th place prize, and the computer would have done the rest for you without you changing anything. (It's a good feature once I figured out how it worked)