Go Back   IceInSpace > Beginners Start Here > Beginners Talk

Reply
 
Thread Tools Rating: Thread Rating: 7 votes, 4.57 average.
  #61  
Old 18-12-2008, 12:19 PM
drahyrt's Avatar
drahyrt (Steve)
Registered User

drahyrt is offline
 
Join Date: Nov 2008
Location: Port Macquarie
Posts: 15
Thanks Glen, I am appreciating you sharing this resource, just got my nokkies today, and love the excell workbooks and log, incredible.
An old thread but a great one!
Reply With Quote
  #62  
Old 19-12-2008, 03:56 AM
glenc's Avatar
glenc (Glen)
star-hopper

glenc is offline
 
Join Date: Jun 2005
Location: Terranora
Posts: 4,311
Images of 100+ DSO

This link will take you to images of 140 DSO including the original 95 Easy DSO.
http://picasaweb.google.com.au/dunlo...hernObservers#
Slide the bar at the top right for larger images or click on Slideshow.
The images were made using http://www.wikisky.org/

Last edited by glenc; 19-12-2008 at 04:37 AM.
Reply With Quote
  #63  
Old 19-12-2008, 04:08 PM
wasyoungonce's Avatar
wasyoungonce (Brendan)
Certified Village Idiot

wasyoungonce is offline
 
Join Date: Jul 2006
Location: Mexico city (Melb), Australia
Posts: 2,336
Conversion of decimal to DMS and back again

Quote:
Originally Posted by glenc View Post
Here is a file combining a list, a "map" and a log for recording 95 bright deep sky objects for southern observers.
Actually I'm pleased you posted this excel sheet giving coordinates in decimal or DMS spread across more than one cell. The document posted is excellent but it always bugs me with coordinates in decimal format or converted to DMS format across many cells.

I am just putting the final touches to excel formula's and macros that do these coordinate conversions in one Excel cell.

That is convert RA (or DEC) Decimal to HMS (or DMS) by applying a cell formula or Macro. Or to reverse the process ...if needed by formula or macro.

I originally wrote Macros to do this and they work well, but, I decided to try to write cell formulas to accomplish the same. There was/is very little on the internet for this type of thing and many of what is there does not do the task correctly.

Anyway, trying to write excel formulas for this was a "Big" task, especially for a novice like me. Many months later I finally have them done...a definite labour!

The excel formulas are ready to go now. I'm just checking/tweaking the Macros as I haven't really touched these for a few months. They'll be done very soon.

I'll post a "How to use these" as an article very soon (Iceman permitting)...but if anyone wants to try them out...feel free..I'll send you the data!
Reply With Quote
  #64  
Old 19-12-2008, 04:30 PM
glenc's Avatar
glenc (Glen)
star-hopper

glenc is offline
 
Join Date: Jun 2005
Location: Terranora
Posts: 4,311
I use decimal because it is better for mapping.
Reply With Quote
  #65  
Old 19-12-2008, 05:18 PM
wasyoungonce's Avatar
wasyoungonce (Brendan)
Certified Village Idiot

wasyoungonce is offline
 
Join Date: Jul 2006
Location: Mexico city (Melb), Australia
Posts: 2,336
Quote:
Originally Posted by glenc View Post
I use decimal because it is better for mapping.

Fair enough. I was unaware as to why people use decimal degrees. Insert "I am an idiot tag" here!

But...that means you'll love my Excel formula and macros to automate conversion in the one cell to and fro DD and DMS.
Reply With Quote
  #66  
Old 19-12-2008, 05:37 PM
glenc's Avatar
glenc (Glen)
star-hopper

glenc is offline
 
Join Date: Jun 2005
Location: Terranora
Posts: 4,311
If you want hm and dm see here:http://www.iceinspace.com.au/forum/s...ad.php?t=38919

Last edited by glenc; 19-12-2008 at 11:53 PM.
Reply With Quote
  #67  
Old 19-12-2008, 06:23 PM
wasyoungonce's Avatar
wasyoungonce (Brendan)
Certified Village Idiot

wasyoungonce is offline
 
Join Date: Jul 2006
Location: Mexico city (Melb), Australia
Posts: 2,336
Quote:
Originally Posted by glenc View Post
Thanks, I don't really need the conversions, I applied my own DD to DMS conversions using my Macros way back when there was a list for 100 Brightest Southern Objects (in the Articles page). But this has all now now changed to 100Galaxys, 111Brightest NGC objects etc.

The original data had coordinates in Decimal Degrees so I played around with Macros to convert these to DMS.

Here is a typical example of the formula (in the 2nd column) converting DEC DD to DMS:

Edit...my post went funny so I uploaded a excel sheet with formulas.

Edit:

grumble I keep mucking the upload up...finally here it is in Zip.
Attached Files
File Type: zip Book2.zip (9.6 KB, 37 views)

Last edited by wasyoungonce; 19-12-2008 at 06:31 PM. Reason: Upload not working!
Reply With Quote
  #68  
Old 05-11-2012, 01:16 AM
Suzy's Avatar
Suzy
Searching for Travolta...

Suzy is offline
 
Join Date: Jan 2010
Location: Brisbane, Australia.
Posts: 3,700
Bump!

This thread is too good to be buried and forgotten.
A great list of targets there Glen, thank you so much!
I will print them out and pop them into my observing folder.
Reply With Quote
  #69  
Old 05-11-2012, 03:28 AM
glenc's Avatar
glenc (Glen)
star-hopper

glenc is offline
 
Join Date: Jun 2005
Location: Terranora
Posts: 4,311
Thanks Suzy.
Here is the "map" https://picasaweb.google.com/1100488...11344794121746
M46 should be on the list to.
Reply With Quote
  #70  
Old 05-11-2012, 09:14 AM
deanm (Dean)
Registered User

deanm is offline
 
Join Date: Sep 2010
Location: Adelaide
Posts: 817
Super!

Many thanks, Glen!

I copied + pasted your 5 lists into MS Word, increased font size, added a 40 % transparent layer of red over the lot, emailed it to myself then uploaded on iPhone.

Now I have a easy-to-read, night eye-friendly list without needing torches, soggy sheets of paper and the like.

Cheers!

Dean

Last edited by deanm; 05-11-2012 at 09:15 AM. Reason: Spulling!
Reply With Quote
Reply

Bookmarks

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time is now 12:11 PM.

Powered by vBulletin Version 3.8.7 | Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Advertisement
Testar
Advertisement
Bintel
Advertisement