Official website for iCreate - the creative magazine for Mac users

Mar 29, 2014

# Track your weight loss in Numbers

by Gavin Thomas

## Lose weight and get fit by tracking your weight loss in a Numbers spreadsheet.

Due to popular demand, we’ve revisited our old weight loss tracker and given it a fresh lick of paint in the new version of Numbers.

In this tutorial, we’re going to take a blank canvas and then build our very own weight loss tracker. We’ll be using BMI calculations to figure out what range your target weight should be in, creating a simple table that you can drop your dates and weights into on a regular basis, and displaying all this info in a smart chart.

# Step-by-step: Make a weight loss tracker

To help work out what your target weight should be, we’re going to work backwards from the healthy BMI range. Make a 2×4 table and set the font and colours. Now input your height.

### 2 Calculate ideal weights

BMI is weight divided by height squared, so we rearrange that to calculate weight. In the next cell (Min), type: =18.5*(A2*A2). For Ideal and Max, replace 18.5 with 21.7 and 24.9, respectively.

Now make a 2×2 table and type in your start and target weights (use the previous table to pick your target weight). After that, make a third table with four columns and lots of rows.

### 4 Set up your record

For your headers, type in Date, Weight, Target and Progress. The first two are for you to fill in on a regular basis. Link all the cells under Target to your target weight in the 2×2 table.

### 5 Calculate your progress 1

For Progress, we’re going to work out how far from your target weight you are as a fraction of the total weight that you want to lose. To start with, type in weight B2 minus target C2.

### 6 Calculate your progress 2

Put that in brackets and divide it by (also in brackets) start weight A2 minus target B2 (both in the 2×2 table). Put the whole thing in brackets and then subtract it from 1. Repeat the formula.

### 7 See how far you’ve come

Set the Progress column’s cell format to %. You should now be at 0% on day one and 100% when you reach your target. To see how we added the colours, check out the anon guide at the bottom of this post.

Next, select your weight and target columns and then make a filled line chart (2D). If the weight line is covering up the target line, swap the columns over in the table.

### 9 Tidy it up

To finish, go to Format>Axis>Value (Y) and set the Min Scale value to 60. Under Category (X), delete the Label References then select your date cells, and set a Right Diagonal Label Angle.

# Styling your weight loss tracker

Click the anno guide below to bring up the full-size version, or right-click to download the image then open it Preview.

• Our provides the latest breaking apple news, reviews, tutorials and downloads online and our fan page is the best place to communicate with other iCreate fans.
• Willy

Hey, I had this problem and tried so many
things. Different things work for different people and I was lucky
enough to find one that worked for me. I lost 18 pounds in one month
without much exercise and it’s been a life changer. I’m a little
embarrased to post my before and after photos here but if anyone
actually cares to hear what I’ve been doing then I’d be happy to help in
any way. Just shoot me an email at wberk758[at]gmail.com and I’ll
show you my before and after photos, and tell you about how things are
going for me with the stuff I’ve tried. I wish someone would have helped
me out when I was struggling to find a solution so if I can help you
then it would make my day

• Teykal

How do I open this on the iPad?

• oldfatmotherfucker

Is there a way to change kg to pounds?