Page 3 of 12 FirstFirst 1 2 3 4 5 ... LastLast
Results 31 to 45 of 168
Like Tree39Likes

Thread: Excel Slimming World Record - Version 2

  1. #31
    Starting Again!

    squiddie's Avatar
    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,205
    Rep Power
    345
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 26st9.5lb
    Goal Weight: 10st10lb


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


    Statistics:
    Total Weight Loss: 0st13.5lb
    Weight to Lose: 15st13.5lb
    % Lost 3.49%
    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.

    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record

  2. #32
    Likes to post
    Just_Becca's Avatar
    Join Date
    13th January, 2012
    Location
    Kent
    Posts
    261
    Rep Power
    5
    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
    Get into the 13's - ACHIEVED 04/02/13
    Lose 1 stone - ACHIVED 30/03/13

    Lose 1.5 stone
    Club 10!
    BMI to Overweight
    Lose 2 Stone

    Link to my diary: Beating the Bulge... once and for all
    http://www.minimins.com/slimming-wor...-once-all.html







  3. #33
    Likes to post
    ticktock's Avatar
    Join Date
    13th June, 2010
    Location
    Birmingham
    Posts
    216
    Rep Power
    6
    Diet: Slim & Save
    Height: 5ft1in
    Start Date: 01.01.2014
    Start Weight: 14st7lb
    Current Weight: 13st6lb
    Goal Weight: 9st12lb


    BMI Information:
    Start BMI: 38.4
    Current BMI: 35.5
    Goal BMI: 26.1


    Statistics:
    Total Weight Loss: 1st1lb
    Weight to Lose: 3st8lb
    % Lost 7.39%
    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
    Slim&Save Start date 24.01.2014
    Start: 14st 7lb
    WK1. 14st 0lb lost 7lb
    WK2. 13st 10lb lost 4lb total loss 11lb
    WK3. 13st 8lb lost 2lb total loss 13lb
    WK4. 13st 6lb lost 2lb total loss 1st 1lb
    WK5. 13st 6lb lost 0lb total loss 1st 1lb
    WK6.

  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
    67
    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
    Pickle87
    I wanna be a yummy mummy not a weighty matey!
    1) Lose 1/2 a stone Achieved 10/01/13
    2) Lose 1 stone Achieved 24/01/13
    3) Lose 1.5 stone Achieved 14/02/13
    4) Get bronze body magic award
    5) Get Club 10 award

    January: 18lb lost, 2 SOTW, SOTM
    February: -0.5, -6.5 2 SOTW

  6. #36
    Regular Member

    Join Date
    31st January, 2013
    Posts
    10
    Rep Power
    0
    Height: 5ft3in
    Start Date: 7 January 2013
    Start Weight: 13st13lb
    Current Weight: 12st11.5lb


    BMI Information:
    Start BMI: 34.5
    Current BMI: 31.8


    Statistics:
    Total Weight Loss: 1st1.5lb
    % Lost 7.95%
    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!

    dudette2001uk's Avatar
    Join Date
    22nd April, 2010
    Location
    Pembroke Dock
    Posts
    6,514
    Rep Power
    258
    Diet: Slimming World
    Height: 5ft6in
    Start Date: Restart date - 07/03/2014
    Start Weight: 16st1lb
    Current Weight: 16st1lb
    Goal Weight: 11st0lb
    Goal Date: Slow and steady wins the race...


    BMI Information:
    Start BMI: 36.3
    Current BMI: 36.3
    Goal BMI: 24.9


    Statistics:
    Weight to Lose: 5st1lb
    % 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


    http://www.minimins.com/slimming-wor...ml#post6845095

    Goal 1: Lose 0.5 stone
    Goal 2: Lose 1 stone
    Goal 3: Lose 1.5 stone
    Goal 4: Lose 2 stone
    Goal 5: Lose 2.5 stone
    Goal 6: Lose 3 stone




    Restart weight (07/03/2014): 16 stone 1lb (225lb)



  8. #38
    Starting Again!

    squiddie's Avatar
    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,205
    Rep Power
    345
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 26st9.5lb
    Goal Weight: 10st10lb


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


    Statistics:
    Total Weight Loss: 0st13.5lb
    Weight to Lose: 15st13.5lb
    % Lost 3.49%
    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.

    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record

  9. #39
    Likes to post
    HelzBelz's Avatar
    Join Date
    6th January, 2013
    Posts
    360
    Rep Power
    5
    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!
    Total lost to date: 63lbs





  10. #40
    Starting Again!

    squiddie's Avatar
    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,205
    Rep Power
    345
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 26st9.5lb
    Goal Weight: 10st10lb


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


    Statistics:
    Total Weight Loss: 0st13.5lb
    Weight to Lose: 15st13.5lb
    % Lost 3.49%
    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.

    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record

  11. #41
    Likes to post
    HelzBelz's Avatar
    Join Date
    6th January, 2013
    Posts
    360
    Rep Power
    5
    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)
    Total lost to date: 63lbs





  12. #42
    Likes to post
    Harley Quinn's Avatar
    Join Date
    18th November, 2012
    Location
    Portsmouth
    Posts
    361
    Rep Power
    15
    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.
    Running the madhouse: one husband (the Joker), one 8-year-old (Wee Chum), three cats, seven rats, three degus and a tarantula. Phew!

    Harley Quinn puts his cards on the table - my food diary.







  13. #43
    Starting Again!

    squiddie's Avatar
    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,205
    Rep Power
    345
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 26st9.5lb
    Goal Weight: 10st10lb


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


    Statistics:
    Total Weight Loss: 0st13.5lb
    Weight to Lose: 15st13.5lb
    % Lost 3.49%
    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: SW Record - v2.zip
    Harley Quinn likes this.

    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record

  14. #44
    Likes to post
    Harley Quinn's Avatar
    Join Date
    18th November, 2012
    Location
    Portsmouth
    Posts
    361
    Rep Power
    15
    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!
    Running the madhouse: one husband (the Joker), one 8-year-old (Wee Chum), three cats, seven rats, three degus and a tarantula. Phew!

    Harley Quinn puts his cards on the table - my food diary.







  15. #45
    Starting Again!

    squiddie's Avatar
    Join Date
    26th February, 2009
    Location
    Gloucester
    Posts
    2,205
    Rep Power
    345
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 27/02/2014
    Start Weight: 27st9lb
    Current Weight: 26st9.5lb
    Goal Weight: 10st10lb


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


    Statistics:
    Total Weight Loss: 0st13.5lb
    Weight to Lose: 15st13.5lb
    % Lost 3.49%
    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

    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record

Page 3 of 12 FirstFirst 1 2 3 4 5 ... 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.