[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