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:

Bar-tailed Godwit - Alaska to New Zealand 2026


Welcome to the autumn return flight of our bar-tailed Godwit, reflecting the bird's annual migratory route. This is the penultimate leg in our migration series. (The concluding leg is coming up simultaneously, 'Skimmer Dragonfly', start on the 11th of November. Not part of the 2026 OCCH). This race, at hand, is the next to last leg of the 2026 Ocean Race Championship. The voyage promises to be not only a test of skill and strategy but an immersive experience in the beauty of the vast Central Pacific Ocean. Join us as we push the boundaries of seafaring prowess on this epic adventure.
Let's fly like a Godwit!
Race #2065
INFOby brainaid.de
GunBoat 90 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ4 - OCCH - SYC - MIG
Race starts: Nov 02nd 11:00 Registration Open!
▶ Flash
GO TO RACE

Mistli's Birthday BBQ Race 2026


It’s that time of year again – November 1, time for Mistli’s birthday bash and BBQ! It’s the usual tricky 61.5nm through the SLI-infested Stockholm Archipelago to Mistli’s place at Trosa, this year in a slightly slower but seriously Swedish Scampi 26!
Race #2063
INFO by brainaid.de
Scampi 26 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RED - SYC
Race starts: Nov 01st 14:00 Registration Open!
▶ Flash
GO TO RACE

ORCV Melbourne to Devonport Race 2026

Welcome to the prestigious Rudder Cup, Australia’s oldest and most iconic yacht race! For over 110 years, this legendary 196nm classic has tested sailors' strategy and endurance across the notorious Bass Strait from Melbourne to Tasmania.

Organized by the Ocean Racing Club of Victoria, this year’s battle against the unpredictable Southern Ocean features the stylish Dehler 46. Designed by Judel/Vrolijk as a proper looker and built to race, this regatta cruiser is a virtual flyer packed with modular racing upgrades. Can you master her speed and conquer the shifting elements?

Chart your course and race for glory in this historic adventure!
Race #2068
INFO by brainaid.de
Dehler 46 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TQD - SUPBUD - SYC
RACE CLOSE: Friday,
November 6 at 2300 UTC.
Race starts: Oct 30th 03:30 Registration Open!
▶ Flash
GO TO RACE

Mad Max by Balloon 2026 - Across the Outback


Mad Max Rockatansky doesn’t get to go in a balloon in any of the Legends of the Wasteland, and the Wasteland is not necessarily the Outback of Australia, but Mel Gibson and film director George Miller indubitably are… of Australia, and ballooning as reconnaissance is a main feature of the Mad Max spin-off video game, so here goes: 1500nm in a balloon from somewhere on the edge of the Outback, Goondiwindi, to cross a finish line at Fitzroy Crossing, somewhere on the edge of the Outback!
Race #1974
INFOby brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: BOL - SYC
Race starts: Oct 14th 13:00 Registration Closed
▶ Flash
GO TO RACE

Arctic Tern - Greenland to Antarctica 2026

Welcome to the fifth leg of our MIG series. Now it's time to race the Arctic Terns, on their migration from Greenland to Antarctica, 8300 NM. This is also part of our monthly Ocean Championship, and as such the first race of OCQ4 2026. This race will be sailed in our Maxi Trimaran. Race #2061
INFO by brainaid.de
Maxi Trimaran PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230 Ranking:
OCQ4 - OCCH - SYC - MIG
RACE CLOSE: Wednesday,
November 4 at 2300 UTC.
Race starts: Oct 05th 11:00 Registration Closed
▶ 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 rafa
  4. Sailonline Yacht Club Member rumskib
  5. Sailonline Yacht Club Member cdhinman
  6. Sailonline Yacht Club Member rthinman
  7. Sailonline Yacht Club Member Panpyc
  8. Sailonline Yacht Club Member BRENTGRAY
  9. Sailonline Yacht Club Member brandystrega
  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