Facebook

Login

Support Sailonline

If you haven't already - join the SAILONLINE YACHT CLUB!

Please also consider making a donation - all amounts are greatly appreciated!

Board » Technical Support » Excel for Graduate Dummies

Here's my Excel workbook at https://mega.nz/fm/J5RXgaTQ
for navigating the OD65 from the pre-AGL days. Mega is a free 50MB Cloud store from NZ. I'm just trying it out. Could be I need to share it with others case by case, but perhaps you can just pretend to be me - jan.vanderpuil@gmail.com with pw sa1lonl1ne.
I still use this workbook and its many sisters if I'm sailing Qt-informed but 'by hand'. DON'T UPDATE LINKS, but do allow macro's.
The tab PerfLoss works out PL solutions for you.
The tabs vgprecis and vhprecis give you a read-out of your upwind, downwind and hopping angles. Click the button in cell B1 to toggle from up- to downwind and edit the TWA in cell B1 to pick up different hopping ranges. If you reduce your browser window by bringing in the left margin, you can check your angles as you race.
The tab PerfLoss works out PL solutions for you. How you use that, and the other sheets (WhichEndAgain is quite good)I leave you to figure out yourself.
Nothing is protected, so if you are going to use it, be sure to keep an original copy (which of course you can always go fetch at Mega).
Clipping along
https://mega.nz/C!kpg0UC4b I believe is 'the public content link'
Clipping along
this link works even better mega.nz/file/...



_______
Shortened URL for formatting


--- Last Edited by kroppyer-admin at 2021-01-29 10:10:59 ---

Please login to post a reply.

Races

Next Race: 00d 00h 00m


Current Races:

Shetland Winter Race 2022
A-OI!!! The cry should soon be ringing out in the streets of Lerwick as the Guizer Jarl and his crew, along with the other teams in the Up Helly Aa parade complete their preparations for the biggest fire festival in Europe. While Shetland continues to manage #COVID19 well, Up Helly Aa has been cancelled but this won't stop SOLers racing their Elan 410s this 383nm course from Aberdeen to be sociable in Lerwick Harbour. SAILING NOTE: Gruney may be approached from any direction but must be passed for rounding purposes as indicated on the chart.
Race #1554
INFO by brainaid.de
Elan 410 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Jan 23rd 11:00 Registration Open!

▶ Flash
GO TO RACE

Tuvalu Sprint 2022


We will start our sprint competition this year with a new 35.4 nm race around the Te Namo Lagoon islands of Tuvalu in the central Pacific. We will sail our Fareast 28 boats between the tiny islands of this archipelago. Prepare your boats and crews, and watch out for sandbars and bommies.
Race #1548
INFO by brainaid.de
Fareast 28R PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
SPRQ4 - SPRCH - SUPSOL - SYC
RACE CLOSE: Friday,
January 21 at 2300 UTC.
Race starts: Jan 16th 18:00 Registration Closed
▶ Flash
GO TO RACE

Sail Newport Timed Race 2022


Welcome to Rhode Island in our first TIMEDrace this year. In 2020 we raced on Maxi Trimarans, now we will see how fast we can cover the 87nm route around Block Island, Fishers Island and back to the clubhouse on MC 38 monohulls. The previous record of 4 hours 5 minutes and 21 seconds belongs to Kipper1258. Try to judge your weather window well, but once you've finished (you must have finished), you can always try again (as often as you like) by clicking the link below.
RE-REGISTER HERE to race again after finishing a run.
Race #1549
INFO by brainaid.de
MC 38 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
RANKING: TRQ1-TRCH-SUPSOL-SYC
REGISTRATION CLOSE: Sunday, 23 January at 2200utc
RACE CLOSE: Sunday, 23 January at 2300utc
Race starts: Jan 10th 12:00 Registration Open!
▶ Flash
GO TO RACE

Yellow Sea Race 2022
There are six seas along the eastern seaboard of mainland Asia. Six seas less travelled by the racing sailor. So, here we go. Six races up and down the Asian coast, plus one in the nearest sea to the Asian mainland of the Indonesian Archipelago, to make it a mythical seven; five to count. And in no particular order, we start with a 2200nm or so race criss-cross through the Yellow Sea in ever-elegant Italia 14.98's.
Race #1538
INFOby brainaid.de
Italia 14.98 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SSA
RACE CLOSE: Friday,
January 21 at 2300 UTC.
Race starts: Jan 04th 04:00 Registration Closed

▶ Flash
GO TO RACE

Cape Town to Rio 2022

Welcome to South Africa and RCYC's classic transatlantic Cape2Rio Race from Cape Town, South Africa, to Rio de Janeiro, Brazil. First run in 1971, the next race in reality will be in January 2023, but in the meantime you can test yourself on-course in this, our second virtually-only Cape2Rio Race, which we will once again be sailing in Mark Mills' 74ft speedster, the stunning C2R74.
PRIZE: SMPF
Race #1537
INFO by brainaid.de
C2R74 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ1 - OCCH - SUPSOL - SYC
RACE CLOSE: Tuesday,
January 25 at 2300 UTC.
Race starts: Jan 02nd 14:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member WRmirekd
  2. Sailonline Yacht Club Member FreyjaUSA
  3. Sailonline Yacht Club Member Sax747
  4. Sailonline Yacht Club Member Kipper1258
  5. Sailonline Yacht Club Member rafa
  6. Sailonline Yacht Club Member bonknhoot
  7. Sailonline Yacht Club Member Pit8008
  8. Sailonline Yacht Club Member Vida_Maldita
  9. Sailonline Yacht Club Member Dingo
  10. Sailonline Yacht Club Member TarassBoulba

View full list

Series

Mobile Client

SYC members have the benefit of access to our mobile/lightweight web client!

The mobile client