Golf Tournement Payout

M

mckenph

New Member
Joined
Sep 29, 2015
Messages
5
So I have created a pretty neat spreadsheet for payout for different events for a yearly golf tournament. It looks at the different events, par3, par5's, birdies....figures out where they placed in their flight, figures out how much they get based on how many in their flight got in and then figures their total winnings. When they get in they each gave $40 in different denominations and there was a bonus pot also provided with different denominations. Because there are so many I created a separate tab that figures out who gets what based on their winnings and denominations. Everything works great. However based on how I am doing this the guy up at the top get the big bills and they guy at the end get a lot of ones. I would like spread the small bills out among all the players to keep the envelopes thin. So I would like to add a percentage of bills that each play may get or something to spread the love. If anyone has a few ideas that would be great. the formula I am using is
=MIN(INT(ROUND(($C5 - SUMPRODUCT($D$2:G$2, $D5:G5)), 2) / H$2), H$3 - SUM(H$4:H4)) here is a table that I am using. again everything works out but as you can see the guys at the bottom get a lot of ones. I would like to attach the spreadsheet but could not figure it out. If you can help and you want a copy let me know. I also have a Calcutta sheet that I put together.

[TABLE="width: 793"]
<tbody>[TR]
[TD][/TD]
[TD]DENOM[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]$100[/TD]
[TD="align: right"]$50[/TD]
[TD="align: right"]$20[/TD]
[TD="align: right"]$10[/TD]
[TD="align: right"]$5[/TD]
[TD="align: right"]$1[/TD]
[TD]TOTAL[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]total$[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]380[/TD]
[TD="align: right"]$2,310[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]- [/TD]
[/TR]
[TR]
[TD]John Krusick[/TD]
[TD="align: right"]$188.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$188[/TD]
[/TR]
[TR]
[TD]Bill Poillion[/TD]
[TD="align: right"]$165.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$165[/TD]
[/TR]
[TR]
[TD]Richard Barela[/TD]
[TD="align: right"]$133.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$133[/TD]
[/TR]
[TR]
[TD]Sam Jones[/TD]
[TD="align: right"]$123.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$123[/TD]
[/TR]
[TR]
[TD]John Sanzari[/TD]
[TD="align: right"]$121.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$121[/TD]
[/TR]
[TR]
[TD]Jerry Alderete[/TD]
[TD="align: right"]$114.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$114[/TD]
[/TR]
[TR]
[TD]Ken Samuelson[/TD]
[TD="align: right"]$111.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$111[/TD]
[/TR]
[TR]
[TD]Darin Jeszke[/TD]
[TD="align: right"]$108.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$108[/TD]
[/TR]
[TR]
[TD]Spencer Feix[/TD]
[TD="align: right"]$100.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$100[/TD]
[/TR]
[TR]
[TD]Jack Fenton[/TD]
[TD="align: right"]$94.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$94[/TD]
[/TR]
[TR]
[TD]Bryan Thompson[/TD]
[TD="align: right"]$84.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$84[/TD]
[/TR]
[TR]
[TD]Phil McKenzie[/TD]
[TD="align: right"]$84.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$84[/TD]
[/TR]
[TR]
[TD]Warren VonWorley[/TD]
[TD="align: right"]$83.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$83[/TD]
[/TR]
[TR]
[TD]Skip Haines[/TD]
[TD="align: right"]$78.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$78[/TD]
[/TR]
[TR]
[TD]Mark Vitale[/TD]
[TD="align: right"]$61.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$61[/TD]
[/TR]
[TR]
[TD]Walt Gorsey[/TD]
[TD="align: right"]$61.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$61[/TD]
[/TR]
[TR]
[TD]Jim Quick[/TD]
[TD="align: right"]$60.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$60[/TD]
[/TR]
[TR]
[TD]Pete McKenzie[/TD]
[TD="align: right"]$60.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$60[/TD]
[/TR]
[TR]
[TD]Scott Sachs[/TD]
[TD="align: right"]$60.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$60[/TD]
[/TR]
[TR]
[TD]Lowrey Pendley[/TD]
[TD="align: right"]$55.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$55[/TD]
[/TR]
[TR]
[TD]Jeff Malanify[/TD]
[TD="align: right"]$54.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]$54[/TD]
[/TR]
[TR]
[TD]Lonny Rakes[/TD]
[TD="align: right"]$42.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]$42[/TD]
[/TR]
[TR]
[TD]Tom Thomas[/TD]
[TD="align: right"]$41.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]$41[/TD]
[/TR]
[TR]
[TD]John Stehney[/TD]
[TD="align: right"]$39.00[/TD]
[TD="align: right"]- [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]$39[/TD]
[/TR]
</tbody><colgroup><col><col span="8"><col></colgroup>[/TABLE]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
Did not see a lot of movement so figured out a work around until someone opens this and looks at how this was designed.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Display fraction denominator even if zero
Replies
5
Views
178
Scott Huish
Scott Huish
B
  • Question Question
Chart help - rainfall data
Replies
2
Views
242
JV0710
J
T
  • Solved
Scaling a Data Set
Replies
6
Views
278
felixstraube
F
R
  • Solved
Ignore blanks for a SUM
Replies
2
Views
112
Rex987456
R
rjplante
  • Solved
Loop Count Math issue
Replies
6
Views
324
Akuini
Akuini

Forum statistics

Threads
1,223,582
Messages
6,173,188
Members
452,503
Latest member
AM74

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top