Export and analyze your own data in Excel

Options
EvgeniZyntx
EvgeniZyntx Posts: 24,208 Member
in Health and Weight Loss
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
ifYWK7x.png

5xri8vk.png

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.
«134567…22

Replies

  • Amber82479
    Amber82479 Posts: 629 Member
    Options
    This is SO cool, thank you! I'll download it as soon as I get home from work :)
  • ihad
    ihad Posts: 7,462 Member
    Options
    Bump. Fantastic.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Options
    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.

    YDakXMj.png
  • delicious_cocktail
    delicious_cocktail Posts: 5,797 Member
    Options
    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
    Cranquistador Posts: 39,744 Member
    Options
    wow... thank you:flowerforyou:
  • Otterluv
    Otterluv Posts: 9,083 Member
    Options
    Wow, this is awesome!

    Thank you and I will tinker with it later.
  • beachlover317
    beachlover317 Posts: 2,848 Member
    Options
    You are quite the excellent information poster. Thanks for all your work. :drinker:
  • Sarauk2sf
    Sarauk2sf Posts: 28,072 Member
    Options
    :flowerforyou:
  • _crafty_
    _crafty_ Posts: 1,682 Member
    Options
    :smooched:
  • Angela_2_Oh
    Angela_2_Oh Posts: 579 Member
    Options
    You are awesome. Thank you! :flowerforyou:
  • firstsip
    firstsip Posts: 8,399 Member
    Options
    :drinker:
  • Iron_Feline
    Iron_Feline Posts: 10,750 Member
    Options
    I'm going to download this this evening

    Thanks :drinker:
  • rb16fitness
    rb16fitness Posts: 236 Member
    Options
    Nice one. Thnx
  • taunto
    taunto Posts: 6,420 Member
    Options
    This is absolutely incredible work. I will download and try it ASAP!

    :cheers:
  • HealthyWarrior
    HealthyWarrior Posts: 394 Member
    Options
    :flowerforyou:
  • Leather_N_Lace
    Leather_N_Lace Posts: 518 Member
    Options
    :love: :smooched: :drinker:

    Thank you very much!
  • iamanadult
    iamanadult Posts: 709 Member
    Options
    thanks!
  • samanthahix12
    samanthahix12 Posts: 179
    Options
    This is so elaborate and HELPFUL! Thank you!
    :drinker:
  • RivenV
    RivenV Posts: 1,667 Member
    Options
    Whoa....

    images?q=tbn:ANd9GcQ__0FDHU-vrqJotIKL-m6MRbRtBeq9o8qj08pedonrMaaCVzdvRg
  • ashleybr1980
    ashleybr1980 Posts: 70 Member
    Options
    bump

Categories