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

Buenos Aires to Rio 2023

This year's second ARCH series race will run from Buenos Aires, Argentina to Rio de Janeiro, Brazil on a route designed by SOLer Vida_Maldita (under his former alias of zero) in 2013. This is a replica of a classic triennial race of 1200nm, first run in 1947. More information about this IRL race can be found here.
So, Bemvindo/Bienvenidos in this coastal classic and prepare your 90ft Monohulls well.
Race #1662
INFO by brainaid.de
90ft Monohull PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ1 - ARCH - SUPSOL - SYC
Race starts: Feb 01st 18:00 Registration Open!

▶ Flash
GO TO RACE

Up Helly Aa 2023
A-OI!!! The cry should soon be ringing out in the streets of Lerwick as the Guizer Jarl and his crew, along with the other teams in the Up Helly Aa parade complete their preparations for the biggest fire festival in Europe. As is Sailonline's tradition, we shall be racing the 383nm from Aberdeen to Lerwick to (virtually) take part in the Up Helly Aa festivities there which take place for the first time since 2020 on Tuesday, 31 January. SAILING NOTE: Gruney may be approached from any direction but must be passed for rounding purposes as indicated on the chart.
Race #1660
INFO by brainaid.de
Elan 410 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Jan 28th 11:00 Registration Open!

▶ Flash
GO TO RACE

Iceland TIMED Race 2023
Welcome to Iceland, where the weather is chilly but there are plenty of volcanoes and beaches to admire along Iceland's beautiful south coast. In fact, our first TIMED race of this year will take us on a 150nm eastbound trip in quick Orange Cats from the Vestmannaeyjaber archipalego to the Stokksnes peninsula. Just mind to enjoy the view from a distance and avoid the temptation to BBQ on the pristine beaches!
RE-REGISTER HERE to race again after finishing a run
Race #1650
INFO by brainaid.de
Orange 125 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ1 - TRCH - SUPSOL - SYC
RACE CLOSE: Sunday, 29 January at 23:00 UTC
Race starts: Jan 14th 12:00 Registration Open!

▶ Flash
GO TO RACE

Sinbad Surveys Arabia 2023
Sinbad Al-SOL’er invites you to race him on seven epic voyages (5 to count), not entirely in line with those of his illustrious ancestor Al-Sail’or described in the 1001 Nights, and totally out of line with those voiced over by Brad Pitt in Sinbad - The Seven Seas, commencing with a survey of Arabia, from the island kingdom of Bahrain all the way to Aqaba, there where, in 1917, after a desperate forced march, TE Lawrence, Sherif Nasir and Auda abu Tayi routed the Ottomans. Instead of camels through the sand, though, we’ll voyage the c 3000nm across the sea on IMOCA 60’s.
Race #1636
INFOby brainaid.de
IMOCA 60 v2 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SVS
RACE CLOSE: Tuesday,
January 31 at 2300 UTC.
Race starts: Jan 09th 09:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member WRmirekd
  2. Sailonline Yacht Club Member Pit8008
  3. Sailonline Yacht Club Member FreyjaUSA
  4. Sailonline Yacht Club Member Vida_Maldita
  5. Sailonline Yacht Club Member bonknhoot
  6. Sailonline Yacht Club Member Sax747
  7. Sailonline Yacht Club Member Kipper1258
  8. Sailonline Yacht Club Member SlideRule
  9. Sailonline Yacht Club Member rafa
  10. Sailonline Yacht Club Member TarassBoulba

View full list

Series

Mobile Client

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

The mobile client