![]() |
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 |
| | #16 (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% | Steve is there anyway something could be added that will show you when you will reach goal based on average weight losses ?, prob very complicated and I can just about write a basic formula in Excel so I am prob asking far too much here
__________________ 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 |
| | |
| | #17 (permalink) |
| Likes to post Ings's Profile Albums Ings's Photo Gallery Join Date: 29th August, 2007 Location: Betws yn Rhos, North Wales
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 6 ![]() Diet: Cambridge | Thanks so much Steve! |
| | |
| | #18 (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% | Can we make this a sticky so people can always have access to the spreadsheet.
__________________ 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 |
| | |
| | #19 (permalink) |
| Likes to post Big H's Profile Albums Big H's Photo Gallery Join Date: 3rd September, 2006
Posts: 600
Thanks: 50
Thanked 43 Times in 37 Posts
Rep Power: 73 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Calorie counting Height: 5' 11" Start Date: 2006 Start Weight: 316lb Current Weight: 240lb Goal Weight: 196lb BMI Information: Start BMI: 44.1 Current BMI: 33.5 Goal BMI: 27.3 Statistics: Total Weight Loss: 76lb Weight to Lose: 44lb % Lost 24.05% | Steve - That chart is the bollox - big thanks |
| | |
| | #20 (permalink) |
| Likes to post hazel05's Profile Albums hazel05's Photo Gallery Join Date: 9th July, 2007 Location: Shropshire
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 9 ![]() ![]() Diet: Cambridge Diet/ ww | Hi Steve, thank you, thank you thank you! this is great, i love it! |
| | |
| | #21 (permalink) |
| has started again!! Sez's Profile Albums Sez's Photo Gallery Join Date: 4th March, 2007 Location: Dorset, UK
Posts: 2,302
Blog Entries: 1 Thanks: 51
Thanked 6 Times in 6 Posts
Rep Power: 54 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Extra Easy Slimming World Height: 5' 5" | Thank you. hopefully the kick up the bum I need to motivate me again. About to fill it all in now, so grateful! |
| | |
| | #22 (permalink) |
| Chilling Porgeous's Profile Albums Porgeous's Photo Gallery Join Date: 6th August, 2007 Location: Leighton Buzzard
Posts: 7,221
Blog Entries: 4 Thanks: 15
Thanked 146 Times in 114 Posts
Rep Power: 605 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: CD SS Height: 5' 1" Start Date: 7/8/07 Start Weight: 197lb Current Weight: 122lb BMI Information: Start BMI: 37.2 Current BMI: 23 Goal BMI: Statistics: Total Weight Loss: 75lb % Lost 38.07% | Luvvin it! ![]() ![]() Gx |
| | |
| | #23 (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 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Okay Claire .... working on the "Estimate to Goal" for you. I'll let you know if I manage it. |
| | |
| | #24 (permalink) | |
| Moderator ![]() Summerskye's Profile Albums Summerskye's Photo Gallery Join Date: 20th July, 2006 Location: Loughton, Essex
Posts: 7,445
Thanks: 101
Thanked 190 Times in 162 Posts
Rep Power: 1181 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Cambridge Weight Plan Height: 5' 6" Start Date: 23.02.2006 Start Weight: 263lb Current Weight: 172lb Goal Weight: 161lb BMI Information: Start BMI: 42.4 Current BMI: 27.8 Goal BMI: 26 Statistics: Total Weight Loss: 91lb Weight to Lose: 11lb % Lost 34.6% | Quote:
__________________ ![]() ![]() ![]() ![]() ![]() ![]() Cambridge Maintainer of the Year 2008 Consultant to Cambridge Inspirations Award Winner 2009 http://www.thesun.co.uk/sol/homepage...-on-plane.html http://www.fabafterfifty.co.uk/2011/...?doing_wp_cron | |
| | |
| | #25 (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 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | Okay Claire ...... keep your old spreadsheet if you have loaded it up just in case this blows up!!! I have tested it with my own data and it seems to hold up okay .... I have attached a new version that: a) Has a number of bug fixes to deal with when cells are blank b) Adds two columns for average loss in lbs per day (Q) and per week (R) c) Adds and estimated date for Goal Weight (V/W) Let me know if it works out for you. I have just put in a bug-fix for when you hit goal weight or go under goal weight ..... Last edited by SteveM : 18th September, 2007 at 11:50 PM Reason: Update attachment to deal with reaching goal weight |
| | |
| | #26 (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% | You are amazing Steve, brilliant. What a motivation this is going to be.
__________________ 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 |
| | |
| | #27 (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% | Steve, just tried filling it in and the date boxes are not populating, they are just saying #value#, am I doing something wrong ?
__________________ 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 |
| | |
| | #28 (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% | No I lie, I put the starting date in the wrong format, I put 28th August 07 instead of 28/08/07. Now it works fine, THIS IS 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 |
| | |
| | #29 (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 ![]() ![]() ![]() ![]() ![]() ![]() ![]() | You had me worried for a moment there. I suppose I should/could put some validation on the entered values ....... but I think I will leave it for now. I suppose I should have all the dates in the same format though - that was a bit dense of me putting the Goal Date in a different format ...... If anyone finds any bugs etc, or has suggested improvements, then let me know and I will see what I can do. I will save them up (unless they are bugs) until I have a few and then work them. Not really sure what else this can do, though Claire did come up with an idea that I had never thought of, so you never know. I have been using this sheet now for 18 months (inc. during maintenance etc which has truly screwed my averages up!!), so I just took it for what it was and never thought about adding to it. |
| | |
| | #30 (permalink) |
| Likes to post Big H's Profile Albums Big H's Photo Gallery Join Date: 3rd September, 2006
Posts: 600
Thanks: 50
Thanked 43 Times in 37 Posts
Rep Power: 73 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Diet: Calorie counting Height: 5' 11" Start Date: 2006 Start Weight: 316lb Current Weight: 240lb Goal Weight: 196lb BMI Information: Start BMI: 44.1 Current BMI: 33.5 Goal BMI: 27.3 Statistics: Total Weight Loss: 76lb Weight to Lose: 44lb % Lost 24.05% | Steve - the chart is great 1 small change The Average weight loss is taking into consideration week 1 which is the starting point and has no weight loss - so it is bringing the actually average down Cheers mate |
| | |
![]() |
| 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 |