Thread: Excel Slimming World Record - Version 2

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!!

18/01/2013 UPDATES
- Real time target formula's fixed
- start target dates formula's fixed
- min and max weight formula's fixed

03/02/2013 UPDATES
- Date achieved formula fixed

SW Record - v2.zip

---

26/02/2013 Version 3.0
- new measurements tracker
- set up to 8 measurements to track
- customise what to track
- customise how often you'd like to track it - anywhere from weekly to... well anything!
- graph shows predicted progress
- a line shows your predicted progress based on your average weekly losses
- Numbers rounded to the nearest half pound

If you have any other suggestions, please let me know!

SW_Record_v3.0.xlsx

---

FAQs
Always make sure you are using the latest version of the sheet, for some this may mean reentering a lot of information and for this I apologise.
In future I will itemise the updates I have made, that way you can both choose whether to update, or whether to just change the formula's yourself.

Please read the instructions included in the zip file you downloaded. There are quick start instructions included on the first sheet of the Excel file, and more in-depth instructions included as a .rtf file.

If your question relates to any of the following:

1. the interim targets in the 'Real Time Targets' section displaying the wrong weight/date/target number
2. the interim targets in the 'Start Details' target dates act as though you were starting your eating plan from today (rather than your actual start day)

Please download the latest version: SW Record - v2.zip

Q. My record won't update once I've filled in all the coloured rows provided.
A. You should be able to just include your new weight below your last weigh-in and hit enter. The table should automatically update. If this doesn't work grab the handle of the last cell in the last column of the last row and drag it down to the newly added weight (see images below - click to enlarge)
Attachment 75492

Attachment 75493

Attachment 75494

Q. I looked at the formula's for the my min/max dates, number of gains/loss' etc only go to the xxth row of the record table
A. Any formula that uses the details of the record table will automatically be updated when the table automatically expands. If your table won't automatically expand, see the previous question.

Q. When I achieve a target, the date achieved box doesn't show the date - just an error
A. 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, or download the latest version: SW Record - v2.zip

Q. Can you make an iPhone/iPad/Android/Blackberry/Smartphone/Tablet Version
A. This is something I would love to do and I am looking into it, although I would say it won't be happening soon - so don't hold your breath!

Thanks, this looks fantastic.
Will play around with it at lunchtime.
Wished I was this good with Excel x

thanks again xx

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

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??

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!

Originally Posted by shezam

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.

very slow!! thank you

Thats fab, thank you so much for your hard work!

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

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???

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/.

This is great. Thanks a million

Originally Posted by squiddie

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...

Originally Posted by craigmtc

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