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
107
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
107
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:

Silverrudder 2025


Ahoy, SOLers! Get ready for the epic Silver Rudder – Challenge of the Sea! This 125nm single-handed race around Denmark’s island of Funen is back—shallow waters, narrow straits, and shifting winds await. This year, we trade up to our single-handed X-99s—can you master their power where precision counts most? It’s the world’s largest solo regatta, and your virtual helm is calling! Chart your course, trust your instincts, and race for glory in this ultimate test of seamanship!

It is imperative that you read AND understand these special Starting Conditions for SILVERRUDDER 2025:
Starting Conditions!!
Race #1948
INFO by brainaid.de
X-99 Single-handed PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Sep 19th 09:00 Registration Open!

▶ Flash
GO TO RACE

Rome to Tripoli 2025


The next race in the ARCH series will take us almost straight from Rome to Tripoli. But don't expect this 550nm race to be an easy one. The Mediterranean always offers some surprises. So let's prepare your Lagoon 55 with due care and... Fair Winds.
Race #1943
INFO from brainaid.de
Lagoon 55 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ3 - ARCH - SUPSOL – SYC
Race starts: Sep 15th 17:00 Registration Open!
▶ Flash
GO TO RACE

Carib Rum Run 2025

Welcome to the Caribbean and Sailonline’s legendary Carib Rum Run! This year we trade tall ships for pure speed as we race our sleek Santa Cruz 70s on a 1759nm slalom through the rum islands. Yer mission: plunder barrels from the region’s finest distilleries and deliver ‘em to the rum-thirsty sands of Cancun, Mexico. Finish on or before International Talk Like a Pirate Day, 19 September, to etch yer name in legend! Join SYC before race end and ye scallywags can disguise yer boat with a pirate name for this race only! Hoist the sails, sharpen yer cutlasses—the rum run awaits!
Race #1944
INFO by brainaid.de
Santa Cruz 70 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Sep 15th 00:00 Registration Open!
▶ Flash
GO TO RACE

Roslagen TIMED Sea Race

Welcome to quite possibly the most challenging TIMED race of the year. This month finds us in Sweden with lots of islands and narrow passages when we sail our Seacart 30 trimaran over the 86nm from Lidingö outside Stockholm to the beautiful coastal village of Öregrund. Consider yourself a winner if you complete the course nonstop! This is a TIMEDrace so you may RE-REGISTER HEREto try again after finishing a run. You will have 13 days and 11 hours to test your skill and decision making after the race opens.
Race #1945
INFO by brainaid.de
Seacart 30 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ3 - TRCH - SUPSOL - SYC
Race starts: Sep 07th 12:00 Registration Open!
▶ Flash
GO TO RACE

Great Nicobar to Marion Island 2025

The Adventure Continues – Leg #6 of the RWW Series.
We’re setting sail on the next stage of the RWW Series: a 4,400-nautical-mile passage from Great Nicobar to Marion Island. This demanding leg will test endurance, strategy, and seamanship at the highest level. As part of the 2025 Ocean Championship, this marks the ninth legendary challenge in the series — and one of the most exhilarating yet. The race will be contested aboard the Archer 78’ ketch, a vessel built to push sailors to their limits across the vast Indian Ocean.
PRIZE: SMPF
Race #1942
INFO by brainaid.de
Archer 78 PARTICULARS    
WX Updates:
0430 / 1030 / 1630 / 2230    
Ranking: OCQ3 - RWW - OCCH - SUPSOL - SYC
RACE CLOSE: Thursday,
September 25 at 2300 UTC.
Race starts: Sep 01st 11:00 Registration Closed
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member vida
  2. Sailonline Yacht Club Member WRmirekd
  3. Sailonline Yacht Club Member CriticalHippo
  4. Sailonline Yacht Club Member rafa
  5. Sailonline Yacht Club Member KaSToR
  6. Sailonline Yacht Club Member Kipper1258
  7. Sailonline Yacht Club Member BRENTGRAY
  8. Sailonline Yacht Club Member Sax747
  9. Sailonline Yacht Club Member Panpyc
  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