Golf Skins Scorecard

[DowningAir]

Hi everyone. I'm new to the forum and I've been reading some of the older posts, teaching myself as I go. The information has been very helpful. Thank you for the resource!

That being said, I'm putting together a spreadsheet for golf skins and I want to calculate the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). This is what I have so far...

A21=IF(D21=1,INDEX(A7:A18,MATCH(D21,B7:B18,0)),"Tie") (Inserts the player's name if only 1 low score is recorded and inserts "Tie" if more than 1 low score is recorded)

B21=Hole Number (1 through 18 for cells B21:B38)

C21=MIN(B7:B18) (Finds the low number in the scorecard columns per hole (B=Hole 1))

D21=COUNTIF(B7:B18,C21) (Returns the total of minimum numbers in Column C)

These cells extend from 21:38 for all 18 holes. Like I said, I'd like column E to represent the amount won per hole taking into consideration carry over in the event of a tie from the previous hole(s). 12 players, $5/player/round, so the theoretical pot per hole would be (60/18). Any help would be appreciated. I'm a novice when it comes to excel so if my explanation is unclear please feel free to ask questions. Thank you in advance!

 

[Dave Patton]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Results	570	45	0	0	25	5	Skins game Golf
2	Hole#	Mike	Bill	Dave	Larry	Joe			Winner
3	1	4	4	4	4	3	TRUE	25	Joe		25
4	2	5	6	5	5	5	FALSE	25			25
5	3	5	6	5	5	5	FALSE	50			25
6	4	3	4	4	4	4	TRUE	75	Mike		25
7	5	3	4	4	4	4	TRUE	25	Mike		25
8	6	3	4	4	4	4	TRUE	35	Mike		35
9	7	3	4	4	4	4	TRUE	35	Mike		35
10	8	3	4	4	4	4	TRUE	35	Mike		35
11	9	3	4	4	4	4	TRUE	35	Mike		35
12	10	3	4	4	4	4	TRUE	35	Mike		35
13	11	5	4	4	4	4	FALSE	35			35
14	12	5	4	4	4	4	FALSE	70			35
15	13	5	4	4	4	4	FALSE	115			45
16	14	5	4	4	4	4	FALSE	160			45
17	15	5	4	4	4	4	FALSE	205			45
18	16	5	4	4	4	4	FALSE	250			45
19	17	3	4	4	4	4	TRUE	295	Mike		45
20	18	4	3	4	4	4	TRUE	45	Bill		45
1a

Excel 2003

Cell Formulas
Range	Formula
B1	=SUMPRODUCT(($I$3:$I$20=B2)+0,($H$3:$H$20))
C1	=SUMPRODUCT(($I$3:$I$20=C2)+0,($H$3:$H$20))
D1	=SUMPRODUCT(($I$3:$I$20=D2)+0,($H$3:$H$20))
E1	=SUMPRODUCT(($I$3:$I$20=E2)+0,($H$3:$H$20))
F1	=SUMPRODUCT(($I$3:$I$20=F2)+0,($H$3:$H$20))
G3	=COUNTIF(B3:F3,MIN(B3:F3))=1
G4	=COUNTIF(B4:F4,MIN(B4:F4))=1
G5	=COUNTIF(B5:F5,MIN(B5:F5))=1
G6	=COUNTIF(B6:F6,MIN(B6:F6))=1
H3	=IF(G2,K3,K3+H2)
H4	=IF(G3,K4,K4+H3)
H5	=IF(G4,K5,K5+H4)
H6	=IF(G5,K6,K6+H5)
I3	=IF(G3,INDEX($B$2:$F$2,MATCH(MIN(B3:F3),B3:F3,0)),"")
I4	=IF(G4,INDEX($B$2:$F$2,MATCH(MIN(B4:F4),B4:F4,0)),"")
I5	=IF(G5,INDEX($B$2:$F$2,MATCH(MIN(B5:F5),B5:F5,0)),"")
I6	=IF(G6,INDEX($B$2:$F$2,MATCH(MIN(B6:F6),B6:F6,0)),"")

An example would have been very useful.

My example does not guess at your layout and it uses a payout that increases.

 

[DowningAir]

Dave,

Sorry for the lack of an example, I'm new to the site and will include more details in future inquires. Thank you very much for your response, It's just what I was looking for. I appreciate your help with this!

 

[stkin]

I need help, I have a scorecard I'm working on with carryover skins in golf. If you don't know what that is, every hole is worth so much money and if no one wins the hole with the low net score, the amount is carried to the next hole and continues until someone wins a hole. I am attaching my work, I have skins in C35:U38. You can see that holes 2,5,6,7,8,9 on front is a carryover. I'm looking for a formula that will figure out the care over amount, example hole 3 has a winner, but I don't know how to show 1.50 won instead of .75. I will attach my work. i can see the work book didn't come out good, hopefully someone can understand it.

Thanks

Tommy


[TABLE="width: 1060"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SKINS WON[/TD]
[TD]GREENIES[/TD]
[TD]MONEY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]SKINS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD][/TD]
[TD]FRONT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]BACK[/TD]
[TD]TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TOMMY[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KEITH[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BUZZ[/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DAVE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]