How can I over-ride the handicaps in a NHC workfile

Imported from Yahoo
1

How can I over-ride the handicaps in a NHC workfile ?

I have set up a NHC Club file to use for a club series. The problem is that we have been running the series using a different results system. I want to carry across the handicaps from the old system, use them in the new NHC Club Internal Mode file. This means I need to over-ride the automatic handicap calculation for the first four races. Then for all future races we will use the Sailwave NHC Club worksheet with all future handicap changes made by system automatically.

2

What you are trying to do is rather specialist - so the only way you could do that is using the Excel version and modify the template.

You don’t say if you are using NHC2013 or NHC2014 rules and whether you are using the internal or external calculation modes.

The RYA changed the calculations for NHC in 2014 and I’ve released a new Template which supports the new calculation rules. So by using the external mode and the Excel template you can do the new calculations with the earlier Sailwave.

I’ve nearly finished the updated version that handles the NHC2014 internally i.e. without using Excel. Hopefully will get a Beta of this out tonight.

Going back to your original question . Your would need to modify the template Column AA in the NHC2014 template such that it doesn’t change races 1-4

The formula in this column currently is

=IF(J9,IF(AND(Finishers>=MinFin,M9),Z9*$Z$51,L9),"")

Simply add the statement RaceNo > 4 to the cells in this column and it will leave the first 4 races untouched

=IF(J9,IF(AND(Finishers>=MinFin,M9,RaceNo > 4),Z9*$Z$51,L9),"")

If you would like to discuss it further give me a call on the number below

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 23 March 2014 09:50, bindaree817@yahoo.com wrote:

How can I over-ride the handicaps in a NHC workfile ?

I have set up a NHC Club file to use for a club series. The problem is that we have been running the series using a different results system. I want to carry across the handicaps from the old system, use them in the new NHC Club Internal Mode file. This means I need to over-ride the automatic handicap calculation for the first four races. Then for all future races we will use the Sailwave NHC Club worksheet with all future handicap changes made by system automatically.

3

Thanks Jon. Let me have a go at what you suggested and then come back to you if I am still stuck.