+ Reply to Thread
Results 1 to 5 of 5

Spreadsheet for my golf League

  1. #1
    Registered User
    Join Date
    03-22-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Spreadsheet for my golf League

    I am currently running a golf league on excel and I am trying to autoimate it as much as possible and I have two parts I am struggling with.

    1. To find the lowest 4 scores in a row. The rows have a score in row 20a , 20c 20e , 20g and so on and I want to find the 4 lowest scores in these cells automatically.

    2. The second thing I am trying to do is work out the net score minus stroke index for each player with their different handicap as per below

    Gross Nett Gross Nett
    9 8 -1
    7 6 -1
    3 3 0
    4 3 -1
    5 4 -1
    5 5 0
    4 3 -1
    12 11 -1
    8 7 -1
    4 3 -1
    4 3 -1
    12 12 0
    3 2 -1
    5 4 -1
    8 8 -1
    4 3 -1
    2 1 -1
    5 4 -1
    104 90 0 -15
    14 15
    90 0.1 -15
    14.5

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Spreadsheet for my golf League

    I'm not sure what you mean by in a row? can you post a sample work book.

    You will use some form of =min() to get the lowest scores.

    How do you calculate the stroke index for each player?
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P

  3. #3
    Registered User
    Join Date
    03-22-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Spreadsheet for my golf League

    This is a sample that I need to find the lowest 4 or 6 scores from but it can carry on for around 30 rounds.

    Nett 66 71 64 75 70 76 68 75

  4. #4
    Registered User
    Join Date
    03-22-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Spreadsheet for my golf League

    The stroke index works if a player has a handicp of say 14 he gets a shot off his net score on holes 1 - 14 but not on 15, 16, 17 or 18.

    The stroke index is as follows

    Hole Stroke Index
    1 = 10
    2 = 6
    3 = 18
    4 = 2
    5 = 14
    6 = 16
    7 = 8
    8 = 4
    9 = 12
    10 = 11
    11 = 5
    12 = 17
    13 = 7
    14 = 1
    15 = 15
    16 = 3
    17 = 13
    18 = 9

  5. #5
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Spreadsheet for my golf League

    So you would use =LARGE(A1:H1,1) then just increase 1 to 2 then 3 etc..

+ 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