+ Reply to Thread
Results 1 to 8 of 8

Golf Scoring Formula assistance required

  1. #1
    Registered User
    Join Date
    02-27-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    10

    Golf Scoring Formula assistance required

    Hi everyone,

    I'd appreciate some help putting together a formula for my golf club scoring sheet. I've used this forum before and the help was magnificent. I'll first outline how the scoring works, and then explain the spreadsheet.

    The format is called "Stableford", and rather than putting down the amount of strokes you hit on a hole, each hole is allocated points, based on it's difficulty, and the ability of the golfer.

    Golf handicaps range from 0-36. Depending on the difficulty of a hole (the index), and ability of the golfer, they are allocated "shots" on each hole. The index ranges from 1 as the most difficult hole, through to 18 as the least difficult. For example, if i had a handicap of 9, I would be allocated a "shot" for each of the 9 hardest holes, and no "shots" for the 9 easiest (nb: The Par column has no bearing. I just added it to be consistent with my spreadsheet)

    HOLE - PAR - INDEX - SHOTS
    1 - 4 - 13 - 0
    2 - 4 - 7 - 1
    3 - 4 - 5 - 1
    4 - 5 - 10 - 0

    If my handicap was 18, i would get a shot on every hole. If my handicap was 27, I would get a shot on all 18, and then an extra shot on the 9 hardest

    HOLE - PAR - INDEX - SHOTS
    1 4 13 1
    2 4 7 2
    3 4 5 2
    4 5 10 1

    What i am looking to do with the spreadsheet in Column E is calculate the shots for ALLEN, based on the Index of the hole (column D), and the handicap (cell M1). That is a handicap 18 or less. For Allen, he gets a shot on the 9 hardest holes. I think i have that, as i put =IF(D5<=M1,1,0) and it appeared to work. However...

    I also need to calculate those that have a handicap 19-36, so, in Column E, calculate the shots for BELL (column E), based on the Index of the hole (column D), and the handicap (cell M20). For Bell, he gets one shot for each hole, and get two shots for the 9 hardest holes.

    Hopefully that makes sense


    Cheers
    Damian

    NB: I have also posted this in another forum, in the event no one is able to assist. As per the rules, here is the link mrexcel.com/board/threads/golf-scoring-formula-possibly-if-statement.1150326
    Attached Files Attached Files
    Last edited by thebushwoodgolfclub; 11-05-2020 at 04:52 PM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,028

    Re: Golf Scoring Formula assistance required

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  3. #3
    Registered User
    Join Date
    02-27-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    10

    Re: Golf Scoring Formula assistance required

    Quote Originally Posted by Pepe Le Mokko View Post
    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Thanks for the heads up. I have amended the original post and added a link. I was unable to add a "clickable" link, so added it as best I can.

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,263

    Re: Golf Scoring Formula assistance required

    Try this in E5 and copy down and copy to O5 and copy down.
    =INT($M$1/18)+IF(MOD($M$1,18)>=D5,1,0)

    For E24, change the $M$1 to $M$20

  5. #5
    Registered User
    Join Date
    02-27-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    10

    Re: Golf Scoring Formula assistance required

    Quote Originally Posted by Gregb11 View Post
    Try this in E5 and copy down and copy to O5 and copy down.
    =INT($M$1/18)+IF(MOD($M$1,18)>=D5,1,0)

    For E24, change the $M$1 to $M$20
    Thank you very much for your assistance. Appreciate you getting back to me. I'll give it a shot.

  6. #6
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2019
    Posts
    646

    Re: Golf Scoring Formula assistance required

    This is a copy of our golf workbook. You are welcome to adapt it for your use.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    293

    Re: Golf Scoring Formula assistance required

    The attachment shows the Stableford-calculations in your format.
    It uses 2 helper columns for calculating the Players PAR per hole.
    Attached Files Attached Files
    Kind regards,
    Piet Bom

  8. #8
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2019
    Posts
    646

    Re: Golf Scoring Formula assistance required

    Quote Originally Posted by PietBom View Post
    The attachment shows the Stableford-calculations in your format.
    It uses 2 helper columns for calculating the Players PAR per hole.
    Many thanks for that, I've improved my own workbook (got rid of unneeded columns) with your formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Golf Scoring System_Automatically Highlighting Cells
    By Golf_Tragic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2020, 01:25 PM
  2. [SOLVED] Golf Handicap / Scoring System
    By Golf_Tragic in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 08-13-2020, 08:02 AM
  3. Golf scoring formula request
    By flyerpicker in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 06-10-2017, 04:22 PM
  4. Golf Society Leaderboard and Scoring System
    By CMAGEE94 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-19-2016, 02:23 AM
  5. Excel 2007 : Disc golf scoring and ranking
    By trichard311 in forum Excel General
    Replies: 0
    Last Post: 02-07-2012, 05:43 PM
  6. golf tournament scoring question
    By pwedge in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 05:29 AM
  7. Golf Scoring with a Challenge - UDF
    By Kieranz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2006, 01:05 AM

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