NHC Internal Vs External

I have been using NHC alongside RYA PY Handicap fleets for some time.

Just wanting to understand what is happening under the lid, and with the help of your YouTube video I have rescored our Spring Series results using the external NHC Excel file.

I was surprised to see that the resultant ratings are different using external Vs internal.

Is this expected?

E.g. my final rating with internal is 1046, but 1032 with the External calculations.

Just curious as to the cause of the difference.

Hi Mark

They should be identical if you would like to send me the file you are using I will see what results I get. Jon@Sailwave.com

Jon

Hi Jon,

Thanks for your pointers for this via email I have found the issue.

In cell Main!$S$51, there is a formula: =_xlfn.STDEV.P(S9:S49). For MS Excel 2007, this needs to be: =STDEVP(S9:S49).

I have updated the file in the templates folder: SWNHC3.xls with this change and the results now match.

Thanks for your help with this. I think the query can be closed.