Tournament payout off of a paytable

[TravisBurch]

Starting a tournament series for fishing and want to use pay table I have to add a calculator to my website for people to see rough estimates of what payouts will be. I can't seem to figure this formula out though. Can anyone help?

Example

Payout Chart	0-30	31-40	41-50	51-60	61-70	71-80	81-90	91-120	121-150	151-180
1	50	45	40	37.5	35	34	32	30	28	27
2	30	30	27	23.2	21.6	21.1	19.8	18.6	17.3	16.9
3	20	15	15.5	15.2	14.3	13.8	13.8	13.1	12.5	12
4		10	10	10.5	10.2	9.7	10.1	9.5	9.35	8.5
5			7.5	7.7	7.6	7.2	7.4	7	6.8	6.5
6				5.9	6.1	5.6	5.6	5.2	5.2	5.1
7					5.2	4.6	4.4	4.2	4	3.9
8						4	3.7	3.4	3.1	3
9							3.2	2.7	2.5	2.4
10								2.1	2.05	1.9
11								2.1	2.05	1.9
12								2.1	2.05	1.9
13									1.7	1.6
14									1.7	1.6
15									1.7	1.6
16										1.4
17										1.4
18										1.4

 

[StephenCrump]

Welcome to the Forum!

Do you mean something like this?

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Payout Chart	3	31	41	51	61	71	81	91	121	151		No. participants	35
2	1	50	45	40	37.5	35	34	32	30	28	27		Entry fee	$10	each
3	2	30	30	27	23.2	21.6	21.1	19.8	18.6	17.3	16.9		Prizes
4	3	20	15	15.5	15.2	14.3	13.8	13.8	13.1	12.5	12		1	$157.50
5	4		10	10	10.5	10.2	9.7	10.1	9.5	9.35	8.5		2	$105.00
6	5			7.5	7.7	7.6	7.2	7.4	7	6.8	6.5		3	$52.50
7	6				5.9	6.1	5.6	5.6	5.2	5.2	5.1		4	$35.00
8	7					5.2	4.6	4.4	4.2	4	3.9		5
9	8						4	3.7	3.4	3.1	3		6
10	9							3.2	2.7	2.5	2.4		7
11	10								2.1	2.05	1.9		8
12	11								2.1	2.05	1.9		9
13	12								2.1	2.05	1.9		10
14	13									1.7	1.6		11
15	14									1.7	1.6		12
16	15									1.7	1.6		13
17	16										1.4		14
18	17										1.4		15
19	18										1.4		16
20													17
21													18
22													Total Pool	$350.00
Sheet1

Cell Formulas
Range	Formula
N4:N7	N4	=LET(p,N*Fee*INDEX(B2:K19,,MATCH(N,B1:K1))/100,FILTER(p,p<>0))
N22	N22	=SUM(N4:N21)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Fee	=Sheet1!$N$2	N4
N	=Sheet1!$N$1	N4

 

[TravisBurch]

Yes. I can't seem to get this to work. I must be missing something. I keep getting an error on the calulation.

Payout Chart

3​

31​

41​

51​

61​

71​

81​

91​

121​

151​

No. participants

35​

1​

50​

45​

40​

37.5​

35​

34​

32​

30​

28​

27​

Entry fee

$500​

each

2​

30​

30​

27​

23.2​

21.6​

21.1​

19.8​

18.6​

17.3​

16.9​

Prizes

3​

20​

15​

15.5​

15.2​

14.3​

13.8​

13.8​

13.1​

12.5​

12​

1​

#NAME?​

4​

10​

10​

10.5​

10.2​

9.7​

10.1​

9.5​

9.35​

8.5​

2​

#NAME?​

5​

7.5​

7.7​

7.6​

7.2​

7.4​

7​

6.8​

6.5​

3​

#NAME?​

6​

5.9​

6.1​

5.6​

5.6​

5.2​

5.2​

5.1​

4​

#NAME?​

7​

5.2​

4.6​

4.4​

4.2​

4​

3.9​

5​

8​

4​

3.7​

3.4​

3.1​

3​

6​

9​

3.2​

2.7​

2.5​

2.4​

7​

10​

2.1​

2.05​

1.9​

8​

11​

2.1​

2.05​

1.9​

9​

12​

2.1​

2.05​

1.9​

10​

13​

1.7​

1.6​

11​

14​

1.7​

1.6​

12​

15​

1.7​

1.6​

13​

16​

1.4​

14​

17​

1.4​

15​

18​

1.4​

16​

17​

18​

Total Pool

#NAME?​

 

[StephenCrump]

Have you defined the two range names my formulae are using?

N: =Sheet1!$N$1
Fee: =Sheet1!$N$2