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

Posted by
bonknhoot


Users avatar

Posts
111
Registered at
2013-08-06 21:35:15
2020-12-21 11:57:58 - 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
Posted by
bonknhoot


Users avatar

Posts
111
Registered at
2013-08-06 21:35:15
2020-12-21 12:33:09 - Re: Excel for Graduate Dummies
https://mega.nz/C!kpg0UC4b I believe is 'the public content link'
Clipping along
Posted by
dikkehenk


Users avatar

Posts
66
Registered at
2012-02-24 15:03:37
2020-12-22 11:02:03 - Re: Excel for Graduate Dummies
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:

Roma Giraglia Regata 2026

Our eighth race of nine to celebrate all things Mediterranean - fickle winds, history and olive oil – is another buddy-up; this one with the Circolo Nautico Riva di Traiano . Founded in 1984, as the new Traiano yacht Harbour neared completion, the Circola since then has developed into one of the major yachting competition centres in Italy, and next to the 450nm Roma per Tutti (which SOL buddied earlier in the year), the Roma Giraglia Regata is its other headline offshore event. First raced in 2005, the 210nm course takes competitors from Traiano to a rock on the inside of the Ile de la Giraglia off the northern tip of Corsica and back to the Italian mainland for a finish in the bay of Santo Stefano. We’re racing this one in our Class 40!
Race #2058
INFO by brainaid.de
Class 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: MED - SUPBUD - SYC
Race starts: Oct 08th 16:00 Registration Open!

▶ Flash
GO TO RACE

Arctic Tern - Greenland to Antarctica 2025

Welcome to the fifth leg of our MIG series. Now it's time to race the Arctic Terns, on their migration from Greenland to Antarctica, 8300 NM. This is also part of our monthly Ocean Championship, and as such the first race of OCQ4 2026. This race will be sailed in our Maxi Trimaran. Race #2061
INFO by brainaid.de
Maxi Trimaran PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230 Ranking:
OCQ4 - OCCH - SYC - MIG
Race starts: Oct 05th 11:00 Registration Open!
▶ Flash
GO TO RACE

Bornholm PYOC


Welcome to the Baltic Sea, where we are about to hold another sprint race. The course runs from the north to the south of the beautiful Bornholm island. There are only two waypoints, the start and the finish so the choice of which side of the island to sail along is up to you. Our Albin 79s will cover a distance of approximately 23 nautical miles.
Race #2064
INFO by brainaid.de
Albin 79 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SPQ4 - SPCH - SYC
Race starts: Oct 03rd 06:00 Registration Open!
▶ Flash
GO TO RACE

Cross the Convergence 2026 - Masirah to Chagos


Having crossed, re-crossed and re-re-crossed the Convergence Zones of the Pacific and the Atlantic, we now face our second crossing of the Convergence Zone of the World’s third great equator-spanning sea, the Indian Ocean, taking us from the channel between Masirah Island and the Oman mainland to the Chagos Archipelago. It’s 1900nm and we’ll be sailing our very fine Archer 78, and won’t mention that both locations (of departure and arrival) are heavily militarized and the why’s and what next’s concerning that – mindful as always of SOL Netiquette.
Race #1988
INFOby brainaid.de
Archer 78PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: CCZ - SYC
Race starts: Oct 02nd 18:00 Registration Open!
▶ Flash
GO TO RACE

Carib Rum Run 2026


Ahoy, ye landlubbers and seasoned salts! Welcome back to Sailonline’s legendary Carib Rum Run, perfectly timed to kick off on International Talk Like a Pirate Day, 19 September!

This year, we command the magnificent Falkun—the ultimate high-tech superyacht modeled after the iconic Maltese Falcon. This 1759nm slalom takes us through the Caribbean’s rum islands to plunder barrels from local distilleries and deliver them to the rum-parched sands of Cancun.

Join SYC before the finish to disguise yer boat with a pirate name for this race only. Hoist the sails, sharpen yer cutlasses, and plot your winning course!
Race #2060
INFO by brainaid.de
Falkun PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Sep 19th 05:00 Registration Closed
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member KaSToR
  2. Sailonline Yacht Club Member CriticalHippo
  3. Sailonline Yacht Club Member WRmirekd
  4. Sailonline Yacht Club Member rafa
  5. Sailonline Yacht Club Member Panpyc
  6. Sailonline Yacht Club Member cdhinman
  7. Sailonline Yacht Club Member rumskib
  8. Sailonline Yacht Club Member rthinman
  9. Sailonline Yacht Club Member BRENTGRAY
  10. Sailonline Yacht Club Member Sax747

View full list

Series

Mobile Client

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

The mobile client