too tekkernikkel for me!

Rogue Wave · 02 December 2004, 12:32

Would it be possible to write a script in winders or something to suck the speed and position out of a GPS and store it on a Spreadsheet evey twenty minutes.

gArfishs need not reply '

Matt · 02 December 2004, 13:49

Yeh, I wrote one in C about 12 years ago doing exactly that.
Linked in with a trisponder and a depth sounder to enable 3d plotting of the sea floor.

It's pretty easy to do, you just need something that will configure, and then listen, on a serial port, then log it to a file (or re-process it as you want)

jwalker · 02 December 2004, 14:58

Quote:

Originally Posted by MadMat

Yeh, I wrote one in C about 12 years ago doing exactly that.
It's pretty easy to do, ....

Matt, I think you're being asked to do it again.

steedthrust · 02 December 2004, 16:13

Cant you download your GPS track on to a PC after the event?

Or try this gps toolkit seems to have demo excel scripts.

Also browse this lot gps links

Matt · 02 December 2004, 16:16

That looks good, better than I'd be able to knock up in an evening anyway.
If anyone dabbles in VB6 or excel VB script and the like, you can DIY using the MS Comm control.

Rogue Wave · 02 December 2004, 17:00

Ohh thanks Guys. Yeah WJ you are right about Matt being asked to do it again. but I'll have a look at the toolkit first.

The tug I work on dumps aggregate spoil and the the eniro agency require us to record our position every twenty minutes,

Matt · 02 December 2004, 17:11

Whaddya mean again?

Rogue Wave · 02 December 2004, 17:19

the envorenment Agency or Maffii ( yeah yeah DEFRA) or some other bunch of penpushers require us to record our position on the water every twenty minutes. I't a pain in the ass driving the boat, resetting the timer, holding the torch, finding the pen changing the gps to position, watching the water talking on the VHF, listening to Stevie Ray Vaughn and talking to gArfie on the mobile it all gets a bit difficult.

So I thought if we automated the logging process and told gArfie to fkk off then it'd be a lot more fun

.

Manny · 02 December 2004, 23:29

From the web page:
http://www.windmill.co.uk/rs232.html

"Windmill LabIML software ... is a universal driver for instruments that send or accept ASCII messages over RS232. It automatically feeds data from the instruments to Windows application software. You could, for example, show readings from a GPS receiver and a sonar in an Excel spreadsheet"

Version 4.3 is free for free newsletter subscribers.

roohairy · 03 December 2004, 07:36

Quote:

Originally Posted by Manny

Version 4.3 is free for free newsletter subscribers.

Think they've just had a rush of subscribers....

Mark Halliday · 03 December 2004, 10:58

Rogue

Memory-Map will record a track either live from a GPS or downloaded later. Run your mouse pointer around the track and it will tell you the time and date, position, speed and altitude (I have used it in a plane) at that point at 1 min intervals. It turns a hand held GPS into a chart plotter on your laptop or PDA in a nice dry tug wheelhouse. Cracking bit of kit.
The track can be emailed, and I think you may be able to extract it as a .csv file.

www.memory-map.co.uk/