Prizes formula clarification: Free TON Christmas/New Year greeting card design
Original proposal has a link to the Google Spread sheet with a special formula that is used to calculate prizes for the winners of the contest - https://docs.google.com/spreadsheets/d/1B_XSVRWnnOgC7JHE-1E95Jc8-lbiEwuCrNBlkCmpDzQ/edit#gid=1019156863
As the file is off-chain, we propose to fix the formula in an on-chain document.
Excel Formula for “Reward”:
=IF((PrizeFund/(SUM(Submissions With Avg. Score>Score Threshold)-(Score Threshold*(COUNTIF(Submissions With Avg.Score>Score Threshold)))*(Submission Avg. Score - Score Threshold))>0;(Prize Fund/(SUM(Submissions With Avg. Score>Score Threshold) - (Score Threshold*(COUNTIF(Submissions With Avg.Score>Score Threshold)))*(Submission Avg. Score - Score Threshold));0)
Static values:
PrizeFund = 100k
Score Threshold = 6
Submissions With Avg. Score > 6
Dynamic values:
Submission Avg. Score