Tag Archives: Excel

A Neat Little Graph Chris Made

The other day Chris sent me the following email:

Here is an updated screenshot of my spreadsheet.  New features include:

-Days out column (2nd column)

-Highlights along the first column denoting days I was not at home

Also attached is a screenshot of a neat little graph I made comparing my body weight last prep and this prep. Yes, I make graphs for fun.

Enjoy.

Well, what are we waiting for?  Let’s check them out! sdsfsdfs Good, nice new highlights and “Days Out” column.  “Moving” and “Move into APT” have been added in the highlight column too.  We can see that “Move into APT” was counted as HITT.  I bet gym programmers will see this, be impressed by Chris’s success, and “Move into APT” will soon be the new Zumba.

Gym Goer #1:  “Yeah, gotta get to Move into APT class tonight; we’re carrying mattresses to the 4th floor this session.”

Gym Goer #2: “Oh, right, the 4th floor mattress carry, the 4FMC.  That’s tough but just wait until you get to the pivoting-couch-room-entry.  That’s how I grew these biceps.” sds And there is the “neat little graph!”  We can see a nice comparison of his body weight changes during his 2011 and 2013 (current) contest preps. The part I find most interesting in this “neat little graph” is the steadiness with which Chris lost weight during both preps.  During the 2011 prep, Chris’s schedule was very reliable, he trained in the same gym, he had access to his own kitchen, and, he was not traveling.  During this prep, he’s moved from Oklahoma to Massachusetts and spent time in various other places with an erratic schedule, no consistent kitchen, and training at a variety of gyms.  “How many other gyms?  How many other places?” -you ask.  Well, lucky for you, Chris sent me another email with these fascinating statistics!

Length of Prep:  146 days (21 weeks)

Time away from “home” (in quotes due to changing of “home” during prep which we will define as a place at which we paid rent):  53 of the 146 days (36.3%)

Number of different gyms trained in:  7

States visited during prep:  Oklahoma, Missouri, Illinois, Indiana, Ohio, Pennsylvania, New York, Massachusetts, Florida, New Hampshire, and New Jersey (upcoming)

OK so, all this traveling and time away from “home” is kind of a big deal.  Chris had to plan all his meals, find appropriate gyms, and organize his schedule to get the food and get to the gyms to make all this work.  (And he had to not drive me crazy, which, for the most part, he accomplished). And yet, we look at the graph made for fun, and see how his weight loss was steady, just like it was in 2011 when life was simpler.  You’re physiologically fascinating Chris!

I want to end with one more picture from our Cape Cod trip:  Chris thinks he’s good at putting sunscreen on his own back, but he’s not.

sds
Mr. “No Lindy, I don’t need any help putting sunscreen on my back; I can do it all by myself.”

I’m bitter about his sunscreening abilities because he also sunscreened my back this day giving me a similar patchwork pattern of burn.

In conclusion, Chris:  good at spreadsheeting and steady weight loss; bad at sunscreening.

The Spreadsheet of Life

Today we discuss The Spreadsheet of Life.

I posted a screenshot of The Spreadsheet of Life previously, when it was in it’s infancy.  You will see today that, at 3.5 weeks of age, it has matured into quite the chubby-cheeked child.

The Spreadsheet of Life

The Spreadsheet of Life 

Let us now look deep into The Spreadsheet of Life.

In the first three columns are general notes of scheduled events (such as the Indianapolis trip), the number of weeks until the bodybuilding show, and the date (complete with year, in case the current year is forgotten one can only assume).

The fourth column contains Chris’s step count for the day in a color-coded system where medium-green is the optimal color.

I haven’t mentioned Chris’s step counting before so I guess I better briefly explain:  he found a pedometer at his parents’ house last winter and has been wearing it ever since. In my understanding, he shoots for around the recommended 10,000 steps a day but doesn’t go too out of his way if the count falls short. (Sometimes if he’s less than 100 steps away from 10,000 at the end of day, he’ll pace back and forth in our small apartment to get those last steps in, so that’s weird, but it doesn’t happen too often, so it still falls in the “cute and amusing” rather than the “I must get him to stop this” category of significant-other behavior.)

So, back to the step counts on the spreadsheet.  It’s neat to see that the step counts almost doubled when we were in Indianapolis.  Probably all that walking to the bridge (that we ran over quickly) and to CVS for cottage cheese.

In the next column, we see his body weight in kgs. Ha! No, it’s in lbs. Good one huh? I make this hilarious joke because we can see Chris has found it necessary to include units in the headings of all the other measurements in this spreadsheet which is very important in case he were to look back later at say, May 24th, and think he had eaten 244 kg of protein instead of 244 g. Were he later trying to replicate this diet, he would have to eat a large hippopotamus to get 244 kg of protein, which is the exact weight of “Hippopotamus C” in this algebra problem and thus definitely a real hippopotamus weight.

But I digress.

We were discussing the weight (in lbs) column of The Spreadsheet of Life.  The weight loss has been very steady with the exception of the time in Indianapolis when traveling-induced disruptions in the digestive flow, shall we say, probably hampered weight loss a bit.

In the next column, we see Chris’s protein, fat, and carb intakes (in g, not kg) complete with colored bars to visually compare quantity consumed across days.  Next we see calculated Calories, macronutrient percentages, and workouts performed.

My favorite entry in the spreadsheet is on May 20th in the workout column:  “Off (tornado)”. That entry makes me laugh and yet, in a way, it’s profound. That tornado was such a huge event.  But life goes on. Training goes on.  And an unscheduled off-day needs to have a reason recorded next to it in The Spreadsheet of Life. Thus, “Off (tornado)”.

As contest prep progresses, I will post more screenshots of The Spreadsheet of Life as it grows up.