Its ugly but.. here goes.
What I do is import the US Sailing tables into excell in seperate
I have the excell spreadsheet set up to concatonate the ratings into
two fields for sailwave, the DPN and the Wind adjusted fields,
along with the boat type and the rating designation USPN or Texel.
I standardize on a naming convention for USPN and Texel so that i
can rescore in sailwave by selecting either scoring protocol.
I insert extra rows and write a formula to calculate 5 weight
adjusted numbers(DPN plus 4 wind adjusted numbers) and concatonate
the rating with the H1 ... or L3 rating as well as the crew weight
for the class type... EG Hobie 16 H1 305.
This gives you an excell worksheet with lots of entries for each
boat type. Some boats have lots of combinations. EG. the Nacra
6.0NA which will have 4 lines for the Sloop version (N6.0NA, N6.0NA
H1, etc etc) and then 4 more entries in the csv database with a
rating for the spin modification and weight adjustment.
(Then a club member had a larger main and jib put on the boat and
generated MORE ratings.)
This is not a problem since we use an online registration system. I
process this data and match the sailors self described boat type
with the exact match in the sailwave .csv databse.
I then check the box to always upload the ratings from the file and
make sure that every boat loads a rating.
I can send you my excell worksheet if you need it.
Every year, I simply paste in the published USPN rating for the
baseline boat and the spreasheet calcuates all of the other modifed
ratings. Its a bit quirky since I don't bother with classes which
don't race in my region so I don't send it to the sailwave archive.
If its a series... and you allow different configuration in your
series... then we just use the rating for a specific race toggle.
What is the best way to add in the Portsmouth weight modifiers to
race calculations? We frequently have people who will have crew
race and then none the next race. So it is hard to keep track of
the numbers in the program.
What I have is a spreadsheet it all the numbers and I was planning
pasting in the value for the correct wind range. The number would
multiplied by the "MULTIHULL MODIFICATION PENALTIES AND ALLOWANCES
--- In email@example.com, "Matthew Vicker" <m59v@...> wrote:
HEADSAIL, WEIGHT and WIDTH ADJUSTMENTS."
It is dirty, but works. Let me know if there is an easier way.