Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 14-03-2010, 12:20   #1
Registered User

Join Date: Mar 2010
Posts: 7
Copy and Paste of Route Attributes

Hi,
I would like to import the route waypoints into MS Excel. This is possible over GPX-Import, but without the distances and bearings to/from the next/prior waypoint. If I could copy this infos from the route attribute window (mark and ctrl-c), it would be easy to get them into excel. Or does anyone have another idea?
Thanks
Joe
__________________
surfjoe is offline   Reply With Quote
Old 14-03-2010, 16:39   #2
Registered User

Join Date: Dec 2005
Location: WNA
Boat: Dufour 35
Posts: 3,248
Why not do the actual distances and bearings calculations in excel, once the lat&long of the wpts are imported ?

Thomas
__________________
cagney is offline   Reply With Quote
Old 15-03-2010, 10:52   #3
Registered User

Join Date: Feb 2010
Posts: 619
It would be very good to do the calculations in Excel, starting just from basic geographic data about waypoints - it is easier then to modify the route later on.

Until some passage planning tool is built into OCPN, one might use e.g. Raytech 6.0 (free demo - full function but without instruments). Clumsy as it is, it does import/export routes in Excel and flat text format.

At this point, I am wondering, what is needed to turn Route Properties into Passage Plan. I think it would be for each routepoint:

- arrival time, rest time, departure time (possibly rest time = 0, so arrival=departure)
- tides state for arrival/departure time (e.g. HW slack)
- fuel and water tanks fill state (assumed consumption /h motoring /day)

- assumed speed for each leg

- save/printout capability

The values (e.g. times/dates) would be calculated from assumed defaults or set explicitly at chosen locations.

would be nice...

Piotr
__________________
PjotrC is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy of the RCD Regluation Steven Prince Multihull Sailboats 2 28-07-2009 15:39
Kanga, Aries Copy subrosa Construction, Maintenance & Refit 0 08-07-2007 10:20



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 07:33.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.