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:

Vasco da Gama Ocean Race 2022

Point Yacht Club welcomes Sailonline to the 2022 running of the classic Vasco da Gama Ocean Race. This race is the oldest established international sailing event in South Africa and traditionally starts in the bay of Maputo, the old Portuguese colonial capital of Mozambique and finishes in Durban. Last year, and now again this year, the race was/will be from Durban to East London - circa 250nm in native Cape 31 speed machines.
Race #1573
INFO by brainaid.de
Cape 31 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ2 - ARCH - SUPSOL - SYC
Race starts: May 22nd 08:00 Registration Open!

▶ Flash
GO TO RACE

Elba Rendezvous 2022
Another new race in the SOL calendar. This time a sprint along the route of the classic regatta triangle proposed by Renegade. The theatre of our struggle will be Golfo Di Follonica with its start and finish at Piombino. More buoys were set up in front of Porto Azzurro on Elba Island and next to Punta Ala. One lap of 38 NM will be done with the help of Beneteau Figaro. Carefully plan the direction to start 😊 and "Let the force be with you."
Race #1579
INFO by brainaid.de
Beneteau Figaro PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
SPRQ2 - SPRCH - SUPSOL - SYC
RACE CLOSE: Wednesday,
May 18 at 2300 UTC.
Race starts: May 14th 16:00 Registration Closed

▶ Flash
GO TO RACE

Seoul to Seoul TIMED 2022
In this TIMED race designed by NZL_Scotsman, you'll start at Incheon, sail around 34nm WNW through the Korean DMZ towards the island of Yongmae-do and leave it to port, before returning to Incheon. Luckily, there is no military presence to contend with in this SOL race, though there's still plenty of islands to watch out for and not BBQ on. And once back in Incheon, you can even RE-REGISTER HERE for another attempt. Fastest round trip wins!
Race #1585
INFO by brainaid.de
J130 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TRQ2 - TRCH - SUPSOL - SYC
RACE CLOSE: Sunday,
22 May at 2300 UTC
Race starts: May 09th 12:00 Registration Open!

▶ Flash
GO TO RACE

San Francisco to New York 2022
Cornelius Vanderbilt, who made his money - that his descendants enjoyed to spend sailing and racing yachts - by recognizing that getting from the East Coast to the West Coast of the USA was best done by rail, would have been more than a little amused to see SOL organizing yacht races over the very route by water he made redundant. It's about 13,000 nautical miles, which compares with less than 3000 statute miles by train! Six years ago, the best SOLers managed to complete the passage from San Francisco to New York in around 36 days, sailing our much-used veteran ocean greyhound, the Super Maxi 100. Time to try again, this time on the VO70. If you aim for a SOG of 18kn, it'll only take you a month.
PRIZE: SMPF
Race #1567
INFO by brainaid.de
VO70_v4 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ2 - OCCH - SUPSOL - SYC
Race starts: May 01st 19:00 Registration Closed

▶ Flash
GO TO RACE

Sea of Japan Race 2022
For our fourth Seven Seas of Asia race, we invite you to an exciting 1900nm race down Japan's Pacific seaboard, through the Suwo Sound and back north up the length of the Sea of Japan to a finish off Russia's seaport of Kholmsk on the south western coast of Sakhalin Island, in suitably sturdy Finngulf 43s. Don't miss it!
Race #1542
INFOby brainaid.de
Finngulf 43 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SSA
RACE CLOSE: Thursday,
May 19 at 2300 UTC.
Race starts: May 01st 02:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member WRmirekd
  2. Sailonline Yacht Club Member Vida_Maldita
  3. Sailonline Yacht Club Member Pit8008
  4. Sailonline Yacht Club Member rafa
  5. Sailonline Yacht Club Member GREATSKUA
  6. Sailonline Yacht Club Member Sax747
  7. Sailonline Yacht Club Member rumskib
  8. Sailonline Yacht Club Member FreyjaUSA
  9. Sailonline Yacht Club Member Kipper1258
  10. Sailonline Yacht Club Member Satori

View full list

Series

Mobile Client

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

The mobile client