Just filled my in. Beats trying to work out my own formulas!
Thanks for this.
Get into the 13's - ACHIEVED 04/02/13
Lose 1 stone - ACHIVED 30/03/13
Lose 1.5 stone
BMI to Overweight
Lose 2 Stone
Link to my diary: Beating the Bulge... once and for all
This is excellent but does anyone know how I save it?! spent ages filling in all the pics etc and clicked 'save as' come to look today and its gone ( Have tried to do same again, didnt work, tried copying onto blank spreadsheet but then the formulas didnt work... dont know why it wont save for me?! is it because it says read only?
Thanks in advance! x
Slim&Save Start date 05.06.2013
WK1. 13.8 lost 6lb total 6lb
WK2. 13.5 lost 3lb total 9lb
WK3. 13.4 lost 1lb total 10lb
WK4. 13.1 lost 3lb total 13lb
WK5. 12.12 lost 3lb total 1st 2lb
WK6-10 13.6 gained 8lb total 8lb
WK 11 lost 1lb total 9lb
Just had to sign up to say thanks so much for this, I started trying to make one but not clever enough so thank you for sharing
Thanks for this it's fab x
Pickle87January: 18lb lost, 2 SOTW, SOTM
I wanna be a yummy mummy not a weighty matey!
1) Lose 1/2 a stone Achieved 10/01/13
2) Lose 1 stone Achieved 24/01/13
3) Lose 1.5 stone Achieved 14/02/13
4) Get bronze body magic award
5) Get Club 10 award
February: -0.5, -6.5 2 SOTW
Thank you so much for this, I am useless with excel I am just a filler-inner and I coped brilliantly thanks to your hard work! I am doing this at home alone so this is a really nice tool, now all I need to do is work out how to get a 7lb sticker lol and I will feel like a proper Slimming Worlder!
Hi Squiddie...I've just updated the latest version (v2) and I've achieved Club 10 and my first interim target this week, but in the date achieved box in the Real Time Targets section it's not showing up the dates, it's just showing #N/A. Any idea what I need to do to fix this? xx
Goal 1: Lose 0.5 stone
Goal 2: Get into the 13 stone range
Goal 3: Lose 1 stone
Goal 4: Achieve Club 10 (21lb)
Goal 5: Get down into the Overweight BMI category (24lb)
Goal 6: Lose 1.5 stone
Goal 7: Get into the 12 stone range
Goal 8: Lose 2 stone
Restart weight (08/11/2013): 14 stone 13lb (209lb)
I actually have a similar problem, on my dashboard my start details are fine but my current details all say either #N/A or err508 or err502 so I'm guessing I must have typed something wrong somewhere along the lines but no idea where or what!
Total lost to date: 59.5lbs
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:
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$2:$A$14,MATCH("Club10 Achieved!",Record!$O$2:$O$14,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 targetsCode:=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)))))
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, alternatively you can download an updated version from the first post in this thread.
OK I think I'm being really dense here, but I tried making the alterations to the one I had and it did not like it one little bit! lol! So I re-downloaded the new version (even though that was the one I was already using) and I've got the same problem, its very odd - I don't suppose it would have anything to do with me using openoffice rather than Excel or something? (even though they are pretty similar)
Total lost to date: 59.5lbs
I may be being really dim but where's the link to download from? It could be that I'm not seeing it because I'm on my phone.
Thanks - it looks FAB!
I'm taking suggestions for the next version of the sheet, obviously it'll contain fixes and patches for problems with formulas, but any actual functionality you'd like added, let me know!
So far I have:
- include inches as well as weight
- graph to show predicted progress