[BaseCamp] Can I Copy/Paste Route "Properties" ?

[saddle sore]

Greg
OK.  My route shows arrival and departure times for each waypoint because I
originally put in departure time for the start and then 10 minute
stop-overs for each stop.  Correspondingly, the route properties box shows
arrival and departure times.  But based on you saying those times were
further to the right inside the exported csv spreadsheet, I needed to edit
each waypoint within the route properties box and actually click on the
circle for arrival time (even though the time was right there and it was
shown in my route properties box).   With that completed, I now have the
correct date and Zulu time shown in the exported csv spreadsheet.  Thank
you!
Joe Y.



On Thu, Feb 11, 2016 at 2:39 PM, Greg Horodeck <greghoro at gmail.com> wrote:

> Scroll farther to the right. If you don't have arrival or departure
> explicitly checked for the waypoint, you won't see a date/ time in those
> columns
>
> Greg
>
> > On Feb 11, 2016, at 2:12 PM, saddle sore <ironbutter at gmail.com> wrote:
> >
> > Greg and Troy
> > Thanks for this info!!  I also have wanted to be able to create such a
> > spreadsheet but have been doing them manually since I couldn't figure out
> > how to have BC do it.  I just ran a test, with mixed results for the
> column
> > containing th date and Zulu time.   It appears that the date and Zulu
> time
> > are tied to the time and date that the waypoint was created, not tied to
> > the arrival time stated in my route.   So I'm curious, did you guys see
> > accurate date and Zulu times in your exported csv spreadsheet?    So I'm
> > still scratching my head on this one.
> > Joe Y
> > western PA
> >
> >
> >
> >
> >
> >> On Thu, Feb 11, 2016 at 10:03 AM, Troy Martin <qikslvr1 at gmail.com>
> wrote:
> >>
> >> Thanks Greg, that's a good way.
> >>
> >> I just tested it out and yeah, the information is there for only the
> ones I
> >> had "arrival time" checked. Interestingly though it gave me the times in
> >> Zulu time (GMT) rather than the zone I have it in BC. Like you said
> though,
> >> that's easily remedied.
> >>
> >> I can handle all the excel stuff, but if I have anymore questions about
> >> this method or need to bounce an idea off someone I'll let you know.
> >>
> >> Thank you,
> >> Troy
> >>> On Feb 11, 2016 8:54 AM, "Greg Horodeck" <greghoro at gmail.com> wrote:
> >>>
> >>> Perhaps you can get the information you want by exporting the route to
> a
> >>> csv
> >>> file. In Windows, make sure your route is selected, go to the File
> menu,
> >>> choose Export, Export Selection, tell it where you want the exported
> file
> >>> put and specify csv as the type to be saved.
> >>>
> >>> The data you want is all there. It may not be exactly in the form you
> >> want
> >>> but if you know Excel, you should be able to manipulate the data to put
> >> it
> >>> in the form you want. Certainly a macro could be created to automate
> the
> >>> isolation and reformatting of the data (I can provide help). Note, you
> >> will
> >>> need to make sure that for each waypoint in the route, you explicitly
> >> check
> >>> the Arrival and/or the Departure box. Waypoints with unchecked boxes
> will
> >>> not export Arrival/Departure information.
> >>>
> >>> Look in the rtept section of the exported file for the data you want.
> >>>
> >>> The date and time will be concatenated together in one cell and it is
> >>> expressed in Zulu time, not local time for the waypoint. Which may be a
> >>> positive, keeping a rally clock on Zulu and not having to do possible
> >> error
> >>> prone calculations to convert to local time.
> >>>
> >>>
> >>> Greg
> >>>
> >>> -----Original Message-----
> >>> From: Basecamp [mailto:basecamp-bounces at micapeak.com] On Behalf Of
> Troy
> >>> Martin
> >>> Sent: Wednesday, February 10, 2016 10:36 PM
> >>> To: BaseCamp
> >>> Subject: [BaseCamp] Can I Copy/Paste Route "Properties" ?
> >>>
> >>> Hi all, not sure I'm doing this right so feel free to flog me properly
> >> for
> >>> any mistakes I make.
> >>>
> >>> I'm just getting into using BC (still prefer S&T, but starting to come
> >>> around) and I was wondering if there's any way to copy the information
> >> from
> >>> a route "Properties" tab to say a word document or text file for
> >> printing.
> >>>
> >>> What I want is my "rundown" sheet which has the bonus code in the order
> >> of
> >>> collection and the arrival time at that bonus, but I don't want all the
> >>> turn
> >>> directions. When I try to copy the data it selects all the information
> >> in a
> >>> single box, but when I paste it I only get the code, and not anything
> >> else.
> >>> At a minimum I need the code and arrival time .
> >>>
> >>> I'm sure I'll have more questions in the coming months, but you BC
> >>> die-hards
> >>> will be happy to hear I am actually starting to like BC. It's still
> >> missing
> >>> a few things IMHO but I am working to find ways around that.
> >>>
> >>> --
> >>> Thanks,
> >>> Troy Martin
> >>>
> >>> To make _ANY_ changes, including unsubscribing from this list, click
> >>> ----->http://micapeak.com/mailman/listinfo/basecamp
> >>>
> >>>
> >>> To make _ANY_ changes, including unsubscribing from this list, click
> >> ----->
> >>> http://micapeak.com/mailman/listinfo/basecamp
> >>
> >> To make _ANY_ changes, including unsubscribing from this list, click
> ----->
> >> http://micapeak.com/mailman/listinfo/basecamp
> >
> > To make _ANY_ changes, including unsubscribing from this list, click
> ----->http://micapeak.com/mailman/listinfo/basecamp
> >
>
> To make _ANY_ changes, including unsubscribing from this list, click ----->
> http://micapeak.com/mailman/listinfo/basecamp
>
>