Low Point Scoring BETA - Low point scoring has been added! Using the same simple interface you can now score races using US Sailing low point scoring. Specify "scoring method: low point" on the Google Sheet1 spreadsheet before the finishes are entered.
Race Number no longer required - this update applies to anyone using raceScore before August 2022 race number (e.g. the 1, 2, 3 etc. in Column B) can easily be deduced, so we decided to remove the requirement to enter it. Actually it's now invalid to include race number among the finishes on Sheet1. If you see race numbers being listed as competitors in the results then delete column B (containing race numbers) and re-run raceScore. raceScore will intuitively assume the first set of finish data for any date is the first race of the day and sequentially increase the race number for subsequent races entered on the same date (8/2/2022)
Boat numbers no longer have to be numeric - if your fleet uses text characters - e.g. country codes, boat names, skipper names for example, to identify a boat's finish in a race, then this improvement will be appreciated. In our local fleet, where members borrow different club boats, we use the skippers name instead of the boat number, for example. (7/14/2022)
Participation Credits - if your fleet wants to give competitors that serve on Race Committee, or maybe if they attend a travel event, credit for qualification purposes, use Participation Credits. Each credit increases a competitor's "races sailed" by 1. So, if a competitor has sailed in 10 races, for example, and receives 2 participation credits, it will appear that the competitor sailed in 12 races for qualification purposes and for throwout calculations. Since participation credits are identified using a scoring adjustment, you can provide as many or as few credits as desired. But, credits can only be awarded on a particular day if a race was run and scored on that day. (7/11/2022)
Jun-11 644 602 789 547 626
Overriding Default Parameters
When the raceScore Extension runs a "Results" sheet is added (or replaced) in your spreadsheet.
Overall finish position in the series is followed by scoring details including qualifying specifics, the scoring method used, how ties (if present) are resolved, throwout calculations, and individual race finish positions.
Tips and Help
Here's a link to some sample raceScore input that you can copy and paste into your own Google Sheet where you have installed raceScore. Paste the sample data into your spreadsheet's Sheet1 and click on the raceScore app (under the Extensions menu item). In the sample, the Google Sheet (sometimes called a Tab) named "Sheet1" contains the finish input data used to generate the Google Sheet named "Results". Other Google Sheets in the sample contain examples of the different scoring parameters which can be used to override default values.
Occasionally sailScore may return duplicate results or fail to return a Results sheet. With any unexpected behavior try:
Deleting the Results sheet (if it exists),
Refresh (click: "Reload this page") Sheet1 (which contains the finishes you want to score),
wait 10 seconds, or so, for the raceScore app to reappear under Extensions and,
try running again.
Override parameters have a very specific syntax. Here are examples of parameter declarations that can be copied and pasted into your Sheet1 page - just modify the text to the right of the colon to meet your needs. The only option for "scoring method:" is Cox-Sprague. If this parameter is not present (or commented out e.g. "###scoring method: Cox-Sprague") the default High Point scoring method is used.
If you are still having trouble or if you have any questions please send an email to: email@example.com
Terms of Service
raceScore is free to use. Although we strive for perfection, the use of raceScore is offered without any warranties implied or otherwise. Please report problems to firstname.lastname@example.org