Re: [Utah-astronomy] Excel challenge

Top Page
Delete this message
Reply to this message
Author: William Lockman
Date:  
To: Utah Astronomy
Subject: Re: [Utah-astronomy] Excel challenge
If the file Patrick is talking about is 987 lines, then I didn't sort
the whole thing. I only sorted the one he linked to.

On 5/8/2012 9:13 PM, William Lockman wrote:
> It wasn't that hard either. I went ahead and sorted it for Patrick,
> then sent him the Excel file. It was a little tedious, but it wasn't
> that long of file.
>
> On 5/8/2012 9:08 PM, Daniel Holmes wrote:
>> Not easy with excel, but you could use sed, awk, and a few other
>> command line tools (you have a Mac, right?) to write a script to do it.
>>
>> Dan
>>
>> --
>> Sent from an iPad. There should be less mispelings, but more errors.
>>
>> On May 8, 2012, at 8:12 PM, Patrick Wiggins<paw@???>
>> wrote:
>>
>>> Here's the way the file is produced:
>>>
>>> http://users.wirelessbeehive.com/~paw/temp/excelchallenge.zip
>>>
>>> Looks like it's going to be a long night of data-taking tonight
>>> (yea!) so I'll have lots of time to try out the various suggestions
>>> that have been made here today.
>>>
>>> Thanks all!
>>>
>>> patrick
>>>
>>>
>>> On 08 May 2012, at 15:43, Patrick wrote:
>>>
>>>> Hi,
>>>>
>>>> The original is a text file.
>>>>
>>>> I'm converting it to Excel so I can use Excel's sort function since
>>>> I don't think text files can be sorted.
>>>>
>>>> I'll post a complete original file when I get home this evening for
>>>> folks to play with.
>>>>
>>>> Thanks to all for their help.
>>>>
>>>> patrick
>>>>
>>>>
>>>> On 08 May 2012, at 14:12 , Chrismo wrote:
>>>>
>>>>> i guess i'm not understanding how the original data is formatted.
>>>>> is this
>>>>> stuff:
>>>>> SlewToObject, NGC 2314, 7.20284 75.30996
>>>>> WaitFor , 5 ,
>>>>> TakeImage , 30 ,
>>>>>
>>>>> not in a spreadsheet to start off with?
>>> _______________________________________________
>>> Utah-Astronomy mailing list
>>> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
>>>
>>> Send messages to the list to
>>> Utah-Astronomy@???
>>>
>>> The Utah-Astronomy mailing list is not affiliated with any astronomy
>>> club.
>>>
>>> To unsubscribe go to:
>>> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
>>> Then enter your email address in the space provided and click on
>>> "Unsubscribe or edit options".
>> _______________________________________________
>> Utah-Astronomy mailing list
>> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
>>
>> Send messages to the list to
>> Utah-Astronomy@???
>>
>> The Utah-Astronomy mailing list is not affiliated with any astronomy
>> club.
>>
>> To unsubscribe go to:
>> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
>> Then enter your email address in the space provided and click on
>> "Unsubscribe or edit options".
>
> _______________________________________________
> Utah-Astronomy mailing list
> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
>
> Send messages to the list to
> Utah-Astronomy@???
>
> The Utah-Astronomy mailing list is not affiliated with any astronomy
> club.
>
> To unsubscribe go to:
> http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
> Then enter your email address in the space provided and click on
> "Unsubscribe or edit options".