In my last post I showed how to export data from Cronometer to your favorite spreadsheet. I ran my own data and got this for totals:
|Total Net Carbs||19815.08||4.6%|
This data started at the end of October last year so it has about 7 months of complete food logs.
I have to admit I am surprised that my Protein number is that high (more than 35% of calories from Protein). But following Dr Ted Naiman’s macros that puts me at a P:NPE ratio of 1.045 which is pretty much in the middle of the maintenance range. And I have been fairly stable in weight for the past couple of months.
Here’s my weight plotted across the same time span with a red trend line. I hit a new low this AM (164.1lbs).
Here’s where it gets kinda fun. I was able to plot weight vs calories. For this I used a Pivot Table and used the sums feature to get the totals for each day.
Here I have plotted the P:NPE ratio (normalized by multiplying by 100) against my scale weight hoping to see a correlation. 100 is equal grams of protein to carbs plus fat. Numbers over 100 are more protein. Numbers under 100 are less protein.
When the blue lines are high, I was doing a PSMF cut. When the blue is around 100 I was trying for maintenance. Hard to see much of a correlation there. It could be the scale is exaggerated for the P:NPE ratio compared to the weight scale but the weight seems to be taking a fairly steady drop.
Calories in:Calories Out Meets Reality
Let’s try the same thing with calories. Surely, that will show a correlation to weight change? For this one I added the light blue trend line as a polynomial and the light green line as a poly trend line poly. Calories are scaled down to 1/10th. Clearly, when I eat 1500 calories a day I lose weight a bit faster but it’s really hard to see much of any correlation between my weight and the number of calories I eat.