Time Tracking Template for Excel

Consultants and sub-contractors often need a way to log hours worked differently than regular employees. This time tracking template was designed to help consultants log hours worked and bill for those hours, keeping track of what hours have already been billed.

New Vehicle Maintenance Log Template

This new Vehicle Maintenance Log came about due to a recent request from a Vertex42 Facebook fan. It lets you record the maintenance history and repairs for your vehicle(s). You can also use it to list the manufacturer's recommended maintenance schedule.

Business Mileage Tracking and Reimbursement

If you use a vehicle for business use, then you may be able to deduct mileage expenses on your tax return. To do that, you'll need to keep certain records. Vertex42's new Mileage Tracking Log can help you keep the mileage records as well as calculate the reimbursement amount.

Reward Chart Templates

Download a few different types of Reward Charts for your kids, including a simple reward chart as shown in the image, a practice chart, school behavior chart, and a weekly reward chart for multiple kids.

Immunization Schedules and Vaccination Record

Have you had a new child recently? You can find a recommended immunization schedule on the CDC website. If you want to keep an electronic record of vaccinations for you and your children, download this new Immunization Record for Excel.

Golf Score Log

This Golf Score Log spreadsheet lets you track your golf scores, but the really cool thing is how it lets you filter by Course, # of Holes, etc. It displays your Handicap Index, and if you filter by Course, it will display your Course Handicap. I hope this is useful, but if not, it was at least fun to create. :-)

Running Logs

The new Running Log template actually contains 3 different logs: a running log, walking log, and a race log. You can also download printable versions in PDF format. Record your distance, time, pace, heart rate, the temperature and other route information and comments.

Attendance Record

I originally created this Attendance Record to track attendance for Scouting activities, but it is general enough to be used for meetings, clubs, church attendance, Sunday school attendance, and even school attendance, although I have other templates specifically for daily school attendance tracking.

Workout Log

This Workout Log template helps you track your strength training progress. It lets you track 5 days on a single page. Record the number of sets and reps and the weight for your lifting exercises. Track your weight, hours of sleep, and daily calories ... more info

Exercise Log

This Exercise Log helps you track your fitness and strength training progress. It includes a worksheet for listing 2 days per page and one for listing 3 days per page. List the exercises and then record the number of sets/reps for the weight lifted, or the time/distance and heart rate for cardiovascular activities ... more info

Weight Loss Chart Template

To go along with my recent Exercise and Fitness theme, I've created a new weight loss chart template for Excel, as well as a few printable weight loss logs and charts in PDF format that you can download, print, and keep handy right next to your scale (at least that's what I'm doing). I've got more Exercise Charts coming ... stay tuned.

Daily Food Log Template

This new template is for recording what you eat and how much water you drink each day. Today was my first official day to use the food log, and I was surprised to find out that my typical bowl of Honey Nut Cheerios is actually 550 calories. I looked at the other cereal boxes that we have, and it appears as if the manufacturers just change the serving size so that every serving comes to about 110-120 calories. Interesting trick.

The most useful thing for me is keeping track of how much water I drink. I've definitely found a correlation between that and my headaches, and until today, I've never really known how much water I drink each day. I discuss water intake in more detail on the food log download page. I'm definitely falling short of the recommended amount, even though I thought I was drinking plenty.

I need to find a good source for information about the amount of calories in foods that aren't packaged with Nutrition Fact info (like meats, vegetables, etc).

Gas Mileage Calculator and Mileage Log

A while back, my car went the way of all cars in the 200,000 miles range. I decided to replace it with one that got a much better gas mileage, so I went with one that was supposed to get 28-32 MPG. I began tracking my mileage to make sure it was living up to its potential. I found out that I have a hard time dividing 287 miles by 10.123 gallons in my head. This is what prompted me to create this printable mileage log and the mileage calculator spreadsheet.

I did an experiment in June because I was typically only getting about 27 MPG. I tend to accelerate too much, so I went a whole tank driving very carefully. I included a mileage chart that shows the peak in my mileage during June. So, it really IS possible to increase your gas mileage by just driving more carefully. You will also notice that I couldn't keep it up. It was a very difficult experiment.