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:

Tall Ships Races 2025 - Le Havre to Dunkirk


Welcome to the first of four virtual Tall Ships Races in European waters which are concurrently being organized in-real-life by Sail Training International . The course for this first race is between the French ports of Le Havre and Dunkirk; circa 125nm in Sailonline’s magnificent 90m Barque.
NOTE: Starts and Finishes in tall ships racing are always offshore to avoid conflict with shipping and shipping lanes; online and real-life may not match exactly.
Race #1923
INFO by brainaid.de
Barque 90m PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TS - SYC
Race starts: Jul 07th 16:00 Registration Open!
▶ Flash
GO TO RACE

Red Eye - Key Lime Pie-gatta 2025

Opposite the Bahamas at the tip of the Florida peninsula, we find the Florida Keys, a honky-tonk arpeggio of islands, where another SOL classic, the Key Lime Pie-gatta, so-called after the famous local condensed-milk-based tart speciality, awaits to be navigated once again. We’ll race its “Red Eye” 180nm in very-American Santa Cruz 52s, ignoring such artefacts as bridges, causeways and piers joining the keys one to the other and to the mainland!
Race #1846
INFOby brainaid.de
Santa Cruz 52 PARTICULARS
NAM_AWIP WX Updates:
0245 / 0845 / 1445 / 2045
Ranking: SYC - RED
Race starts: Jul 02nd 12:00 Registration Open!
▶ Flash
GO TO RACE

Sail Around Turkey 2025


Welcome to the 11th running of one of Sailonline's most iconic races, where our fleet races the length of the Turkish coastline from Hopa (the easternmost harbour on Turkey’s Black Sea coast) to Iskenderun (the easternmost harbour on Turkey’s Mediterranean coast). It’s a 1,372nm race and aboard our classic, 1st decade of the 21st Century, version 2 IMOCA 60, you should be able to get around the course in less than a week. That is if, of course, once you get out of the Black Sea you don’t stop to enjoy the sights or a BBQ or two in the Golden Horn, or on the Marble Islands, now land-locked Troy or Gallipoli or any of the myriad Aegean islands, that you shall have to carefully navigate past.
Race #1930
INFOfrom brainaid.de
IMOCA 60 v2 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Jun 27th 15:00 Registration Open!
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member CriticalHippo
  2. Sailonline Yacht Club Member KaSToR
  3. Sailonline Yacht Club Member WRmirekd
  4. Sailonline Yacht Club Member FreyjaUSA
  5. Sailonline Yacht Club Member rafa
  6. Sailonline Yacht Club Member Kipper1258
  7. Sailonline Yacht Club Member rumskib
  8. Sailonline Yacht Club Member BRENTGRAY
  9. Sailonline Yacht Club Member Patrick70119
  10. Sailonline Yacht Club Member CollegeFund

View full list

Series

Mobile Client

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

The mobile client