Woots! Kudos to LucyInThe Sky Afarensis; yesterday she posted lap #300 to the Hotlaps spreadsheet! She hit that tercentennial ceiling in real style too, by adding a new boat class to the list: The ACA Racer Tiny.
On the six Hotlaps courses to date, a total of 54 skippers have sailed 305 laps in 33 different boats. Wowzers! Here’s the current list of skippers who did all that sailing, colored-coded for the spreadsheets:
And next, here’s a copy of the current, active spreadsheet for the Plum Gut course. Individual lap scores are arranged in columns based on boat class, and the colors for each entry identify the skipper. As highlited below, there’s a set of tabs at the very bottom of the sheet that allow a user to switch to different pages in order to view individual race line results, raw entry data, or summary sheets.
Sailors can even edit the various spreadsheet pages. If you make a mistake filling out the entry form, you can go to the Lap data page, find the error there and correct it. If any Hotlaps user wants to rearrange or sort the data for a particular page, please feel free to open a new tab on the spreadsheet to do that. You can then copy the data you’re interested in to your new page for editing, and leave the original intact.
Of course Plum Gut is just one of the six Hotlaps venues. There are five more.
This collected lap data has many potential uses. Individual sailors can follow their own laptimes to see if different sailing strategies make a measurable difference in their scores, or they can compare how their times match up against other sailors in the fleet.
The hotlaps data also makes it possible to “performance handicap” the many, popular boats in SLSailing. As I’ve discussed before, that’s done by comparing the average lap time for a given boat on a particular racecourse against the same information for a standard, “index” boat: The Melges-24. After nearly two months of data collection, the Melges is looking like a great index, for a dozen reasons I wont bore you about here. If you own a Quest Melges-24, you likely know the reasons already.
Anyway, here’s the handicap table as of yesterday. Below, the table to the left shows the handicap factors for boats on each of the six hotlaps courses (where the data is available). The table on the right shows the average handicap score for each of those boats, with the associated standard deviation for the small sample of values in each case.
So, how useful and reliable are the handicap factors?
Well, that’s what were still trying to figure out, but let me briefly talk about three points that came up in last Thursday’s Midnight Madness races.
Midnight Madness is a fun, multiclass race every Thursday at 9:00 pm, cosponsored by Danshire and Eden Bay Yacht Clubs. At the moment I’m using Madness results to calculate potential handicap ‘adjustments’ and comparing them to the uncorrected, “normal” finish times.
As usual, a small but really great group of skippers showed up this past Thursday to race the Hepurn Hotlaps course. Here’s the result for race one.
Race Two Results:
1: Chaos Mandelbrot M24 crew, 1.10 — 10:08 — Corrected 11:09
2: Kris Hollysharp M24, 1.0 – 10:39 – Corrected 10:39
3: Pensive Mission Tako 3.3 (1.03) – 10:49 – Corrected 11:08
4: Glorfindel Arrow M24, 1.0 — 13:24 – Corrected 13:24
5: SteveLL Resident IDJB25 — 00:14:45 – Corrected 11:14