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 » General Discussion » Polar analysis spreadsheet

Page: Previous 1 2 3

Posted by
NZL_undercover


Users avatar

Posts
65
Registered at
2009-07-31 03:29:32
2010-04-08 09:26:47 - Re: Polar analysis spreadsheet
Thanks Crazycanuk.
The problem was I was not refreshing the pivotal data column. Also discovered when I loaded other boat data I had gaps in the winspeeds. ie 1.94 3.89 9.72 11.66 17.49. To fix this I clicked the tab on the data file TWS and manually unchecked (manual filtering) some of the top end wind speeds. This allowed the gaps to fill in. Hope this helps others.

Cheers Undercover
Posted by
Squall


Users avatar

Posts
8
Registered at
2008-12-25 21:03:23
2010-09-06 10:04:14 - Re: Polar analysis spreadsheet
Hi Guys, I must be a dummy but followed all the instructions and end up with DIV/0 in the VMG overview worksheet. Any ideas? Pasted data ok, refreshed ok, but no good in the worksheet. By the way great piece of work. Thanks
Al
Posted by
Squall


Users avatar

Posts
8
Registered at
2008-12-25 21:03:23
2010-09-07 03:10:30 - Re: Polar analysis spreadsheet
Problem solved, just had to change the sort settings in the pivot table for TWS, this was stuffing up the lookup. All good. Again, love it.
Al

Page: Previous 1 2 3

Please login to post a reply.

Races

Next Race: 00d 00h 00m

Current Races:

Tall Ships Races 2025 - Kristiansand to Esbjerg


Welcome to the fourth of four virtual Tall Ships Races in European waters which are concurrently being organized in-real-life by Sail Training International . This fourth race is from Kristiansand in Norway down Denmark’s North Sea coast to Esbjerg; circa 150nm 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 #1926
INFO by brainaid.de
Barque 90m PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TS - SYC
Race starts: Aug 02nd 16:00 Registration will open soon
▶ Flash
GO TO RACE

Marstrand to Cowes 2025


We invite you to another race, which will kick off the third quarter of our ARCH series. We'll set off from Marstrand, Sweden, which, along with Skagen, Denmark, marks the line commonly recognised as the border separating the Baltic Sea from the North Sea. The 650nm route will take our Ripitide 50 across the North Sea and the English Channel to Cowes, England. Watch out for the fast ferries crossing the Channel from Calais to Dover 😊.
Race #1935
INFO from brainaid.de
Riptide 50 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ3 - ARCH - SUPSOL – SYC
Race starts: Jul 28th 17:00 Registration Open!
▶ Flash
GO TO RACE

Sinbad by Balloon 2025 - Baia de l'Oiseau to Carnarvon


How ever shall I return to report with clarity to my Great Sultan – asked Sinbad. It needs be told this island and all its fables shall be expunged from the annals of every thousand and one night. The wind howls – and sun be none (it’s Winter, Sin’bro, ed.) – and all days from the west, but let’s launch anyway and see if we can work our SOL Balloon north as the days pass aiming for Asthralaya, where The Mahabharata tells the ancients once tested mighty weapons, about a quarter and a million qasbah away (2500nm, ed.), perhaps one month.
Race #1885
INFOby brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SBB
Race starts: Jul 23rd 11:00 Registration Open!
▶ Flash
GO TO RACE

Tall Ships Races 2025 - Aberdeen to Kristiansand


Welcome to the third of four virtual Tall Ships Races in European waters which are concurrently being organized in-real-life by Sail Training International . This third race is from Aberdeen in Scotland east across the North Sea to Norway’s Kristiansand; circa 330nm 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 #1925
INFO by brainaid.de
Barque 90m PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TS - SYC
RACE CLOSE: Wednesday,
July 30 at 2300 UTC.
Race starts: Jul 22nd 16:00 Registration Closed
▶ Flash
GO TO RACE

Young Island to Great Nicobar 2025

The adventure continues as we launch this fifth leg of the RWW series, racing from Young Island to Great Nicobar on the edge of the Bay of Bengal. Get ready for a chilling start as we set sail on the seventh leg of the 2025 Ocean Championship Series! A 5200nm journey of endurance, strategy, and pure sailing excitement. This leg will be pursued aboard the Super Maxi 100v2, pushing sailors to their limits. Do you have what it takes to conquer the Indian Ocean? Join us and put your skills to the ultimate test!
PRIZE: SMPF
Race #1929
INFO by brainaid.de
Super Maxi 100 v2 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ3 - RWW - OCCH - SUPSOL - SYC
Race starts: Jul 07th 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 WRmirekd
  3. Sailonline Yacht Club Member KaSToR
  4. Sailonline Yacht Club Member rafa
  5. Sailonline Yacht Club Member Kipper1258
  6. Sailonline Yacht Club Member vida
  7. Sailonline Yacht Club Member BRENTGRAY
  8. Sailonline Yacht Club Member rumskib
  9. Sailonline Yacht Club Member Sax747
  10. Sailonline Yacht Club Member FreyjaUSA

View full list

Series

Mobile Client

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

The mobile client