Howdy folks, I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file. What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky): SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 , SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 , SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 , And then have it come out sorted like this: SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 , SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 , SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 , Note that it's sorted by the number in the third column with everything else remaining the same. Any ideas? Thanks, patrick
I believe the way to do that is first select the column to sort by, then 'select all' and then do the sort On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick _______________________________________________ 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 <javascript:;>
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".
-- Sent from my iPad
You are on he right track Chrismo, except that somehow he needs to be able to select three lines as the "chunk" that stays together, and then gets sorted as those "chunks" by the data in one cell within that chunk. Moving it all to one line would make the sort work, but you would need to automate moving all the info on each set of three lines to one line, and then have it move back to the three line format when the sort is over. I am sure there is a way to do this, but I don't know what it is off the top of my head. I would love to see the solution if anyone figures it out! Jo Quoting Chrismo <djchrismo@gmail.com>:
I believe the way to do that is first select the column to sort by, then 'select all' and then do the sort
On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick _______________________________________________ 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 <javascript:;>
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".
-- Sent from my iPad _______________________________________________ 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".
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? On Tuesday, May 8, 2012, Josephine Grahn wrote:
You are on he right track Chrismo, except that somehow he needs to be able to select three lines as the "chunk" that stays together, and then gets sorted as those "chunks" by the data in one cell within that chunk. Moving it all to one line would make the sort work, but you would need to automate moving all the info on each set of three lines to one line, and then have it move back to the three line format when the sort is over. I am sure there is a way to do this, but I don't know what it is off the top of my head. I would love to see the solution if anyone figures it out!
Jo
Quoting Chrismo <djchrismo@gmail.com>:
I believe the way to do that is first select the column to sort by, then
'select all' and then do the sort
On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick ______________________________**_________________ Utah-Astronomy mailing list http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy>
Send messages to the list to Utah-Astronomy@mailman.xmission.com <javascript:;>
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<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".
-- Sent from my iPad ______________________________**_________________ Utah-Astronomy mailing list http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<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<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<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<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".
It is, but my limited excel experience only knows how to sort every individual line, and he needs it to sort by one cell in chunk of data that is 4 columns wide and 3 lines high. My result would have all the "slew to object" lines put together, and then a whole bunch of "wait for"s and then a bunch of "Take image"s. As I say, my excel is limited to financial stuff, so I don't know how to have it sort 3 lines, as 1 piece of data.... Quoting Chrismo <djchrismo@gmail.com>:
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?
On Tuesday, May 8, 2012, Josephine Grahn wrote:
You are on he right track Chrismo, except that somehow he needs to be able to select three lines as the "chunk" that stays together, and then gets sorted as those "chunks" by the data in one cell within that chunk. Moving it all to one line would make the sort work, but you would need to automate moving all the info on each set of three lines to one line, and then have it move back to the three line format when the sort is over. I am sure there is a way to do this, but I don't know what it is off the top of my head. I would love to see the solution if anyone figures it out!
Jo
Quoting Chrismo <djchrismo@gmail.com>:
I believe the way to do that is first select the column to sort by, then
'select all' and then do the sort
On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick ______________________________**_________________ Utah-Astronomy mailing list http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy>
Send messages to the list to Utah-Astronomy@mailman.xmission.com <javascript:;>
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<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".
-- Sent from my iPad ______________________________**_________________ Utah-Astronomy mailing list http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<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<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<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<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".
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?
Word has a sort function that will sort text files. I think many word processors do also. The easiest thing to do would be to put it all on the same line and then sort. Then you need to beak it apart for the rest of the sort. Excel will learn a macro to do this of you can show it what you want. Else, you can write a macro to do so. From: Patrick <paw@wirelessbeehive.com> To: Utah Astronomy <utah-astronomy@mailman.xmission.com> Sent: Tuesday, May 8, 2012 3:43 PM Subject: Re: [Utah-astronomy] Excel challenge 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".
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?
Mrs Chrismo says it can't be done. I'm hoping someone else knows how. If it were me, I'd just sort the main data, then cnp the 2nd and 3rd rows of each section, since they're all the same anyway. On Tue, 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".
-- Chrismo I fix things, all kinds of things... (801) 897-9075
On 08 May 2012, at 21:04 , Chrismo wrote:
Mrs Chrismo says it can't be done.
That's the feeling I'm getting.
If it were me, I'd just sort the main data, then cnp the 2nd and 3rd rows of each section, since they're all the same anyway.
That would work for short runs but a full run typically runs over 800 lines. That's a lot of cutting and pasting. :) Still, there's gotta be an easier way... patrick
Just in case anyone is still interested and following this thread I just noticed that tonight's first run consists of 987 lines. That will get me to about 2 am. The 2-5 am run will be much shorter at about 100 or so. Thanks again to all who have been making suggestions, patrick
It looks like the file you linked to wasn't the whole file. That one wasn't anywhere near 987 lines. On 5/8/2012 9:11 PM, Patrick Wiggins wrote:
Just in case anyone is still interested and following this thread I just noticed that tonight's first run consists of 987 lines. That will get me to about 2 am. The 2-5 am run will be much shorter at about 100 or so.
Thanks again to all who have been making suggestions,
patrick _______________________________________________ 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".
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".
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".
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".
Hi Bill, You got it! Huzzah!!! I had to remove columns D & E and then save it as a format called "Windows Comma Separated (.csv)" No idea what that format is but the program accepted it. Just another example of the huge amount of knowledge and willingness to help found here on Utah-Astronomy. Thanks! On 08 May 2012, at 22:13, 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.
well done! the various methods of saving text from excel are one of the biggest hurdles to overcome for people who don't use it much, or use it for other purposes. On Wed, May 9, 2012 at 4:06 AM, Patrick Wiggins <paw@wirelessbeehive.com>wrote:
Hi Bill,
You got it! Huzzah!!!
I had to remove columns D & E and then save it as a format called "Windows Comma Separated (.csv)"
No idea what that format is but the program accepted it.
Just another example of the huge amount of knowledge and willingness to help found here on Utah-Astronomy.
Thanks!
On 08 May 2012, at 22:13, 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.
_______________________________________________ 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".
-- Chrismo I fix things, all kinds of things... (801) 897-9075
You're welcome. It occurs to me that I never explained how I imported the file. Here's how you do that in Excel 2003: On the top menu bar, click "Data". In the drop down box that opens click "Import External Data". In the axillary dialog box, click "Import Data". A browsing box opens. Browse to the file and double click on the file or click on it then click Open. This opens a dialogue box. Select the radio button "Delimited". Click Next> In the Delimiters section of the box that opens, the "Tab" check box is checked by default. Additionally put a check in "Comma" (it looked like most of the data was separated by commas to me. There are some other choices if it isn't comma delimited). Click Next>. Click Finish. On the last sheet, select the appropriate radio button. I have always started this from the worksheet on to which I wanted to import the text file. Make sure the cell in the selection box is the one in which you want the data to start. Click OK The text file imports, in the same format as was on the spreadsheet I sent. From here you can copy this imported data to a different worksheet and Sort it as per the instructions I sent. On 5/9/2012 3:06 AM, Patrick Wiggins wrote:
Hi Bill,
You got it! Huzzah!!!
I had to remove columns D& E and then save it as a format called "Windows Comma Separated (.csv)"
No idea what that format is but the program accepted it.
Just another example of the huge amount of knowledge and willingness to help found here on Utah-Astronomy.
Thanks!
On 08 May 2012, at 22:13, 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.
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".
Is the problem that you need to keep the data for each right ascension in three rows, so you want those three rows to remain intact? This guy: http://www.youtube.com/user/ExcelIsFun?feature=watch If it's possible to do something in Excel, he can most likely tell you how. He answers questions too. On 5/8/2012 6:27 AM, Chrismo wrote:
I believe the way to do that is first select the column to sort by, then 'select all' and then do the sort
On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick _______________________________________________ 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<javascript:;>
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".
participants (7)
-
Brent Watson -
Chrismo -
Daniel Holmes -
Josephine Grahn -
Patrick -
Patrick Wiggins
-
William Lockman