Tue Mar 28, 2006 4:06 am
Tue Mar 28, 2006 4:07 am
Elric wrote:After doing several of these, I'm noticing a mathematecal pattern
The highest dots are exactly 200 points apart, and are exactly aligned horozontally.
The middle dots are exactly 120 points apart, and are exactly aligned horozontally.
The lowest dots are exactly 40 points apart, and are exactly aligned horozontally.
For example:
12, 320
52, 290
92, 260
132, 260
172, 290
212, 320
That might help you guys get your stars better.
Tue Mar 28, 2006 4:08 am
Tue Mar 28, 2006 4:11 am
Tue Mar 28, 2006 4:15 am
Tue Mar 28, 2006 4:16 am
Tue Mar 28, 2006 4:18 am
Sylence wrote:thanks so much for that suggestion hon -goes to try-
Tue Mar 28, 2006 4:19 am
Tue Mar 28, 2006 4:32 am
c_shanholtzer wrote:Realized my earlier post was kind of unclear so to sum it up a bit better (if you can see it on the starmap that way is faster, but...):
pre-step: Make sure you've visited the tomb door and then the lenny archivist.
Step 1: http://www.neopets.com/altador/astro.phtml?get_star_data=1
Step 2: Copy this and paste into MS Word. Replace | with ^p then , with ^t.
Step 3: Copy into Excel and select all. Then use data->sort and sort the whole thing using column B, doesn't matter ascending or descending.
Step 4: Look for areas where Column B has identical values. Now check Column A to see if the difference in X values is 200, 120, or 40. There's a good chance this star is in your constellation.
Step 5: Go to your telescope and find this star. Be amazed as the rest of the constellation pops out at you;)
Tue Mar 28, 2006 4:35 am
Tue Mar 28, 2006 4:36 am
Katy wrote:c_shanholtzer wrote:Realized my earlier post was kind of unclear so to sum it up a bit better (if you can see it on the starmap that way is faster, but...):
pre-step: Make sure you've visited the tomb door and then the lenny archivist.
Step 1: http://www.neopets.com/altador/astro.phtml?get_star_data=1
Step 2: Copy this and paste into MS Word. Replace | with ^p then , with ^t.
Step 3: Copy into Excel and select all. Then use data->sort and sort the whole thing using column B, doesn't matter ascending or descending.
Step 4: Look for areas where Column B has identical values. Now check Column A to see if the difference in X values is 200, 120, or 40. There's a good chance this star is in your constellation.
Step 5: Go to your telescope and find this star. Be amazed as the rest of the constellation pops out at you;)
I'm stuck on Step 3... how do I copy into Excel and have it actually show up in three columns instead of just as an unholy, unsortable mess?
Tue Mar 28, 2006 4:40 am
Tue Mar 28, 2006 4:41 am
AngelFoxBlue wrote:Step 2 sorts the data into a table in Word. If this has been done correctly, the information will automatically paste into columns in Excel, rather than all into a single cell.
Tue Mar 28, 2006 4:48 am
Tue Mar 28, 2006 4:50 am