Welcome to my Excel page. Below you will find links to Excel workbooks that have been created to automate various tasks. Most of these contain macros. I hope you enjoy them. If you have any questions or comments, please feel free to contact me.
| File Name | Description |
|---|---|
| Account Register 08_26_08.xls | Maintain and balance a checking account |
| Attendance History_09_17_08.xls | Maintain an annual attendance for up to 50 employees. |
| Baseball Lineup 08_01_08.xls | Make a baseball lineup |
| Basic Math Problems 12_23_05.xls | Generate random math problems. Accommodates various skill levels |
| Basic Math Problems Instructions.xls | Download and print these instructions for the file above |
| CalendarPersonal Instructions.xls | Instructions for the calendar below |
| CalendarPersonal_3-5_N.xls | Enter personal anniversary and birth dates, select various U.S. holidays |
| DataSort12x1000.xls | Small database, 12 columns by 1000 rows. Sort and filter data |
| Gantt_Chart_Using_Conditional_Formatting.xls | Has start & end events, start & dwell and start & end dates |
| Handy 03_11_09.xls | Assorted helpful worksheets. Example: Trig, Loan Payments, Tap Drill, etc. |
| Personnel Timesheet 08-12-07.xls | Calculates hours and wages for a week. Generates Shift, Group and Job Reports |
| RFQ_Master_05_17_07.xls | Setup for each vendor. Add parts info then complete master RFQ from drop downs. Maintains a history |
| Statistical Analysis_10_08_06.xls | Check the reliability of a process using "K" factors. Cp, Cpk & Cpm can be calculated to check process capability. |
| Sudoku Help 11_20_06.xls | Assistance for solving Sudoku puzzles |