Weight Loss Support Give and get support here!

Reply
 
Thread Tools
Old 12-15-2008, 08:47 AM   #1  
New mom, aspiring DVM
Thread Starter
 
Rock Chalk Chick's Avatar
 
Join Date: Mar 2007
Location: Ames, IA
Posts: 167

S/C/G: 280/ticker/135

Height: 5'7"

Default 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?
Rock Chalk Chick is offline   Reply With Quote
Old 12-15-2008, 09:17 AM   #2  
Stepping Up
 
PrettyPaula's Avatar
 
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868

S/C/G: 228/ticker/160

Height: 5ft 9.5

Default

whats your blog address?
PrettyPaula is offline   Reply With Quote
Old 12-15-2008, 10:05 AM   #3  
Back in Action
 
Lori Bell's Avatar
 
Join Date: Jun 2008
Location: A Nebraska Farm
Posts: 3,107

S/C/G: 213/197/140

Height: 5'6"

Default

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.
Lori Bell is offline   Reply With Quote
Old 12-15-2008, 10:07 AM   #4  
Stepping Up
 
PrettyPaula's Avatar
 
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868

S/C/G: 228/ticker/160

Height: 5ft 9.5

Default

i want to learn how to do it!! anyone wanna help me?!
PrettyPaula is offline   Reply With Quote
Old 12-15-2008, 10:38 AM   #5  
PR 1 Mile: 9:44
 
dixied's Avatar
 
Join Date: Aug 2007
Location: Pensacola
Posts: 1,555

S/C/G: 200.5/160/130

Height: 5'-4"

Default

I love this one I found online: http://southbeachcenturyclub.com/goal.php

you can view it as a webpage or in excel.
dixied is offline   Reply With Quote
Old 12-15-2008, 10:40 AM   #6  
New mom, aspiring DVM
Thread Starter
 
Rock Chalk Chick's Avatar
 
Join Date: Mar 2007
Location: Ames, IA
Posts: 167

S/C/G: 280/ticker/135

Height: 5'7"

Default

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.
Rock Chalk Chick is offline   Reply With Quote
Old 12-15-2008, 11:56 AM   #7  
Senior Member
 
JulieJ08's Avatar
 
Join Date: Apr 2008
Location: California
Posts: 7,097

S/C/G: 197/135/?

Height: 5'7"

Default

I am so addicted to my spreadsheets it's not funny.

Last edited by JulieJ08; 12-15-2008 at 11:56 AM.
JulieJ08 is offline   Reply With Quote
Old 12-15-2008, 12:06 PM   #8  
Just Yr Everyday Chick
 
JayEll's Avatar
 
Join Date: May 2004
Location: Florida
Posts: 10,852

S/C/G: Lost 50 lbs, regained some

Height: 5'3"

Default

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
JayEll is offline   Reply With Quote
Old 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"

Default

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.

.
PhotoChick is offline   Reply With Quote
Old 12-15-2008, 12:14 PM   #10  
Stepping Up
 
PrettyPaula's Avatar
 
Join Date: Apr 2008
Location: Nottingham, UK
Posts: 868

S/C/G: 228/ticker/160

Height: 5ft 9.5

Default

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!
PrettyPaula is offline   Reply With Quote
Old 12-15-2008, 12:15 PM   #11  
Xan
serial rejoiner
 
Xan's Avatar
 
Join Date: Aug 1999
Location: Washington DC area
Posts: 643

S/C/G: 296/264/160

Height: 5' 8"

Default

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....
Xan is offline   Reply With Quote
Old 12-15-2008, 12:33 PM   #12  
New mom, aspiring DVM
Thread Starter
 
Rock Chalk Chick's Avatar
 
Join Date: Mar 2007
Location: Ames, IA
Posts: 167

S/C/G: 280/ticker/135

Height: 5'7"

Default

Quote:
Originally Posted by PrettyPaula View Post
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!
Rock Chalk Chick is offline   Reply With Quote
Old 12-15-2008, 12:49 PM   #13  
Senior Member
 
JulieJ08's Avatar
 
Join Date: Apr 2008
Location: California
Posts: 7,097

S/C/G: 197/135/?

Height: 5'7"

Default

Or the lazy way ... just draw a line
JulieJ08 is offline   Reply With Quote
Old 12-15-2008, 12:57 PM   #14  
aka Sarah
 
WarMaiden's Avatar
 
Join Date: May 2008
Posts: 1,221

S/C/G: 289/193/159

Height: 5'7"

Default

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.
WarMaiden is offline   Reply With Quote
Old 12-15-2008, 02:44 PM   #15  
I will be positive
 
inspired by you's Avatar
 
Join Date: Oct 2008
Location: Ontario, Canada
Posts: 299

S/C/G: 224/183/135

Height: 5'4"

Default

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
inspired by you 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 02:08 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 © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.