|
|
01-13-2007, 06:27 PM
|
#1
|
There is no Try
Thread Starter
Join Date: Nov 2006
Location: Florida
Posts: 25
S/C/G: 215/213.4/135
Height: 5'4"
|
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.
|
|
|
01-13-2007, 06:34 PM
|
#2
|
Senior Member
Join Date: Aug 2006
Location: San Diego, CA
Posts: 141
Height: 5'2.5"
|
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.
|
|
|
01-13-2007, 06:43 PM
|
#3
|
Senior Member
Join Date: Jul 2006
Posts: 2,860
S/C/G: 285.2/285.2/185
Height: 5'9"
|
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!
|
|
|
01-13-2007, 06:47 PM
|
#4
|
Resident Witchling
Join Date: Oct 2005
Location: In exile, in TN
Posts: 647
S/C/G: 198/190/140
Height: 5'7"
|
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!
|
|
|
01-13-2007, 07:13 PM
|
#5
|
newlifestyle
Join Date: Jun 2006
Location: Canada
Posts: 930
S/C/G: 250/200/177
Height: 5' 3"
|
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
|
|
|
01-13-2007, 07:28 PM
|
#6
|
There is no Try
Thread Starter
Join Date: Nov 2006
Location: Florida
Posts: 25
S/C/G: 215/213.4/135
Height: 5'4"
|
Ladies check your PM's. newlifestyle, I couldn't PM you -- need an email address to send it to. Thanks!
|
|
|
01-13-2007, 08:22 PM
|
#7
|
Kee
Join Date: Nov 2006
Posts: 253
S/C/G: 135/135/120
|
Hey Yodagirl i would love a copy as well!
|
|
|
01-13-2007, 08:40 PM
|
#8
|
Member
Join Date: Apr 2006
Location: Ohio
Posts: 70
|
Your spreadsheet sounds awesome. I'd like one too, please.
|
|
|
01-13-2007, 08:48 PM
|
#9
|
omeomy
Join Date: Aug 2004
Location: California
Posts: 93
S/C/G: 275/269.5/155
|
Hi yodagirl could i have one also thank you.........
|
|
|
01-13-2007, 08:54 PM
|
#10
|
Senior Member
Join Date: Jan 2006
Location: Colorado
Posts: 240
Height: 5'7"
|
PMed ya.
|
|
|
01-13-2007, 10:22 PM
|
#11
|
Member
Join Date: Nov 2006
Posts: 31
S/C/G: 286/145
|
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!
|
|
|
01-13-2007, 10:41 PM
|
#12
|
There is no Try
Thread Starter
Join Date: Nov 2006
Location: Florida
Posts: 25
S/C/G: 215/213.4/135
Height: 5'4"
|
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!
|
|
|
01-13-2007, 11:22 PM
|
#13
|
Senior Member
Join Date: Sep 2006
Location: San Diego, CA
Posts: 1,689
S/C/G: 300/180/135
Height: 5'3"
|
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.
|
|
|
01-14-2007, 12:45 AM
|
#14
|
Senior Member
Join Date: Oct 2006
Location: Texas
Posts: 137
S/C/G: 217/See Ticker/150
Height: 5'4"
|
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
|
|
|
01-14-2007, 01:41 AM
|
#15
|
Resident Witchling
Join Date: Oct 2005
Location: In exile, in TN
Posts: 647
S/C/G: 198/190/140
Height: 5'7"
|
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*
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 08:12 PM.
|