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

[Greg Horodeck]

All routes will show Arrival times for each waypoint in the route Properties
tab. If the arrival time is not underlined, it means it is calculated. If it
is underlined, it means the user has explicitly assigned an arrival time.
Departure times are not normally displayed, except for the starting waypoint
but are displayed when one has been explicitly assigned to the waypoint.
This is for Windows, assume Mac does the same.

Caution, by explicitly checking the Arrival or Departure box for a waypoint,
you are now freezing the arrival and/or departure time for that waypoint.
Any recalculation or manipulation of the route will not cause the arrival
and/or departure time to be recalculated for that waypoint. You are
overriding the calculation for that waypoint and are impacting other
waypoints, as well.  

Freezing an arrival time for a waypoint will impact all preceding waypoints
calculated departure time. Freezing a departure time for a waypoint will
impact all subsequent calculated waypoints arrival time. There may be
exceptions I am not aware of. Note, you will be warned (red font along with
calculated value) if it determines that your explicit arrival time is too
soon to be possible. However, it won't warn you if a following waypoint now
has a lot of slack built in to arrive by the explicitly assigned arrival
time. Play around, it's the only way you will really learn how explicit
arrival and departure times works.

I'm guessing that the designers were expecting the export/import function to
be primarily used for sharing information. They needed a way to denote when
a waypoint's arrival and departure information was calculated or when it was
explicitly assigned by the user. The easy way was to only export a data
value when it was explicit and leave it blank it when it was calculated.
When importing, the program would look at the arrival and departure field
values; if blank, would allow the waypoint to be calculated and if
non-blank, would use the value to specify the arrival or departure time.
Again, just a hypothesis on my part, I didn't write the program.
 

Greg

-----Original Message-----
From: Basecamp [mailto:basecamp-bounces at micapeak.com] On Behalf Of saddle
sore
Sent: Thursday, February 11, 2016 2:11 PM
To: BaseCamp
Subject: Re: [BaseCamp] Can I Copy/Paste Route "Properties" ?

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

To make _ANY_ changes, including unsubscribing from this list, click
----->http://micapeak.com/mailman/listinfo/basecamp