Astronomy functions as class modules

HarryS

Board Regular
Joined
May 2, 2008
Messages
211
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 calculation fully if already calculated information is needed. Is there some classes written to calculate these as types with a Boolean to avoid recalculation. I have searched for these astronomy functions put into class modules for modern VBA.. Many of the UDF are adjusted Q basic or earlier. Can any one point me in the direction of a source of these.. Graphics showing earth moon sun moon phases etc as shapes are too slow when the calculations are repeating .
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Similar threads

Forum statistics

Threads
1,176,514
Messages
5,903,486
Members
435,032
Latest member
crone123456

We've detected that you are using an adblocker.

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.
Go back
Top