|
12-15-2008, 08:47 AM
|
#1
|
New mom, aspiring DVM
Thread Starter
Join Date: Mar 2007
Location: Ames, IA
Posts: 167
S/C/G: 280/ticker/135
Height: 5'7"
|
Anyone else love projections/charts?
Ok, so I'm aware that weight-loss is not a linear process. You lose 4 pounds one week and 0.2 for the next two, etc. There are a lot more factors involved than just straight calories in/out during a short time frame, but the overall trend reflects the caloric deficit (or at least that's how it is for me - some of you might manage to march ahead at a steady 2 pounds/week, every week!)
Anyhow, focusing on the "big picture" seems to help me keep on task - if I average 1000 calorie deficit/day (7000/week), over time I will average ~2 pounds/week. With that said, excel is my friend - I love to see the predictions that I'll be X weight by Y date, and, just as importantly, that even if I lose less, I'll still be making major progress as I move down the line. (i.e. if I "only" lose 1.5/week, I'll still be down X-5 amount by Y, instead of X) If you want to hear any more of my ranting on this, I put a big post on my blog, but I don't want to get long-winded here!
So, anyone else do this? Want to share your projections?
|
|
|
12-15-2008, 09:17 AM
|
#2
|
Stepping Up
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868
S/C/G: 228/ticker/160
Height: 5ft 9.5
|
whats your blog address?
|
|
|
12-15-2008, 10:05 AM
|
#3
|
Back in Action
Join Date: Jun 2008
Location: A Nebraska Farm
Posts: 3,107
S/C/G: 213/197/140
Height: 5'6"
|
Hehe...I'm an accountant by trade....you should see how many projection charts I've made made over the years. Unfortunately *for me* I've never followed through on a single one. It's taken *me* the old "one day at a time" slogan to make it as far as I have this time.
|
|
|
12-15-2008, 10:07 AM
|
#4
|
Stepping Up
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868
S/C/G: 228/ticker/160
Height: 5ft 9.5
|
i want to learn how to do it!! anyone wanna help me?!
|
|
|
12-15-2008, 10:38 AM
|
#5
|
PR 1 Mile: 9:44
Join Date: Aug 2007
Location: Pensacola
Posts: 1,555
S/C/G: 200.5/160/130
Height: 5'-4"
|
I love this one I found online: http://southbeachcenturyclub.com/goal.php
you can view it as a webpage or in excel.
|
|
|
12-15-2008, 10:40 AM
|
#6
|
New mom, aspiring DVM
Thread Starter
Join Date: Mar 2007
Location: Ames, IA
Posts: 167
S/C/G: 280/ticker/135
Height: 5'7"
|
Whoops! I used to have my blog in my signature, but I lost it!
letstri.blogspot.com
It's more about my is-it-good-or-is-it-bad rambling about the charting, rather than how to do it. But I can sure put up a how-to if anyone's interested. I love this stuff!
Oh, and the vertical line there is my wedding in May.
Last edited by Rock Chalk Chick; 12-15-2008 at 10:42 AM.
|
|
|
12-15-2008, 11:56 AM
|
#7
|
Senior Member
Join Date: Apr 2008
Location: California
Posts: 7,097
S/C/G: 197/135/?
Height: 5'7"
|
I am so addicted to my spreadsheets it's not funny.
Last edited by JulieJ08; 12-15-2008 at 11:56 AM.
|
|
|
12-15-2008, 12:06 PM
|
#8
|
Just Yr Everyday Chick
Join Date: May 2004
Location: Florida
Posts: 10,852
S/C/G: Lost 50 lbs, regained some
Height: 5'3"
|
I love my FitDay charts! I even printed one out to take to my doctor so he could see my progress. He liked it, too!
Of course, I never did hit anything like the projections... my actual numbers were usually off; I don't think I ever hit a weight goal "on time." But, it gave me a trend to shoot for!
Jay
|
|
|
12-15-2008, 12:10 PM
|
#9
|
Senior Member
Join Date: Jan 2008
Location: The Deep South
Posts: 4,445
S/C/G: 237/165.8/130
Height: 5'4"
|
Spreadsheet Queen here. I have everything in Excel - menus, plans, calorie logs, shopping lists (with pricing), calorie projections, goals, charts ....
Yeah. I'm a geek.
.
|
|
|
12-15-2008, 12:14 PM
|
#10
|
Stepping Up
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868
S/C/G: 228/ticker/160
Height: 5ft 9.5
|
OMG. someone help me do this myself. i can do some basic stuff at work in excel (working out percentages of sales to footfall etc) but i would love to be able to do this!
|
|
|
12-15-2008, 12:15 PM
|
#11
|
serial rejoiner
Join Date: Aug 1999
Location: Washington DC area
Posts: 643
S/C/G: 296/264/160
Height: 5' 8"
|
How many times? Three times a day maybe I don't do it on line, or on a spread sheet. I do it the old-fashioned way, writing down the dates and the projected weight, usually in three columns, Possible, Bad, and Whistling Dixie (the 3 pounds a week option).
I know it's silly, but it keeps me from eating Of course, I could be walking....
|
|
|
12-15-2008, 12:33 PM
|
#12
|
New mom, aspiring DVM
Thread Starter
Join Date: Mar 2007
Location: Ames, IA
Posts: 167
S/C/G: 280/ticker/135
Height: 5'7"
|
Quote:
Originally Posted by PrettyPaula
OMG. someone help me do this myself. i can do some basic stuff at work in excel (working out percentages of sales to footfall etc) but i would love to be able to do this!
|
Ok, it's pretty straightforward, if you know the basics of excel.
My approach is to make a column of weights vs dates, and then create the graph. First cell (let's say A2) - starting weight. Next one down (A3) - " =A2-2". And so on - if you enter the formula (=A2-2), then you can select and drag down to create the column (each one will be 2 less than the one above).
Then do the same with the dates - today's date, then a week from now, then drag.
Depending on the version of excel, you can then do "insert chart" and either create an X-Y graph and "add trendline" or directly create a line-scatter plot in the newest Excel.
Hopefully this makes sense - it's easier to show than explain!
|
|
|
12-15-2008, 12:49 PM
|
#13
|
Senior Member
Join Date: Apr 2008
Location: California
Posts: 7,097
S/C/G: 197/135/?
Height: 5'7"
|
Or the lazy way ... just draw a line
|
|
|
12-15-2008, 12:57 PM
|
#14
|
aka Sarah
Join Date: May 2008
Posts: 1,221
S/C/G: 289/193/159
Height: 5'7"
|
I go a little farther. I have my weight loss projected in a spreadsheet based not on a flat number of pounds per week, but based on my actual current overall rate of loss (0.6% of bodyweight per week). I also have a bodyfat % projection based on my current rate of loss and an assumption about how much of that loss is fat versus lean.
At my current rate, it will take me until around March 2010 to be at goal. I'm mostly OK with that, though I am currently attempting to tweak my exercise and food to raise my rate a little.
|
|
|
12-15-2008, 02:44 PM
|
#15
|
I will be positive
Join Date: Oct 2008
Location: Ontario, Canada
Posts: 299
S/C/G: 224/183/135
Height: 5'4"
|
someone posted this site one day. you put in a little info and it will do the projection for you. i like to look every now and then to see if i'm on track for my trip to vegas in april
http://losertown.org/eats/cal.php
|
|
|
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 02:08 PM.
|