|
18th September, 2007
| #16 (permalink) |
| Likes to post  cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 288
My Mood:  Rep Power: 6  Diet: Cambridge 790 | 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 |
|       |
|
18th September, 2007
| #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
My Mood: Rep Power: 3 Diet: Cambridge | Thanks so much Steve!
__________________ Ings x   Week 1: -9lbs Week 2: -6lbs Week 3: -0lbs  (not been 100% + TOTM)Week 4: -2lbs  |
|
| |
|
18th September, 2007
| #18 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 288
My Mood: Rep Power: 6 Diet: Cambridge 790 | Can we make this a sticky so people can always have access to the spreadsheet. |
|
| |
|
18th September, 2007
| #19 (permalink) |
| Likes to post  Big H's Profile Albums Big H's Photo Gallery Join Date: 3rd September, 2006
Posts: 175
My Mood:  Rep Power: 7 Height: 5' 11" Start Date: July 2006 Start Weight: 316lb Current Weight: 225lb Goal Weight: 214lb Goal Date: 19/12/08 BMI Information: Current BMI: 31.4 Start BMI: 44.1 Goal BMI: 29.8 Statistics: Total Weight Loss: 91lb Weight to Lose: 11lb % Lost 28.8% | Steve - That chart is the bollox - big thanks |
|
| |
|
18th September, 2007
| #20 (permalink) |
| Likes to post  hazel05's Profile Albums hazel05's Photo Gallery Join Date: 9th July, 2007 Location: Shropshire
Posts: 119
My Mood:  Rep Power: 6 Diet: Cambridge Diet/ ww | Hi Steve, thank you, thank you thank you! this is great, i love it!  |
|
| |
|
18th September, 2007
| #21 (permalink) |
| Maybe this time......  Sez's Profile Albums Sez's Photo Gallery Join Date: 4th March, 2007 Location: Dorset, UK
Posts: 2,182
My Mood:  Blog Entries: 1 Rep Power: 47   Diet: Cambridge diet | Thank you. hopefully the kick up the bum I need to motivate me again. About to fill it all in now, so grateful!
__________________ No more will I happen to become a fat person in a slim body; I am going to be slim in mind AND body!! (With thanks to KD!)    Mini Goals : Join WW for first time ever - Done 08/10/08 Lose first half stone Lose one stone Lose stone & a half and so it goes on.........  |
|
| |
|
18th September, 2007
| #22 (permalink) |
| Chilling  Porgeous's Profile Albums Porgeous's Photo Gallery Join Date: 6th August, 2007 Location: Leighton Buzzard
Posts: 5,502
My Mood:  Blog Entries: 4 Rep Power: 194  Diet: CD SS Height: 5' 1" Start Date: 7/8/07 Start Weight: 197lb Current Weight: 122lb BMI Information: Current BMI: 23 Start BMI: 37.2 Goal BMI: Statistics: Total Weight Loss: 75lb % Lost 38.07% | Luvvin it! Gx |
|
| |
|
18th September, 2007
| #23 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 345
My Mood:  Rep Power: 11 | Okay Claire .... working on the "Estimate to Goal" for you. I'll let you know if I manage it.
__________________ Steve. |
|
| |
|
18th September, 2007
| #24 (permalink) | |
| Cambridge Diet Counsellor  Summerskye's Profile Albums Summerskye's Photo Gallery Join Date: 20th July, 2006 Location: Loughton, Essex
Posts: 5,364
My Mood:  Rep Power: 140 Diet: Cambridge Diet (now maintenance) Height: 5' 6" Start Date: 23.02.2006 Start Weight: 263lb Current Weight: 154lb Goal Weight: 147lb Goal Date: 15.12.2006 BMI Information: Current BMI: 24.9 Start BMI: 42.4 Goal BMI: 23.7 Statistics: Total Weight Loss: 109lb Weight to Lose: 7lb % Lost 41.44% | Quote:
 | |
|
| |
|
18th September, 2007
| #25 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 345
My Mood: Rep Power: 11 | 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 .....
__________________ Steve. Last edited by SteveM : 18th September, 2007 at 11:50 PM. Reason: Update attachment to deal with reaching goal weight |
|
| |
|
19th September, 2007
| #26 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 288
My Mood: Rep Power: 6 Diet: Cambridge 790 | You are amazing Steve, brilliant. What a motivation this is going to be. |
|
| |
|
19th September, 2007
| #27 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 288
My Mood: Rep Power: 6 Diet: Cambridge 790 | Steve, just tried filling it in and the date boxes are not populating, they are just saying #value#, am I doing something wrong ? |
|
| |
|
19th September, 2007
| #28 (permalink) |
| Likes to post cmacca's Profile Albums cmacca's Photo Gallery Join Date: 17th April, 2007 Location: Great Missenden
Posts: 288
My Mood: Rep Power: 6 Diet: Cambridge 790 | 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 |
|
| |
|
19th September, 2007
| #29 (permalink) |
| Likes to post SteveM's Profile Albums SteveM's Photo Gallery Join Date: 25th September, 2006 Location: Swindon, Wiltshire
Posts: 345
My Mood: Rep Power: 11 | 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.
__________________ Steve. |
|
| |
|
19th September, 2007
| #30 (permalink) |
| Likes to post Big H's Profile Albums Big H's Photo Gallery Join Date: 3rd September, 2006
Posts: 175
My Mood: Rep Power: 7 Height: 5' 11" Start Date: July 2006 Start Weight: 316lb Current Weight: 225lb Goal Weight: 214lb Goal Date: 19/12/08 BMI Information: Current BMI: 31.4 Start BMI: 44.1 Goal BMI: 29.8 Statistics: Total Weight Loss: 91lb Weight to Lose: 11lb % Lost 28.8% | 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 | |
| Display Modes | |
| |
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 |
Linear Mode
