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

Greg Horodeck greghoro at gmail.com
Thu Feb 11 11:39:50 PST 2016


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
> 


More information about the Basecamp mailing list