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

Raja Muda Selangor 2025 - Port Klang to Pangkor

Sailonline is delighted to be able to offer online sailors an opportunity to once again compete in all three of the offshore races of the Raja Muda Selangor International race week, organised by the Royal Selangor Yacht Club in association with the RORC, and commencing with a 75nm trip from Port Klang to Pangkor. This year we will be racing this race, and the other two, which together will count towards our Sailonline Raja Muda Series (RMS), in J-109s.
Race #1961
INFO by brainaid.de
J-109 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RMS - SYC
Race starts: Nov 15th 04:00 Registration Open!

▶ Flash
GO TO RACE

Africa by Sea 2025 - Suez to Port Said


When Napoleon (briefly) occupied Egypt at the turn to the 19th C, he ordered his expedition’s Directeur des Ponts et Chaussées, Jacques-Marie Le Père, to evaluate the ancient, derelict, infilled course of a Ptolemaic canal connecting the Red Sea to the Nile via the Great Bitter Lake, versus a new canal to the Mediterranean directly. Neither were considered feasible – locks to climb a pauvre-surveyed 10m sea-level difference, or continuous dredging of the Nile, would both be equally financially prohibitive. Fifty years passed before the unlikeliness of Le Père’s survey finding was challenged and a French Compagnie Universelle du Canal Maritime de Suez obtained a 99-year concession from the Khedive of Egypt, Said Pasha, to construct and operate a canal from the Red Sea to the Mediterranean, much against the will of the Ottoman Sultan, Abdulmecid I (the Pasha’s nominal overlord), and the wishes of the (Irish) British prime minister, Lord Palmerston. The year was 1859, the very number of this race (planning, dear boy, planning!), which, despite the canal’s double-super-tanker gauge and lack of locks, is strictly prohibited IRL. 85nm in Fareast 28Rs to complete your circumnavigation of Africa!
Race #1859
INFOby brainaid.de
Fareast 28R PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - ABS
Race starts: Nov 12th 17:00 Registration Open!
▶ Flash
GO TO RACE

Round Hong Kong TIMED Race 2025

This month’s TIMED race takes us to the hectic, bustling sea lanes of the South China Sea for a 118 nm race beginning and ending in Hong Kong rounding several of the 260 nearby islands along the way. The boat for this race is the South African built Cape 31. This is a TIMEDrace so you may RE-REGISTER HEREto 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 #1964
INFOby brainaid.de
Cape 31 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ4 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
22 November at 23:00 UTC
Race starts: Nov 09th 12:00 Registration Open!
▶ Flash
GO TO RACE

Fernando de Noronha to Faroe 2025

The RWW Series concludes with a spectacular journey from Fernando de Noronha to the Faroe Islands, a legendary destination in the wild North Atlantic. Panning 4,100 nautical miles, this leg will be a true test of endurance, strategy, and sheer determination. Also the penultimate leg of the 2025 Ocean Championship, it’s your chance to prove your mettle against the sea, the wind, and yourself. We’ll be racing aboard the Ragamuffin 100, a vessel built for speed and challenge — demanding planning, precision and grit from every sailor on deck. Do you have what it takes to master the Northern Atlantic?.
PRIZE: SMPF
Race #1960
INFO by brainaid.de
Ragamuffin 100 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RWW - OCQ4 - OCCH - SUPSOL - SYC
Race starts: Nov 03rd 11:00 Registration Closed
▶ Flash
GO TO RACE

Sinbad by Balloon 2025 - Carnarvon to Dondra


From here, our home in Bharatavarṣa is now north west of us – said Sinbad to his fellow balloonists. Perhaps we can ride the wind first further north, and then catch the winds that every year bring the rain, perhaps not. It’s 2600nm and we could be aloft awhile, so, Master el-Quarters, victuals only, no sandbags, provisioning the giant hamper. It will be not a picnic!
Race #1886
INFOby brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SBB
Race starts: Oct 15th 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 WRmirekd
  4. Sailonline Yacht Club Member vida
  5. Sailonline Yacht Club Member rafa
  6. Sailonline Yacht Club Member CollegeFund
  7. Sailonline Yacht Club Member Panpyc
  8. Sailonline Yacht Club Member BRENTGRAY
  9. Sailonline Yacht Club Member Sax747
  10. Sailonline Yacht Club Member Kipper1258

View full list

Series

Mobile Client

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

The mobile client