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:

Isle of Mull TIMED Race 2026

Welcome to the west coast of Scotland for an 80 nm race around the Isle of Mull. Mull is home to castles, distilleries, and the Highland Games. The race begins just north of Oban in the shadow of Dunstaffnage Castle and after rounding the island finishes down the coast at Crinan. The Twister 28 with its classic long keel is the boat for this race.
This is a TIMEDrace so you may RE-REGISTER HEREto try again after finishing a run. You will have two weeks to test your skill and decision making after the race opens.
Race #2057
INFOby brainaid.de
PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ3 - TRCH - SYC
RACE CLOSE: Saturday,
26 September at 23:00 UTC
Race starts: Sep 13th 12:00 Registration will open soon
▶ Flash
GO TO RACE

Cross the Convergence 2026 - Cocos to Sagar Island


Kapil Muni, incarnation of Lord Vishnu, founder of the Samkhya school of philosophy, disturbed from his meditation, in his wrath reduced the 60,000 sons of Sagar to ashes, as they dug the earth to retrieve the sacrificial horse that Lord Indra, the king of the Gods, stole off Sagar, thus creating the Sagara (ocean). Aeons later, Bhagiratha, a descendant of Sagara, asked Ganga to cleanse the ashes of the 60,000 princes, and her resultant torrential fall from heaven created the great river and where it met the ocean, the princes’ souls were washed and raised to heaven and Gangasagar (Sagar Island) was formed. So, let us join the pilgrimages to Kapi Muni’s Temple (see above) and race 2400nm from Cocos Island deep in the Sagara thence, in rather rapid Rapido 60s.
Race #1987
INFOby brainaid.de
Rapido 60PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: CCZ - SYC
Race starts: Sep 11th 18:00 Registration Open!
▶ Flash
GO TO RACE

The Vineyard Race 2026


For the 16th consecutive year, our SOLers are invited to tackle this iconic 250nm overnighter. The classic route charges out through the sound, leaves Buzzards Bay Light to starboard, rounds Block Island to starboard, and heads home.

This year's weapon of choice is the Beneteau First 47.7. A proven performer since its 2012 SOL debut, this Farr-designed cruiser/racer excels at leading real and virtual handicap fleets. Success will demand sharp tactical navigation, so watch the polars closely to conquer the sound's shifting winds!
Race #2056
INFO by brainaid.de
First 47.7 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SUPBUD - SYC
RACE CLOSE: Sunday,
September 13 at 2300 UTC.
Race starts: Sep 04th 17:05 Registration Closed
▶ Flash
GO TO RACE

Shearwater - Rio de la Plata to Irish Sea 2026

Welcome to the fourth leg of our MIG series. This time we're racing the Sooty Shearwater on their migration from the breeding grounds in South America to the northern Atlantic. This is also part of our Ocean Championship, and as such the third race of OCQ3 2026. This race will be sailed in our Gunboat 90. Race #2055
INFO by brainaid.de
GunBoat 90 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ3 - OCCH - SYC - MIG
Race starts: Sep 02nd 11:00 Registration Closed
▶ 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 rafa
  5. Sailonline Yacht Club Member Panpyc
  6. Sailonline Yacht Club Member cdhinman
  7. Sailonline Yacht Club Member rthinman
  8. Sailonline Yacht Club Member BRENTGRAY
  9. Sailonline Yacht Club Member Sax747
  10. Sailonline Yacht Club Member vida

View full list

Series

Mobile Client

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

The mobile client