Calculated Ratings Tab

Tab 4. Calculated Ratings - Instructions

 You can now review the "calculated ratings" like the CKSP, SKSP and other handicap conversions all in one sheet.

 

Highlights include:

 

  • Drop down list for "Class Name" allows for either using the NEW class that is entered in the SP Estimators sheet or from the list of classes that PHRF-LO has already handicapped.
  • Now includes additional "Calculated Ratings"
    SRSP - Schell regression SP
    JT-NFSP - a Non-Flying sails estimator created by Jim Teeters of US Sailing on behalf of PHRF-LO.
  • Can be used for evaluating a class handicap when addressing Appeals etc.
  • allows YOU to choose up to 3 comparable yachts and gives details of differences from "selected standard class" data.

 

 

This tab allows you to compare "calculated ratings" from other sources.

 

The sources for calculating the "SP - Speed Potential" of the standard class are:

 CKSP - Charlie Kramer SP

 SKSP - Steve Killing SP

 SRSP - Schell Regression SP

 

Portsmouth Yardstick

The sources for calculating the "ASP - Adjusted Speed Potential" of an individual boat are:

 IRC

 IMS (using the GP 10)

 MORC

 

 

Tab 4. Calculated Ratings - Instructions

 You can now review the "calculated ratings" like the CKSP, SKSP and other handicap conversions all in one sheet.

 

Highlights include:

 

  • Drop down list for "Class Name" allows for either using the NEW class that is entered in the SP Estimators sheet or from the list of classes that PHRF-LO has already handicapped.
  • Now includes additional "Calculated Ratings"
    SRSP - Schell regression SP
    JT-NFSP - a Non-Flying sails estimator created by Jim Teeters of US Sailing on behalf of PHRF-LO.
  • Can be used for evaluating a class handicap when addressing Appeals etc.
  • allows YOU to choose up to 3 comparable yachts and gives details of differences from "selected standard class" data.

 

 

This tab allows you to compare "calculated ratings" from other sources.

 

The sources for calculating the "SP - Speed Potential" of the standard class are:

 CKSP - Charlie Kramer SP

 SKSP - Steve Killing SP

 SRSP - Schell Regression SP

 

Portsmouth Yardstick

The sources for calculating the "ASP - Adjusted Speed Potential" of an individual boat are:

 IRC

 IMS (using the GP 10)

 MORC

 

 

The basics

 

Lets start with the basics!

 At the top of the screen you will see the following:

 

V.12 f is the Version number for the "whole" worksheet.

It is important to ensure that you use the most recent version of the worksheet which will include the most up-to-date formulas for calculations and adjustments.

 Rel "Date" is the date that the Standard Class List (SP List) was last updated.

It is also important to ensure that you use the most recent "Date" which will include an up-to-date list of all PHRF-LO classes.

Clear Sheet (Button on right)

 After completing a worksheet you have the option to remove all entered data. By clicking on the "Clear Sheet" button all entered values will be returned to their original state.

 


 Line numbers are used throughout the workbook to help direct you to the correct "place" on the worksheet.

 

 

To begin with, you need to know that throughout the "Handicappers Worksheet" you will find that all boxes (cells) that are Green are for entry purposes and all boxes (cells) that are Grey contain "lists" of items that you can choose from. Boxes that are Yellow will be filled in by the form.

 

 

Class Selection

 

Choosing the Class(es) you want to use.

 NOTE: If you have already completed the "Comparables Tab" and want to use the same classes, click here.

 The first thing that you need to do is tell the worksheet if this is a "New" or existing PHRF-LO class on line 3 (Is this a new class?)

 The worksheet is defaulted to "No", which means that the drop down list will consist of currently handicapped PHRF-LO classes.

 

 

 

If you choose "Yes", the worksheet will look to the "Initial Assignment" tab to populate the drop down list.

 

 

Link to instructions for the "Initial Assignment" tab.

 


 

Using the "Use Comparables" button.

 If you have already completed the "Comparables Tab" and selected classes, you can quickly transfer those classes to this worksheet.

 By clicking on the "Use Comparables" button, all the classes will be automatically transferred to this sheet.

 

 

Calculating Ratings - SP

 

Calculating Ratings

 Once you have chosen your classes, many of the calculated ratings will automatically fill.

 This sheet DOES NOT use the ratings that have been calculated, but rather uses the "Delta" to derive an "Implied Handicap".

 As you will see below, the worksheet calculated the ratings using the CKSP, SKSP & SRSP formula.

 The "Implied Handicap" is based on the FS-SP (Flying Sail Speed Potential) of the "Compared" boats plus/minus the "Delta" of the calculated SP(s).

 

NOTE: This sample is for example purposes only and may not accurately depict differences in the vessels being compared.

 

 

The Portsmouth Yardstick is still widely used and the ratings are available on-line via US Sailing.

 We have supplied a direct link in the worksheet to the US Sailing site which has links to the various classes.

 

 

 

 

Calculated Rating ASP

 

Calculated Rating ASP

 IRC, IMS and MORC are comparable only to the PHRF-LO FS-ASP.

 Adjustments (R) that are normally applied to a specific boat must be included in order to compare ratings.

 

 

If you know one (or more) of the individual boats IRC, IMS or MORC handicap then you will be able to use those values to compare the boats ASP.

 Remember, you need to enter a value of R (total adjustments by PHRF-LO) in order to do a fair comparison.

 

 

The Summary

 

 The Summary

 

Once all the data has been entered, you will see a Summary of what the "Implied Handicap" is for the class you are looking at.

 

NOTE: This sample is for example purposes only and may not accurately depict differences in the vessels being compared.