Hi there.
Another silly question for the day.
<tbody>
A
B
C
D
1
Date
Low Tide
High Tide
Moon
2
1/2/18
06:30
13:00
Full
3
2/2/18
07:15
13:45
1 Day Past Full
4
2/2/18
</tbody>
Take for instance the above table, As an example i have entered into A3 and A4 the same dates, Obviously...
Could you direct me toward some class modules (VBA or VB) to calculate the moon ( and planets ) rise set altitude azimuth for locations ( Lat, Lng, Elevation ).
Most I can find are about 1998 models using UDF 's on worksheets.
Need to graphically present these for high school students.
Need some modern Excel functions for science students and astronomy. On www there are a multitude of UDF that calculate astronomical values. Most of these use an index and repeat the same pre calculation three times to get information like x y z or radius theta phi ... and repeat the same 3...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.