Export and analyze your own data in Excel

1…5681011…15

Replies

  • otter090812
    otter090812 Posts: 380 Member
    Just seen this. In to download later - looks amazing!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Updated today:

    V3.13 - Corrected issue with secondary axis in 8 week Macro graph, age issue and Activity Level calculation. Rewrote oTDEE Graph to only show one maximal value per weight

    Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927

    I'm also taking advantage of this post to explain two graphs:

    It is possible to review how much protein and fat one is "leaving on the table" by tracking these macros versus objective. With my own date, here is much fat and protein I've been off from my goals (ignore pre 5/13 data, wasn't tracking well)
    H4rUsEql.png

    Also, in a single place, I have average daily Carbs/Fats/Protein and Cals for the last 8 weeks.
    This tells me my protein and fats tracked have been going up over this period - once I have consistent tracking for an 8 week period I can evaluate the direction of these macros and total cals.

    mCcD4Ncl.png
  • adopp062715
    adopp062715 Posts: 93 Member
    bump to come back to
  • kethry70
    kethry70 Posts: 404 Member
    Tagging for finding again later - jic
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Updated Again

    v4.01 - Configuration is improved. Import method rewritten to speed up and reduce queries. Now exports cholesterol, sugar, sodium and fiber. Layout and configure changes. Added ignore today button, not fully supported yet.

    Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
  • minizebu
    minizebu Posts: 2,716 Member
    I can't use the tool because I'm on a Mac, but it gladdens my heart just knowing that someone out there has created this tool (namely, you, EvgeniZyntx).

    Thanks for making this tool available to those you have longed for this very capability.
  • coolraul07
    coolraul07 Posts: 1,606 Member
    *bump* and to track in my own feed... Many thanks!!
    Updated Again

    v4.01 - Configuration is improved. Import method rewritten to speed up and reduce queries. Now exports cholesterol, sugar, sodium and fiber. Layout and configure changes. Added ignore today button, not fully supported yet.

    Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
  • Aeramis13
    Aeramis13 Posts: 135 Member
    This is awesome! Thank you for taking the time to make and share this with the world :)
  • dapunks
    dapunks Posts: 245 Member
    BUMP
  • ActuarialChef
    ActuarialChef Posts: 1,413 Member
    BUMP!

    THANK YOU for doing this!
  • NovemberJune
    NovemberJune Posts: 2,525 Member
    *bump* and to track in my own feed... Many thanks!!
    Updated Again

    v4.01 - Configuration is improved. Import method rewritten to speed up and reduce queries. Now exports cholesterol, sugar, sodium and fiber. Layout and configure changes. Added ignore today button, not fully supported yet.

    Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927

    This is my first time seeing this! Thanks!!! Now I have a reason to set my actual macro goals in mfp... I always just leave them set to default but keep my real goal in my mind :wink:
  • Empty_Calories
    Empty_Calories Posts: 81 Member
    This looks awesome. Looking forward to downloading later. Thanks!
  • kbolton322
    kbolton322 Posts: 358 Member
    bump to find later
  • 1Cor1510
    1Cor1510 Posts: 413 Member
    Bump to download after work :)
  • danielleeu
    danielleeu Posts: 127 Member
    Bump to get this download this evening. Thanks in advance!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Here is one example of the graph you can create with this.

    H7pm3Y0l.jpg
  • OtekahSunshield
    OtekahSunshield Posts: 42 Member
    Bump. Tagging for later!
  • palmerddj
    palmerddj Posts: 59 Member
    Bump
  • Spartan_1_1_7
    Spartan_1_1_7 Posts: 132 Member
    Bump
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    If you uploaded the worksheet yesterday, and had no data from a year ago, the export would have crashed. This is now repaired. Program update is available at the same link

    https://www.dropbox.com/s/biixuaat0ysj2ji/mfp4v01.xlsm
  • Flissbo
    Flissbo Posts: 302 Member
    What can I say....you are a superstar for all your hard work on this! Thanks a million :drinker:

    I feel bad to bother you....however this did not work for me....I got an error message that said:

    "Error: After location 6 in function ImportXMLdataMFP. The most recent error number is 5. Its message text is: invalid procedure call or argument."

    I tried at 365 days and then at 29 days as I've only just got back into loggin for the last 30 days after taking quite a long break. Neither worked. Do I need to change some settings perhaps?

    All my good data is from a few years back when I was loggin consistantly (just getting back into it) but I believe the report works for the last year only?

    Again, thank you sooooo much for putting this together!! Really appreciated by everyone here from the looks of it!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Ok, I believe I've resolved your issue - the program crashed during the reading of settings when someone used "stone/lbs". This is now resolved. Also, the program should now work with Excel 2007/2010/2013.

    Updates are at the usual location:
    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
  • Flissbo
    Flissbo Posts: 302 Member
    It worked!!! :smokin:

    I can't believe how clever you are - the info on there is amazing!

    Thank you ever so much - can't tell you how much I appreciate this!!!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    You are welcome!
    And thanks for the feedback!:flowerforyou:
  • zchastain
    zchastain Posts: 55 Member
    This looks incredible! Replying to download when I get home. Thanks!!!
  • phil4v7
    phil4v7 Posts: 68 Member
    Tagging for later.
  • lulu150
    lulu150 Posts: 58 Member
    I am going to have to try this! Thanks!!!
  • sjaplo
    sjaplo Posts: 974 Member
    Bumping for later!
  • Nightstar76
    Nightstar76 Posts: 48 Member
    Bumping so I can check this out later.
  • klyn05
    klyn05 Posts: 88 Member
    this is an awesome tool. Can't let this one go unnoticed, too great!!!! Wonderful job on that, I still have to read a little closer to correctly interpret what some of the charts display. But this is incredible ;)

Categories