237 clusters, nebulae and galaxies

[glenc]

The attached list contains 237 clusters, nebulae and galaxies.
There are 51 OC, 50 GC, 46 PN and 90 Gxy, all south of declination +60.
Mostly they are the brightest objects of each type, including 75 Messier objects.

The columns are
Name, M: NGC, IC and M number. (M 3-6 is PNG 253.9+05.7)
Type: OC, GC, PN, Gxy, (no nebula).
Con: Constellation.
Mv: Visual magnitude.
Size': Size in arc minutes.
RA, Dec: RA and declination (2000).
Rank: The brightest object for each type is ranked 1 etc.
Season: Southern season at 10pm (11pm DST).

There are 87 autumn objects, including 55 galaxies.
Galaxies peak in autumn. OC, GC and PN peak in winter.

The attached tab delimited file can be copied to MS Excel and sorted.

[DobDobDob]

Thanks Glen, much appreciated :thumbsup:

[danielsun]

Excellent stuff Glen, very handy!:thumbsup:
That will keep me occupied for a while.:)

Thanks.

[glenc]

The objects were ranked by magnitude before the northern objects were left out. This means there is no galaxy ranked 6 and no PN ranked 6 because M81 and N6543 are both north of dec +60. etc
References:
OC from Lynga 1987. M45 is #1
GC from Harris 2003. Omega Cen is #1
PN from Kent Wallace and Acker+ 1992. M27 is #1
Gxy from de Vaucouleurs+ 1991. LMC is #1

[glenc]

Some Bright Summer Objects.
OC: M45 2264 2362 2451 2516
GC: 1851 M79
PN: IC418 2392 2440
Gxy: LMC 1291 1316

Some Bright Autumn Objects.
OC: 3114 3532 4755
GC: 2808 5139 M3
PN: 3242 3918 5189
Gxy: M104 5128 M83

[Starkler]

I spent some time on this file trying to massage it into a form to be usable in the argo navis. The problem is the RA in decimal hours and I cant think how to get excel to do the conversion to hh:mm :(

[Gargoyle_Steve]

You should be able to extract & mod the relevant calcs from my excel convertor for lat & long here -
http://www.iceinspace.com.au/forum/showthread.php?t=17683


if: Cell A1 = R.A. in decimal hours

Cell A2 = Hours (only) =INT(A1)
Cell A3 = Minutes (decimal) =A1-INT(A1)*60

or if you want Hrs, Mins and Secs separated:

A3(minutes) = INT((A1-INT(A1))*60)
&
A4(seconds) = (((A1-INT(A1))*60)-A3)*60

[Starkler]

Thanks Steve thats good for a one-off calc but I need to convert a whole column of hh.hhh to hh:mm:ss inserting the colons and hoping to not have to do it manually :doh:
Thanks for the formula help , a little more work in excel and search/replace in text and ill get there.

Glenc does your list generator have an option of outputting RA in hh:mm:ss or even hh:mm.mm ?

[Ric]

Thanks Glen for the list, that should give me plenty to look at and image over the coming months.

Cheers

[ballaratdragons]

Thanks Glen,

The first list (NGC, IC, M,) will be great for the Synscan :thumbsup:

[Gargoyle_Steve]

Ken what I'd do is put Glen's original data in an Excel spreadsheet, then using his decimal RA column as the reference field add the extra cells with formula as above, then simply copy and paste downwards from there to add the formula with new reference field to each line of data .....

Ah forget it - here it is, completed
;)

2 files - one has converted RA(decimal) to Hrs & Mins, the other converted to Hrs, Mins & Secs.

Hope you find it useful!

[glenc]

I tend to think that hrs mins secs are archaic like pounds shillings and pence but I do use both. ;)

[Starkler]

Well I finally did it, and learned a few things about excel along the way ;)

Here is an argo-navis ready version. The fields size, rank and season are merged into the comment field of the AN.

Just upload with argonaut with the serial cable and away you go.

[glenc]

The list of 237 clusters, nebulae and galaxies is part of a list of 635 objects. See post #9 in:
http://www.iceinspace.com.au/forum/showthread.php?t=12801&highlight=ranked