Re: [Utah-astronomy] Numbers question
Hi all, Thanks to all who are trying to assist. I'm not sure if y'all don't quite understand what I'm trying to do or if I'm not understanding the replies. So here's an example using real numbers from a recent night's data runs. Early in the evening I had my software come up with a list of NGC objects to image based on the type, size, brightness and if they are above my local horizon. After taking data on those objects I waited a few hours and ran a second list of targets based on the same specifications. As always happens there are objects on the second run's list that were on the first run's list. When that happens I do not want to work the duplicates so I'm trying to come up with some way of deleting the duplicates so all I work are the new objects. What follows is a text version I assembled manually showing what I'm hoping a spreadsheet could do automatically. In the first column I'd enter the NGC numbers of the objects in the first run. In the second column I'd enter the NGC numbers of the objects in the second run. The spreadsheet would then examine both columns and list the duplicates in the third column and the new objects in the forth column. I'd then feed the numbers from the 4th column into the software that controls the telescope mount and camera and away it would go taking data only on the objects that only appeared in the second run's list. So, NGC 1560 only shows up in column 2 so it survives through to the 4th column for further study while NGC 1530 was in the first column so it is moved to column 3 indicating no further study is needed and it will not be imaged during the 2nd run. I hope this all makes sense... :) patrick Run1 . Run2 . Dup . New 1530 . 1560 . 147 . 1265 6503 . 1530 . 185 . 1272 6643 . 1573 . 205 . 1275 6340 . 2146 . 221 . 1560 6412 . 2258 . 278 . 1569 6654 . 2441 . 812 . 1573 6395 . 2314 . 846 . 1961 6689 . 2655 . 891 . 2146 6434 . 2715 . 910 . 2253 6411 . 2748 . 1003 . 2258 6521 . 2634 . 1123 . 2273 6946 . 2523 . 1129 . 2314 6952 . 2732 . 1161 . 2320 6869 . 2633 . 1169 . 2337 6701 . 2646 . 1174 . 2340 6764 . 2591 . 1530 . 2344 6824 . 2551 . 7640 . 2347 205 . 2629 . . 2366 221 . 1569 . . 2403 185 . 2403 . . 2441 147 . 2366 . . 2460 278 . 1961 . . 2500 891 . 2273 . . 2523 1003 . 2460 . . 2537 812 . 2347 . . 2541 1129 . 2253 . . 2549 1123 . 2340 . . 2551 910 . 2320 . . 2552 846 . 2549 . . 2591 1161 . 2500 . . 2629 1169 . 2552 . . 2633 1174 . 205 . . 2634 6703 . 221 . . 2646 6702 . 185 . . 2655 6997 . 147 . . 2715 7640 . 278 . . 2732 . 891 . . 2748 . 1003 . 812 . 1129 . 1123 . 910 . 846 . 1161 . 1169 . 1174 . 1275 . 1272 . 1265 . 2344 . 2337 . 2541 . 2537 . 7640
A pencil works extremely well, especially for such a small data set. ;-)
Put this statement in C1 (assuming C1 is the first data cell in column C), =if(A:1 = B:1, A:1,"") then copy this formula down the entire column using Excel's copy /paste feature. (should auto adjust for cell names). Then in D1, =if(A:1 <> B:1, B:1,"") Then you copy this if statement in each of the cells in the D colum as above. :) Julie Clyde On Fri, Nov 18, 2011 at 7:11 PM, Chuck Hards <chuck.hards@gmail.com> wrote:
A pencil works extremely well, especially for such a small data set. ;-) _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php
Ha! Actually that's what I've been doing. Trouble is many of the lists are well over 100 numbers long so I'm thinking there just has to be a way of automating the process. patrick On 18 Nov 2011, at 19:11, Chuck Hards wrote:
A pencil works extremely well, especially for such a small data set. ;-)
Kind of reminds me of the fun (but false) story about NASA spending a mint to develop a writing instrument that would work in space while the Soviets solved the same problem by using pencils. patrick
I'm just giving you good natured grief. I work with Excel every day, from accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.com/~paw/temp/sample01.xls Column A has numbers from the first run and column B has numbers from the second run. The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D. Cheers, patrick
Which excel are you using, (i.e. 2003, 2007, 2010)? Depending on your version, I may have a solution... Jo Quoting Patrick Wiggins <paw@wirelessbeehive.com>:
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.com/~paw/temp/sample01.xls
Column A has numbers from the first run and column B has numbers from the second run.
The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D.
Cheers,
patrick _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php
Ignore that question, I sent you something that may work for you, no matter which Excel you have. Jo Quoting Josephine Grahn <bsi@xmission.com>:
Which excel are you using, (i.e. 2003, 2007, 2010)? Depending on your version, I may have a solution... Jo
Quoting Patrick Wiggins <paw@wirelessbeehive.com>:
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.com/~paw/temp/sample01.xls
Column A has numbers from the first run and column B has numbers from the second run.
The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D.
Cheers,
patrick _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php
_______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php
Here are formulas that will work for the problem as defined. There are also unique values in column A wich are not included in cols C & D C =IFERROR(INDEX($A$2:$A$55,MATCH(B3,$A$2:$A$55,0)),"") D =IF(C2="",INDEX($B$2:$B$55,MATCH(A2,$B$2:$B$55,0)),"") Copy the formulas to match Col B On Fri, Nov 18, 2011 at 11:53 PM, Josephine Grahn <bsi@xmission.com> wrote:
Ignore that question, I sent you something that may work for you, no matter which Excel you have. Jo
Quoting Josephine Grahn <bsi@xmission.com>:
Which excel are you using, (i.e. 2003, 2007, 2010)? Depending on your
version, I may have a solution... Jo
Quoting Patrick Wiggins <paw@wirelessbeehive.com>:
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from
accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.**com/~paw/temp/sample01.xls<http://users.wirelessbeehive.com/~paw/temp/sample01.xls>
Column A has numbers from the first run and column B has numbers from the second run.
The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D.
Cheers,
patrick ______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
-- Siegfried
Oops, Got ahead of myself Col D should be =IF(C2="",B2,"") On Sat, Nov 19, 2011 at 8:27 AM, Siegfried Jachmann <siegfried@jachmann.org>wrote:
Here are formulas that will work for the problem as defined. There are also unique values in column A wich are not included in cols C & D
C =IFERROR(INDEX($A$2:$A$55,MATCH(B3,$A$2:$A$55,0)),"")
D
=IF(C2="",INDEX($B$2:$B$55,MATCH(A2,$B$2:$B$55,0)),"")
Copy the formulas to match Col B
On Fri, Nov 18, 2011 at 11:53 PM, Josephine Grahn <bsi@xmission.com>wrote:
Ignore that question, I sent you something that may work for you, no matter which Excel you have. Jo
Quoting Josephine Grahn <bsi@xmission.com>:
Which excel are you using, (i.e. 2003, 2007, 2010)? Depending on your
version, I may have a solution... Jo
Quoting Patrick Wiggins <paw@wirelessbeehive.com>:
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from
accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.**com/~paw/temp/sample01.xls<http://users.wirelessbeehive.com/~paw/temp/sample01.xls>
Column A has numbers from the first run and column B has numbers from the second run.
The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D.
Cheers,
patrick ______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
-- Siegfried
-- Siegfried
participants (6)
-
Chuck Hards -
Josephine Grahn -
Julie Clyde -
Patrick -
Patrick Wiggins
-
Siegfried Jachmann