+ Reply to Thread
Results 1 to 3 of 3

Help to calculate pay outs for golf outing.

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Detroit
    MS-Off Ver
    Excel 2003
    Posts
    20

    Help to calculate pay outs for golf outing.

    2013 Golf Trip (1).xls

    Hey guys. First off thank you to all the people on the forum who have helped me put this together. Right now my next hurdle is a way to calculate pay outs. Only problem is I have having a hard time figuring out how to handle multiple scores that are the same. Basically i need to set the program to evaluate the scores and assign a pay out value based on a set amount. But if scores are duplicate, say 3 people shot 36 on the front, i need it to take 1st through 3rd payouts, add them together, then divide it among the 3, then continue with 4th place and on. The second issue is trying to figure out how to handle if there are 10 people who all together only have 5 different scores among them. I would like to use the columns just to the right of the rankings to display the pay outs. for simplicity just use 50, 40, 30 ,20, and 10 for the payouts. I know this may be too much and if it can't be done simply then i wont worry about it and will do it by hand.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Help to calculate pay outs for golf outing.

    This is very easy, although you will need integer versions of the scores which have fractional additions for the sake of ordering non-unique entries.

    Insert a column at AL
    I called it 'real score'
    Formula: AL4=int(AM4)

    You need a list of the payout you want for the positions, I put it in AT (I arbitrarily started with 240 and AT5=AT4-9)

    I then put this into AU4:
    =AVERAGEIF($AL$4:$AL$27,AL4,$AT$4:$AT$27)

    Incidentally, it's completely arbitrary which of columns AL and AM you hide.

    Assuming you get the principle you can apply this method flexibly.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    02-15-2013
    Location
    Detroit
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Help to calculate pay outs for golf outing.

    I actually found something similar to what you said. Ill post an updated version expanded for people to see. I order tehm with my extra decimals but also make a rank order based on teh raw score. I then order the raw score ranks which will always match up with the decimal score rankings and this allowed me to apply the average formula to calculate payouts. Now i am working on a way to create a running winnings total.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1