If anyone wants a personal weight tracker spreadsheet you can make a copy of this and keep it just for yourself : https://docs.google.com/spreadsheets/d/1ogSAwH5vdArN5YuQxN7P38OBzdigd5IC5iFHhfl9uYw/edit?usp=sharing
This is all =calculated in KG so that 10+10 =20 instead of 1st 3 lb and 7 farthings but does show the weight in Stones and Pounds as well.
Columns you can change
Column A : Target weekly weight loss. I start with a higher number and then quite quickly reduce to a steady and sustainable number but you can adjust as you like.
Column B : The date you weigh yourself. It is current set to show every day but if you just type over with the actual date you weighed then it does all the maths to cope with that.
Column C : Your weight on the date you weighed yourself.
Columns for Information
Columns D – F : Your target in KG and then your weight and Target in imperial
Graph
This shows how you are doing over time against the target.
Right Click and select Vertical Axis to adjust the range of weights as it is currently set between 90kg – 110kg and you might want a different range.
Enjoy and please suggest improvements