Course handicap calculation, round down?

[timd77]

Hi,

I’m just sorting out handicaps for the courses we’re playing in Portugal in a few weeks. First time I’m doing this, usually just use the eg app! Got a spreadsheet on the go and everything!

Question really is about whether to round up or down, finding conflicting info. The one player for example, is coming out with a course handicap of 15.6. Hole19 says 15 shots, an online calculator says 15, another comes out at 16! And when I google whether to round up or down, it says round up if .5 or above, round down if below.

We’re just using 100% by the way.

Can someone confirm which it is please?

 

[KenL]

A golf hcp is just a number, and numbers should be rounded correctly. So, for me, 15.6 is rounded to 16.

Edit. You might want to post index, slope and course rating off whatever tees you are using.

 

[Orikoru]

All I will say is don't trust Hole19 for playing handicaps etc. I use it but it's been well out of date with some of the shots it suggests. On one course it said I would get 16 shots, when in actual fact their course ratings had changed and I only got 8!

 

[nickjdavis]

Hi,

I’m just sorting out handicaps for the courses we’re playing in Portugal in a few weeks. First time I’m doing this, usually just use the eg app! Got a spreadsheet on the go and everything!

Question really is about whether to round up or down, finding conflicting info. The one player for example, is coming out with a course handicap of 15.6. Hole19 says 15 shots, an online calculator says 15, another comes out at 16! And when I google whether to round up or down, it says round up if .5 or above, round down if below.

We’re just using 100% by the way.

Can someone confirm which it is please?

Use normal mathematical rounding.

 

[woofers]

Or just wait until you get there and read the handicap chart at the club.

 

[wjemather]

Hi,

I’m just sorting out handicaps for the courses we’re playing in Portugal in a few weeks. First time I’m doing this, usually just use the eg app! Got a spreadsheet on the go and everything!

Question really is about whether to round up or down, finding conflicting info. The one player for example, is coming out with a course handicap of 15.6. Hole19 says 15 shots, an online calculator says 15, another comes out at 16! And when I google whether to round up or down, it says round up if .5 or above, round down if below.

We’re just using 100% by the way.

Can someone confirm which it is please?

Cálculo de Handicap de Campo - FPG - Institucional

CÁLCULO DE HANDICAP DE CAMPO

portal.fpg.pt

 

[timd77]

Thanks all. Turns out it was my error inputting the formula into excel!

 

[NearHull]

Thanks all. Turns out it was my error inputting the formula into excel!

I believe excel will round down where golf needs to round up. In excel 15.500000 will round down to 15. In ‘machine calculated’ handicaps 15.50000 wil come out as 16.

 

[timd77]

I believe excel will round down where golf needs to round up. In excel 15.500000 will round down to 15. In ‘machine calculated’ handicaps 15.50000 wil come out as 16.

When I say excel, it’s Google sheets, just checked and it follows standard maths rounding so we’re all good, but thanks for mentioning that, wouldn’t have known.

Ps - never doing this again, I’ll just stick to paying my money and turning up when told!

 

[KenL]

I believe excel will round down where golf needs to round up. In excel 15.500000 will round down to 15. In ‘machine calculated’ handicaps 15.50000 wil come out as 16.

Well, that’s just wrong. How the number is “rounded” should be an option in Excel.
15.5 becoming 15 is a truncation rather than rounding.

 

[NearHull]

Well, that’s just wrong. How the number is “rounded” should be an option in Excel.
15.5 becoming 15 is a truncation rather than rounding.

I think it might be an option , but excel is not in my portfolio of ‘ excel’ lant skills . See what I did there, sophisticated comedy.

 

[rulefan]

I think it might be an option , but excel is not in my portfolio of ‘ excel’ lant skills . See what I did there, sophisticated comedy.

Rounding in Excel can be done using several functions, with the most common being ROUND, ROUNDUP, and ROUNDDOWN. The ROUND function allows you to round a number to a specified number of digits, while ROUNDUP always rounds up and ROUNDDOWN always rounds down.