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 » Nmea in2 Excel

Page: 1 2 Next

Posted by
Roddo


Users avatar

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


Users avatar

Posts
300
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


Users avatar

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


Users avatar

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


Users avatar

Posts
300
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


Users avatar

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


Users avatar

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
Posted by
sol


Users avatar

Posts
300
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


Users avatar

Posts
347
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


Users avatar

Posts
300
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:

The British Isles Circumnavigation 2026


The British Isles Circumnavigation is here! Inviting skippers to take on an epic 1,720nm clockwise voyage around Britain and Ireland! Starting and finishing in Cowes, the course passes some of the most iconic landmarks in offshore sailing, including Fastnet Rock, Tearaght Lighthouse, Black Rock, St. Kilda and Muckle Flugga before the long run home. Racing in our fast and versatile TP52, this Super-Buddy Championship race will reward smart routing, changing weather strategy and sustained concentration over every mile. Good luck!
Race #2052
INFO by brainaid.de
TP-52 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SUPBUD - SYC
Race starts: Aug 09th 10:00 Registration Open!
▶ Flash
GO TO RACE

SSANZ Triple Series 2026 - Race 2

Welcome back to race two of the SSANZ Triple Series—it's time for the Lewmar 100! Our dynamic fleet of Young 88s returns for another exhilarating 65 nautical mile battle across the stunning waters off Auckland, New Zealand. Once again, our skilled Sailonline racers will test their strategic minds and endurance. With intense competition, shifting conditions, and plenty of tactical decision-making, this race promises high-energy sailing and edge-of-your-seat excitement from start to finish!
Race #2047
INFO by brainaid.de
Young 88 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SSANZ - SUPBUD - SYC
RACE CLOSE: Friday,
August 14 at 2300 UTC.
Race starts: Aug 08th 21:15 Registration Open!
▶ Flash
GO TO RACE

Lake Vättern PYOC 2026


Back in 2013, longstanding SOLer Musigny and his friend xthyra invited us for a three race tour of beautiful Lake Vättern in the heart of southern Sweden. After many years, we return there for a quick sprint from a start in front of the village of Brandstorp, either way around Visingso island in the middle of the lake, but PORT HAND ROUND a buoy off the Granna piers on the eastern shore and back, once again avoiding Visingso as best you can. At least 20nm in trusty Scandinavian 11m One Designs; good luck!
Race #2046
INFO by brainaid.de
11m OD PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SPQ3 - SPCH - SYC
RACE CLOSE: Wednesday,
August 12 at 2300 UTC.
Race starts: Aug 08th 21:00 Registration Open!
▶ Flash
GO TO RACE

Easter Island to Tristan da Cunha 2026

Welcome to the second leg of our RNW series, rounding Cape Horn. This middle-most leg Round the New World, from Easter Island to Tristan da Cunha, is also part of our Ocean Championship, and as such the second race of OCQ3 2026. This race, like the previous race in the RNW series, will be sailed in our revised 'version 2' Imoca 60 Foil. Race #2050
INFO by brainaid.de
Imoca 60 Foil v2 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ3 - RNW - OCCH - SYC
Race starts: Aug 03rd 11:00 Registration Open!
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member KaSToR
  2. Sailonline Yacht Club Member CriticalHippo
  3. Sailonline Yacht Club Member WRmirekd
  4. Sailonline Yacht Club Member Panpyc
  5. Sailonline Yacht Club Member rafa
  6. Sailonline Yacht Club Member cdhinman
  7. Sailonline Yacht Club Member rthinman
  8. Sailonline Yacht Club Member ms0689
  9. Sailonline Yacht Club Member BRENTGRAY
  10. Sailonline Yacht Club Member Sax747

View full list

Series

Mobile Client

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

The mobile client