This A4-sized template in PDF format allows you to quickly and easily record all your meals and snacks during the week, as well as your Healthy Extras, Syns, Water intake, and Body Magic.
One of the main advantages over the official Slimming World diary is that it’s much bigger, and gives you more space to record the food and drink that you have.
I thought I’d share with you the tracking spreadsheet I created for monitoring my weight loss.
This spreadsheet was created using Microsoft Excel 2010, so it should work with that version or more recent versions. I haven’t tested it with Excel 2007.
The chart allows you to record your weekly weigh-ins in order to track progress. You enter data into the cells that have a white background, and all the values with a coloured background are calculated.
Each week enter:
Date – the day of the week and the number of weeks is then automatically calculated
Weight in stones and pounds – the equivalent in pounds and kilos is automatically calculated. If the date is also in the past then the recording is marked as ‘Real’ – to distinguish from any projected losses you might enter
Optionally record any target/award or countdown information that might apply.
The first line is your starting weight, so make sure that’s entered correctly.
The spreadsheet will calculate your weekly loss (the difference in weight from the previous line) and total loss to date (in both pounds and stones/pounds). It’ll also tell monitor your progress against a weekly loss goal (e.g. 2 lbs a week), and your current BMI value.
The chart
Above the chart you can enter your weekly weight loss goal – how much you’d like to lose per week. That’s used to plot a goal line on the chart – the blue line. Your actual weight loss is the red line.
Your Target is your PAT, and is shown as the purple line.
Your Club 10 value is automatically calculated and is shown as the cyan line
The height value needs to be set correctly (in metres) to calculate your BMI value.
The chart automatically updates whenever you enter new weight information.
UPDATE: In response to a number of requests I’ve updated the Excel to remove the protection, so anyone should be able to download the latest version and edit/amend/extend it to their heart’s content. Enjoy!
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Cookie
Duration
Description
_ga
2 years
The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.
_gat_gtag_UA_46938954_7
1 minute
Set by Google to distinguish users.
_gid
1 day
Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Cookie
Duration
Description
__cf_bm
30 minutes
This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.
Leave a Comment