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

Hello,

Does anyone how to get NMEA into Excel - from the excel end?

thanks in advance

Rod
content deleted on request of Rainbowchaser

--- Last Edited by sol at 2016-08-17 11:04:51 ---
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
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.
content deleted on request of Rainbowchaser

--- Last Edited by sol at 2016-08-17 11:04:16 ---
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 ---
Do you mean like this??
Attachments
content deleted on request of Rainbowchaser

--- Last Edited by sol at 2016-08-17 10:58:18 ---
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 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 :)
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:

Van Isle 360 2020
Welcome back to Vancouver and the 525nm delightful course designed by SOLer fastpassage39. This is a tricky race, combining tight channels and open water which our seldom sailed and elegant Dufour 40 will love.
Race #1336
INFO by brainaid.de
Dufour 40 Particulars
WX Updates: 0430 / 1030 / 1630 / 2230
Ranking: SYC
ALT. CLIENT:Classic

Race starts: Apr 01st 17:00 Registration Open!
New HTML5 Client GO TO RACE

A3 2020- Leg 3 - Hobart to Sydney
SOL's continuing tribute to AGage is the A3 - Agage's Around Australia Series. This race is Leg 3 of a 9-race series. Not a race goes by without the name of AGage appearing somewhere in race chat. We continue our running of this tribute circumnavigation of Australia in his memory. Leg 3 is a 630nm race from Hobart to Sydney.
Race #1330
INFO by brainaid.de
First 47.7 Particulars
WX Updates: 0430 / 1030 / 1630 / 2230
Ranking: A3 - SYC
ALT. CLIENT:Classic

Race starts: Mar 28th 19:00 Registration Open!
New HTML5 Client GO TO RACE

Lisbon to Cape Town 2020
Our third OCC race in Q1 is also our first race of a special 4-race RTW series. Given that this leg 1 is taking us on a more than 5000nm passage from Lisbon to Cape Town, the betting has to be that the subsequent legs will be into the wind. Hopefully not in replicas of Ellen McArthurs Orange catamaran then!
PRIZE: SMPF
Race #1310
INFOby brainaid.de
Orange 125ft Cat Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: OCCH - OCQ1 - RTW - SUPSOL - SYC
ALT. CLIENT: Classic
RACE CLOSE: Sunday,
April 5 at 2300 UTC.
Race starts: Mar 08th 19:00 Registration Closed
New HTML5 Client GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member bonknhoot
  2. Sailonline Yacht Club Member WRmirekd
  3. Sailonline Yacht Club Member rafa
  4. Sailonline Yacht Club Member calmxy
  5. Sailonline Yacht Club Member Kipper1258
  6. Sailonline Yacht Club Member Beliberda
  7. Sailonline Yacht Club Member Starship
  8. Sailonline Yacht Club Member batatabh
  9. Sailonline Yacht Club Member Bimmer
  10. Sailonline Yacht Club Member Mouthansar

View full list

Series

Mobile Client

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

The mobile client