I spent 60 days weighting myself and counting calories every day so I could develop an easy Weight loss dashboard using Microsoft Excel. The experiment started on October 20th, weighting 77,4kg and finished it on December 18th, with 77,1kg. Every meal was registered using MyFitnessPal. Here's the results (so far in a single page).
Some of the spreadsheet functionalities:
Calories goal for every day of the week: As you can see, I’m used to binge during the weekends, so it is possible to add a different goal based on your routine;
- Week follow up: By looking up a date, you can easily see your week weight fluctuation (red being weight gain, green a weight loss);
- Weight goal follow up: Using a speedometer (red until 50%, orange between 50 and 70%, green from 70% and beyond
- Weight and calories follow up: Every day logged is a dot on the graph. It is easy to look into patterns and weight trends
Future perspectives:
- Adding a Scatter graph on another tab, with the possibility to look into the Weight x Calories relation, as well as Weight and the 3 different Macros
- Adding a Macro goal, maybe based on weekdays
I’m thinking on translating it fully to English and launching it online, so anyone who’s interested will be able to use. Of course I’d take the time to write a manual on how to fill it. Just wanted to know if you guys interested and ask for tips on possible websites.
[link] [comments]
from loseit - Lose the Fat http://bit.ly/2An3aad
No comments:
Post a Comment