Recent content by stocks4

  1. S

    9 hole general play handicap

    Haha - yes!! Being a lowly 11.2, I'd not tested my spreadsheet for the likes of a near-scratch golfer. Need another adjustment!
  2. S

    9 hole general play handicap

    Yeah, I make that 3.7 too. I don't suppose he had a PCC adjustment did he? (which I know would be odd, given you didn't). Another possibility is an ESR adjustment, has he had one SINCE this round?
  3. S

    9 hole general play handicap

    The above uses your actual 39, your derived 39, the 9H Course Rating and the Slope Rating. What I find unfathomable is why, despite WHS coming in, we actually use a different interpretation of it to arrive at a course handicap if we play in (say) England vs USA. The overall effect on Handicap...
  4. S

    9 hole general play handicap

    ((39+39) - (35.9*2)) * (113/128)
  5. S

    9 hole general play handicap

    Yes, agree - the CR-Par piece is necessary. This is necessary for all 18 hole rounds too!
  6. S

    9 hole general play handicap

    Glad it worked for you, it should work for all. Good call out earlier regarding PCC. I just have an extra column for this adjustment in my spreadsheet, and update this if a PCC appears on the app. I've also worked out how an ESR is handled, but perhaps save that for another day!
  7. S

    9 hole general play handicap

    Excel formula becomes: =SUM(ROUND(ROUND((3.3*(128/113))+(35.9*2)-(35*2),0)/2,0)+1,35) This results in a figure of 39, which is added to your gross (+39), giving a scaled up 18-hole total of 78 78 gives a score differential of 5.5
  8. S

    9 hole general play handicap

    Using my Excel formula above, I make that a score differential of 5.5
  9. S

    9 hole general play handicap

    Quick Q: did you use the Course Rating for 9 holes or 18 ? (should be for 9H)
  10. S

    9 hole general play handicap

    Hi again - what were the four variables (course rating, slope rating, 9H par & your index) and your 9-hole gross score?
  11. S

    9 hole general play handicap

    Hi Wabinez, is your 'little sheet' also in Microsoft Excel? If so, I had the same problem and came up with the following: =SUM(ROUND(ROUND((HandicapIndex*(SlopeRating/113))+(CourseRating*2)-(9HolePar*2),0)/2,0)+1,9HolePar) The calculated number should then be added to your (adjusted) gross...
  12. S

    9 hole general play handicap

    Hi all, just joined this as was searching on Google for some text received from EG, and (lo and behold) it was replicated here. Here is my email exchange: Me (Weds 6th): Hi there, I note that my WHS index has changed overnight since yesterday and is due to a 'recalculated' differential in...
Top