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

[Troy Martin]

What Greg said. I was looking at the creation date too until I scrolled
right and saw the "arrival time" column. I purposely only checked arrival
time on all but the last 2 bonuses on my list to see what happens if it
isn't checked. True to Greg's word, there was no time in the unchecked
cells.
On Feb 11, 2016 1:42 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
>
>