Tab 5. National Worksheet - Instructions
You can now enter details of ratings from all National PHRF organizations and gain insight into the ratings.
- 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.
- includes an assessment of reliability of the PHRF Region rating and calculates deltas for comparable yachts.
- 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.
** Having trouble with "Buttons" not working. Check our article: Enable Macros using Excel
A MUST READ: Article by Jamie Dike about How to use US Sailing numbers
This tab allows you to compare handicaps from all other PHRF regions.
US Sailing Documents
US Sailing publishes a list of submitted PHRF ratings and this report is available by selecting "Reports" from the Handicappers menu or by clicking the image below.
There are 3 reports, the center report has all the national ratings for Monohull classes.
The report is printed in a PDF format and will require Adobe to open it.
Once opened, you will need to locate the subject class and you will be presented with a list of PHRF Regions and other important information.
Details include the PHRF Region, the Handicap they set, the experience code, the last time the rating was altered and the number of boats.
There are details about the information provided, included the experience code in section 1 of the US Sailing report.
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.
Choosing the Class(es) you want to use.
The first thing that you need to do is tell the worksheet if this is a "New" or existing PHRF-LO class on line 4 (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.
You can then choose up to 3 comparable classes.
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.
Once you have chosen your classes, you will need to choose which PHRF Regions you would like to use for comparisons purposes and related data.
A drop down list of all PHRF Regions is available. You will need to refer to the US Sailing National Handicaps book for the reported handicaps.
Using the numbers - There is an article available that will help you to make appropriate choices when looking at PHRF Regions and their ratings.
Please take a look at Jamie Dikes: US Sailing Numbers - A guide to using
** - Regions marked with double asterix (**) are preferred regions as their experience and handicap models are more reliable.
It is recommended to choose regions where they list the most boats with the higher level of experience.
You will now need to enter all related handicaps and number of boats for each of the classes and regions you have chosen.
It is best to choose regions that have at least 1 boat as the worksheet uses a "weighted" average of the entries and regions without any boats will not be included.
Once you have entered the National Data, you will see a summary indicating the "Implied Handicap" of the class being reviewed.
The implied handicap is based on the PHRF-LO handicap of the compared class less the US weighted average delta.
NOTE: Due to the fact that all Regions are independent and the ratings set are indicative of sailing conditions on that particular body of water, this worksheet uses the Handicap Deltas (differences) when calculating the "Implied Handicap"