Export and analyze your own data in Excel

13468915

Replies

  • GarthBear
    GarthBear Posts: 51 Member
    Bump!
  • DopeItUp
    DopeItUp Posts: 18,771 Member
    Checking back in, I'm glad you made a blog with an updated download link. You keep making this thing better and better.
  • Buddhasmiracle
    Buddhasmiracle Posts: 925 Member
    Bump and thank you
  • julie2407
    julie2407 Posts: 44 Member
    Yay.
  • ingoiolo
    ingoiolo Posts: 104 Member
    No mac :(
  • foodfastfit
    foodfastfit Posts: 154 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/
  • Debbie_Ferr
    Debbie_Ferr Posts: 582 Member
    Fantastic ! thanks.
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    Thanks again for this. With the data I've been able to work out this:
    Over 269 days, total cals in = 752901
    Lost = 10 lbs
    Deficit = 35000 calories
    Cals out = 752901 + 35000 = 784401
    Over 269 days, observed TDEE = 2929 calories per day.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thanks for this. That's a neat way of doing it!

    I'm not currently running chrome on my machines for various reasons and am focusing on the next version of my tool. But afterwards, when I have a moment I'll install it and take a look!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Thanks again for this. With the data I've been able to work out this:
    Over 269 days, total cals in = 752901
    Lost = 10 lbs
    Deficit = 35000 calories
    Cals out = 752901 + 35000 = 784401
    Over 269 days, observed TDEE = 2929 calories per day.

    Very cool!
  • AmykinsCatfood
    AmykinsCatfood Posts: 599 Member
    I just got super bummed out. My version of excel doesn't work with it. It looks fantastic though!
  • The_WoIverine
    The_WoIverine Posts: 367 Member
    Bump
  • beckywilliams1967
    beckywilliams1967 Posts: 58 Member
    Bump thank you!
  • SandySweats
    SandySweats Posts: 38 Member
    This is very cool. I can't get any of the weight data to download, but the meal log, macros, etc. downloads fine.
    I use excel 2010 in windows 7. Not sure what the problem is.... I will reread through the thread to see if I missed something.

    Thank you again.
  • LesaDave
    LesaDave Posts: 1,480 Member
    bump
  • DapperKay
    DapperKay Posts: 140 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    This is very cool. I can't get any of the weight data to download, but the meal log, macros, etc. downloads fine.
    I use excel 2010 in windows 7. Not sure what the problem is.... I will reread through the thread to see if I missed something.

    Thank you again.

    Try the different export methods and see if one of them works, please also see the setting notes in the blog.
  • delicious_cocktail
    delicious_cocktail Posts: 5,797 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Depending on the way excel interprets dates, it could think that 11/13 is actually 1/11/13, and 11/14 is 1/11/14; misinterpreting the day for years
  • foodfastfit
    foodfastfit Posts: 154 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/
  • DapperKay
    DapperKay Posts: 140 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Much better now. Now follows: MM/DD/YYYY. I'll just re-configure it to DD/MM/YYYY myself, thanks!
  • Bump for later :smile:
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/
    You can download ky2k, that will make it easier to insert 4 digits into your date.
  • coolraul07
    coolraul07 Posts: 1,606 Member
    ...
    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
    ...
    It can be downloaded here: http://www.fileswap.com/dl/jIALndWL1T/
    ...
    Thanks!:drinker:

    *ETA: Old version (v4) wouldn't open in Excel 2013, but newer version (v13) did. I got the link from OP's profile:
    http://www.myfitnesspal.com/evgenizyntx
  • pinkstp
    pinkstp Posts: 220 Member
    bump & thank you :D
  • missionskinnynow
    missionskinnynow Posts: 88 Member
    bump
  • omma_to_3
    omma_to_3 Posts: 3,265 Member
    Nevermind LOL.
  • mumblemagic
    mumblemagic Posts: 1,090 Member
    Bump for later nerdery :smile:
  • Just tried it and its not getting any weight data on any of the options. Getting "there was a problem with your request" on option 3 from MFP when I log in.

    Running on Excel 2013. Not sure if it is just a temporary problem?
  • minizebu
    minizebu Posts: 2,716 Member
    I think I'm in love.

    Bumping to entertain my inner nerd later.

    Seriously, are you taken? Oh, wait. I'm already married. :P
  • DaveInFL
    DaveInFL Posts: 84 Member
    Just tried it and its not getting any weight data on any of the options. Getting "there was a problem with your request" on option 3 from MFP when I log in.

    Running on Excel 2013. Not sure if it is just a temporary problem?

    Just downloaded this today and I am getting the same issue. I'm wondering if this is because I have only 7 days of data so far?