BACKDROPsilhouette
01-22-2012, 09:51 PM

Writing down weight and individual measurements, and then going back and subtracting to find the progress week after week is frustrating and annoying. Whether you are taking the measurements on your own or not, it's important to have organized records that document this information during a weight loss journey. I am a perfectionist when it comes to keeping track of measurements. When I write down the information, it has to be written neatly and each column has to be the same width apart. By the time I've just recorded five measurements, I have about twelve sheets of paper wasted because of re-dos. HOPEFULLY this spreadsheet is as useful to you all as it is to me.

This post is going to be long. The reason for this is that I wanted to address every aspect so that each person (whether they know how to use Excel or not) will be able to make use of this little Diary.

-----
Choosing the Correct Sheet
Customizing Areas of Measurement
Inputting Information

This spreadsheet will be able to hold information for up to 51 weeks (it may be 52; however, I can't remember if I included the starting week in my original count or not). Each week contains three tables. The table furthest to the left is for measurements. This is the only table in each week that actually needs to be edited. The table in the middle shows change in measurements based on what you measured the previous week. Calculations are done automatically. The table furthest to the right reflects on how much weight you have lost since the beginning of your diary, as well as difference in body measurement since the beginning.

http://i42.tinypic.com/aele7a.jpg

The file you will download is called an Excel Workbook, and within it are three spreadsheets. The first two sheets are diary sheets; however you will only need to work with one or the other. If you take your measurements in metric units (kg, cm), you will use the spreadsheet labeled appropriately. If you take your measurements in imperial units (lb, in), you will use that spreadsheet. To choose the appropriate sheet, look at the bottom left where there are tabs. It is important that you are working in the right spreadsheet because of formulas entered into certain boxes that allow for conversions to show.

The third sheet just has a chart for determining pant size and one for shirt size. I did not make this; it's one I found from the internet. I checked between multiple clothing stores and their criteria are pretty similar, so it's great for an estimate.

http://i39.tinypic.com/2dvomh.jpg

CUSTOMIZING AREAS OF MEASUREMENT

Before you even start this diary, you need to choose which areas of your body you will keep track of. You also want to make note of where on the body you are taking the measurement so that even if it isn't technically the "right" location, you are always consistent. For instance, I take my forearm measurement 6cm below my inner elbow. I have a large list of body areas already pre-entered into the spreadsheet. You don't have to take all of those measurements, however more measurements truly shows how much progress you have made and may keep you motivated even if you don't drop a large number of pounds on the scale.

Now because of the setup of this entire spreadsheet, it is important not to remove any of the rows in a table. This will likely mess up a formula entered somewhere in the spreadsheet and I likely won't be able to fix it for you. If you want to do all the measurements I have listed: GREAT! You don't need to worry about this and can move on. However, if you want to change the order of the body areas or make your own list of areas you want to track, this is for you.

First, open up a notepad text file. Make a list of the body areas you want to keep track of (up to 13). I like to order mine according to order of the body areas from top to bottom. You are also going to need to figure out where you are taking the measurements from and make a note of it so you can remain consistent throughout the weeks. Now you need to prepare your tables. To do this, first you delete the contents of the very first table's first two columns (aside from the weight row). To do this, take your cursor and click the middle of the first rectangle. Don't lift your finger up, and drag it across until all sections are highlighted.

http://i44.tinypic.com/28sbgxi.jpg

Next you press the delete key on your keyboard. Then you can go through and input your body areas for measurement in the first column. In the second column, go ahead and type in where you are going to take your measurements from. Now you need to copy and paste this information to the next week's table. You can choose to do this for all 51 weeks at once, or to do it week by week. I adjust everything at once so I don't have to worry about it later. To copy and paste the information, highlight the same boxes we did earlier and hold CTRL and C at the same time, or right click and "copy" to copy the information. Once done, the table should be highlighted as earlier, but this time with little dashes moving around it. Go to the next week's table; click the first box on the left, right underneath the "weight" rectangle. Right click and choose "paste" or hold CTRL and V (you can even hit enter if you will only be pasting it once). You need to do the same thing with only the first column so that the names in the second table match up and so you can see the measurement changes as they happen.

http://i40.tinypic.com/e5ipug.jpg
http://i44.tinypic.com/vdk5tk.jpg

The very top of the spreadsheet is just one table. This is where you enter your previous or current measurements. I suggest making it your current measurements, this way you are able to choose the body areas you want measured. When it comes to entering your measurements, choose the square you want to edit in either the metric or the imperial column. If you are measuring in metric units, you need to input your measurements in the metric column. REMEMBER: if you are not in the right sheet you will not be able to see both units of measurement because it will break the conversion code. Your table will also look really weird.

To type your measurement, select the appropriate square and type the number, then press the enter button.

http://i44.tinypic.com/binxgg.jpg

The only table you input measurements to is the first table. The other two are for calculations and that work is done automatically.

So now just go through your measurements and put them in. If you didn't use all 13 rows available for custom body area measurements, that's fine. Input 0 as the measurement and it will show up as a dash on any area that section would otherwise be used for.

http://i40.tinypic.com/ojgm8k.jpg

Now you should be able to happily store your progress and see the changes, however small, week by week!

If I didn't make something clear or you have questions, feel free to ask. Depending on how many people may need help with any of the steps, I might be able to customize the spreadsheet depending on what that person wants in it. We'll see as the time comes for that!

If you weigh in using imperial units, but measure in metric, then you can download and use this (http://www.mediafire.com/?qldcxyqqhm3lwo0) spreadsheet.

lindac36
01-23-2012, 01:04 AM
pretty cool! Thanks. I downloaded it tonight won't have a chance to work with it until tomorrow. Hope you are feeling better.
Linda

Linden
01-23-2012, 01:56 AM

THIS IS JUST SUPER! Thank you so much and how are you doing?

BACKDROPsilhouette
01-23-2012, 02:02 AM
I am glad you love it! :D

And I am doing so much better than I was on Monday. I still have a really bad cough, but I'm taking it easy and my antibiotics are working well. I can hopefully get back OP in about two weeks, and hopefully I don't gain any inches or pounds before I restart. Thanks for caring<3

Linden
01-23-2012, 02:21 AM
I am glad you love it! :D

And I am doing so much better than I was on Monday. I still have a really bad cough, but I'm taking it easy and my antibiotics are working well. I can hopefully get back OP in about two weeks, and hopefully I don't gain any inches or pounds before I restart. Thanks for caring<3

Yay for feeling a bit better, and double yay for losing 20 POUNDS!

BACKDROPsilhouette
01-23-2012, 02:42 AM
It's more than that now! But since I don't know if I'm going to gain any of it back I'm not letting it count. When I went to the Doctor they said I weighed 235.

BACKDROPsilhouette
01-23-2012, 07:39 PM
Bump

northernfawn
01-23-2012, 10:14 PM
glad you're feeling better. Thanks for doing up the spreadsheet it looks awesome, it'll be even better when I have some numbers to put in .....

BACKDROPsilhouette
01-23-2012, 11:02 PM
It looks like I made a mistake with some of the reference points in the calculation tables . . . I'm fixing it now and will upload the correct version shortly!

BACKDROPsilhouette
01-23-2012, 11:11 PM
Uploaded the fixed version . . . sorry to anyone that has already entered info and been confused because of the difference tables!

lingereverywhere
01-24-2012, 01:26 AM
Thank you!!

BACKDROPsilhouette
01-25-2012, 01:31 AM
Le bump~

Linden
01-25-2012, 04:31 PM
I've already confessed my ineptitude once today. Something I didn't think I had until I tried to search the threads. :( But I honestly cannot find the newly-posted charts. Did you sneakily hide it somewhere or am I just losing it? Oh, I forgot. I'm on pain killers so I have an excuse. :fr:

BACKDROPsilhouette
01-25-2012, 04:35 PM
Aww, it's okay!
When I updated the files I just replaced the old links! They're still in the first post :3

BACKDROPsilhouette
01-26-2012, 05:54 AM
bump

Linden
01-26-2012, 07:11 AM
I can't get the files to unzip. And trying to unzip them as excel files. Is that right?

BACKDROPsilhouette
01-26-2012, 07:31 AM
They're not zipped! It should download as an excel file already. As long as you have Excel installed on your computer, you should just be able to double click the file and open it. If you don't have Excel, you can get the Microsoft Office as a free trial.

Linden
01-26-2012, 10:16 AM
They're not zipped! It should download as an excel file already. As long as you have Excel installed on your computer, you should just be able to double click the file and open it. If you don't have Excel, you can get the Microsoft Office as a free trial.

I have Excel on both my daughter-in-law's old Mac and my new one, and on each -- when I download to my desktop -- both files are zipped. I guess it's back to my old Excel file. Darn it.

BACKDROPsilhouette
01-26-2012, 10:20 AM
Aww. Well I uploaded it as an .xlsx file. Maybe I could upload it in a different file format for you?
If it's zipped, you should just be able to unzip it the way you would unzip a regular file.

Mischyff
01-26-2012, 12:42 PM
Thank you so much for sharing this great spreadsheet. I have a question: I'd like to track my measurement metrically (sp?) but my weight in pounds, do I have to use separate sheets for that?

BACKDROPsilhouette
01-26-2012, 12:52 PM
I do the same thing! I'll make a spreadsheet for that and add it to the first post ^.^

Mischyff
01-26-2012, 01:19 PM
Thank you so much!

Linden
01-26-2012, 01:33 PM
Aww. Well I uploaded it as an .xlsx file. Maybe I could upload it in a different file format for you?
If it's zipped, you should just be able to unzip it the way you would unzip a regular file.

My son says the problem is I'm using a Mac. Where's the smiley that shows someone throwing their hands in the air. :( Sorry to cause you all this trouble.

EDIT: So I just did this freakish thing that I won't go into and all kinds of bells and whistles went off, but it downloaded, and I got a message saying the material is not supported by Excel for Macs and any info I enter and try to save will probably be lost. But what the hey, I got this far. I'll try it out tomorrow morning.

SomedayBubblySomeday
01-26-2012, 01:41 PM
Hi Linden,

I am on a mac and I am able to download and view it. When you downloaded it, did it show up looking like a folder or a piece of paper?

Linden
01-26-2012, 01:59 PM
Hi Linden,

I am on a mac and I am able to download and view it. When you downloaded it, did it show up looking like a folder or a piece of paper?

Well shoot!

It came us just like a regular excel file so I'm thinking it may work. Did you have to go through an intermediary program to download it (I did), or did it just download?

SomedayBubblySomeday
01-26-2012, 02:13 PM
I followed the direct download link, and it took me to a site to download from. I pushed the green button and it downloaded to my desktop. It came as a sheet and not a folder icon for me. Then, I popped into my excel and it said I needed to convert it to a newer version, so I pressed OK. I have Office 2004, so it didn't open up with all the bells and whistles, but definitely opened up as a useable spreadsheet.
If you have trouble opening it, you can throw it in the trash and download it again. I can help you if you still can't get it open :)

Linden
01-26-2012, 02:17 PM
I followed the direct download link, and it took me to a site to download from. I pushed the green button and it downloaded to my desktop. It came as a sheet and not a folder icon for me. Then, I popped into my excel and it said I needed to convert it to a newer version, so I pressed OK. I have Office 2004, so it didn't open up with all the bells and whistles, but definitely opened up as a useable spreadsheet.
If you have trouble opening it, you can throw it in the trash and download it again. I can help you if you still can't get it open :)

That's really kind of you. :hug: Let's see what tomorrow brings.

BACKDROPsilhouette
01-30-2012, 12:13 PM
Linden, I hope you got it to work!

And bump for those that need it~

SaraBean
01-30-2012, 04:01 PM
This is great!