OK I put one such spreadsheet in https://drive.google.com/open?id=0B-NqAxQ6JxFTbG9JcGs1MFpWOTQ, called Corrections.xlsx. It shows time corrections in seconds using PHRF TOT for a number of different boats in my club, given elapsed time in a race. For example in a one-hour JAM race I have to beat the Catalina 27s by two minutes, and the Catalina 25 by 3.5 minutes, or they'll correct over me.
You could edit the spreadsheet to contain data for the boats in your race (given their PHRF ratings), and use the data to figure out start times. Column D contains the Time Correction Factor for each boat, given its PHRF rating and the PHRF TOT formula TCF=A/(B+PHRF). You can plug in whatever values your club uses into cells B2 and B3. I've asked my club's scorer for his pursuit race start time spreadsheet, and will put it on my Google drive when I get it, and notify you. Cheers, Randy ----- Original Message ----- From: "Kevin Driscoll" <kevindrisc...@gmail.com> To: "RANDY" <randy.staff...@comcast.net>, "cnc-list" <cnc-list@cnc-list.com> Sent: Monday, October 10, 2016 9:13:09 PM Subject: Re: Stus-List Race Committee for Pursuit Race Thanks everybody. Randy, if it were not too much trouble it would be great to see your spreadsheet. Dennis sent one that I could definitely use too. I have this great IRC version, but it doesn't apply for PHRF. Regatta Rasta man is pay to play so I am going to pass on that. We'll be doing time on distance with the course set up ahead of thin time. Keep sharing your experience of you have more to add. Thanks again everyone! On Mon, Oct 10, 2016, 6:39 PM RANDY < randy.staff...@comcast.net > wrote: Yeah we just had one yesterday. Start times per PHRF rating were calculated using TOT (A=715, B=515) assuming a two-hour race. We just race laps around three pre-designated marks in our lake. 90 minutes into the race, the next mark ahead for the lead boat becomes the last mark everybody has to round. We don't use an RC boat for this; starting at the right time is an honor system (and the finish order is obvious; no correction needed). We use a pair of no-wake-zone buoys as the start line, and the marina channel markers as the finish line. You can see our SIs here, including a table of start times per PHRF rating (assuming a 2:00 p.m. start for the first (slowest) boat racing) - https://csyc.org/wp-content/uploads/2016/09/CSYC-2016-PursuitRace.pdf . I don't have the spreadsheet that was used to figure these start times, but I could probably get it if you want it. Cheers, Randy Stafford S/V Grenadine C&C 30-1 #7 Ken Caryl, CO From: "Kevin Driscoll via CnC-List" < cnc-list@cnc-list.com > To: "C&C List" < cnc-list@cnc-list.com > Cc: "Kevin Driscoll" < kevindrisc...@gmail.com > Sent: Monday, October 10, 2016 5:16:20 PM Subject: Stus-List Race Committee for Pursuit Race Has anyone been organized and been Race Committee for a 'Pursuit Race' before? I am curious how you went about it. Obviously there is some calculation of start times in relation to each boat's rating. These are our contestants . I figure there will be three starts. 1 for the 'Level' racers, 1 for 'No Score' racers, and another for PHRF, i.e. the Pursuit racers. This is the first race in our winter series, which runs till March. We thought we might kick it off with a fun race format. Thanks for your input! Kevin 30-2 _______________________________________________ This list is supported by the generous donations of our members. If you like what we do, please help us pay for our costs by donating. All Contributions are greatly appreciated!
_______________________________________________ This list is supported by the generous donations of our members. If you like what we do, please help us pay for our costs by donating. All Contributions are greatly appreciated!
