Reply
 
Thread Tools
Old 01-13-2007, 06:27 PM   #1  
There is no Try
Thread Starter
 
YodaGirl's Avatar
 
Join Date: Nov 2006
Location: Florida
Posts: 25

S/C/G: 215/213.4/135

Height: 5'4"

Default Tracking Spreadsheet

I don't know if anyone else is as anal as I am, but I created an Excel spreadsheet that tracks my weight each week (on Saturday), the amount lost each week, a running tally of my total amount lost, goals, BMI changes, body fat % changes (they have on of the little hand-held body fat calculator things at the gym I attend), and measurement changes. I'm weighing each week (well, recording each week -- have to admit I'm jumping on the scale a lot in between) and everything else monthly. I'm hoping that seeing it on the screen / on paper will help me to be more committed to watching the numbers drop...and more even-headed during those times when they don't.

I also have little "conditional formatting" things in there to do fun stuff when I reach good points, like changing the text color to green when my BMI reaches normal range, and turning the cell bright yellow when I hit at or below goal.

If anyone wants a copy, let me know. If there's enough of a demand, I'll probably stick it online somewhere -- otherwise I can email.
YodaGirl is offline   Reply With Quote
Old 01-13-2007, 06:34 PM   #2  
Senior Member
 
sakuya3834's Avatar
 
Join Date: Aug 2006
Location: San Diego, CA
Posts: 141

Height: 5'2.5"

Default

I do this as well. I also track my calories every day and average it out for the week. I like to see the big picture, plus I'm a math freak so I like numbers.
sakuya3834 is offline   Reply With Quote
Old 01-13-2007, 06:43 PM   #3  
Senior Member
 
LisaMarie71's Avatar
 
Join Date: Jul 2006
Posts: 2,860

S/C/G: 285.2/285.2/185

Height: 5'9"

Default

Yodagirl, I'd like a copy of your spreadsheet! I have one where I track my weight and I have a graph that shows my actual vs. goal, etc. I don't have my BMI in there or any conditional formatting set up, though. I used to deal with Excel all the time when I was a financial analyst, but now that I'm an English teacher I'm out of practice! I'm sure I could figure it out pretty quickly, but it would be easier to just copy yours!
LisaMarie71 is offline   Reply With Quote
Old 01-13-2007, 06:47 PM   #4  
Resident Witchling
 
Nikaia's Avatar
 
Join Date: Oct 2005
Location: In exile, in TN
Posts: 647

S/C/G: 198/190/140

Height: 5'7"

Default

OMG, I'd love a copy! I tried something similar a while back, but Excel has never been my strong point. Sounds like it could be really motivating!
Nikaia is offline   Reply With Quote
Old 01-13-2007, 07:13 PM   #5  
newlifestyle
 
Newlifestyle's Avatar
 
Join Date: Jun 2006
Location: Canada
Posts: 930

S/C/G: 250/200/177

Height: 5' 3"

Default

Yodagirl - It would be awesome if I could get a copy of that. It sounds like it would help me see my progress and keep me motivated.
Thanks
Newlifestyle is offline   Reply With Quote
Old 01-13-2007, 07:28 PM   #6  
There is no Try
Thread Starter
 
YodaGirl's Avatar
 
Join Date: Nov 2006
Location: Florida
Posts: 25

S/C/G: 215/213.4/135

Height: 5'4"

Default

Ladies check your PM's. newlifestyle, I couldn't PM you -- need an email address to send it to. Thanks!
YodaGirl is offline   Reply With Quote
Old 01-13-2007, 08:22 PM   #7  
Kee
 
Lose25's Avatar
 
Join Date: Nov 2006
Posts: 253

S/C/G: 135/135/120

Default

Hey Yodagirl i would love a copy as well!
Lose25 is offline   Reply With Quote
Old 01-13-2007, 08:40 PM   #8  
Member
 
WaistingAweigh's Avatar
 
Join Date: Apr 2006
Location: Ohio
Posts: 70

Default

Your spreadsheet sounds awesome. I'd like one too, please.
WaistingAweigh is offline   Reply With Quote
Old 01-13-2007, 08:48 PM   #9  
omeomy
 
ogibson's Avatar
 
Join Date: Aug 2004
Location: California
Posts: 93

S/C/G: 275/269.5/155

Default

Hi yodagirl could i have one also thank you.........
ogibson is offline   Reply With Quote
Old 01-13-2007, 08:54 PM   #10  
Senior Member
 
MaWhit's Avatar
 
Join Date: Jan 2006
Location: Colorado
Posts: 240

Height: 5'7"

Default

PMed ya.
MaWhit is offline   Reply With Quote
Old 01-13-2007, 10:22 PM   #11  
Member
 
Happy Apple's Avatar
 
Join Date: Nov 2006
Posts: 31

S/C/G: 286/145

Default

Count me in please, I'd love a copy as well. I've got a spreadsheet, but it's really REALLY boring, lol!

Thank you so much for sharing this, it'll make things more fun!
Happy Apple is offline   Reply With Quote
Old 01-13-2007, 10:41 PM   #12  
There is no Try
Thread Starter
 
YodaGirl's Avatar
 
Join Date: Nov 2006
Location: Florida
Posts: 25

S/C/G: 215/213.4/135

Height: 5'4"

Default

Please PM with an email if you are requesting a copy of the spreadsheet, it will be really helpful -- otherwise I'm going to have to PM you anyway to get your email... LOL

Thanks much!

I'm a little behind at the moment, but will try to get them out tomorrow and Monday. I'm so excited that so many people think it's useful!
YodaGirl is offline   Reply With Quote
Old 01-13-2007, 11:22 PM   #13  
Senior Member
 
RememberHowToSmile's Avatar
 
Join Date: Sep 2006
Location: San Diego, CA
Posts: 1,689

S/C/G: 300/180/135

Height: 5'3"

Default

I just wanted to let you know that you are not the only one that is that anal. I am too. I created an excel sheet that has all of the weights starting at 229 and going to 135. With each I have the BMI for my high and the stages of obesity (Morbidly Obese, Severely Obese, Obese, Overweight, Slightly Overweigh, and Healthy). I then have a date column where I put on what day I meat that weight.
RememberHowToSmile is offline   Reply With Quote
Old 01-14-2007, 12:45 AM   #14  
Senior Member
 
KCWMU's Avatar
 
Join Date: Oct 2006
Location: Texas
Posts: 137

S/C/G: 217/See Ticker/150

Height: 5'4"

Default

Whoo hoo, way to go ladies with your excel spreadsheets! I'm a computer teacher who is constantly trying to convice my students that they WILL be using excel for many different things for pretty much the rest of their lives, so I'm always excited to hear how people are using it differently!

Aubrey
KCWMU is offline   Reply With Quote
Old 01-14-2007, 01:41 AM   #15  
Resident Witchling
 
Nikaia's Avatar
 
Join Date: Oct 2005
Location: In exile, in TN
Posts: 647

S/C/G: 198/190/140

Height: 5'7"

Default

Ahem...I'd like to point out that I have never gotten *into* Excel and it has yet to hamper me. I figure out other ways to do things. Are you sure Excel is that vital?

This is a discussion I've had a few times...I have yet to have anybody who's really convinced me that Excel is *necessary* in life. It might be useful for some things - witness this creative application of it - but necessary?

*gets off soapbox*
Nikaia is offline   Reply With Quote
Reply


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

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



All times are GMT -4. The time now is 05:20 PM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.