Portsmouth weight modifiers

Matthew_Vicker · 5 April 2006 16:09

What is the best way to add in the Portsmouth weight modifiers to the
race calculations? We frequently have people who will have crew one
race and then none the next race. So it is hard to keep track of all
the numbers in the program.

What I have is a spreadsheet it all the numbers and I was planning on
pasting in the value for the correct wind range. The number would be
multiplied by the "MULTIHULL MODIFICATION PENALTIES AND ALLOWANCES FOR
HEADSAIL, WEIGHT and WIDTH ADJUSTMENTS."

It is dirty, but works. Let me know if there is an easier way.

Thank you,

Matt

sailsandskis · 9 April 2006 17:22

Matt,
Our club has the same problem with regards to using the portsmouth
weight modifiers. I asked a similar question a few months ago but
received no response.
Currently I am basicly doing the same thing you are, but I would
like to see the "Race Rating" field become a formula based entry so
you could enter something like "default*1.02" to make a minor
adjustment to a default rating in a given race. This would save the
need for a calculator or spreadsheet and reduce the posibility of a
foolish keystroke error. It would also allow you to change your
ratings file and rescore a season using the same modifiers but new
ratings.
Hopefully Colin will respond with his thoughts on the feasibility of
implementing this.
-Matt

What is the best way to add in the Portsmouth weight modifiers to

the

race calculations? We frequently have people who will have crew

one

race and then none the next race. So it is hard to keep track of

all

the numbers in the program.

What I have is a spreadsheet it all the numbers and I was planning

on

pasting in the value for the correct wind range. The number would

be

multiplied by the "MULTIHULL MODIFICATION PENALTIES AND ALLOWANCES

FOR

···

--- In sailwave@yahoogroups.com, "Matthew Vicker" <m59v@...> wrote:

HEADSAIL, WEIGHT and WIDTH ADJUSTMENTS."

It is dirty, but works. Let me know if there is an easier way.

Thank you,

Matt

MSchneider · 17 May 2006 04:06

Hello,

Its ugly but.. here goes.

What I do is import the US Sailing tables into excell in seperate
worksheets.

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.

Good luck.

Take Care
Mark