Page 1 of 14 1 2 3 11 ... LastLast
Results 1 to 15 of 205
Like Tree50Likes

Thread: Excel Slimming World Record - Version 3.5

  1. #1
    Starting Again!

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


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


    Statistics:
    Total Weight Loss: 2st13lb
    Weight to Lose: 14st0lb
    % Lost 10.59%

    Excel Slimming World Record - Version 3.5

    17/04/2014 - Update

    Hi All,
    As you all know I've been ill and whatnot and I'm still working on that other all singing all dancing version, but I've had other priorities, like finding somewhere to live! In the meantime I have this new version which I'm calling 3.5 because I don't know where I've got to!! I know there is some problems with date predictions and so on and also people were confused with which version to download, so I'm going to change the layout of this post so there's just one download link so you can only click that, or the one in my signature. I've lost track of the features in previous versions, full details are below.

    Features
    - Use in stone and pounds
    - Pick up to 4 interim targets
    - Warning if you set a final target that is too high or low for a healthy BMI (you can ignore this, it won't affect the functionality)
    - Keeps track of your weight loss
    - Estimates target dates based on your progress
    - Insert photos at different stage of your journey
    - All you need to start is your height, start weight and goal weight
    - Requires Excel or other software that reads .xlsx files
    - Charts your progress in colourful line graph
    - Track your measurements as well as your weight - graphs these too

    Drawbacks/Potential Troubleshooting
    - At the moment you'll need to use Excel, I'm really trying hard to convert it to work with free software
    - Assumes you weigh in weekly
    - You might see errors like #N/A when you first open the file, fill in all your information and they should all go away
    - If you want to play around with the code, feel free, just go to Review > Unlock Worksheet the password is blank
    - If you download this new (or any) new version you will have to renter your progress
    - I want to log more than 9 measurements/12 weigh ins:
    When you get to the end of the measurements table and/or the weigh in table you need to unprotect the worksheet (Review > Unprotect Worksheet) and just put your new weight or measurement in as normal and the rest of the table will jump to fill in. If for some reason it doesn't automatically expand the table, you need to hover over the tiny square in cell 11-I until the mouse cursor turns to a double arrow, then click and drag it down to the new entry.



    Quick Start
    - Just fill in the green on the Dashboard!
    - The start date of you plan (I hate the word diet)
    - Your height (in feet and inches)
    - Your start weight (in stones and pounds)
    - Your interim targets (if you have any - you can fill in as many or as few as you like)
    - Your final Personal Attainment Target or PAT (you must fill in this one, even if youre not sure, just put in anything)
    - Finally put in what you'd like to lose on average every week (you should aim for 1 -2 pounds per week)
    - You can then fill in your measurements if you want to and how often you'd like to track them (every 4 weeks is a good idea)
    - The dashboard really comes into it's own when you start filling in the Weight Record;
    That is every week, after your weigh in, just pop your new weight in and you'll see the formulas do their thing.

    Anything Else
    - I try to be about to answer any questions, but there are lots of friendly people here who will help if they can
    - Feel free to share the record, but please don't credit steal!
    - If you make alternations or find cool things to do with it, feel free to share!
    - Please don't be mean - I'm one poorly fat lass doing the best she can!


    Download Now: SW_Record_Public_3_5.xlsx

    New unprotected version - use at your own risk: SW_Record_Public_3_5 -UNPROTECTED.xlsx
    Last edited by squiddie : 3 Days Ago at 03:03 PM Reason: 17/04/2014 - Version 3.5 Upload
    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record


  2. #2
    Likes to post
    GlamUp's Avatar
    Join Date
    18th May, 2012
    Location
    London
    Posts
    440
    Rep Power
    7
    Diet: Slimming World
    Height: 5ft3in
    Goal Weight: 10st0lb
    Goal Date: Summer 2014


    BMI Information:
    Goal BMI: 24.8
    Thanks, this looks fantastic.
    Will play around with it at lunchtime.
    Wished I was this good with Excel x
    Week 1: -1lb; Week 2: -3lbs; Week 3: -2lbs; Week 4: +2lbs;
    Week 5:
    -2lbs; Week 6: -2lbs; Week 7: STS; Week 8: STS; Week 9: STS; Week 10: STS; Week 11: -1lb


  3. #3
    Trendsetter!

    Mrs.S.'s Avatar
    Join Date
    1st December, 2010
    Location
    Leeds, UK
    Posts
    10,216
    Rep Power
    316
    Diet: Weight Watchers
    Height: 5ft9in
    Start Date: 14/05/2014
    Start Weight: 17st12.5lb
    Current Weight: 17st1.5lb
    Goal Weight: 14st0lb


    BMI Information:
    Start BMI: 37
    Current BMI: 35.4
    Goal BMI: 28.9


    Statistics:
    Total Weight Loss: 0st11lb
    Weight to Lose: 3st1.5lb
    % Lost 4.39%
    thanks again xx

  4. #4
    ♥ Slimming World ♥

    Princess_Stevie's Avatar
    Join Date
    29th March, 2011
    Location
    County Durham
    Posts
    9,808
    Rep Power
    447
    Diet: Slimming World
    Height: 5ft6in
    Start Date: 14th July 2014
    Start Weight: 12st5.5lb
    Current Weight: 11st13lb


    BMI Information:
    Start BMI: 28
    Current BMI: 27


    Statistics:
    Total Weight Loss: 0st6.5lb
    % Lost 3.75%
    I love this, it's really clever! I've saved it and entered all of my stats in. Actually can't wait to get weighed next week and put my new weight in, hehe. Thanks for sharing x

    Princess Stevie
    Rejoined as a brand new member 14-07-14!

    "Countdown to Tenerife" aim: lose 1st 9.5lb in 7wks
    Week 1: -4.5lb (1st 5lb to go!)
    Week 2: -2lb (1st 3lb to go!)
    Week 3: ??
    Week 4: ??
    Week 5: ??
    Week 6: ??
    Week 7: ??


    You can find my New Food Diary: here!


  5. #5
    Really Really likes to post!
    shezam's Avatar
    Join Date
    3rd January, 2012
    Location
    East Coast Scotland
    Posts
    1,103
    Rep Power
    14
    Diet: Slimming World
    Start Date: 8th January 2014
    Start Weight: 13st8.5lb
    Current Weight: 12st7.5lb
    Goal Weight: 10st7lb


    Statistics:
    Total Weight Loss: 1st1lb
    Weight to Lose: 2st0.5lb
    % Lost 7.87%
    Thank you!

    This is really great, i'm confused though, I've put my starting details in, where do I put the information from my weigh in tonight? in the dashboard chart under current stats? There is a forumla in there so i don't think i'm supposed to put tongihts details there??

  6. #6
    Really Really likes to post!
    shezam's Avatar
    Join Date
    3rd January, 2012
    Location
    East Coast Scotland
    Posts
    1,103
    Rep Power
    14
    Diet: Slimming World
    Start Date: 8th January 2014
    Start Weight: 13st8.5lb
    Current Weight: 12st7.5lb
    Goal Weight: 10st7lb


    Statistics:
    Total Weight Loss: 1st1lb
    Weight to Lose: 2st0.5lb
    % Lost 7.87%
    oops, just noticed you've only to write in the green boxes, so i've put my start date as last week, where do I put todays information? Sorry if i'm being very slow!

  7. #7
    ♥ Slimming World ♥

    Princess_Stevie's Avatar
    Join Date
    29th March, 2011
    Location
    County Durham
    Posts
    9,808
    Rep Power
    447
    Diet: Slimming World
    Height: 5ft6in
    Start Date: 14th July 2014
    Start Weight: 12st5.5lb
    Current Weight: 11st13lb


    BMI Information:
    Start BMI: 28
    Current BMI: 27


    Statistics:
    Total Weight Loss: 0st6.5lb
    % Lost 3.75%
    Quote Originally Posted by shezam View Post
    oops, just noticed you've only to write in the green boxes, so i've put my start date as last week, where do I put todays information? Sorry if i'm being very slow!
    Use the tabs at the bottom to navigate between the sheets. You input your results in the "record" sheet.

    Princess Stevie
    Rejoined as a brand new member 14-07-14!

    "Countdown to Tenerife" aim: lose 1st 9.5lb in 7wks
    Week 1: -4.5lb (1st 5lb to go!)
    Week 2: -2lb (1st 3lb to go!)
    Week 3: ??
    Week 4: ??
    Week 5: ??
    Week 6: ??
    Week 7: ??


    You can find my New Food Diary: here!


  8. #8
    Really Really likes to post!
    shezam's Avatar
    Join Date
    3rd January, 2012
    Location
    East Coast Scotland
    Posts
    1,103
    Rep Power
    14
    Diet: Slimming World
    Start Date: 8th January 2014
    Start Weight: 13st8.5lb
    Current Weight: 12st7.5lb
    Goal Weight: 10st7lb


    Statistics:
    Total Weight Loss: 1st1lb
    Weight to Lose: 2st0.5lb
    % Lost 7.87%
    very slow!! thank you
    Princess_Stevie likes this.

  9. #9
    Likes to post
    spinme307's Avatar
    Join Date
    26th March, 2012
    Posts
    168
    Rep Power
    24
    Height: 5ft6in
    Start Weight: 16st3.5lb
    Current Weight: 15st5.5lb
    Goal Weight: 12st0lb


    BMI Information:
    Start BMI: 36.7
    Current BMI: 34.8
    Goal BMI: 27.1


    Statistics:
    Total Weight Loss: 0st12lb
    Weight to Lose: 3st5.5lb
    % Lost 5.27%
    Thats fab, thank you so much for your hard work!


    Week 1-4 = -10lbs
    Week 5 = No wi...poorly sick
    Week 6 = -2lbs

    1. Get into 14's
    2. Club 10

    3. Get into 13's
    4. Fit into my favourite dress Size 16
    5. Fit into my favourite trousers Size 14...eeek!

  10. #10
    Likes to post
    LizB's Avatar
    Join Date
    15th April, 2012
    Location
    Huddersfield,UK
    Posts
    163
    Rep Power
    4
    Diet: Xenical/Low GI
    Height: 5ft6in
    Start Date: 12/08/13
    Start Weight: 18st10lb
    Current Weight: 17st3lb
    Goal Weight: 11st6lb


    BMI Information:
    Start BMI: 42.3
    Current BMI: 38.9
    Goal BMI: 25.8


    Statistics:
    Total Weight Loss: 1st7lb
    Weight to Lose: 5st11lb
    % Lost 8.02%
    Thanks for this! I filled it in last night and its really made me think about improving my reel time targets which at this point mean ill be at target by the end of 2016! No more naughty treats! Just a shame I can't get it to work on my phone to make me stop and think.


    Liz

    Sent from my iPhone using MiniMins
    The Road may be long and tough but I will get there in the end, PCOS will not beat me!

    ​TOTAL WEIGHT LOSS




    CHRISTMAS CHALLENGE




  11. #11
    Likes to post
    Amy_Maria's Avatar
    Join Date
    24th October, 2012
    Location
    Nottingham
    Posts
    162
    Rep Power
    3
    Diet: Slimming World
    Height: 5ft4in
    Start Date: 11/10/2012
    Start Weight: 14st7lb
    Current Weight: 12st2lb
    Goal Weight: 9st10lb
    Goal Date: 01/01/2014


    BMI Information:
    Start BMI: 34.8
    Current BMI: 29.2
    Goal BMI: 23.3


    Statistics:
    Total Weight Loss: 2st5lb
    Weight to Lose: 2st6lb
    % Lost 16.26%
    This is great I could never have done this myself. Thanks.
    There are a few errors, some I've managed to fix but there are some I'm not clever enough to fix if you could tell me what to change.
    Errors I have fixed = Real time targets - interim target 3 brings up target 1.
    Current Stats minimum weight only goes up to week 14 so if you put in more data than that you will need to change the 14 in the code to what ever number you are on on the record page.

    But the ones I can't fix are the start details club 10 and target dates, they are way out of what they should be and seem to be working out my expected dates as if I weighed my start weight now.

    Any help on how to fix this???

    Starting again after 6 months off plan.

    Last time I lost 2st11lbs then lost my way a little.

    Now I'm 12St 2lb and back on the waggon

    Hoping to lose another 2St2lbs along my way back to a healthy me

    This time im going to stick to calorie counting and exercise to get me there!!

  12. #12
    Regular Member
    craigmtc's Avatar
    Join Date
    11th June, 2012
    Posts
    70
    Rep Power
    3
    Excellent, thanks. Really helpful. The only thing I can't get to work are the dates for interim target on left side of the dashboard, although the dates are correct on the right hand side of dashboard/.
    Starting weight 15 stone 5.5lb
    Current weight 13 stone 10.5lb
    1/2 Stone Award
    1 Stone Award
    1.5 S tone Award
    Club 10 Award
    Target 12 stone

  13. #13
    Likes to post
    Jennie123's Avatar
    Join Date
    11th October, 2012
    Location
    Ireland
    Posts
    368
    Rep Power
    15
    Diet: Slimming World
    Height: 5ft8in
    Start Date: 26 Sept 2012
    Start Weight: 14st13lb
    Current Weight: 12st10lb
    Goal Weight: 11st6lb


    BMI Information:
    Start BMI: 31.8
    Current BMI: 27.1
    Goal BMI: 24.3


    Statistics:
    Total Weight Loss: 2st3lb
    Weight to Lose: 1st4lb
    % Lost 14.83%
    This is great. Thanks a million

  14. #14
    needs to get a life
    maintainer
    century club
    gazter's Avatar
    Join Date
    25th March, 2012
    Location
    Carlisle
    Posts
    1,398
    Rep Power
    106
    Diet: SW EE
    Height: 5ft11in
    Start Date: 07/03/2012
    Start Weight: 21st9.5lb
    Current Weight: 12st7.5lb
    Goal Weight: 12st7.5lb
    Goal Date: 25/4/2013


    BMI Information:
    Start BMI: 42.3
    Current BMI: 24.5
    Goal BMI: 24.5


    Statistics:
    Total Weight Loss: 9st2lb
    % Lost 42.17%
    Quote Originally Posted by squiddie View Post
    This is a follow up from the Excel Slimming World Record thread.

    This is the latest version of the the Excel Slimming World Record, updates include;

    - Use in stone and pounds
    - Pick up to 4 interim targets
    - Warning if you set a final target that is too high or low for a healthy BMI (you can ignore this, it won't affect the functionality)

    Other Functionality
    - Keeps track of your weight loss
    - Estimates target dates based on your progress
    - Insert photos at different stage of your journey
    - All you need to start is your height, start weight and goal weight
    - Instructions included in the zip
    - Requires Excel or other software that reads .xlsx files

    Any questions just ask!!

    Attachment 74805
    lol, been using your original one for ages...
    -127.5 lbs


  15. #15
    Starting Again!

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


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


    Statistics:
    Total Weight Loss: 2st13lb
    Weight to Lose: 14st0lb
    % Lost 10.59%
    Quote Originally Posted by craigmtc View Post
    Excellent, thanks. Really helpful. The only thing I can't get to work are the dates for interim target on left side of the dashboard, although the dates are correct on the right hand side of dashboard/.
    Hiya, could you please expand on what you mean by that? The dates on the left in the "Start Details" area are estimated dates based on your start date and what you've put in the weekly loss aim box. The dates on the right in the "Real Time Targets" area used today's date and your actual average weekly loss. The ones on the left don't change, but the right ones do. This way you can compare when you reach those targets - did you get there quicker, slower or on time.

    Hope This Helps,
    Natt
    Imagine. Believe. Achieve.
    Download the Excel Slimming World Record


Page 1 of 14 1 2 3 11 ... 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.