I lost 60 pounds and realized two important things about eating with Google Docs

Me, before and after
Me, before and after
Image: Paul Smalera
We may earn a commission from links on this page.

I’ve been thinking about how to write this story for years. Should it be a book? An entire blog? A self-help guide? Ever since I realized I’d lost 60 pounds over the course of 18 months, I knew I wanted to find a way to talk about it, and maybe help others with their weight loss struggles. This is my first public attempt to do that.*

A note about the rounding of my roundness: My peak weight, shortly after I began weighing myself in 2010, was 242 lbs. My lowest weight since I started weighing myself has been 183.2 lbs** — right in line with where I should be, at 6’3″ tall. I’m sure that I weighed more than 242 lbs. at maximum girth, but frankly, I don’t care that I don’t have the data to account for those last 1.2 lbs.

Adam Davidson’s New York Times Magazine story, “How Economics Can Help You Lose Weight,” helped organize my thinking about how to finally write this article. In his story, Adam explains that the rigid protocol his doctor puts him through acts as a kind of economic incentive for him to stay on the diet. I’m highly skeptical that the special liquid meals he can only buy directly through his dietician will help him keep off the weight. I tried all sorts of diets in the many years that I was overweight and though I never tried the Adam’s solution, it doesn’t sound like a recipe for long term success. At least twice, I lost weight and then gained it all, and more, back. (Meta note: I feel terrible writing that. Adam, I wish you the best. Maybe something you read here will help you keep off the weight you have already lost, and congratulations on that difficult achievement.)

So, now that I’ve managed to make weight loss sound simple, and sound smarmy about my success (I’ve stayed within my desired weight range for nearly four years now), what’s my big secret? At first, it was data. Just like I said in the headline, I keep a Google Doc spreadsheet in which I’ve religiously logged my weight every morning for the last five-plus years, starting on January 1, 2010, when I knew I had to do something about my borderline obesity.

Image for article titled I lost 60 pounds and realized two important things about eating with Google Docs

I found this doc in the Google templates section, and I haven’t even used it to its fullest intent. It was too complicated, asking me to log my calories, workouts, sick days, etc. All I wanted from the doc was two things: a place to record my daily weight, and a field where I could see my 10-day moving average weight (see the D column in the image above). That’s all the spreadsheet does: When I enter my weight, formulas in the cells then calculate the change from yesterday, along with the weighted average of the prior 10 days. I added some charts to it, but once I got close to my target weight, I stopped using them. After I had a few years of data, I copied my weights from years past into my current view of the sheet, so I could see what I weighed on a given day one, two or three years ago. By the way, I bought my scale in August 2009 but I didn’t start the spreadsheet until January 2010. I spent most of that quarter year figuring out that the scale alone wouldn’t be enough.

I’ve cleaned it up and published the template I use on Google Docs: here it is.

The scale/spreadsheet combination helped me correct for what I came to believe is the biggest problem with trying to lose weight: getting relevant data. When I weighed myself without recording the number, during those months before January, all I got was feedback on the past day or so. Maybe if I remembered my number from the day before, I could guess whether my weight was going up or down. But a 10-day moving average is a computation beyond the mental capabilities of the average human — yet it was crucial to my understanding of how my diet was working.

Indeed it was only after a full year, despite all the physical evidence I had, and two clean-outs of my closet, that I really believed I was losing weight. The numbers overcame everything psychological, emotional, mental, and physical that so often conspired to ruin my past efforts at weight loss.

Throughout my dieting, I’d occasionally have a pig out day, whether it was at a party, a fancy dinner, or a road trip, only to be stunned the next morning that my three- or four-pound one-day weight gain had barely affected my 10 day average. I knew, though, if I had too many days like that in a row, my average would climb all the way back up to match my weight. By the way, when I say I dieted, what I really mean is that my eating habits changed over time, so that I kept the number on my spreadsheet moving downwards. Gradual changes are what worked for me.

When I gained three pounds in one day, I’d be so distraught that I’d practically fast the next day and lose almost all of the gain, if not more, in 24 hours.(That’s because, of course, fat burns slowly, and most of those fluctuations were probably water. But if I didn’t get that extra weight out of my system quickly, my body would adapt to keep carrying it, and I’d keep it on.)

I weighed myself every day for almost three months before I started to make an attempt to change my diet. (Note again that I bought my scale three months before I even started keeping my daily spreadsheet; nothing about this process happened overnight. The spreadsheet, I’ll repeat, helped me see time on a different scale, and not get frustrated when I didn’t lose 60 pounds in one month.) I wanted a baseline data set before I really tried to lose weight, but I also wanted some time to experiment and see what techniques might work for me. Here are some things that I did over that time period that resulted in weight loss:

  • I had oral surgery.
  • I skipped dinner sometimes, lunch others, but never breakfast.
  • I had lots of wine and liquor, but not a lot of beer.
  • I cut out almost all processed foods.
  • I ate as many vegetables as I could before turning to meat or cheese.
  • I ate a lot of soup.
  • I ran a marathon.
  • I started doing some exercises at home in the morning, two to three times per week.

I’m not going to unpack all of these bullet points here, but I will tell you what I think the most effective tools for my weight loss have been, after the data helped me understand my weight flucuations. These are the two most important things I eventually realized: I had to eat better food, and eat less of it. Losing weight was truly that simple.

Running the marathon was great for my fitness level, but I had already lost almost all the weight I was going to lose by the time I started training for it. Running and simple exercises at home have made me stronger physically and in overall better shape, but had little to do with the weight loss.

The only successful way for me to lose weight was to eat less, and the only way I found that worked to eat less was to eat more real food and less processed food. Real food, once I cleansed my palate of processed food, simply tasted way better and satisfied me more.

In another New York Times Magazine article, “The Extraordinary Science of Addictive Junk Food,” Michael Moss explains that processed food is engineered to make us crave more, and more, and more, and more of it, until there’s no physical room in our systems for anything else. The thing is, we keep expanding — our stomachs, fat cells, intestines, appetites — to accommodate all these extra calories. It’s just the way humans are built. But I was repulsed and disturbed to think of businessmen and scientists competing for my “mouth share” and “stomach share.” Processed food is a big business, but the convenience and accessibility of it is just about the last thing humans, who are used to foraging or hunting and have ample ways to store energy, need.

So, I became overweight because I was eating all sorts of crappy, horrible food. And most of the time that food just made me hungry for more food. When I did eat real food, I was only hungry for the richest, boldest flavors I could find: cheeseburgers, steaks, deep-fried spicy foods. Despite being a foodie and having a love of cooking and high-end cuisine, I had almost no interest in a piece of fish or a salad, not because I didn’t enjoy eating them — I did — but because I wasn’t satisfied by them.

Resetting my taste buds was the hardest part. It took months. But now, processed food is something I’d rather not eat, because all it will do is make me hungry later. I still love a good steak or burger, or a piece of pizza, or an amazing piece of cheese or even chocolate. The big difference these days is that I’d never eat a burger two days in a row, or scarf down half of a pizza. It’s just too rich for me. The day after a meal like that, I now crave a salad or a vegetable soup. At first I had to play mind games with myself to temper my desire for rich food. But it only took a few months before that resistance became rote. I prefer a bowl of lentil soup or Greek salad, provided it’s fresh and made with quality ingredients, to another greasy burger, even if that first burger was awesome.

When I slip and make the mistake of indulging too much, which I still do sometimes, I feel it right away, in that I feel bloated and awful, and I see it on the scale. These days I often prefer to wait for a quality meal and be a little (or even a lot) hungry, than to eat some crap at the airport or bad, passed hors d’oeuvres at a poorly catered party. As I lost weight, I knew that my stomach was shrinking too. I also stopped trying to finish my plate and, thanks to the quality of the food I sought out, was better able to sense when I was full.

By the way, I draw my processed food line at butter and wine: Minimal processing, especially techniques humans have used for centuries to preserve food, is okay by me. I love pickles and jams, and couldn’t live without them. So, I’m not a raw food person, a vegan person, a paleo person, etc. All of those things are fine, but any diet strategy should just be a vehicle for better overall quality food. A vegan who eats cinnamon raisin bagels with soy chocolate cream cheese every day is not going to fare any better in the diet category than a paleo dieter who eats nothing but sausage wrapped in bacon. (One other thing I still try to do is eat meat at only one meal per day. I got this from Mark Bittman, who is a “vegan before dinner.”) Any food product born in a laboratory is probably messing with nutritional value in a way that will distort with my appetite, and my weight.

If all this sounds like a big effort, at times it can seem like it. Sure, if I’m going on a long flight or trip, I make sure I have nuts or dried fruit with me, or something even more substantial. But I desire those foods, instead of the gloopy chicken at the airport Panda Express. Having them with me is a treat, especially since I refuse to eat the other stuff, so it’s not actually that hard to remember to bring it. Chain restaurants and food companies are spending billions to get in front of my eyeballs and get me to buy their food. That’s the modern food system at work. Surely I can spend a little bit of time and effort of my own to provide myself an alternative.

This is the diet strategy that worked for me and has helped me to keep the weight off. Nothing in this story is about health or longevity or advice to you. This is about the spreadsheet, about the tracking of my daily weight and making the data visible to me on a timeline that human brains simply aren’t built to intuit. If you, reader, wanted to eat at McDonald’s every day, but track your weight daily and adjust your consumption to make the number on the spreadsheet go down, you’ll lose weight. Whether you can keep it off on that kind of food, and not croak from a lifetime of eating at McDonald’s, I can’t say.

You might’ve noticed that I haven’t used the word “calorie” yet. That’s because I never counted one, and I still don’t. Calories are funny, weird things. I burned more of them when I was training for my marathon, but I ate more of them, too. Some nice days I walk miles in New York; some cold days I might walk a few hundred steps between my bed, the subway, the cafeteria, and back to my apartment door. Counting calories is difficult and to me, irrelevant.

Indeed, when I watch Brian Stelter estimate calories on his weight-loss Twitter account, I am happy not to even attempt to do the same. His weight loss has been an awesome story, and perhaps the calorie counting helps him, but I know that for me, calories are just noise distracting from the signal, the real number I’m after: what I weigh, every day.

Exercise, I’d say, is irrelevant, to weight loss too, although, let’s be clear, you can be skinny and still be out of shape. (See: me, right after my weight loss, but before I started marathon training.) There’s no question that exercise is great for your health, but 10 extra minutes on the treadmill when I was overweight never helped me much. Feeling light enough to walk a few extra blocks, swim on vacation, run, or play catch did far more for me. Bottom line: If you want to lose weight, you have to eat less. And I found that eating less consistently was only possible for me if I did these two simple things:

  • Weighed myself every day, in order to see my 10-day average and figure out if my weight was going up , going down, or holding steady;
  • Ate foods that didn’t make me hungry for more food later.

I’ll probably be weighing myself every day for the rest of my life.*** I thought about cutting down to once a week, but I want that 10-day moving average, so I still do it daily. It takes all of 20 seconds, right after I wake up. The scale is in my closet, so I stand on it as I find clothes for the day. I usually remember my weight and enter it in as I settle into my desk at work, though now that Google Docs is mobile, sometimes I do it on my phone. Some Mondays, if I haven’t pulled out my computer over the weekend, I’ll enter three days worth of figures at once.

My only cheat in weighing myself happens when I am traveling. I don’t weigh myself at all when I’m away from home. I’m sure I could find a way, but I don’t find it necessary. Instead I weigh myself my first morning back at home. Then I fill in all the missing days, increasing or decreasing from my last real weigh-in, so I end up at the weight I recorded on my first day back on the scale. It’s not really accurate, of course, but it hasn’t been a problem yet, either. When I remember, I bold the “estimated” days, but that’s just a visual cue.

It’s both shocking and satisfying to me to look at my spreadsheet today and see this:

Image for article titled I lost 60 pounds and realized two important things about eating with Google Docs

I put on a little weight recently, but I didn’t eat anything particularly heavy yesterday. I don’t know why, and I don’t really care. I’m still down 45 pounds from this day in 2010, and 53 overall. I can see my 10-day average is going up, but it’s not that bad. Anyway, today I’m not so hungry, so I’ll probably eat less. I wonder, though, what I will weigh tomorrow.

*Note: I first published this story on Medium on March 23, 2013. I’ve lightly updated a few sections to include some new insights from the past two years. Most notably, I recently stopped recording my weight every day, due to some changes in my routine, though I do still step on the scale every morning. **And my new lowest weight is 179.8 pounds, thanks to a new exercise routine, not an intentional attempt to lose more weight! ***After four years of maintaining my weight in the range I wanted to be in, I don’t think I will resume recording my daily weight unless I gain 10 or even 15 pounds for a prolonged period of time.