| Zipped | ||
|
M
I S C |
Mortgage | Calculate monthly, semi-monthly, etc. mortgage. VBA used to print. Version 10/25/2002 |
| Social Security | When will regular retirement benefits exceed early retirement benefits? | |
| S U N R I S E |
Sun Rise & Set Times | Calculates sun rise and set times for civil, nautical, and astronomical sun rise and sun set. |
| Sun Rise - Set - Path & Charts | Calculates sun rise and set times. Charts show today’s path and current position. Includes civil, nautical, & astronomical rise & set from above. Revision: September 2, 2009 | |
| Original Sunrise | As above with a few additional calculations. NOTE: Chart Input macro can run very slow. | |
| TIME & DATE |
Time and Date Formats | Use VBA to enter time or date without format, converts to AM/PM time or military time, and to formatted date (123105 = 12/31/2005). |
| Calendar | Pop-Up calendar. Zip contains both xls & xla (add-in). Right click for calendar, click date to fill in cell. Choice of formats. | |
| H E L P |
Excel Functions | Here a spreadsheet covering almost all excel functions, with examples. Was available on web, but site seems to have disappeared. |
| Excel 200 Colors | Color chart and 2 VBA color functions. | |