You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Can anyone recommend something simple and free? I've been weighing myself every Monday for about a year and writing the figure on my calendar.
All I want is to see a nice encouraging graph.
Ta
Really simple - Excel/Google Sheets or whatever
MyFitnessPal app will log weight and shows a graph, encouraging or otherwise.
MS Excel if you've got access to it or freeware equivalent.
There are loads of phone apps that will do this
Edit - I've just installed this which is nice and simple...
https://play.google.com/store/apps/details?id=com.gmail.makasewicz.maciej
MyFitnessPal app will do this, you can also show the graph over different periods.
Google Sheets is very easy to use, too.
Garmin for me but I've used Excel or Sheets in the past.
Why stop at weight...Everyone takes a phone to the toilet these days.
https://play.google.com/store/apps/details?id=com.appstronautstudios.pooplog&hl=en_GB&gl=US
Google sheets is fine.
Thanks, I've got Open Office excel equivalent but no idea how to use it. Will check out one of the apps.
‘Lose it’ would do the job - it’s free unless you pick the premium option
I can try and post a link to the Google Sheets tracker I wrote. You can make a copy for yourself. It is pretty basic though.
Apple Health, built in to the phone if you're on iOS, does this perfectly. I assume that Google Fit does similar, if you're on the dark side of the mobile platform wars.
Please save your own version
https://docs.google.com/spreadsheets/d/1OedgC5LNENRxxTL7mH9iSd_fcS-EBRpiCUebD6477VY/edit?usp=sharing
All done in metric measurements so that 109 + 10 = 20 not 3 groats and a furlong
Column A = How much weight you want to lose each week. Early weight loss is easier but it is harder later on
Column B - the date you weighed yourself. You don't neet to weigh every day but can if you like
Column C - What you weighed on this date
Column D - What your target weight at this point is. Calculated from your start weight and desired weight loss so don't change this
Column E & F = Column C & D for old folk
Graph to the right showing Actual in Blue and Target in Red.
Hope this helps
This is what I use, a bit rough round the edges, but lets you easily see progress. Weigh every day and take an average for the week
https://docs.google.com/spreadsheets/d/1mk9FQiZjuXWx1Cpkxj5edBlqblq4OD78Yo1WgyqZOyI/edit?usp=sharing
Added a 7 day rolling average.
Good idea Matty
Ah brilliant, thanks guys!
I have a garmin scale, which automatically uploads my weight to my garmin account.
The problem with this is even though I weigh myself every morning, it has just become something I do without really even registering. As someone who very much needs to lose some weight, I wonder if I manually wrote down my weight every morning, it might force a better "feedback loop" where I thought more about what I eat and activity levels.
Apple Health, built in to the phone if you’re on iOS, does this perfectly.
This was the first thing I tried but it only seemed to want to let me start inputting data from today, and as I've weighing myself for a year it was annoying I couldn't put in the data backdated.
EDIT: Just had another look and actually, yes I can put in backdated data. Must've been my fat sausage fingers mashing the keypad...
I helps with me - daily weight can fluctuate a fair bit anyway, but if I see a daily spike it does help focus the mind into 'better have a salad for lunch' etc.
MSP - Feel free to use a copy of the link I shared.
7 day rolling average as well as daily weigh lets you get motivated by a spike / not get demotivated by one rogue reading.
I have a blood pressure spreadsheet that shows the normal this over that normally recorded but also shows the rolling 7 day average of the mid-point between them. This is not a number used by medics but does give a nice trend line through the centre of the graph. I use a stocks and shares graph with opening, closing and high share to display it best.
Why not just use Google Fit? It'll do weight, blood pressure, activity levels etc etc. You can enter data retrospectively though not as easily as on a spreadsheet I suppose. I've got years worth of weight readings on mine...
I try and avoid Google if at all possible. Something about them that creeps me out. Yes I'm well aware of the irony of being an iPhone user...
So looking at me graph, it doesn't really show me anything interesting. I weigh once a week and seem to generally go from 14st to 15st. Usually coming in somewhere between. Ideally I'd like to be between 13st and 14st so it's not too bad I suppose.
That's where I find the weekly average useful based from the 7 previous daily weighs.
Once a week is too arbitrary as a one off weigh on one day doesn't really tell you much.. You may have had a pizza last night ot you may be carrying water and poo.
To me, a weekly average based from the previous 7 days data gives me an 'actual weight' as I can easily be plus or minus a kilo day to day.
But the daily rates are also kinda useful.. They make the weekly average more of a real figure and daily spikes and dips can be attributed to 'skipped lunch that day' or 'had 6 pints and a donner kebab last night'.
If you use Garmin Connect, that has a weight tracker on the website (with graph) and in the app.
Whatever works best for you really.
Spreadsheets are free and for me at least, manually putting the data in and seeing the graph change, kinda re-enforces my goal in my mind and keeps it more in my conscience.
If anyone is using the weight tracker I shared the link to, update column D showing the target for every value after the first one to use the formula below. This will correctly based the target on the dates you actually record your weight rather than expecting yopu to do it every day.
=D3-(A4*((B4-B3)/7))
Google Fit
My Fitness Pal
A lot of the fat analysing scales on Amazon ebay etc have Bluetooth. If you step on while their app is open, it'll sync all the metrics to the app. I haven't yet got that app to sync with Google Fit tho
If you have an iPhone, the Health app has weight as one of the (hundreds of) metrics, and will give you charts and stuff.
I wrote a trivial Shortcut so it's just a one-tap from the home screen to bring up an entry to add a weight reading:
- Scripting: Ask for "Number" with "How much do you weigh (kg)?"
- Health: Log Health Sample. Type: Weight, Value: Provided Input kg, Date: Current Date.
I try and avoid Google if at all possible. Something about them that creeps me out.
Is it because they used to include "don't be evil" as part of their mission statement but then they dropped it? Leading one to conclude...