Export and analyze your own data in Excel

191012141522

Replies

  • 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 ;)