help needed from handicap guru

[pHz]

hoping someone who knows about handicaps can clear this one up for me

this is my first outdoor season so i was starting from maximum handicap whatever that is (100 ? )

the official scores (ie - club target day rounds and competitions) i have shot are as follows -

Date Round Score Class Handicap
20-May-07 FITA 900 640 2nd Class 48
25-Mar-07 Albion 400 U/C 59
25-Feb-07 American 605 2nd Class 50
22-Apr-07 American 599 2nd Class 50
29-Apr-07 American 550 3rd Class 54
03-Jun-07 Bristol 2 1060 2nd Class 43
18-Feb-07 Warwick 286 3rd Class 52
28-May-07 Warwick 294 3rd Class 51
15-Apr-07 Western 527 3rd Class 54

(individual score handicaps calculated using the saints and sinners online handicap calculator)

i use the latest version of robbos records spreadsheet and with these scores and handicaps inputted it tells me my overall handicap is currently 49

our club records officer uses golden records and with the same data my overall handicap comes out of that at 53

anyone any ideas why the discrepancy ?

saints and sinners calculator ?
robbos spreadsheet ?
roxik software golden records ?
something else ?

if anyone has another method of calculating handicap it would be cool to compare if its not too onerous a task

slainte : rob

[GeoffT]

After your first three scores your handicap was the average of these :
48, 59, 50 i.e 53 (you always round up to the higher figure)

It then gets reduced every time you get 2 points below your handicap. by 1/2 of the difference

22 apr you got 50 now your h/cap is 52

3rd june you got 43 now your h/cap is 48 You haven't better that since, so I reckon your h/cap should be 48.


By the way, you didn't start with 100.....you don't get a h/cap until you have shot three rounds.

Anybody disagree?

[Old Bloke]

Your handicap is based (or should be based) on the last three submitted scores. Add them up and divide by three. By doing it on the last three submitted scores you might find that your handicap can go down as well as up. If done over more than three, then you can only say that your average handicap is...etc.

[GeoffT]

Originally Posted by Old Bloke

Your handicap is based (or should be based) on the last three submitted scores. Add them up and divide by three. By doing it on the last three submitted scores you might find that your handicap can go down as well as up. If done over more than three, then you can only say that your average handicap is...etc.

Have to disagree Old bloke. Can't go up .... unless my green book is out of date.... unless you fail to shoot a complete round during a year in which case you effectively start again or it goes up when you are reassesed at the end of the year when it is calculated from your best three scores during the year.

[pHz]

Originally Posted by Old Bloke

Your handicap is based (or should be based) on the last three submitted scores. Add them up and divide by three. By doing it on the last three submitted scores you might find that your handicap can go down as well as up. If done over more than three, then you can only say that your average handicap is...etc.

if thats right it would be 47.33333333etc (rounded down to 47 or up to 48 ? )

im no clearer TBH - although geoffTs intitial handicap calculation of 53 matches what golden records says

slainte : rob

[TWIW]

Originally Posted by GeoffT

After your first three scores your handicap was the average of these :
48, 59, 50 i.e 53 (you always round up to the higher figure)

It then gets reduced every time you get 2 points below your handicap. by 1/2 of the difference

22 apr you got 50 now your h/cap is 52

3rd june you got 43 now your h/cap is 48 You haven't better that since, so I reckon your h/cap should be 48.


By the way, you didn't start with 100.....you don't get a h/cap until you have shot three rounds.

Anybody disagree?

Spot on Geof

[GeoffT]

My mistake Phz I assumed that you had presented the scores in calendar order. You need to do the maths that I outlined with the scores in calendar order.

If I have it right it should be ;

52 \
50 54
59 /
54 no change
50 now 52
54 no change
48 now 50
51 no change
43 now 47

[pHz]

Originally Posted by GeoffT

My mistake Phz I assumed that you had presented the scores in calendar order. You need to do the maths that I outlined with the scores in calendar order.
If I have it right it should be ;
52 \
50 54
59 /
54 no change
50 now 52
54 no change
48 now 50
51 no change
43 now 47

ah - you edited before i hit 'quote' so i now dont need to ask if you agree with this -

18-Feb-07 Warwick 286 3rd Class 52
25-Feb-07 American 605 2nd Class 50
25-Mar-07 Albion 400 U/C 59

initial handicap - 54

15-Apr-07 Western 527 3rd Class 54
22-Apr-07 American 599 2nd Class 50

4 points below handicap so 2 off handicap - 52

29-Apr-07 American 550 3rd Class 54
20-May-07 FITA 900 640 2nd Class 48

4 points below handicap so 2 off handicap - 50

28-May-07 Warwick 294 3rd Class 51
03-Jun-07 Bristol 2 1060 2nd Class 43

7 points below handicap so 3 off handicap - 47

current handicap - 47

are we at a consensus ?

thanks everyone BTW

slainte rob

[Murray]

Geoff is generally correct but you don't need to do the handicaps in calendar order, just pick the highest 3 scores (lowest 3 handicaps) and do an average (rounded up) et voila, 47.

Easy peasy And we have an accord!

(well, I've got a Fabia, but that's another matter...)

For the techies, the calculation you need for excel is: =ROUNDUP(AVERAGE(hcap1, hcap2, hcap3),0)

And sorry OB, but your wrong. Handicap can only ever reduce until the annual reassessment, then the archer starts the season with the handicap calculated from the previous season's best 3 scores.

[WhitehartFB]

Initially I agreed with Murray but since becoming records officer I have had to change my view.

GeoffT refers to your Handicap Average which is a running total through out the year for all scores given in to the RO and this can go up or down.
Murray refers to your Handicap which is your best 3 handicap ratings and in my view the only one that really counts which in most cases can only go down or stay the same. pHz = 47

In my efforts to slim down the number of scores being handed in I suggested that archers only gave in scores that were equal or better than their current handicap (unless they did not know) but reading the big green book I am required to take in all scores given to me and work out the H/avg and the Handicap.