8Likes
LinkBack URL
About LinkBacksDoes anyone have an example of a graph or spreadsheet they are using to calculate weight loss and when you should be at goal etc, really need something to keep me motivated.
Thanks ever so
Does anyone have an example of a graph or spreadsheet they are using to calculate weight loss and when you should be at goal etc, really need something to keep me motivated.
Thanks ever so
13 Stone 7 lbs Start weight
10 Stone 7 lbs Goal weight
Week 1: 12 Stone 8lbs = 13 lbs loss
Week 2: 12 Stone 6.5lbs = 1.5lbs loss
Week 3: 12 Stone 2lbs = 4.5lbs loss
Week 4: 11 Stone 11lbs = 5lbs loss
Week 5: 11 Stone 7lbs = 4lbs loss
Week 6: 11 Stone 3lbs = 4lbs loss
Week 7: 11 Stone 1lb = 2lbs loss
Week 8: 10 Stone 12lbs = 3lbs loss
Week 10: 10 Stone 9lbs = 3lbs loss
2lbs until goal
Claire
That traker thing u use at the bottom has a graph on it when u update ur weight, shows u where u started and where u will b in a few weeks time if u keep going the rate u are now
My Graph is only in days, so I can only see 7 days ahead, anyone know how to change this.
13 Stone 7 lbs Start weight
10 Stone 7 lbs Goal weight
Week 1: 12 Stone 8lbs = 13 lbs loss
Week 2: 12 Stone 6.5lbs = 1.5lbs loss
Week 3: 12 Stone 2lbs = 4.5lbs loss
Week 4: 11 Stone 11lbs = 5lbs loss
Week 5: 11 Stone 7lbs = 4lbs loss
Week 6: 11 Stone 3lbs = 4lbs loss
Week 7: 11 Stone 1lb = 2lbs loss
Week 8: 10 Stone 12lbs = 3lbs loss
Week 10: 10 Stone 9lbs = 3lbs loss
2lbs until goal
Hi Claire - I have a spreadsheet that I developed that records your losses, does all the calcs, AND draws a graph!!
I will see if I can find it and post it here
I have one, but it's in Exel and that's not a permitted upload type. Sorry.
Claire, I don't want to publically post my email address, and I can't pm you, but if you can pm me your own email address, I'll send you my spreadsheet.
Week 1: -7lb
Week 2: -2lb
Week 3: -3lb
Week 4: -3lb
Week 5: -1lb
Week 6: -1lb
Week 7: sts (holiday naughtiness)
Week 8: -4lb
Week 9: -1lb
Week 10: -3lb
Here we go Claire - just fill in the yellow boxes as you go. It does the rest.
When you get past 30 weeks, just cut-n-insert the last row of figures into the block (right click the last line (e.g. 42), Copy, and then right click the following line (e.g. 43) and Insert Copied Cells). The graph automagically adjusts itself.
Hey Dub - if you need to upload a non-permitted type, just ZIP it and post the zip file. Mine is Excel too ....
Thanks Steve Light dawned when I saw your post, but I'd forgotten how to zip
Here's my version, Claire...
Last edited by Dub07 : 19th November, 2007 at 01:40 PM
Week 1: -7lb
Week 2: -2lb
Week 3: -3lb
Week 4: -3lb
Week 5: -1lb
Week 6: -1lb
Week 7: sts (holiday naughtiness
Week 8: -4lb
Week 9: -1lb
Week 10: -3lb
Thank you so much, these are brilliant
13 Stone 7 lbs Start weight
10 Stone 7 lbs Goal weight
Week 1: 12 Stone 8lbs = 13 lbs loss
Week 2: 12 Stone 6.5lbs = 1.5lbs loss
Week 3: 12 Stone 2lbs = 4.5lbs loss
Week 4: 11 Stone 11lbs = 5lbs loss
Week 5: 11 Stone 7lbs = 4lbs loss
Week 6: 11 Stone 3lbs = 4lbs loss
Week 7: 11 Stone 1lb = 2lbs loss
Week 8: 10 Stone 12lbs = 3lbs loss
Week 10: 10 Stone 9lbs = 3lbs loss
2lbs until goal
Steve your a legend! Best graph we could have asked for!
cheers!
isnt it brilliant, fantastic. Thanks ever so
13 Stone 7 lbs Start weight
10 Stone 7 lbs Goal weight
Week 1: 12 Stone 8lbs = 13 lbs loss
Week 2: 12 Stone 6.5lbs = 1.5lbs loss
Week 3: 12 Stone 2lbs = 4.5lbs loss
Week 4: 11 Stone 11lbs = 5lbs loss
Week 5: 11 Stone 7lbs = 4lbs loss
Week 6: 11 Stone 3lbs = 4lbs loss
Week 7: 11 Stone 1lb = 2lbs loss
Week 8: 10 Stone 12lbs = 3lbs loss
Week 10: 10 Stone 9lbs = 3lbs loss
2lbs until goal
Yes, Steve - yours is excellent! Thanks - have adopted it.
Week 1: -7lb
Week 2: -2lb
Week 3: -3lb
Week 4: -3lb
Week 5: -1lb
Week 6: -1lb
Week 7: sts (holiday naughtiness
Week 8: -4lb
Week 9: -1lb
Week 10: -3lb
Hey Steve ~ thought I was a bit of a whizz at excel, but you are the bomb. Excellent spreadsheet and highly informative re BMI, % of weight loss etc ~ kinda thing I really like, so thanks
I am thinking of extending it to do the estimated body fat %age as well based on gender, weight, and waist measurement ...... only a rough estimate based on a formula from one of Patrick Holfords books.
I have a separate spreadsheet that does that, and just thought I would combine the two.
BTW - you are all welcome. I found it a good inspiration to see the graph which is why I built this in the first place.
If anyone has any suggestions on what extra it could do, or what it could do better/different, then let me know!
Posting Permissions
Reply With Quote
