Excel Slimming World Record - Version 3.5

I have used this every week and I love it, thanks again for sharing with us x
 
Hi iv downloaded this and it looks fantastic,just a shame i cant enter any of my details in :-(
 
Thank you for doing the new spreadsheet. I do have one question though. My predicted dates in the Real Time Targets are the same for interim 2 and interim 3 even though there is a stone difference and also interim 4 and PAT are the same?

CLUB 10173.0 lbs12 st 5 lbs
lbs to go18.6 lbs1 st 4.59999999999999 lbs
Predicted Date1 August 2013
Interim Target 01185.0 lbs13 st 3 lbs
lbs to go6.6 lbs0 st 6.59999999999999 lbs
Predicted Date9 May 2013
Interim Target 02178.0 lbs12 st 10 lbs
lbs to go13.6 lbs0 st 13.6 lbs
Predicted Date27 June 2013
Interim Target 03164.0 lbs11 st 10 lbs
lbs to go27.6 lbs1 st 13.6 lbs
Predicted Date27 June 2013
Interim Target 04157.0 lbs11 st 3 lbs
lbs to go34.6 lbs2 st 6.59999999999999 lbs
Predicted Date9 January 2014
PAT150.0 lbs10 st 10 lbs
lbs to go41.6 lbs2 st 13.6 lbs
Predicted Date9 January 2014


The start details are looking okay though
Club1001 August 2013
Interim Target 019 May 2013
Interim Target 0227 June 2013
Interim Target 033 October 2013
Interim Target 0421 November 2013
Final PAT9 January 2014
 
Ooh just found this, will have a play around tomorrow once I log in on the laptop:)
 
love this sheet...thanks for sharing
 
Susie25 said:
It's okay. I unprotected the sheet and was able to change the formula numbers for the predicted date. All working okay now :)
Click to expand...

How did you do this hun? I can't work out which numbers I need to put in or change to get it to work as I'm having the same problem at the moment (with version 2 and version 3) xx
 
Hiya, I just wanted to say that this spreadsheet is awesome! I dread to think how long it took you but thank you for taking the time to help us! :)xxx
 
Wow - I thought I was an excel nerd - but my SW spreadsheet seems completely pathetic compared to this - thank you!
 
Have just discovered this, it's great! Thank you :)
 
Finally found time to download this and it's totally fab, thank you SO MUCH squiddie! I took the time to update it all the way through from when I started SW (back in July last year) and the graphs look great, and the table's SO useful - much better than the SW online one even!

:thankyou:
 
This is super. Thank you so much. My target is now officially in black and white. Looks achievable for my big birthday.
 
Hi there! I'm using Version 3 of this spreadsheet and I've just tried to input my weight in the third row of the record sheet, and now all the predicted dates in the Real Time targets are showing as #DIV/0!

Anyone know how to solve this problem? xx


EDIT: The dates changed fine when I filled in the second row, which was a loss, but then it's having issues with the third row, which is a gain. Could this be affecting the formulas?
 
Last edited:
Hi There,

I have downloaded but it won't let me edit it as I only have Excel Starter? Can anyone send me a non protected version? I would PM the OP but it says I need to have posted 50 messsages to do that? Not sure if that means you can't PM me?

Thanks if anyone can help :)
 
You must log in or register to reply here.

Similar threads

AliGal
Team Challenge - Christmas 2024
2
Replies
22
Views
3K
Susie58
Susie58
F
VLCD (Cambridge/LL/Shake that weight) support 2024 ✨
Replies
0
Views
377
Frozenfjords
F
Y
Weight loss journey intro -
Replies
5
Views
1K
Zafira
Zafira
F
Getting fit for 40! My diary (feel free to join me)
Replies
13
Views
2K
AliGal
AliGal
Y
Starting a VLCD for good this time!
Replies
4
Views
1K
Kitty07
K
Back
Top