Help with office pool payout table

[wakopamos]

Hello all,

I'm trying to put together a general payout schedule for office pools showing percentages that each place would get paid out depending on # of entries. Looking to put together something that can range from 10-300 entries and show payout %'s for either 10 or 15% of total entries. Would like to be able to set max and min payouts (ie. 50-60% for 1st and 1-2% for last but that would potentially change based on the # of entries.)

What I'm thinking of is below, I just can't figure out the formulas required to make the sheet a little more dyanamic and help fill in the middle %'s using a formula of some sort. I'm a little lost and don't really know where to start. Any help would be greatly appreciated.

Thanks!

#	Total	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
1-10	100.0%	100.0%
11-20	100.0%	65.0%	35.0%
21-30	100.0%	57.1%	23.8%	19.1%
31-40	100.0%	56.5%	24.3%	9.6%	9.6%
41-50	100.0%	53.7%	19.5%	12.2%	7.3%	7.3%
51-60	100.0%	46.1%	22.5%	11.8%	7.8%	5.9%	5.9%
61-70	100.0%	45.9%	22.9%	11.5%	8.2%	4.9%	3.3%	3.3%
71-80	100.0%	43.8%	21.1%	12.7%	7.0%	5.6%	4.2%	2.8%	2.8%
81-90	100.0%	42.5%	20.4%	12.3%	7.4%	6.2%	3.7%	2.5%	2.5%	2.5%
91-100	100.0%	42.3%	20.3%	13.2%	7.7%	5.5%	4.4%	2.2%	2.2%	1.1%	1.1%
101-110	0.0%
111-120	0.0%
121-130	0.0%
131-140	0.0%
141-150	0.0%
151-160	0.0%
161-170	0.0%
171-180	0.0%
181-190	0.0%
191-200	0.0%

<colgroup><col><col><col span="20"></colgroup><tbody>
</tbody>