![]() |
Custom Search
MiniMins.com Site Search
Web Search |
| |||||||
| Cambridge Diet Forum Now known as the Cambridge Weight Plan, this forum is for people following the Cambridge Diet in all it's many forms. It is a place to get support if you are struggling, to discuss how you are coping, and share your successes. |
![]() |
| | LinkBack | Thread Tools |
| | #1 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 338
Thanks: 34
Thanked 6 Times in 6 Posts
Rep Power: 33 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Cambridge SS Height: 5' 4" Start Date: 2nd August 2010 Start Weight: 189lb Current Weight: 147lb Goal Weight: 147lb Goal Date: 2nd November 2010 BMI Information: Start BMI: 32.4 Current BMI: 25.2 Goal BMI: 25.2 Statistics: Total Weight Loss: 42lb Weight to Lose: 0lb % Lost 22.22% | Graph or Spreadsheet 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 |
| | |
| Register to remove these ads |
| | #2 (permalink) |
| Regular Member crewboi83's Profile Albums crewboi83's Photo Gallery Join Date: 15th August, 2007 Location: Newcastle
Posts: 88
Thanks: 0
Thanked 2 Times in 2 Posts
Rep Power: 5 ![]() Diet: Exante Height: 5' 6" Start Date: 11/01/2011 Start Weight: 204lb Current Weight: 190lb Goal Weight: 155lb BMI Information: Start BMI: 32.9 Current BMI: 30.7 Goal BMI: 25 Statistics: Total Weight Loss: 14lb Weight to Lose: 35lb % Lost 6.86% | 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 |
| | |
| | #3 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 338
Thanks: 34
Thanked 6 Times in 6 Posts
Rep Power: 33 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Cambridge SS Height: 5' 4" Start Date: 2nd August 2010 Start Weight: 189lb Current Weight: 147lb Goal Weight: 147lb Goal Date: 2nd November 2010 BMI Information: Start BMI: 32.4 Current BMI: 25.2 Goal BMI: 25.2 Statistics: Total Weight Loss: 42lb Weight to Lose: 0lb % Lost 22.22% | 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 |
| | |
| | #4 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 510
Thanks: 0
Thanked 11 Times in 9 Posts
Rep Power: 24 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | 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 |
| | |
| | #5 (permalink) |
| Likes to post Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 259
Thanks: 7
Thanked 8 Times in 6 Posts
Rep Power: 11 ![]() ![]() ![]() Diet: Dukan - Cruise Height: 5' 2" Start Date: 15/08/11 Start Weight: 159lb Current Weight: 137lb Goal Weight: 110lb Goal Date: 31/01/11 BMI Information: Start BMI: 29.1 Current BMI: 25.1 Goal BMI: 20.1 Statistics: Total Weight Loss: 22lb Weight to Lose: 27lb % Lost 13.84% | 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. |
| | |
| | #6 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 510
Thanks: 0
Thanked 11 Times in 9 Posts
Rep Power: 24 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | 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. |
| | |
| | #7 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 510
Thanks: 0
Thanked 11 Times in 9 Posts
Rep Power: 24 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Hey Dub - if you need to upload a non-permitted type, just ZIP it and post the zip file. Mine is Excel too .... |
| | |
| | #8 (permalink) |
| Likes to post Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 259
Thanks: 7
Thanked 8 Times in 6 Posts
Rep Power: 11 ![]() ![]() ![]() Diet: Dukan - Cruise Height: 5' 2" Start Date: 15/08/11 Start Weight: 159lb Current Weight: 137lb Goal Weight: 110lb Goal Date: 31/01/11 BMI Information: Start BMI: 29.1 Current BMI: 25.1 Goal BMI: 20.1 Statistics: Total Weight Loss: 22lb Weight to Lose: 27lb % Lost 13.84% | Light dawned when I saw your post, but I'd forgotten how to zip ![]() Here's my version, Claire...
__________________ ![]() 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 Last edited by Dub07 : 19th November, 2007 at 02:40 PM |
| | |
| | #9 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 338
Thanks: 34
Thanked 6 Times in 6 Posts
Rep Power: 33 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Cambridge SS Height: 5' 4" Start Date: 2nd August 2010 Start Weight: 189lb Current Weight: 147lb Goal Weight: 147lb Goal Date: 2nd November 2010 BMI Information: Start BMI: 32.4 Current BMI: 25.2 Goal BMI: 25.2 Statistics: Total Weight Loss: 42lb Weight to Lose: 0lb % Lost 22.22% | 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 |
| | |
| | #10 (permalink) |
| Likes to post LucyLou's Profile Albums LucyLou's Photo Gallery Join Date: 1st September, 2007 Location: Dublin
Posts: 695
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16 ![]() ![]() ![]() ![]() Diet: Cambridge Diet | Steve your a legend! Best graph we could have asked for! cheers!
__________________ Louise |
| | |
| | #11 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 338
Thanks: 34
Thanked 6 Times in 6 Posts
Rep Power: 33 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Cambridge SS Height: 5' 4" Start Date: 2nd August 2010 Start Weight: 189lb Current Weight: 147lb Goal Weight: 147lb Goal Date: 2nd November 2010 BMI Information: Start BMI: 32.4 Current BMI: 25.2 Goal BMI: 25.2 Statistics: Total Weight Loss: 42lb Weight to Lose: 0lb % Lost 22.22% | 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 |
| | |
| | #12 (permalink) |
| Likes to post Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 259
Thanks: 7
Thanked 8 Times in 6 Posts
Rep Power: 11 ![]() ![]() ![]() Diet: Dukan - Cruise Height: 5' 2" Start Date: 15/08/11 Start Weight: 159lb Current Weight: 137lb Goal Weight: 110lb Goal Date: 31/01/11 BMI Information: Start BMI: 29.1 Current BMI: 25.1 Goal BMI: 20.1 Statistics: Total Weight Loss: 22lb Weight to Lose: 27lb % Lost 13.84% | Yes, Steve - yours is excellent! Thanks - have adopted it. |
| | |
| | #13 (permalink) |
| Likes to post domino's Profile Albums domino's Photo Gallery Join Date: 24th May, 2007 Location: Norfolk
Posts: 273
Thanks: 4
Thanked 9 Times in 9 Posts
Rep Power: 18 ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Exante Height: 5' 5" Start Date: Exante start: 11.4.11 Start Weight: 188lb Current Weight: 181lb Goal Weight: 150lb Goal Date: Summer 2011 BMI Information: Start BMI: 31.3 Current BMI: 30.1 Goal BMI: 25 Statistics: Total Weight Loss: 7lb Weight to Lose: 31lb % Lost 3.72% | 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
__________________ |
| | |
| | #14 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 510
Thanks: 0
Thanked 11 Times in 9 Posts
Rep Power: 24 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | 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. |
| | |
| | #15 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 510
Thanks: 0
Thanked 11 Times in 9 Posts
Rep Power: 24 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | 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! |
| | |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want to chart my losses on a graph, anyone know a good website for this ? | Bigmama2littlemama | Cambridge Diet Forum | 3 | 8th February, 2007 11:21 AM |