Crunching Data from Cronometer

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:

Item kcal percent
Energy (kcal) 434318.19
Total Protein 155395.72 35.8%
Total Fat 259107.39 59.7%
Total Carbs 33405.04
Total Fiber 13593.28
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.


Author: Doug

I'm an Engineer who is also a science geek. I was pre-diabetic in 1996 and became a diabetic in 2003. I decided to figure out how to hack my diabetes and in 2016 found the ketogetic diet which reversed my diabetes.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.