Spreadsheet: 147177d1332564051-need-an-alternative-to-lots-of-nested-if-statements-payout
Sheet: PayOut

 |  |  |  |  |  |  |  |  |  |  | 1 | 1
End of Season Payout - Rounded to the Nearest Dollar |  |  |  |  |  |  |  |  |  |  | 2 | IF(D22=D23,1,2)
 |  |  |  |  |  |  |  |  |  |  | 3 | IF(AND(D22>D23,D23>D24),3,IF(AND(D22>D23,D23=D24),2,IF(AND(D22=D23,D23=D24),1,2)))
Criteria |  |  |  | League Funds and Allocations |  |  | % | Total | Per Week |  | 4 | IF(AND(D22>D23,D23>D24,D24>D25),4,IF(AND(D22=D23,D23>D24,D24>D25),3,IF(AND(D23>D24,D24=D25),3,IF(AND(D23=D24,D24=D25),2,IF(AND(D22=D23,D23=D24),2,3)))))
24 | Teams |  |  | League Operation |  |  | 0.05
40 | Sponsor Fee per Team |  |  | Team Payout |  |  | 0.85
30 | Team Fee per Week |  |  | All Stars Tournament |  |  | 0.1 |  |  |  |  | RANK(A1,$A$1:$A$10,1)+COUNTIF($A$1:$A1,A1)-1
 | BYE Per Week |  |  |  |  |  |  |  |  |  |  | RANK(D22,D$22:D$45)
 | Weeks of Competition |  |  |  |  |  |  |  |  |  |  | SUM(IF(A2>$A$2:$A$7,1/COUNTIF($A$2:$A$7,$A$2:$A$7)))+1
 | Projected Pot
Team Payout Fund Allocation |  |  | % | Total |  | All Stars Tournament Payout
% of team payout for Games Won |  |  | 1 |  |  | Place | % | Total | Per Player
 |  |  |  |  |  | 1 | 0.4444
 |  |  |  |  |  | 2 | 0.3333
 |  |  |  |  |  | 3 | 0.2222
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Season
 |  |  |  |  |  |  |  | Minus Dues Not Paid |  | Per Player |  |  |  |  |  | Season
Place (no ties) | Place (with ties) | Team | Total Games Won This Season | % of Team Pay Out (no ties) | % of Team Pay Out (with ties) | Total | Per Player | Total Dues Not Paid | Deducted | Final Payout |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
1 |  | Pastime 1 | 137 |  |  |  |  | 0 |  |  |  | 1 | 0.27 | 0.25 | 0.25 | 0.22 | 0.235 | 0.23 | 0.227 | 0.223 | 0.21 | 0.194 | 0.185 | 0.18 | 0.176 | 0.168 | 0.152 | 0.152 | 0.148 | 0.148 | 0.148
2 |  | Columbia 1 | 137 |  |  |  |  | 0 |  |  |  | 2 | 0.21 | 0.19 | 0.19 | 0.18 | 0.18 | 0.16 | 0.148 | 0.144 | 0.14 | 0.14 | 0.14 | 0.138 | 0.137 | 0.135 | 0.125 | 0.125 | 0.121 | 0.12 | 0.12
3 |  | Columbia 2 | 123 |  |  |  |  | 0 |  |  |  | 3 | 0.16 | 0.15 | 0.14 | 0.13 | 0.13 | 0.12 | 0.111 | 0.106 | 0.105 | 0.105 | 0.105 | 0.105 | 0.105 | 0.105 | 0.104 | 0.1 | 0.1 | 0.1 | 0.1
4 |  | Wigwam 2 | 109 |  |  |  |  | 0 |  |  |  | 4 | 0.14 | 0.125 | 0.11 | 0.11 | 0.11 | 0.1 | 0.1 | 0.098 | 0.098 | 0.098 | 0.098 | 0.095 | 0.09 | 0.09 | 0.09 | 0.085 | 0.085 | 0.085 | 0.085
5 |  | Kozy 2 | 96 |  |  |  |  | 0 |  |  |  | 5 | 0.12 | 0.105 | 0.095 | 0.1 | 0.08 | 0.085 | 0.087 | 0.087 | 0.087 | 0.087 | 0.087 | 0.085 | 0.085 | 0.085 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075
6 |  | Tekila 1 | 93 |  |  |  |  | 0 |  |  |  | 6 | 0.1 | 0.095 | 0.09 | 0.08 | 0.07 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07
7 |  | Pastime 2 | 85 |  |  |  |  | 10 |  |  |  | 7 |  | 0.085 | 0.075 | 0.07 | 0.06 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.06 | 0.06 | 0.059 | 0.059 | 0.056 | 0.056 | 0.056 | 0.055 | 0.055
8 |  | Wigwam 1 | 85 |  |  |  |  | 0 |  |  |  | 8 |  |  | 0.05 | 0.06 | 0.055 | 0.055 | 0.054 | 0.052 | 0.052 | 0.052 | 0.052 | 0.052 | 0.052 | 0.052 | 0.051 | 0.051 | 0.051 | 0.05 | 0.05
9 |  | Kozy 1 | 84 |  |  |  |  | 0 |  |  |  | 9 |  |  |  | 0.05 | 0.045 | 0.045 | 0.045 | 0.041 | 0.041 | 0.041 | 0.041 | 0.041 | 0.041 | 0.041 | 0.046 | 0.046 | 0.046 | 0.045 | 0.045
10 |  | 1 | 81 |  |  |  |  | 0 |  |  |  | 10 |  |  |  |  | 0.035 | 0.035 | 0.035 | 0.036 | 0.036 | 0.036 | 0.036 | 0.036 | 0.036 | 0.036 | 0.041 | 0.041 | 0.041 | 0.04 | 0.04
11 |  | 2 | 80 |  |  |  |  | 0 |  |  |  | 11 |  |  |  |  |  | 0.03 | 0.03 | 0.031 | 0.031 | 0.031 | 0.031 | 0.031 | 0.031 | 0.031 | 0.036 | 0.036 | 0.036 | 0.035 | 0.035
12 |  | 3 | 74 |  |  |  |  | 0 |  |  |  | 12 |  |  |  |  |  |  | 0.023 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.031 | 0.031 | 0.031 | 0.03 | 0.03
13 |  | 4 | 68 |  |  |  |  | 0 |  |  |  | 13 |  |  |  |  |  |  |  | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022
14 |  | 5 | 68 |  |  |  |  | 0 |  |  |  | 14 |  |  |  |  |  |  |  |  | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
15 |  | 6 | 54 |  |  |  |  | 0 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018
16 |  | 7 | 52 |  |  |  |  | 0 |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | 0.014 | 0.014 | 0.014 | 0.014 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016
17 |  | 8 | 50 |  |  |  |  | 0 |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  | 0.012 | 0.012 | 0.012 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014
18 |  | 9 | 47 |  |  |  |  | 0 |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  | 0.011 | 0.011 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012
19 |  | 10 | 44 |  |  |  |  | 0 |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 | 0.011 | 0.011 | 0.011 | 0.011 | 0.01
20 |  | 11 | 42 |  |  |  |  | 0 |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 | 0.01 | 0.01 | 0.01 | 0.009
21 |  | 12 | 40 |  |  |  |  | 0 |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.009 | 0.009 | 0.009 | 0.008
22 |  | 13 | 37 |  |  |  |  | 0 |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.008 | 0.008 | 0.007
23 |  | 14 | 34 |  |  |  |  | 0 |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.007 | 0.006
24 |  | 15 | 33 |  |  |  |  | 0 |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.005