Graph or Spreadsheet

Discussion in 'Cambridge Weight Plan' started by cmacca, 17 September 2007 Social URL.

  1. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    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
     
  2. Avatar

    MiniMins.com Matched Content

  3. crewboi83

    crewboi83 Full Member

    Posts:
    90
    Likes Received:
    1
    Start Weight:
    14st10lb
    Current Weight:
    14st8lb
    Goal Weight:
    11st1lb
    Lost(%):
    0st2lb(0.97%)
    Diet:
    Slim and Save
    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
     
  4. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    My Graph is only in days, so I can only see 7 days ahead, anyone know how to change this.
     
  5. SteveM

    SteveM Silver Member

    Posts:
    509
    Likes Received:
    51
    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
     
  6. Dub07

    Dub07 Full Member

    Posts:
    256
    Likes Received:
    9
    Start Weight:
    11st5lb
    Current Weight:
    9st11lb
    Goal Weight:
    7st12lb
    Lost(%):
    1st8lb(13.84%)
    Diet:
    Dukan - Cruise
    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.
     
  7. SteveM

    SteveM Silver Member

    Posts:
    509
    Likes Received:
    51
    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.
     

    Attached Files:

  8. SteveM

    SteveM Silver Member

    Posts:
    509
    Likes Received:
    51
    Hey Dub - if you need to upload a non-permitted type, just ZIP it and post the zip file. Mine is Excel too ....
     
  9. Dub07

    Dub07 Full Member

    Posts:
    256
    Likes Received:
    9
    Start Weight:
    11st5lb
    Current Weight:
    9st11lb
    Goal Weight:
    7st12lb
    Lost(%):
    1st8lb(13.84%)
    Diet:
    Dukan - Cruise
    Thanks Steve

    Light dawned when I saw your post, but I'd forgotten how to zip :D

    Here's my version, Claire...
     
    Last edited: 19 November 2007
  10. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    Thank you so much, these are brilliant
     
  11. LucyLou

    LucyLou Silver Member

    Posts:
    692
    Likes Received:
    6
    Start Weight:
    15st11.5lb
    Current Weight:
    15st5lb
    Goal Weight:
    10st7lb
    Lost(%):
    0st6.5lb(2.93%)
    Diet:
    Weight Watchers
    Steve your a legend! Best graph we could have asked for!
    cheers!
     
  12. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    isnt it brilliant, fantastic. Thanks ever so
     
  13. Dub07

    Dub07 Full Member

    Posts:
    256
    Likes Received:
    9
    Start Weight:
    11st5lb
    Current Weight:
    9st11lb
    Goal Weight:
    7st12lb
    Lost(%):
    1st8lb(13.84%)
    Diet:
    Dukan - Cruise
    :)

    Yes, Steve - yours is excellent! Thanks - have adopted it.
     
  14. domino

    domino Full Member

    Posts:
    273
    Likes Received:
    13
    Start Weight:
    13st6lb
    Current Weight:
    12st13lb
    Goal Weight:
    10st10lb
    Lost(%):
    0st7lb(3.72%)
    Diet:
    Exante
    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 :character00148:
     
  15. SteveM

    SteveM Silver Member

    Posts:
    509
    Likes Received:
    51
    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.
     
  16. SteveM

    SteveM Silver Member

    Posts:
    509
    Likes Received:
    51
    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!
     
  17. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    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
     
  18. Ings

    Ings Full Member

    Posts:
    104
    Likes Received:
    5
    Diet:
    Cambridge
    Thanks so much Steve!
     
  19. cmacca

    cmacca Full Member

    Posts:
    335
    Likes Received:
    19
    Start Weight:
    13st7lb
    Current Weight:
    10st7lb
    Goal Weight:
    10st7lb
    Lost(%):
    3st0lb(22.22%)
    Diet:
    Cambridge SS
    Can we make this a sticky so people can always have access to the spreadsheet.
     
  20. Big H

    Big H Silver Member

    Posts:
    640
    Likes Received:
    24
    Start Weight:
    23st11lb
    Current Weight:
    19st1lb
    Goal Weight:
    15st0lb
    Lost(%):
    4st10lb(19.82%)
    Diet:
    Slim & Save
    Steve - That chart is the bollox - big thanks
     
  21. hazel05

    hazel05 Full Member

    Posts:
    119
    Likes Received:
    24
    Diet:
    Cambridge Diet/ ww
    Hi Steve, thank you, thank you thank you! this is great, i love it!:thankyou:
     
Popular Forums
  1. MiniMins.com is a weight loss support community helping each other on their weight loss journey. We have a multitude of forums, from Slimming World and Exante, to Success Stories. Click the logo at the top right to return to the forum home page at any time.
Loading...