Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 33
Like Tree74Likes

Thread: Messier Logging Spreadsheet and Wiki Tool

  1. #11
    bladekeeper's Avatar
    bladekeeper is offline Super Moderator
    Points: 297,078, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 100.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!200+ Posts Achievement!
    Awards:
    Activity Award
    Join Date
    Aug 2014
    Location
    Lowell, Arkansas, USA
    Posts
    38,160
    Points
    297,078
    Level
    100
    Thanks
    28,705
    Thanked 17,409x 11,899 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool



    Quote Originally Posted by TheFatKitty View Post
    Nice, Bryan, you certainly thought that through. I have to say, I have been wanting to at least start this, but the weather has just not been good. Now I have no excuse Seriously, well done; a whole lot easier than a template in notepad or even Word. I'll use this for sure! Your post was easy to follow; good pics, step by step; it would be worth printing out to make following the steps the first few times easier.

    Just as a note, I read your post and my computer was in Linux Mint 18.1, your XLS file opened fine in LibreOffice, and I gave all your steps a trial run (no submission). So as well as Windows, it Works in Linux. Ya done good

    Thanks again for that; if the weather holds I too may have some Messier awards to chase!
    Mark
    Sweet! Thanks Mark! Nice to know this works with Linux as well.

    Good luck on your Messier journey! I am looking forward to following along!
    TheFatKitty likes this.
    Bryan
    Scopes: Apertura AD12 f/5; Celestron C6-R f/8; ES AR127 f/6.4; ES AR127 f/9.4; Stellarvue SV102T f/7; ES AR102 f/9.8; iOptron MC90 f/13.3; Orion ST80A f/5; Celestron Premium 80 f/11.4; Celestron C80 f/11.4; Meade NG60 f/10
    Mounts: Celestron AVX; Bresser EXOS-2; ES Twilight I; ES Twilight II; iOptron Cube-G; AZ3/wood tripod; Vixen Polaris
    Eyepieces: GSO Super Plössl 40mm, 32mm, 15mm, 9mm; ES 82° Series; GSO Superview 30mm; Celestron Plössl 26mm, 20mm; ES 70° 25mm; ES Plössl 25mm; Vite Aspheric 23mm, 10mm, 4mm; Orion Expanse 20mm, 9mm; KK Ortho 18mm, 12.5mm; Bresser 70° 15mm; Coulter Optical 12.5mm; BCO 10mm; ES 62° 9mm; Zhumell Z Series 5mm
    Binoculars: Pentax PCF WP II 10×50, Bresser Corvette 10×50, Bresser Hunter 16×50 and 8×40, Garrett Gemini 12×60 LW, Gordon 10×50, Apogee 20×100

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.


    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.

    Galaxy Hunter's Creed - When you play whack-a-mole, sometimes you hit 'em on the head, sometimes you miss 'em. But its always fun to play, and if you don't play, you ain't gettin no moles! - KT4HX

  2. The Following User Says Thank You to bladekeeper For This Useful Post:

    TheFatKitty (10-02-2017)

  3. #12
    bobharmony's Avatar
    bobharmony is offline HYPER GIANT
    Points: 34,729, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 12.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!Blogger Achievement!
    Join Date
    Dec 2015
    Location
    Connecticut USA
    Posts
    6,035
    Points
    34,729
    Level
    100
    Thanks
    1,427
    Thanked 2,239x 2,141 Posts
    Blog Entries
    15

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    That's nice Bryan... now can you script something for the AP award that sets up the scope, captures and post processes the images, and makes the appropriate entries in the forum topic page? . Seriously, i think this is a very nice help for the visual folks, thanks for taking the time to put it together..

    Bob
    Hardware: Celestron C6-N w/ Advanced GTmount, Baader MK iii CC,
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    ST-80, Canon 60D (unmodded), Orion SSAG

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    : BYE, PHD2, DSS, PhotoShop CC 2017, StarTools, Cartes du Ciel, AstroTortilla
    visit my
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    blog:
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    href="http://clearoutside.com/forecast_image_small/41.70/-72.67/forecast.png" rel="lightbox[signatures]">
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.

  4. The Following User Says Thank You to bobharmony For This Useful Post:

    bladekeeper (10-02-2017)

  5. #13
    bladekeeper's Avatar
    bladekeeper is offline Super Moderator
    Points: 297,078, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 100.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!200+ Posts Achievement!
    Awards:
    Activity Award
    Join Date
    Aug 2014
    Location
    Lowell, Arkansas, USA
    Posts
    38,160
    Points
    297,078
    Level
    100
    Thanks
    28,705
    Thanked 17,409x 11,899 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Quote Originally Posted by bobharmony View Post
    That's nice Bryan... now can you script something for the AP award that sets up the scope, captures and post processes the images, and makes the appropriate entries in the forum topic page? . Seriously, i think this is a very nice help for the visual folks, thanks for taking the time to put it together..

    Bob
    Thanks Bob! I'm sure SGP would be more than capable.
    bobharmony likes this.
    Bryan
    Scopes: Apertura AD12 f/5; Celestron C6-R f/8; ES AR127 f/6.4; ES AR127 f/9.4; Stellarvue SV102T f/7; ES AR102 f/9.8; iOptron MC90 f/13.3; Orion ST80A f/5; Celestron Premium 80 f/11.4; Celestron C80 f/11.4; Meade NG60 f/10
    Mounts: Celestron AVX; Bresser EXOS-2; ES Twilight I; ES Twilight II; iOptron Cube-G; AZ3/wood tripod; Vixen Polaris
    Eyepieces: GSO Super Plössl 40mm, 32mm, 15mm, 9mm; ES 82° Series; GSO Superview 30mm; Celestron Plössl 26mm, 20mm; ES 70° 25mm; ES Plössl 25mm; Vite Aspheric 23mm, 10mm, 4mm; Orion Expanse 20mm, 9mm; KK Ortho 18mm, 12.5mm; Bresser 70° 15mm; Coulter Optical 12.5mm; BCO 10mm; ES 62° 9mm; Zhumell Z Series 5mm
    Binoculars: Pentax PCF WP II 10×50, Bresser Corvette 10×50, Bresser Hunter 16×50 and 8×40, Garrett Gemini 12×60 LW, Gordon 10×50, Apogee 20×100

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.


    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.

    Galaxy Hunter's Creed - When you play whack-a-mole, sometimes you hit 'em on the head, sometimes you miss 'em. But its always fun to play, and if you don't play, you ain't gettin no moles! - KT4HX

  6. #14
    bbird826's Avatar
    bbird826 is offline White Dwarf
    Points: 1,163, Level: 19
    Level completed: 63%, Points required for next Level: 37
    Overall activity: 0%
    Achievements:
    2 Posts Achievement365 Days+ Registered Achievement!750 Days+ Registered Achievement!First 1000 Experience Points
    Join Date
    Jul 2017
    Location
    Springfield, mo
    Posts
    5
    Points
    1,163
    Level
    19
    Thanks
    0
    Thanked 0x 0 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Can we use our records from last century? I used to keep track of my messier views and still have the notebook that I used. I've never applied for any awards, sounds pretty cool to do. Thanks for the online spreadsheet, now to copy my paper to electrons.
    Lowjiber and bladekeeper like this.

  7. #15
    Gabby76's Avatar
    Gabby76 is offline Super Moderator
    Points: 78,318, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 85.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!Gallery Achievement!Album Achievement!50 Posts Achievement!
    Join Date
    Jan 2016
    Location
    Live: Slovakia Work: Canada
    Posts
    18,170
    Points
    78,318
    Level
    100
    Thanks
    3,412
    Thanked 5,717x 4,800 Posts
    Blog Entries
    4

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    As far as I know if you have all the required information then you are good to go
    Lowjiber and bladekeeper like this.
    Refractors: Antares 105 f/15, Celestron 150 f/8, Stellarvue NHNG 80 f/6.9, TAL 100RS f/10, TS 102 f/11, UR 70 f/10, Vixen SD115s f/7.7
    Mounts: Celestron SLT w/ pier mod & EQ-3 tripod, Celestron hypertuned CG-5 w/ tracking motor & Argo Navis, Manfrotto 028B w/ Stellarvue M2C, Manfrotto 055PRO w/ 128RC, TAL-1 HD EQ, Vixen SXP w/ HAL-130 SXG & half pier Diagonals: 2" Astro-Physics MaxBright, 2" Zeiss/ Baader prism, 2" Baader Herschel Wedge (Photo Version), 2"
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    Amici prism, 2" Stellarvue Dielectric, 2" TeleVue Everbrite Eyepieces: A-Z

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.

    The weakest link in the optical chain is the large nut located directly behind the
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    / camera. - Gabrielle

    Ya gotta keep this Apo/
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    thing in some balance of perspective. Apos are awesome, but long focus Achros aren't that far behind them - Siriusandthepup (CN)

    Refractors kick arse precisely because they don't hide behind excuses. That is, they have no obstructions to hide behind. - Jon Isaacs (CN)

  8. #16
    MikeWest's Avatar
    MikeWest is offline Light Pollution Attractor
    Points: 11,582, Level: 74
    Level completed: 44%, Points required for next Level: 168
    Overall activity: 0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!365 Days+ Registered Achievement!
    Join Date
    Jan 2015
    Location
    Skylands/Sussex Area New Jersey USA
    Posts
    965
    Points
    11,582
    Level
    74
    Thanks
    122
    Thanked 257x 209 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Great job Bryan! Anything to make it a little easier to participate.

    Clear skies!
    bladekeeper likes this.
    So many trees in NJ!

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    Celeron C8 S XLT | Celeron CR 150HD |
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    120ST | Dörr Danubia
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    200
    | Orion XT8i | Orion GoScope II
    SW NEQ6 Pro | Cel CG5 ASGT | Dörr EQ-5 | TS AZ5 | SW AZ3
    Weather Station - https://goo.gl/6z4yR1 /
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    -
    https://goo.gl/sy0wCg

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    count - 82/110, Caldwell count - 16/109, Herschel count - 18/400
    NJ USA
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.

  9. The Following User Says Thank You to MikeWest For This Useful Post:

    bladekeeper (10-05-2017)

  10. #17
    Macrob1's Avatar
    Macrob1 is offline SUPER GIANT
    Points: 5,923, Level: 52
    Level completed: 87%, Points required for next Level: 27
    Overall activity: 4.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!50 Posts Achievement!5 Threads Achievement!200+ Posts Achievement!
    Join Date
    Feb 2017
    Location
    Melbourne, Australia
    Posts
    1,140
    Points
    5,923
    Level
    52
    Thanks
    411
    Thanked 258x 239 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Quote Originally Posted by bladekeeper View Post
    So my thought was, if one begins logging their Messier observations on the spreadsheet from the onset, the spreadsheet will then format the data in the proper manner to easily copy and paste to the appropriate wiki page.

    This way, you only have to keying your data one time.

    Fact is, participation in the Messier visual awards program has been down this year. Some of that is due to poor observing conditions, some due to lack of interest altogether, and for some folks, the wiki entry part of the qualification turns into a chore, i.e. too much work. My thought here was to alleviate some of the burden on the participants.
    Excellent idea imho. The Southern Sky Challenge is certainly less burdensome from the data gathering and reporting perspectives. So i'll continue on my Messier quest.

    Cheers
    bladekeeper likes this.
    Bob


    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    :

    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    Star Discovery Mak 127 + SW 9x50 RACI on SynScan alt/az go-to mount; Saxon ST80; Bintel (GSO) 8" dob Eyepieces: SW kit 25mm, Starguider Dual ED 8mm and 15mm, SW 19mm flat field, SW 32mm Plossl, Vixen NLV 20mm, Svbony 12.5 mm illuminated reticle Barlows: SW 2x, Celestron Omni 2x Binoculars: Acuter 15x70, Olympus 10x50 DPSI

  11. The Following User Says Thank You to Macrob1 For This Useful Post:

    bladekeeper (10-06-2017)

  12. #18
    Peter802's Avatar
    Peter802 is offline HYPER GIANT
    Points: 16,935, Level: 89
    Level completed: 96%, Points required for next Level: 15
    Overall activity: 0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!50 Posts Achievement!5 Threads Achievement!365 Days+ Registered Achievement!
    Join Date
    Feb 2016
    Location
    United Kingdom. At present in Germany.
    Posts
    4,298
    Points
    16,935
    Level
    89
    Thanks
    703
    Thanked 1,427x 1,403 Posts
    Blog Entries
    1

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Great job Bryan.
    Thank you for taking time out to post this.
    Makes my log look a little primitive.
    Clear skies.
    bladekeeper likes this.
    Peter.


    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    : Bresser AR-127S 635mm. Celestron Travel
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    70. Mount: Bresser EXOS - 2 modified to belt drive and AstroEQ mount controller.
    Cameras: Un modded Canon 450D.
    Bino's: Nikon Aculon A211. 16x50 4.2 degs.

  13. The Following User Says Thank You to Peter802 For This Useful Post:

    bladekeeper (10-06-2017)

  14. #19
    Ben Cartwright SASS's Avatar
    Ben Cartwright SASS is online now Gold Supporter
    Points: 34,225, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 9.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!200+ Posts Achievement!
    Join Date
    Jul 2015
    Location
    S/E Massachusetts
    Posts
    2,680
    Points
    34,225
    Level
    100
    Thanks
    4
    Thanked 601x 408 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    Bryan,
    I just finished and received the M70 award and have one Messier towards the 110. I have been using Excel but only in a rudimentary way not like this. This is really sharp

    Do I have to go back and input all my data into this new spreadsheet manually, or do I only fill it out for 71-110? Winter is coming so most weekends I will be trapped inside by the snow and cold and may have time to input the data.
    bladekeeper likes this.
    Home obs pad has Bortle 7.5-8.0 sky, Lunt LS80DS, LS50DS, Quark Chromosphere
    Cameras: ZWO ASI071MC ASI120MC ASI120MM-S ASI174MM ASI174MM-cool ASI178MC-cool; Skywatcher EQ6-R, Orion Skyview PRO EQ
    Scopes: Celestron: EDGE 8" HD, 1998 Nexstar 5, XLT120, XLT102AZ, SW: ED100 APO, 102 Mak, SV: SV80ST APO, Orion: ST80, 120ST, 127 Mak,
    website
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    page: https://www.jeffpadellphotography.com

  15. The Following User Says Thank You to Ben Cartwright SASS For This Useful Post:

    bladekeeper (10-06-2017)

  16. #20
    Ben Cartwright SASS's Avatar
    Ben Cartwright SASS is online now Gold Supporter
    Points: 34,225, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 9.0%
    Achievements:
    2 Posts Achievement20 Posts Achievement!5 Threads Achievement!50 Posts Achievement!200+ Posts Achievement!
    Join Date
    Jul 2015
    Location
    S/E Massachusetts
    Posts
    2,680
    Points
    34,225
    Level
    100
    Thanks
    4
    Thanked 601x 408 Posts

    Default Re: Messier Logging Spreadsheet and Wiki Tool

    one comment on the spreadsheet, I use military time 2200 hrs, you use that but put it as 22:00, there is no such time it is either 10:00 pm or 2200

    I will see about changing that column for my use. I will find some time to go back and copy from my spreadsheet to this one. I may ask a guy at work who knows excel about copying from one sheet to the other, at least for the common columns, even if they are in different positions
    bladekeeper likes this.
    Home obs pad has Bortle 7.5-8.0 sky, Lunt LS80DS, LS50DS, Quark Chromosphere
    Cameras: ZWO ASI071MC ASI120MC ASI120MM-S ASI174MM ASI174MM-cool ASI178MC-cool; Skywatcher EQ6-R, Orion Skyview PRO EQ
    Scopes: Celestron: EDGE 8" HD, 1998 Nexstar 5, XLT120, XLT102AZ, SW: ED100 APO, 102 Mak, SV: SV80ST APO, Orion: ST80, 120ST, 127 Mak,
    website
    To view links or images in signatures your post count must be 5 or greater. You currently have 0 signatures.
    page: https://www.jeffpadellphotography.com

 

 
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. Who made that excell spreadsheet for messier objects?
    By UlteriorModem in forum Astronomy Beginners Forum
    Replies: 9
    Last Post: 03-05-2016, 03:25 PM
  2. Messier objects vs eyepiece spreadsheet
    By evilfer in forum Telescope Eyepieces Forum
    Replies: 28
    Last Post: 08-21-2014, 06:46 AM
  3. Free logging tool Observation Manager
    By Doergn in forum Astronomy Software Forum
    Replies: 16
    Last Post: 01-17-2012, 07:24 AM
  4. Free logging tool: Observation Manager
    By Doergn in forum Astronomy Software Forum
    Replies: 0
    Last Post: 03-13-2010, 12:50 PM
  5. Free and open logging tool - Observation Manager
    By Doergn in forum Astronomy Software Forum
    Replies: 1
    Last Post: 11-09-2009, 10:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin® Version 4.2.0
Powered by vBulletin®
All times are GMT. The time now is 10:35 AM.