| 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? | |
| Excel Diabetic Log with Marcros | Excel 2003 log book for diabetic and blood pressure information. File is zipped. Uses macros (Excel VBA), I found on web, some I adjusted, might even be one I wrote. Feel free to copy anything in the file. Original sources are listed for some macros. Made some changes & corrections: Oct 13 2012. | |
| Excel Diabetic Log WITHOUT Macros | Same log without the macros. Not as fancy but works. No spreadsheet, try Gnumeric its free, portable (can use on a USB stick) and small. File and Gnumeric will fit on the smallest of USB sticks. Gnumeric is 71MB installed. Made some changes & corrections: Oct 13 2012. | |
| 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, & More |
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. | |
| Weather with VBA | Excel file for a few simple weather calculations. Fahrenheit to Celsius, and back, have a VBA function, if you choose to use them, see Module: Weather in VBA Editor. Some functions require analysis pack. | |
| 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. | |
| John Walkenbach |
List of free workbook and addins (with and without macros) demonstrate useful techniques in Excel, most by John Walkenbach. Excelent! | |