Playing golf Handicap software

[tinkuds09]

Cheers for all the aid thus far. So far as I am able to view the formula functions for you to common the cheapest 10 scores throughout numerous info dismissing absolutely nothing prices. Nevertheless, if the player won't have a minimum of 10 scores this formula can not work.
=AVERAGE(SMALL(IF(Y2:AQ2<>0,Y2:AQ2),ROW(INDIRECT("1:10"))))

[newdoverman]

This post appears to be an advertising "come-on".

[LJMetzger]

The following post may help you. When the number of scores is less than 0 and greater than or equal to 5, there are special rules for calculating the handicap, which complicates things a bit. A lookup table can be used to determines the number of lowest scores to use when there are less than 10 scores.

http://www.excelforum.com/excel-gene...p-program.html

Rounds Differentials Used
05-06----------- 1
07-08----------- 2
09-10 -----------3
11-12 -----------4
13-14----------- 5
15-16 -----------6
17---------------7
18---------------8
19---------------9
20--------------10

Lewis

[MarvinP]

Hi tinkuds and welcome to the forum,

You need to follow the rules and use less than 10 scores if a person doesn't have that many... Read
http://www.usga.org/handicapping/pub...x-Will-Travel/

or

http://www.usga.org/handicapping/art...Unhandicapped/

You are correct that the above formula will not work if a player has less than 10 scores. If you supply a sample workbook we might be able to find a better formula for you.

[MarvinP]

Hey,

I think the OP simply put a link on his formula instead of correct formatters.

Maybe a moderator can fix it?

[martindwilson]

=average(small(if(y2:aq2<>0,y2:aq2),row(indirect("1:"&min(10,count(y2:aq2))))))