Export and analyze your own data in Excel

Fantastic update!

For some reason the Observed and Theoretical TDEE graph isn't generating for me (Excel 2013). The other 3 graphs (and rest of the document) work great. Not sure what might be causing that, but it's still worth using regardless.

Bump

Couple of comments:

- observed TDEE (oTDEE) doesn't use exercise or burn data; it's what you eat and gain/lose in weight that is used. It assumes a constant relationship of 3500 for each lb gained/lost (which isn't exactly true). Therefore the calculation isn't impacted at all by the fitbit adjustment or errors in evaluating or recording exercise burns.

- by subtracting burns from oTDEE to create a "non-exercise" oTDEE we introduce those possible sources of error - fitbit corrections as exercise, burn data variability

The resulting non-exercise oTDEE can be used to set-up MFP custom Net Calories Consumed* but what happens with those extra bitfit calories?

Let's say that the fitbit is adding on 200 extra cals and exercises give 300 cals per day average. Let's build up an sample situation:

Settings = 2000 cals
oTDEE = 2500 cals
burns=500 (200+ fitbit, 300 recorded)

There wouldn't be an issue because the fitbit is only adding the extra cals missed from exercise and MFP setting. If the person recorded 400 exercise cals, the fitbit will only add 100 as it estimates the total burn and eliminates the exercise period - if the user wrote the correct duration when recording the exercise burn.)

Does this make sense? Do you guys see it otherwise?

That is totally correct, that adjustment, one direction or another, will happen if you have syncing pos/neg enabled.

I wasn't even intending to attempt to bring Fitbit in to the equation, but merely that fact if you grab exercise records, and attempt to subtract them from oTDEE, some of those records are actually not exercise but adjustments to get MFP up to the TDEE Fitbit saw.

Doesn't impact oTDEE at all.

In fact, for using Fitbit, if someone is short and has a low BMR and low estimated TDEE outside of exercise (MPF maintenance) because of selecting sedentary, they get less deficit using MPF built-in methods than otherwise. Because MFP stops deficit at 1200.
So if that meant you only got 330 deficit instead of selected 500, but you always were more active like Lightly Active, your max deficit would still only be 330 because of the way MFP handles the math.
Better to select Lightly Active and get full 500 deficit, and receive a few more negative adjustments when the day is done.

I wouldn't even try to include those points though.
I was merely commenting on fact that everything that shows up as exercise isn't always exercise, but indeed has no effect on the oTDEE obtained by math.

Thanks for the feedback, Aaron!
Looks like you are being quite successful.

You are right the lower the number of days to average, it will have be influence by recent changes to diet/exercise. I should make sure to keep it at 30 days as default.
The trend line drawn on the lower right graph is a linear least square fit - not "wrong", just not a good fit. You've either gotten more active as you lose, or worked on changing body comp. Food for thought for me - there's no reason that should be a linear trend, it's not a population analysis. We modify our behavior - will need to think about that line. Thanks.

Fair enough on the trend fit, it just looked like it was weighting the earlier data heavier to me since it seemed a better fit would have been a straight flat line but math is math so I assume that is the best fit and its my eyes that deceive.

bump...want to look at this later at home...

Bump........looks great. Thanks:flowerforyou:

I don't think mine is working correctly. On my "check-in" tab, it doesn't list any calories, carb, fat, etc imported. But it shows net cals, cals burned. Nothing listed in the calculated from setup columns either. What am I doing wrong?

I can't believe I'm just now seeing this. I've been putting my mfp data into excel by hand for years!

Bump

I will check this out as soon as I get home from work. Thank you :flowerforyou:

Is there a way to make it capture ALL of my data going back to when I first joined MFP on 1/3/2011? Right now, I can set it to capture 1000 days max (without errors - entering a number higher than this throws errors), but then on the weight sheet it only goes back 500 days, and actually data starting on 8/6/2013 is all zeroes.

My diary is set to public.

Thanks, love the tool!

this tool really is amazing. i'm planning to take the results to my next doctor's appointment as proof that something really is wrong with me. according to my charts, my activity level is registering as below sedentary and i go to the gym 3-5 days a week.

tsawrie wrote: »

I don't think mine is working correctly. On my "check-in" tab, it doesn't list any calories, carb, fat, etc imported. But it shows net cals, cals burned. Nothing listed in the calculated from setup columns either. What am I doing wrong?

I am getting the same result. Any update available? Thanks for your work!