|
17th September, 2007
| #1 (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 | 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 |
|       |
| Register to remove these ads |
| |
|
17th September, 2007
| #2 (permalink) |
| Regular Member crewboi83's Profile Albums crewboi83's Photo Gallery Join Date: 15th August, 2007 Location: Newcastle
Posts: 55
My Mood:  Rep Power: 2 Diet: Cambridge | 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
__________________  |
|
| |
|
17th September, 2007
| #3 (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 | My Graph is only in days, so I can only see 7 days ahead, anyone know how to change this. |
|
| |
|
17th September, 2007
| #4 (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 | 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
__________________ Steve. |
|
| |
|
17th September, 2007
| #5 (permalink) |
| Likes to post  Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 172
Rep Power: 7 Diet: Cambridge - SS | 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. |
|
| |
|
17th September, 2007
| #6 (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 | 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.
__________________ Steve. |
|
| |
|
17th September, 2007
| #7 (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 | Hey Dub - if you need to upload a non-permitted type, just ZIP it and post the zip file. Mine is Excel too ....
__________________ Steve. |
|
| |
|
17th September, 2007
| #8 (permalink) |
| Likes to post Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 172
Rep Power: 7 Diet: Cambridge - SS |  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 02:40 PM. |
|
| |
|
18th September, 2007
| #9 (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 | Thank you so much, these are brilliant |
|
| |
|
18th September, 2007
| #10 (permalink) |
| Likes to post LucyLou's Profile Albums LucyLou's Photo Gallery Join Date: 1st September, 2007 Location: Dublin
Posts: 695
My Mood:  Rep Power: 13 Diet: Cambridge Diet | Steve your a legend! Best graph we could have asked for! cheers!
__________________ Louise |
|
| |
|
18th September, 2007
| #11 (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 | isnt it brilliant, fantastic. Thanks ever so |
|
| |
|
18th September, 2007
| #12 (permalink) |
| Likes to post Dub07's Profile Albums Dub07's Photo Gallery Join Date: 17th August, 2007 Location: Dublin
Posts: 172
Rep Power: 7 Diet: Cambridge - SS |  Yes, Steve - yours is excellent! Thanks - have adopted it. |
|
| |
|
18th September, 2007
| #13 (permalink) |
| Likes to post  domino's Profile Albums domino's Photo Gallery Join Date: 24th May, 2007 Location: Norfolk
Posts: 185
Rep Power: 4 Diet: Cambridge | 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  |
|
| |
|
18th September, 2007
| #14 (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 | 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.
__________________ Steve. |
|
| |
|
18th September, 2007
| #15 (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 | 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!
__________________ Steve. |
|
| |
  |
| 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
