Page 1 of 24 1 2 3 11 ... LastLast
Results 1 to 15 of 351
Like Tree9Likes

Thread: Graph or Spreadsheet

  1. #1
    Likes to post

    Join Date
    17th April, 2007
    Location
    Great Missenden
    Posts
    335
    Rep Power
    36
    Diet: Cambridge SS
    Height: 5ft4in
    Start Date: 2nd August 2010
    Start Weight: 13st7lb
    Current Weight: 10st7lb
    Goal Weight: 10st7lb
    Goal Date: 2nd November 2010


    BMI Information:
    Start BMI: 32.4
    Current BMI: 25.2
    Goal BMI: 25.2


    Statistics:
    Total Weight Loss: 3st0lb
    % 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

  2. #2
    Regular Member

    Join Date
    15th August, 2007
    Location
    Newcastle
    Posts
    90
    Rep Power
    8
    Diet: Slim and Save
    Height: 5ft6in
    Start Date: 14/11/2012
    Start Weight: 14st10lb
    Current Weight: 14st8lb
    Goal Weight: 11st1lb


    BMI Information:
    Start BMI: 33.2
    Current BMI: 32.9
    Goal BMI: 25


    Statistics:
    Total Weight Loss: 0st2lb
    Weight to Lose: 3st7lb
    % Lost 0.97%
    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. #3
    Likes to post

    Join Date
    17th April, 2007
    Location
    Great Missenden
    Posts
    335
    Rep Power
    36
    Diet: Cambridge SS
    Height: 5ft4in
    Start Date: 2nd August 2010
    Start Weight: 13st7lb
    Current Weight: 10st7lb
    Goal Weight: 10st7lb
    Goal Date: 2nd November 2010


    BMI Information:
    Start BMI: 32.4
    Current BMI: 25.2
    Goal BMI: 25.2


    Statistics:
    Total Weight Loss: 3st0lb
    % 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. #4
    Likes to post

    Join Date
    25th September, 2006
    Location
    Swindon, Wiltshire
    Posts
    509
    Rep Power
    26
    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. #5
    Likes to post

    Join Date
    17th August, 2007
    Location
    Dublin
    Posts
    259
    Rep Power
    14
    Diet: Dukan - Cruise
    Height: 5ft2in
    Start Date: 15/08/11
    Start Weight: 11st5lb
    Current Weight: 9st11lb
    Goal Weight: 7st12lb
    Goal Date: 31/01/11


    BMI Information:
    Start BMI: 29.1
    Current BMI: 25.1
    Goal BMI: 20.1


    Statistics:
    Total Weight Loss: 1st8lb
    Weight to Lose: 1st13lb
    % 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.




    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

  6. #6
    Likes to post

    Join Date
    25th September, 2006
    Location
    Swindon, Wiltshire
    Posts
    509
    Rep Power
    26
    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 Attached Files

  7. #7
    Likes to post

    Join Date
    25th September, 2006
    Location
    Swindon, Wiltshire
    Posts
    509
    Rep Power
    26
    Hey Dub - if you need to upload a non-permitted type, just ZIP it and post the zip file. Mine is Excel too ....

  8. #8
    Likes to post

    Join Date
    17th August, 2007
    Location
    Dublin
    Posts
    259
    Rep Power
    14
    Diet: Dukan - Cruise
    Height: 5ft2in
    Start Date: 15/08/11
    Start Weight: 11st5lb
    Current Weight: 9st11lb
    Goal Weight: 7st12lb
    Goal Date: 31/01/11


    BMI Information:
    Start BMI: 29.1
    Current BMI: 25.1
    Goal BMI: 20.1


    Statistics:
    Total Weight Loss: 1st8lb
    Weight to Lose: 1st13lb
    % Lost 13.84%

    Red face 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 01:40 PM




    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

  9. #9
    Likes to post

    Join Date
    17th April, 2007
    Location
    Great Missenden
    Posts
    335
    Rep Power
    36
    Diet: Cambridge SS
    Height: 5ft4in
    Start Date: 2nd August 2010
    Start Weight: 13st7lb
    Current Weight: 10st7lb
    Goal Weight: 10st7lb
    Goal Date: 2nd November 2010


    BMI Information:
    Start BMI: 32.4
    Current BMI: 25.2
    Goal BMI: 25.2


    Statistics:
    Total Weight Loss: 3st0lb
    % 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. #10
    Likes to post

    Join Date
    1st September, 2007
    Location
    Dublin
    Posts
    691
    Rep Power
    18
    Diet: Weight Watchers
    Start Date: 9th August 2014
    Start Weight: 15st11.5lb
    Current Weight: 15st8lb
    Goal Weight: 10st7lb
    Goal Date: Slow and stead....want to do it this time


    Statistics:
    Total Weight Loss: 0st3.5lb
    Weight to Lose: 5st1lb
    % Lost 1.58%
    Steve your a legend! Best graph we could have asked for!
    cheers!
    Louise

    Week 1: -3.5lbs (Simple Start)
    Week 2:
    Week 3:
    Week 4:

  11. #11
    Likes to post

    Join Date
    17th April, 2007
    Location
    Great Missenden
    Posts
    335
    Rep Power
    36
    Diet: Cambridge SS
    Height: 5ft4in
    Start Date: 2nd August 2010
    Start Weight: 13st7lb
    Current Weight: 10st7lb
    Goal Weight: 10st7lb
    Goal Date: 2nd November 2010


    BMI Information:
    Start BMI: 32.4
    Current BMI: 25.2
    Goal BMI: 25.2


    Statistics:
    Total Weight Loss: 3st0lb
    % 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. #12
    Likes to post

    Join Date
    17th August, 2007
    Location
    Dublin
    Posts
    259
    Rep Power
    14
    Diet: Dukan - Cruise
    Height: 5ft2in
    Start Date: 15/08/11
    Start Weight: 11st5lb
    Current Weight: 9st11lb
    Goal Weight: 7st12lb
    Goal Date: 31/01/11


    BMI Information:
    Start BMI: 29.1
    Current BMI: 25.1
    Goal BMI: 20.1


    Statistics:
    Total Weight Loss: 1st8lb
    Weight to Lose: 1st13lb
    % Lost 13.84%


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




    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

  13. #13
    Likes to post
    domino's Avatar
    Join Date
    24th May, 2007
    Location
    Norfolk
    Posts
    273
    Rep Power
    21
    Diet: Exante
    Height: 5ft5in
    Start Date: Exante start: 11.4.11
    Start Weight: 13st6lb
    Current Weight: 12st13lb
    Goal Weight: 10st10lb
    Goal Date: Summer 2011


    BMI Information:
    Start BMI: 31.3
    Current BMI: 30.1
    Goal BMI: 25


    Statistics:
    Total Weight Loss: 0st7lb
    Weight to Lose: 2st3lb
    % 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. #14
    Likes to post

    Join Date
    25th September, 2006
    Location
    Swindon, Wiltshire
    Posts
    509
    Rep Power
    26
    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. #15
    Likes to post

    Join Date
    25th September, 2006
    Location
    Swindon, Wiltshire
    Posts
    509
    Rep Power
    26
    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!

Page 1 of 24 1 2 3 11 ... LastLast

Similar Threads

  1. I want to chart my losses on a graph, anyone know a good website for this ?
    By Bigmama2littlemama in forum Cambridge Diet Forum
    Replies: 3
    Last Post: 8th February, 2007, 10:21 AM




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 ©2011, Crawlability, Inc.