Find solution
How to get an NRL tipping spread sheet?

I'm trying to get an excel spread sheet to get Golf handicaps using the lowest 5 of last 6 scores?

  • I need one for 5 lowest of last 6 sores with blanks and less, with 1 or more scores! I have manipulated the other formulas until I am blue in the face and cannot get it to work; I need help from someone much smarter than me! If anyone can help me, I would greatly appreciate it!

  • Answer:

    im not a golfer it would help if you provide a good sample need some cell references, and what you mean by blanks and less i am guessing your sheet looks something like this a1 89 a2 90 a3 blank a4 91 a5 92 a6 93 and you want the 5 lowest averaged? maybe you coluld sample the b column for other questions. what does the 1 or more mean? is that 1 score and 5 blanks? edit see if this works for you put it together in 1 cell =IF(COUNTBLANK(A1:A6)>0,AVE RAGE(A1:A6),(SUM(A1:A6)-MAX(A1:A6))/5)

rickrush... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You really can't do this very well. A HC is a function of the actual score on a course that has a slope rating. So that the same score on two different courses with different ratings will affect your HC differently. Addionally, HCs are a measure of a golfers capability, not of what they did... The final HC is not the 'weighted' average of the score, but rather a percentage (I think it is 96%) of that weighted average. If you hit your local USGA section site, there is a whole section on HCs and how they are computed.

staffingpro9999

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.