Moonrise/Moonset formula

[Ormus]

I have found the VBA code that I can do sunrise/sunset, but have not been able to locate one for moonrise/moonset.

Thanks

 

[Matt Rogers]

Hi.

Look this:
http://www.mrexcel.com/forum/showthread.php?t=440548

 

[Ormus]

Yah I saw that post earlier but does not give or direct to where the macro would be. I have the moon phase working, that is easy, but am needing the moonrise and moonset time based on your lat/lon. kd4dna posted on that thread that he had made the script, but did not post it.

 

[gsbelbin]

You may not find one specifically written in VBA so I searched for algorithms for this. If you look for the algorithm you may find a description of how to code it or possibly find it in another language that you can convert. Using this approach I found this site (http://aa.usno.navy.mil/faq/docs/rs_algor.php) which refers to another (http://www.skyandtelescope.com/resources/software/3304911.html) and says that there is a BASIC program for doing this called MOONUP.BAS. Unfortunately it's not listed there any more. However these sites may give you other leads.

Good luck!

 

[Matt Rogers]

Maybe you can import this:



http://aa.usno.navy.mil/data/docs/RS_OneDay.php