Sailonline.org - Online Sailing

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!

Tweets by @sailonline

Board » Technical Support » Nmea in2 Excel

Page: 1 2 Next

Posted by Roddo Posts 13 Registered at 2014-06-28 00:51:17	2016-08-05 12:40:58 - Nmea in2 Excel
	Hello, Does anyone how to get NMEA into Excel - from the excel end? thanks in advance Rod
Posted by sol Posts 296 Registered at 2008-08-14 11:08:14	2016-08-05 18:58:39 - Re: Nmea in2 Excel
	content deleted on request of Rainbowchaser --- Last Edited by sol at 2016-08-17 11:04:51 ---
Posted by Roddo Posts 13 Registered at 2014-06-28 00:51:17	2016-08-05 22:06:42 - Re: Nmea in2 Excel
	At this stage I want to be able to display the data on an excel sheet; TWA,TWD,BSP,COG that sort of thing. Is it possible? Could you point me in the right direction for research? I've tried a couple of time but was not succesful
Posted by Schakel Posts 183 Registered at 2008-12-19 09:19:00	2016-08-06 09:03:00 - Re: Nmea in2 Excel
	I suppose it could be done. Excel 2013 has two new functions called webservice and filterxml which you could probably use to pull boat.xml into Excel and display what you want.
Posted by sol Posts 296 Registered at 2008-08-14 11:08:14	2016-08-06 11:42:43 - Re: Nmea in2 Excel
	content deleted on request of Rainbowchaser --- Last Edited by sol at 2016-08-17 11:04:16 ---
Posted by muggles Posts 24 Registered at 2024-07-11 11:58:13	2016-08-08 19:38:00 - Re: Nmea in2 Excel
	Maybe the attached beginning of an excel macro will help you.... 9 aug 2016: I have removed the attachment. --- Last Edited by krimpvrij at 2016-08-09 09:41:32 ---
Posted by Bimmer Posts 447 Registered at 2015-02-23 15:38:27	2016-08-10 03:12:47 - Re: Nmea in2 Excel
	Do you mean like this?? Attachments 2TALL.csv (319.7 KB)
Posted by sol Posts 296 Registered at 2008-08-14 11:08:14	2016-08-10 09:12:22 - Re: Nmea in2 Excel
	content deleted on request of Rainbowchaser --- Last Edited by sol at 2016-08-17 10:58:18 ---
Posted by kroppyer Posts 346 Registered at 2010-02-05 15:25:55	2016-08-10 09:35:07 - Re: Nmea in2 Excel
	1. use timestamp=2147483647, it will get rid of the chat messages in the response, which can contain characters that not all xml parsers can handle. 2. There's a performance loss thread somewhere in the forum where I've posted (I think) a PHP script that logs some data in a csv. 3. This might not help Roddo. using boat.xml might work for sol, but won't help him when he's sailing IRL. Roddo: what do you need this for..? and what exactly do you need? It's easy to assume you want a log of boat parameters every x seconds in a spreadsheet, so that you can apply some analysis afterwards. But maybe you want your spreadsheet log to grow automatically as racing continues. Or perhaps you don't want a log at all, but just the most recent values, updating live within the spreadsheet. Have a look at one of Kipper's most recent posts on http://solfans.org/. He has a java application that (I believe) logs boat parameters (it does a lot more than that too). I have no licence of expedition or excel, so I can't really hand you a solution, but at least I can try to make the problem clear --- Last Edited by kroppyer-admin at 2022-01-09 11:36:36 ---
Posted by sol Posts 296 Registered at 2008-08-14 11:08:14	2016-08-10 10:02:01 - Re: Nmea in2 Excel
	content deleted on request of Rainbowchaser --- Last Edited by sol at 2016-08-17 10:57:41 ---

Page: 1 2 Next

Please login to post a reply.

Races

Next Race: 00d 00h 00m

Current Races:

Kapiti Chetwodes Race 2024

For only the second time in SOL history, we have the pleasure of inviting you to the Kapiti Chetwodes Race, held in the Cook Strait region. Organised IRL by the Royal Port Nicholson Yacht Club from Wellington in New Zealand. The approximately 160nm long route, full of turning points, will take us from the bay at RPNYC around the islands of Somes, Kapiti and Chetwodes and back to the finish line at RPNYC. We have only a 26 ft Albin 79 yacht at our disposal. All this means that we will have a lot of fun, so fair winds!
Race #1864
INFO by brainaid.de
Albin 79 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ4 - ARCH - SUPSOL - SYC
Race starts: Nov 25th 17:00 Registration will open soon

▶ Flash

GO TO RACE

Raja Muda Selangor 2024 - Penang to Langkawi

Welcome to the third and last online race of the Raja Muda Selangor International offshore series – a 70nm final trip further north again up the Malacca Strait from Penang to the exotic island of Langkawi, and again in Ker 40s.
Race #1871
INFO by brainaid.de
Ker 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RMS - SYC
Race starts: Nov 21st 04:00 Registration Open!

▶ Flash

GO TO RACE

Raja Muda Selangor 2024 - Pangkor to Penang

Welcome to our second online offshore race in cooperation with Raja Muda Selangor International – an 80nm trip from Pangkor north to Penang up the Malacca Strait, again in Ker 40s.
Race #1870
INFO by brainaid.de
Ker 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RMS - SYC
RACE CLOSE: Saturday,
November 23 at 2300 UTC.
Race starts: Nov 18th 04:00 Registration Open!

▶ Flash

GO TO RACE

Two Oceans Doublecross TIMED Race 2024

Our November Timed race takes us to Cape Town near where the Atlantic and Indian oceans meet. Our ride is a beautiful ketch, the Archer 78. Starting at Cape Town, we’ll round Robben Island, then head south to round Cape Point, up around Seal Island before heading north to round Dassen Island before returning to Cape Town. This is a TIMED race, so you may RE-REGISTER HERE to 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 #1872
INFO by brainaid.de
Archer 78 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ4 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
30 November at 23:00 UTC
Race starts: Nov 17th 12:00 Registration Open!

▶ Flash

GO TO RACE

Nassau to Bodo 2024

Prepare for the grand finale - the 6th and concluding leg of the RTW challenge, an odyssey from Nassau in the Caribbean to Bodø in Norway. Embracing a journey of 4000 nautical miles, this leg promises an exhilarating 18-day voyage. It also heralds the November installment of our prestigious Ocean Race Championship. Embark on a voyage of a lifetime, where prowess, tactics, and camaraderie unite in the pursuit of triumph. We eagerly await your presence at the starting line! May the winds be ever in your favor.
PRIZE: SMPF
Race# 1866
INFO from brainaid.de
Swan 65 PARTICULARS
WX updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ4 - OCCH - RTW - SUPSOL - SYC
Race starts: Nov 11th 11:00 Registration Closed

▶ Flash

GO TO RACE

Go to race archive

SYC Ranking

View full list

Series

Mobile Client

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

The mobile client