3 Fat Chicks on a Diet Weight Loss Community  

Go Back   3 Fat Chicks on a Diet Weight Loss Community > Support Forum > Support Groups > 100 lb. Club

Does anyone else keep a spreadsheet?

Reply
 
Thread Tools
Old 09-10-2007, 02:03 PM   #1
Becomming a Monster
 
slimmingsi's Avatar
 
Join Date: Mar 2003
Location: Uk
Posts: 1,320

S/C/G: 329/253/210

Height: 6'0

Default Does anyone else keep a spreadsheet?

as we all know weight loss is a mysterious process you can work real hard and not lose a pound some weeks and others you seem to just let things flow and you drop? my nan was a gold card weight watcher for 30years and she always used to say don't trust the scales always trust the tape measure. sound advice that is promoted in many books.

does anyone else live for the tape measure? i measure and weight officially every thursday morning. i take neck chest waist hips, biceps foreamrs wrists thighs and calfs. all plotted in a spread shee this is good. cos 1. i can see in figures how my body is changing especially the waist/hip to chest ratio. but also after 2 weeks you can highlight the two weeks and drag across to the next colum and so and at excel will update those colums based on your previous results. i use this as a target. not a wholey achievable target as weight loss changes but each week you add your new results and each week highlight and drag across. so the more weeks the more accurate it becomes. i use this to make goal predictors.

being a bit sad and having alot of time i like to highlight the indiviual results in different colours. Red if its gone up. yellow if its stayed the same and green if i've lost. obviously as long as its not waist or hips i don't arms neck or chest getting bigger.
__________________
To infinity and beyond!
Target
Goal
slimmingsi is offline   Reply With Quote
Old 09-10-2007, 02:12 PM   #2
Senior Member
 
Join Date: Feb 2007
Location: Virginia, USA
Posts: 132

S/C/G: 245/237/165

Height: 5'10.5"

Default Spreadsheet OCD...

uuummm,...yeah.
I keep a spreadsheet.
I'm a tad embarrassed to say that it contains the date, my daily weight, my exercise record, if I've been dehydrated or sick, notations about starting/stopping medications...and a few other items.
I've kept the spreadsheet since Feb of 06. It's cool to chart weight loss. (Alternatively, it sucks to chart weight gain.)
so...yeah, I'm a bit OCD about it, but, I keep a spreadsheet too.
__________________
Cammie

ShyCammie is offline   Reply With Quote
Old 09-10-2007, 02:35 PM   #3
Former Quitter
 
GirlyGirlSebas's Avatar
 
Join Date: Nov 2006
Location: Atlanta
Posts: 5,500

S/C/G: 310/310/180

Height: 5'7

Default

I sure do. My favorite is a weight loss chart with graph. I also use a spreadsheet for my calories. Fitday and the other sites just get on my nerves. Hubby just told me about a marvelous new spreadsheet he found on our new computer. Its on Microsoft Works under program templates. The form is called "Fitness" and it includes a food diary complete with calorie/fat/carbohydrate tracking and water consumption tracking. It also includes a page for strength training and one for aerobic exercise. Now, if I can ever get my turn on the home computer, I might find these very useful.
__________________
- Rhonda

"Live the life you've always imagined." Henry David Thoreau


GirlyGirlSebas is offline   Reply With Quote
Old 09-10-2007, 03:04 PM   #4
Never want to go back!
 
CLCSC145's Avatar
 
Join Date: Apr 2006
Posts: 2,804

S/C/G: 338.4/190.8/165

Height: 6 ft

Default

Yeah. It tracks the date, weight, total weight lost to date, difference from the day before (colored coded like yours so if I gained it turns red, if it's the same it's yellow, and if it's a loss from the day before it turns green). Then I have it total the change for the week. Then I have it all feed into a plotted chart to visually show the changes over time with a trend line so I can see where I might be over the next year if I keep up the same pace. Anal, but I used to do a ton of spreadsheets in my last job and I find it fun and inspirational.
__________________
CLCSC145 is offline   Reply With Quote
Old 09-10-2007, 05:28 PM   #5
Senior Member
 
xJox's Avatar
 
Join Date: May 2002
Posts: 1,416

S/C/G: 336/314/199

Height: 5'8"

Default

I dont use a spreadsheet but I do keep track of Weekly weigh ins, daily weigh ins, measurements, exercise, food, etc.. all on my blog.
__________________
xJox
xJox is offline   Reply With Quote
Old 09-10-2007, 05:43 PM   #6
I'm not nuts, I'm happy!
 
Kati's Avatar
 
Join Date: Sep 2007
Location: Germany
Posts: 237

S/C/G: 241/220/160

Default

Slim, can you give me a more detailed explanation of your spreadsheet? I don't understand exactly and I need the codes you used, TY
__________________
Army Strong!



1,859 miles to Iraq
113 down!

One for each 5 pounds lost!
Kati is offline   Reply With Quote
Old 09-10-2007, 05:56 PM   #7
Becomming a Monster
 
slimmingsi's Avatar
 
Join Date: Mar 2003
Location: Uk
Posts: 1,320

S/C/G: 329/253/210

Height: 6'0

Default

across the top dates mine is done every thursday. down the A column list the body parts to be measured. Neck, Chest, waist, hips, thighs, calfs, biceps, forarms, wrists. have separate row for each of the left and the right side limbs. and one for weight in lbs. after the second week you highlight both columns of results only. in the bottom right use the corner and drag out across the columns no codes needed. the only codes on mine i manually typed were for a seperate set of data on the same sheet that just converts the top imperial measures to a metric one. so i have the data in both imperial and metric on the same sheet.
__________________
To infinity and beyond!
Target
Goal
slimmingsi is offline   Reply With Quote
Old 09-10-2007, 06:16 PM   #8
Live with Intention
 
Pita09's Avatar
 
Join Date: Jun 2007
Location: Georgia
Posts: 1,100

S/C/G: 260.6/see ticker/160

Height: 5'7"

Default

I use a spreadsheet to track my monthly measurments, monthly weight, BBI, and clothing size. My weight is recorded weekly at my TOPS meetings as well. I use Fitday and love it.
__________________
This is my final time 6/16/09


One for every 10lbs-->
Just when the caterpiller thought the world was over, it became a butterfly!
Pita09 is offline   Reply With Quote
Old 09-10-2007, 06:34 PM   #9
Senior Member
 
tolose85's Avatar
 
Join Date: Mar 2004
Posts: 1,060

S/C/G: 247/177.5/130

Height: 5'3"

Default

I have a binder that records my weekly weigh in info along with my measurements. I love the tape more than the scale I think... Even if I don't lose any weight, I can always count on a few inches being gone.

I also keep a daily journal that contains breakfast lunch, dinner and snack info-- my food journal, I record water intake and Exercise as well. I love to be able to revert back to it to see my progress and it also gives me ideas on meal plans.

I am obsessed with tracking everything. I think it also helps me to stay focused on what my goals are AND keeps me from eating bad stuff!
__________________
Gretchen
On this rollercoaster ride for the last time!


tolose85 is offline   Reply With Quote
Reply
Posts by members, moderators and admins are not considered medical advice
and no guarantee is made against accuracy.


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


All times are GMT -4. The time now is 03:29 AM.






Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2