Apr 252013
 
Creating an Excel Fitness Log in 6 Parts - Part 6 - Dashboarding

Well, we made it to the end of the series. In this section, I will show you how I took the various pieces of the previous five posts, and condensed all of that information into an above-the-fold, single sheet dashboard. As a quick recap, the items I’ve decided to track are: Weight – tracking scale [...]

Feb 172013
 
Snowshoeing at Paradise, Mount Rainier National Park, Washington

On Saturday, I joined a few great friends for a trip to Mt. Rainier, Paradise, to enjoy my second snowshoeing experience. Short version: I’m loving this enough that I have decided to purchase a set of snowshoes to carry me for future treks. Long version: We started our trek by meeting at the Nisqually gate [...]

Feb 012013
 

The first month is down, and things are going, about on track. I was ahead of the game after the first two weeks, but, sadly, I succombed to some stresses in life, and my go-to for comfort is food. *sigh* Still, I’ve managed to fit in enough healthy activities to ward off slipping too fa [...]

Jan 312013
 
Creating an Excel Fitness Log in 6 Parts - Part 5 - Tracking Body Measurements

In this part of the series, I will show how I set up a sheet to track the body measurements that mattered to me. Much like the nutrition sheet, there is very little before the visualization methods (which will be covered in the next post) to go over. First, I have to decide which body [...]

Jan 302013
 
Snowshoeing Gold Creek, Snoqualmie Pass, Washington

Last Sunday marked my first time going snowshoeing, and the experience was so beautiful and enjoyable, that I’m looking for more opportunities to go. This trip was taken with a couple of good friends, and was destined to occur at Gold Creek, up in the Snoqualmie Pass area of the Cascade Mountains in Washington, about [...]

Jan 262013
 
Aggressive Hiking Goal for 2013

2011 was probably the most fun I’ve had, as far as the outdoors go. I did some serious hiking, got in some great camping, and went on my first backpacking trip. Then, things petered out. I only got in one backpacking trip in 2012, and I wasn’t in top form for that one. This year, [...]

Jan 252013
 
Creating an Excel Fitness Log in 6 Parts - Part 4 - Creating a Habit Checklist and Scorecard

This may be the easiest of all of the spreadsheets I will show you. I will go through the steps I used to create a quick view of whether I was following through on certain behaviors, with a corresponding score related to those habits, and a simple letter grade visual to represent that. Also, since [...]

Jan 232013
 
Creating an Excel Fitness Log in 6 Parts - Part 3 - Tracking Nutrition

In this portion of the series, I will cover how I like to track nutrition. I’m going to start by saying, this can very easily be done via many online solutions, such as NutritionData.Self.com or Nutrimirror.com. However, I’m an Excel geek, and I want to have all of my data available in one place. Granted, [...]

Jan 182013
 
Creating an Excel Fitness Log in 6 Parts - Part 2 - Tracking Calisthenics

In the first portion of this series, we covered constructing a spreadsheet tool for tracking body weight and its components. In this portion, I will go over how I set up a sheet to track my progress in doing sit-ups, push-ups, pull-ups, and my time and distances for running. This section will be very short, [...]