Export and analyze your own data in Excel

EvgeniZyntx · October 2013

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 · October 2013

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

ihad · October 2013

Bump. Fantastic.

EvgeniZyntx · October 2013

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 · October 2013

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 · October 2013

wow... thank you:flowerforyou:

Otterluv · October 2013

Wow, this is awesome!

Thank you and I will tinker with it later.

beachlover317 · October 2013

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

Sarauk2sf · October 2013

:flowerforyou:

_crafty_ · October 2013

:smooched:

Angela_2_Oh · October 2013

You are awesome. Thank you! :flowerforyou:

firstsip · October 2013

:drinker:

Iron_Feline · October 2013

I'm going to download this this evening

Thanks :drinker:

rb16fitness · October 2013

Nice one. Thnx

taunto · October 2013

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

:cheers:

HealthyWarrior · October 2013

:flowerforyou:

Leather_N_Lace · October 2013

:smooched: :drinker:

Thank you very much!

iamanadult · October 2013

thanks!

samanthahix12 · October 2013

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

RivenV · October 2013

Whoa....

images?q=tbn:ANd9GcQ__0FDHU-vrqJotIKL-m6MRbRtBeq9o8qj08pedonrMaaCVzdvRg

ashleybr1980 · October 2013

bump

TygerTwoTails · October 2013

Schweet, thanks!

cjohn2278 · October 2013

BUMP

tamika4life · October 2013

Bump

jontay81 · October 2013

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

_benjammin · October 2013

Awesome! Thanks.
And...

images?q=tbn:ANd9GcQ__0FDHU-vrqJotIKL-m6MRbRtBeq9o8qj08pedonrMaaCVzdvRg

megdinga · October 2013

Awesome - thank you!

yustick · October 2013

Bump.

and thank you!

uptomoonandback · October 2013

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

DopeItUp · October 2013

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 · October 2013

Whoa....

He's gotta be a wizard!!

Export and analyze your own data in Excel

Replies

Categories