I ended up doing that but If I wanted to adjust the prize pool during a tourney it does not work well.
So the % should just be the total Prize pot and no other variables involved.
I will give you a scenario
total prize pot: $1260
Suggested
name,Recipient,Award,Amount,Points,Awarded To
1st Place,Rank 1,40.00%,$500.00 ,0,Michael B
2nd Place,Rank 2,23.00%,$285.00 ,0,Jim V
3rd Place,Rank 3,13.00%,$160.00 ,0,Steve F
4th Place,Rank 4,10.00%,$125.00 ,0,Doug F
5th Place,Rank 5,8.00%,$100.00 ,0,Maria P
6th Place,Rank 6,6.00%,$75.00 ,0,Ian G
,,,,,
,,,"$1,245.00 ",,
Adjusted
Name,Recipient,Award,Amount,Points,Awarded To
1st Place,Rank 1,$450.00 ,$450.00 ,0,Michael B
2nd Place,Rank 2,23.00%,$165.00 ,0,Jim V
3rd Place,Rank 3,13.00%,$95.00 ,0,Steve F
4th Place,Rank 4,10.00%,$70.00 ,0,Doug F
5th Place,Rank 5,8.00%,$55.00 ,0,Maria P
6th Place,Rank 6,6.00%,$40.00 ,0,Ian G
7th place,Rank 7,$75.00 ,$75.00 ,0,Tim W
,,,,,
,,,$950.00 ,,