Jump to content


Messier & Herschel 400 CheckList in Excel


Recommended Posts

An excel file is attached with the checklists for both Messier and Herschel 400 objects.

On Sheet 1: Totals.

On Sheet 2: Messier Checklist

On Sheet 3: Herschel 400 Checklist

You only have to fill in the "Date Observed" column on each check list and the totals page will auto update. You can also use standard Excel filters to filter each column by value or order by a column. It's useful if you wan't it ordered by constellation, list number, NGC, etc..

If you like it feel free to use it. :headbang:

PS-> I copy pasted the values from some html tables I googled last week. I only organized stuff and did some quick formulas. I would like to give credit to whoever put the tables togheter but I didn't save the links. :D

EDIT: Use the version 4 posts bellow if you want Caldwell too without bugs. Or click here.

Edited by pvaz
Link to comment
Share on other sites

Your Welcome! :D

Found a bug on the Caldwell catalog table.:headbang:

When you reordered by a column the "Date Observed" values wouldn't be attached to the rest of the columns witch kind of defeat the purpose.

Corrected now:

Link to comment
Share on other sites

  • 1 year later...
  • 1 month later...
  • 2 months later...
Bit of an old thread, but like the above poster I wondered if anyone had the link as it's broken?


I too would like the link but it does not seem to be working although i have this one which i will be printing to use with my bins.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. By using this site, you agree to our Terms of Use.