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@wirelessbeehive.com> 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@mailman.xmission.com
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@mailman.xmission.com
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@mailman.xmission.com
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".