Export and analyze your own data in Excel

EvgeniZyntx

I've create an Excel program that export your data and provides some analysis. Based on a member's prior work to create an export service, I have updated the program to make it run correctly since the recent MFP updates and added some functionality.

This Excel program exports weight, calorie, macro and dairy data, provides some trend and projection analysis and takes a look at your macros. It provides reference TDEEs and calculates an observable TDEE from your own data.

The current file is MFP2v4.xlsm

Here are a few screenshots of what it looks like




It can be downloaded here: http://www.fileswap.com/dl/jIALndWL1T/

Feel free to provide feedback, I'm sure it will evolve over the next weeks or months.

IT IS PROVIDED AS IS. I might update it and expand it in the future but I do not intend to debug it significantly for Windows version x,y or z or old Excel versions - I've developed it on Excel 2010. But do let me know if you have issues.

Amber82479

This is SO cool, thank you! I'll download it as soon as I get home from work

ihad

Bump. Fantastic.

EvgeniZyntx

The program will also give you an average of protein and fat macros vs your settings in MFP and let you know, on average, how much protein and fat your are "leaving on the table" as well as show if these are directionally changing over the last month.

delicious_cocktail

The program will also give you an average of protein and fat macros vs your settings in MFP and let you know, on average, how much protein and fat your are "leaving on the table" as well as show if these are directionally changing over the last month.

Brilliant. Will play with this once I aggregate more source data.

Cranquistador

wow... thank you:flowerforyou:

Otterluv

Wow, this is awesome!

Thank you and I will tinker with it later.

beachlover317

You are quite the excellent information poster. Thanks for all your work. :drinker:

Sarauk2sf

:flowerforyou:

_crafty_

:smooched:

Angela_2_Oh

You are awesome. Thank you! :flowerforyou:

firstsip

:drinker:

Iron_Feline

I'm going to download this this evening

Thanks :drinker:

rb16fitness

Nice one. Thnx

taunto

This is absolutely incredible work. I will download and try it ASAP!

:cheers:

HealthyWarrior

:flowerforyou:

Leather_N_Lace

:smooched: :drinker:

Thank you very much!

iamanadult

thanks!

samanthahix12

This is so elaborate and HELPFUL! Thank you!
:drinker:

RivenV

Whoa....

ashleybr1980

bump

TygerTwoTails

Schweet, thanks!

cjohn2278

BUMP

tamika4life

Bump

jontay81

Could someone mirror this? The download link isn't working for me. Thanks.

_benjammin

Awesome! Thanks.
And...

megdinga

Awesome - thank you!

yustick

Bump.

and thank you!

uptomoonandback

Will look at this when I get home from work. Thanks!

DopeItUp

This is a wonderful piece of artwork. Nicely done.

Interestingly enough, it's showing that my TDEE is rising despite losing weight. I think this might be because I have been slowly trying to shore up my logging and be more accurate. So I'm logging the same calories but in reality eating less so it appears that my TDEE is going up. Guess that makes sense. Gotta have accurate data to have accurate results.

Fab30s

Whoa....

He's gotta be a wizard!!