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:

Pantaenius Shetland Race 2022 - Leg 2
As always, we don't spend much time in Lerwick, Shetland and after some brief but excellent celebrations we are rapidly heading back to Bergen, Norway, for the second leg of the Pantaenius Shetland Race 2022. The North Sea always provides with some exciting racing and we are sure that this race will be no different!
Race #1581
INFO from brainaid.de
First 40.7 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
RANKING: SYC - SHE
Race starts: Jun 26th 09:00 Registration Open!

▶ Flash
GO TO RACE

Isla St George Sprint 2022
The Bass Islands, in western Lake Erie, are a mere couple of miles west of the southernmost boundary of Canada. In this 21nm PYOC sprint, we will set off from East Harbor in our RC 44s and leave North Bass Island (historically Isle St. George) to port before quickly returning to East Harbor.
Race #1584
INFOby brainaid.de
RC 44 PARTICULARS
NAM_AWIP WX Updates:
0245 / 0845 / 1445 / 2045
Ranking: SPRQ2 - SPRCH - SUPSOL - SYC
Race starts: Jun 25th 18:00 Registration Open!

▶ Flash
GO TO RACE

Pantaenius Shetland Race 2022 - Leg 1
Welcome back to outer Korsfjorden, Norway, for the first leg of two in
Pantaenius Shetland Race 2022 from Norway to Shetland. Sailonline is extremely excited to be buddying-up for this amazing series which is a classic that Sailonline has had the honour of presenting to its community for some years now. We will be competing in our ever so exciting First 40.7’s which will in no doubt cater for some exciting racing. We look forward to seeing you at the start line!
Race #1580
INFO from brainaid.de
First 40.7 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
RANKING: SYC - SHE
Race starts: Jun 22nd 08:00 Registration Closed

▶ Flash
GO TO RACE

Newport Bermuda Race 2022


The 635-mile biennial Newport Bermuda Race is one of the oldest regularly scheduled ocean races, and with the Fastnet Race and the Sydney to Hobart Race, it is one of the three great classic races of the yachting world. Founded in 1906, this the 52nd running of the Bermuda Race can also be participated in online.
Entries are invited for one of the four divisions:
Double-Handed Division:
Jeanneau Sun Fast 3300
St. David's Lighthouse Division:
First 44.7 Asymmetric
Gibbs Hill Lighthouse Division:
Reichel Pugh 64
Finisterre Division:
Delphia 47
Details for each yacht are available in the ‘Particulars’ links below and be sure to register your online choice on the Bermuda Race Online link – there are some fine prizes to be won.
As in real life, you can only sail one boat in one division, so choose your virtual yacht carefully, and because of the unusual (for SOL) 4-division nature of the event, please note results will not count towards ANY Sailonline Rankings.
Race #1568
INFOby brainaid.de
Sun Fast 3300 PARTICULARS
First 44.7 A PARTICULARS
RP 64 PARTICULARS
Delphia 47 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: None
Sponsors:

RACE CLOSE: Saturday,
July 2 at 2300 UTC.
Race starts: Jun 17th 17:00 Registration Closed
▶ Flash
GO TO RACE

Geraldton to Cape Town 2022
A race in the Southern Indian Ocean is always entertaining, especially in a Riptide 50. Traditionally the course would be West to East, to take advantage of the prevailing winds, but this time the SRC is challenging us to an E-W course, from Geraldton in Western Australia to Cape Town in South Africa. A brief 4800nm!
PRIZE: SMPF
Race #1575
INFO by brainaid.de
Riptide 50 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ2 - OCCH - SUPSOL - SYC
Race starts: Jun 12th 05:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

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

View full list

Series

Mobile Client

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

The mobile client