Thread: Excel Slimming World Record

Hi All,

After all the positive replies to my post the other week I officially started back on plan yesterday (Friday). I'm giving myself 20 syns to start with to get my way back into it. I will make an effort to post more as I'm much more useful at giving pep talks than receiving them!

Anyhoo I'm a little bit obsessed with starts and numbers and figures and what not so I've made a weight loss tracker with Excel. I thought I'd share it with you so you can use it for your own goals. At the moment it's just in it's BETA phase i.e. needing people to test it so please let me know if you find any bugs with it and I will try to fix it ASAP there are instructions included on the START HERE tab, however I've included more detailed instructions.

Features start details (date, weight height BMI), targets, timeline estimates, record, graph progress images.

I'd really appreciate your feedback and ideas.

Thanks All
Natt x

Edit: thanks to Chipmunk89 all problems *should* now be fixed in both records. Please accept my apologies for any hassle it has caused you. I am trying my best as a non-professional weight loss enthusiast.

SW Record - Pounds.zip
SW Record - Stones.zip

PS. Please Note: It is in .xslx format: that is Microsoft Excel 2003 and beyond, I'm working on making it compaitable up to Excel 1997 - however there is free software available on the internet that reads .xslx format.

Quick Start Guide
Fill in your start date, weight and height in the GREEN cells
For each weigh in add your new weight under the last weigh-in
When you get to end of the table, just add your weight as normal and the table will expand
Full instructions included

UPDATE
Version 3 has just been released. Keep up-to-date on this thread (Excel Slimming World Record - Version 2).
SW_Record_v3.0.xlsx

Im very impressed! I wish I was more capable on the computer.
I have completed it for my weight loss journey. The only thing was it gave me my club 10 at half pound heavier than when slimming world gave me mine but apart from that its brilliant

I love stuff like this I have tickers or trackers or whatever they are called all over my phone. I'll be sure to check it out when I go on the computer, thanks

Wow this is brill - but can you tell me how i can use it as stones and pounds rather than pounds?

Also loving the progress bit - can i upload a pic in there?

Thanks

This is fantastic Squiddie! I love all of the predicted dates - they're such a motivation! You must have put loads of work into this hun - very impressive! xx

P.S. Welcome back to SW - I'm also restarting my weight loss after faffing around for 18 months. Good luck!

Thank you so much, this is great.

Great, thanks!

Quick question - how do I add extra weeks to record my weight loss? Can I just copy the formulas down into the rows below?

Originally Posted by Sleepy59

Quick question - how do I add extra weeks to record my weight loss? Can I just copy the formulas down into the rows below?

To answer myself - yes! LOL

Thats very clever thanks for sharing!!!

Originally Posted by catkin69

The only thing was it gave me my club 10 at half pound heavier than when slimming world gave me mine but apart from that its brilliant

It may be slimming world round up and I round down or vice versa - I will look into this

Originally Posted by Trash

Wow this is brill - but can you tell me how i can use it as stones and pounds rather than pounds?

Also loving the progress bit - can i upload a pic in there?

Thanks

I'm working on a way to make it so you just input stones, however it will show you the stone equivalent and there is a weight converter included. The reason it uses pounds is for the maths! You can add your own photos using Insert > Image > Picture. Full details are given in the Instructions file.

Originally Posted by Sleepy59

Quick question - how do I add extra weeks to record my weight loss? Can I just copy the formulas down into the rows below?

You just need to type your weight as usual and the table will automatically expand. You can copy the forumla's down but the graph won't update. Look for the little arrow in the last cell of the bottom row and pull it down to include all the new rows.

Wow! Thank you for sharing. X

This is fantastic! The predicted dates are really inspirational (finding out I should reach my goal by haloween, and also realising im only a couple of weeks from my first target is really good!)

The green and blue boxes are really simple. Being able to put things in stones and pounds might make it more user friendly for people who are not used to excel, but im not sure how you could do that because of the formulas!

Really really impressive! And welcome back to SW!

This is brilliant - thank you!! I had to do advanced Excel for part of my AAT but I couldn't have managed to put something like this together!! OH and I are off to Vegas in August next year and looking at this I can see if I am really really good I will be at target by then. It's definitely given me the kick up the arse I need!!!

Thank You!!!

Welcome back Squiddie and I think you are a very clever lady. I am a complete IT dino!