Page 3 of 16 FirstFirst 1 2 3 4 5 13 ... LastLast
Results 31 to 45 of 235
Like Tree61Likes

Thread: Excel Slimming World Record - Version 3.5

  1. #31
    Starting Again!


    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,223
    Rep Power
    346
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 23st12lb
    Goal Weight: 10st10lb
    Goal Date: 7/6/16


    BMI Information:
    Start BMI: 58.8
    Current BMI: 50.8
    Goal BMI: 22.8


    Statistics:
    Total Weight Loss: 3st11lb
    Weight to Lose: 13st2lb
    % Lost 13.7%
    Quote Originally Posted by HelzBelz View Post
    This is absolutely awesome but I don't suppose it would be possible to add a section for inch loss as well? Ie waist, chest, thigh etc as I know some people like to see the inch loss as well as the lb loss
    I will make this top of my priority list for version 3 (hopefully finished by mid-February).
    Thanks for the feedback!
    need 2 diet likes this.

  2. #32
    Likes to post

    Join Date
    13th January, 2012
    Location
    Kent
    Posts
    254
    Rep Power
    6
    Diet: Slimming World
    Height: 5ft5in
    Start Date: January 7th 2013
    Start Weight: 14st4.5lb
    Current Weight: 13st1lb
    Goal Weight: 12st5lb
    Goal Date: 23rd December


    BMI Information:
    Start BMI: 33.4
    Current BMI: 30.4
    Goal BMI: 28.8


    Statistics:
    Total Weight Loss: 1st3.5lb
    Weight to Lose: 0st10lb
    % Lost 8.73%
    Just filled my in. Beats trying to work out my own formulas!

    Thanks for this.

    x

  3. #33
    Likes to post

    Join Date
    13th June, 2010
    Location
    Birmingham
    Posts
    240
    Rep Power
    8
    Diet: weight watchers
    Height: 5ft1in
    Start Date: 27.10.2014
    Start Weight: 14st5.5lb
    Current Weight: 13st7.5lb
    Goal Weight: 9st12lb


    BMI Information:
    Start BMI: 38.1
    Current BMI: 35.8
    Goal BMI: 26.1


    Statistics:
    Total Weight Loss: 0st12lb
    Weight to Lose: 3st9.5lb
    % Lost 5.96%
    This is excellent but does anyone know how I save it?! spent ages filling in all the pics etc and clicked 'save as' come to look today and its gone ( Have tried to do same again, didnt work, tried copying onto blank spreadsheet but then the formulas didnt work... dont know why it wont save for me?! is it because it says read only?

    Thanks in advance! x

  4. #34
    Member

    Join Date
    30th January, 2013
    Posts
    1
    Rep Power
    0
    Start Weight: 13st0lb
    Current Weight: 12st8lb
    Goal Weight: 9st0lb


    Statistics:
    Total Weight Loss: 0st6lb
    Weight to Lose: 3st8lb
    % Lost 3.3%
    Just had to sign up to say thanks so much for this, I started trying to make one but not clever enough so thank you for sharing

  5. #35
    Likes to post

    Join Date
    31st January, 2010
    Location
    Leeds
    Posts
    390
    Rep Power
    68
    Diet: Slimming World
    Height: 6ft2in
    Start Date: 3rd January 2013
    Start Weight: 26st13lb
    Current Weight: 25st2lb
    Goal Weight: 16st10lb


    BMI Information:
    Start BMI: 48.4
    Current BMI: 45.2
    Goal BMI: 30


    Statistics:
    Total Weight Loss: 1st11lb
    Weight to Lose: 8st6lb
    % Lost 6.63%
    Thanks for this it's fab x

  6. #36
    Regular Member

    Join Date
    31st January, 2013
    Posts
    77
    Rep Power
    3
    Height: 5ft3in
    Start Date: 22 April 2014
    Start Weight: 14st3lb
    Current Weight: 12st5.5lb
    Goal Weight: 11st7lb


    BMI Information:
    Start BMI: 35.2
    Current BMI: 30.7
    Goal BMI: 28.5


    Statistics:
    Total Weight Loss: 1st11.5lb
    Weight to Lose: 0st12.5lb
    % Lost 12.81%
    Thank you so much for this, I am useless with excel I am just a filler-inner and I coped brilliantly thanks to your hard work! I am doing this at home alone so this is a really nice tool, now all I need to do is work out how to get a 7lb sticker lol and I will feel like a proper Slimming Worlder!

  7. #37
    I will be a Princess!


    Join Date
    22nd April, 2010
    Location
    Pembroke Dock
    Posts
    7,242
    Rep Power
    267
    Diet: Slimming World
    Height: 5ft6in
    Start Date: 20/02/2015
    Start Weight: 18st2.5lb
    Current Weight: 18st2.5lb
    Goal Weight: 11st0lb
    Goal Date: Slow and steady wins the race...


    BMI Information:
    Start BMI: 41.1
    Current BMI: 41.1
    Goal BMI: 24.9


    Statistics:
    Weight to Lose: 7st2.5lb
    % Lost 0%
    Hi Squiddie...I've just updated the latest version (v2) and I've achieved Club 10 and my first interim target this week, but in the date achieved box in the Real Time Targets section it's not showing up the dates, it's just showing #N/A. Any idea what I need to do to fix this? xx

  8. #38
    Starting Again!


    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,223
    Rep Power
    346
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 23st12lb
    Goal Weight: 10st10lb
    Goal Date: 7/6/16


    BMI Information:
    Start BMI: 58.8
    Current BMI: 50.8
    Goal BMI: 22.8


    Statistics:
    Total Weight Loss: 3st11lb
    Weight to Lose: 13st2lb
    % Lost 13.7%
    Quote Originally Posted by dudette2001uk View Post
    Hi Squiddie...I've just updated the latest version (v2) and I've achieved Club 10 and my first interim target this week, but in the date achieved box in the Real Time Targets section it's not showing up the dates, it's just showing #N/A. Any idea what I need to do to fix this? xx
    Hiya, I'm not sure why this would be, I've just checked in my testing sheet and it's come up ok - so I've sent you a PM.

  9. #39
    Likes to post

    Join Date
    6th January, 2013
    Posts
    360
    Rep Power
    6
    Diet: Slimming World
    Height: 5ft9in
    Start Date: 7th Jan 2013
    Start Weight: 25st7.5lb
    Current Weight: 21st0.5lb
    Goal Weight: 20st0lb


    BMI Information:
    Start BMI: 52.8
    Current BMI: 43.5
    Goal BMI: 41.3


    Statistics:
    Total Weight Loss: 4st7lb
    Weight to Lose: 1st0.5lb
    % Lost 17.62%
    I actually have a similar problem, on my dashboard my start details are fine but my current details all say either #N/A or err508 or err502 so I'm guessing I must have typed something wrong somewhere along the lines but no idea where or what!

  10. #40
    Starting Again!


    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,223
    Rep Power
    346
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 23st12lb
    Goal Weight: 10st10lb
    Goal Date: 7/6/16


    BMI Information:
    Start BMI: 58.8
    Current BMI: 50.8
    Goal BMI: 22.8


    Statistics:
    Total Weight Loss: 3st11lb
    Weight to Lose: 13st2lb
    % Lost 13.7%
    The issue seems to be if you extend the table beyond the current week. The way to fix it is to change the formula in each of the date achieved cells (not the one with the text, the one where the actual date should appear).
    For example the one for Club10 is:
    Code:
    =IF(E5="","",IF(E7="","",IF(E9="","",IF(Dashboard!K14="",E21,IF(Dashboard!K6<=P5,INDEX(Record!$A$2:$A$14,MATCH("Club10 Achieved!",Record!$O$2:$O$14,0)),K5+(K6-E9)/K14*7)))))
    You need to remove the $'s and the numbers so it reads:
    Code:
    =IF(E5="","",IF(E7="","",IF(E9="","",IF(Dashboard!K14="",E21,IF(Dashboard!K6<=P5,INDEX(Record!A:A,MATCH("Club10 Achieved!",Record!O:O,0)),K5+(K6-E9)/K14*7)))))
    In other words, Record!$A$2:$A$14 needs to change to Record!A:A and Record!$O2:$O14 needs to become Record!O:O, and the same for the other targets
    T1 - A:A and Q:Q
    T2 - A:A and S:S
    T3 - A:A and U:U
    T4 - A:A and W:W
    PTA - A:A and Y:Y

    If anyone has any problems they can PM me and send me your sheet and I'll fix it for you, alternatively you can download an updated version from the first post in this thread.

  11. #41
    Likes to post

    Join Date
    6th January, 2013
    Posts
    360
    Rep Power
    6
    Diet: Slimming World
    Height: 5ft9in
    Start Date: 7th Jan 2013
    Start Weight: 25st7.5lb
    Current Weight: 21st0.5lb
    Goal Weight: 20st0lb


    BMI Information:
    Start BMI: 52.8
    Current BMI: 43.5
    Goal BMI: 41.3


    Statistics:
    Total Weight Loss: 4st7lb
    Weight to Lose: 1st0.5lb
    % Lost 17.62%
    OK I think I'm being really dense here, but I tried making the alterations to the one I had and it did not like it one little bit! lol! So I re-downloaded the new version (even though that was the one I was already using) and I've got the same problem, its very odd - I don't suppose it would have anything to do with me using openoffice rather than Excel or something? (even though they are pretty similar)

  12. #42
    Likes to post

    Join Date
    18th November, 2012
    Location
    Portsmouth
    Posts
    351
    Rep Power
    16
    Diet: Slimming World with a Lap-Bandô
    Height: 5ft8in
    Start Date: Friday 16th November 2012
    Start Weight: 15st2.5lb
    Current Weight: 13st4.5lb
    Goal Weight: 10st7lb


    BMI Information:
    Start BMI: 32.3
    Current BMI: 28.4
    Goal BMI: 22.3


    Statistics:
    Total Weight Loss: 1st12lb
    Weight to Lose: 2st11.5lb
    % Lost 12.24%
    I may be being really dim but where's the link to download from? It could be that I'm not seeing it because I'm on my phone.

  13. #43
    Starting Again!


    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,223
    Rep Power
    346
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 23st12lb
    Goal Weight: 10st10lb
    Goal Date: 7/6/16


    BMI Information:
    Start BMI: 58.8
    Current BMI: 50.8
    Goal BMI: 22.8


    Statistics:
    Total Weight Loss: 3st11lb
    Weight to Lose: 13st2lb
    % Lost 13.7%
    Quote Originally Posted by HelzBelz View Post
    OK I think I'm being really dense here, but I tried making the alterations to the one I had and it did not like it one little bit! lol! So I re-downloaded the new version (even though that was the one I was already using) and I've got the same problem, its very odd - I don't suppose it would have anything to do with me using openoffice rather than Excel or something? (even though they are pretty similar)
    I wouldn't have thought that OpenOffice would have made any difference, I changed the formula on the new version, so are you sure you downloaded the new one?. Either way, send me a PM and I can have a look at your sheet

    Quote Originally Posted by Harley Quinn View Post
    I may be being really dim but where's the link to download from? It could be that I'm not seeing it because I'm on my phone.
    I'm not sure if it's viewable on mobile, but it's on the first post of this thread, and also right here: Attachment 77921
    Harley Quinn likes this.

  14. #44
    Likes to post

    Join Date
    18th November, 2012
    Location
    Portsmouth
    Posts
    351
    Rep Power
    16
    Diet: Slimming World with a Lap-Bandô
    Height: 5ft8in
    Start Date: Friday 16th November 2012
    Start Weight: 15st2.5lb
    Current Weight: 13st4.5lb
    Goal Weight: 10st7lb


    BMI Information:
    Start BMI: 32.3
    Current BMI: 28.4
    Goal BMI: 22.3


    Statistics:
    Total Weight Loss: 1st12lb
    Weight to Lose: 2st11.5lb
    % Lost 12.24%
    Thanks - it looks FAB!

  15. #45
    Starting Again!


    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,223
    Rep Power
    346
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 23st12lb
    Goal Weight: 10st10lb
    Goal Date: 7/6/16


    BMI Information:
    Start BMI: 58.8
    Current BMI: 50.8
    Goal BMI: 22.8


    Statistics:
    Total Weight Loss: 3st11lb
    Weight to Lose: 13st2lb
    % Lost 13.7%
    I'm taking suggestions for the next version of the sheet, obviously it'll contain fixes and patches for problems with formulas, but any actual functionality you'd like added, let me know!

    So far I have:
    - include inches as well as weight
    - graph to show predicted progress

Page 3 of 16 FirstFirst 1 2 3 4 5 13 ... LastLast




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.