Export and analyze your own data in Excel

12357…15

Replies

  • FredDoyle
    FredDoyle Posts: 2,272 Member
    Diary. Public. Thanks.
    It's not intuitive because you give your credentials to the script...
  • franknitty69
    franknitty69 Posts: 29 Member
    on mac (office 2011 for mac), i get the following error:

    compile error, can't find project or library

    i'm not sure if it is supposed to work on mac.

    works great on windows tho.
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    bump
  • Barbonica
    Barbonica Posts: 337 Member
    Bump
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    I tried version 9, it's not importing anything. I tried just doing October of this year.
  • nelinelineli
    nelinelineli Posts: 330 Member
    Bump to check it out later! Thank you so much for this OP!:)
  • ilessa
    ilessa Posts: 61 Member
    bump for later :)
  • CindyArlene
    CindyArlene Posts: 1,289 Member
    When I try to download - I keep getting the message "Invalid download link" :( Anybody else face this issue?

    I have that problem as well, have tried all the links as well as the one in the blog.
  • mumblemagic
    mumblemagic Posts: 1,090 Member
    Bump
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    When I try to download - I keep getting the message "Invalid download link" :( Anybody else face this issue?

    I have that problem as well, have tried all the links as well as the one in the blog.

    I've added a mirror link.
    Download links will be kept updated here from now on - (single place):

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-extractor-and-trend-watcher-the-program-post-589839
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    New version! V.2.10

    Improved weight import functions so that it will not lock up while waiting for IE. Corrected weight averaging function. Corrected estimate date to target. Corrected TDEE estimator to give value even if download data is partially missing based on prior values. Updated Import method 2 so that, if data is not loaded, it will not loop indefinitely but fail with a msg.

    available:

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-extractor-and-trend-watcher-the-program-post-589839
  • WRXymama
    WRXymama Posts: 342 Member
    Thanks for sharing!
  • Spartan_1_1_7
    Spartan_1_1_7 Posts: 132 Member
    When I try to download - I keep getting the message "Invalid download link" :( Anybody else face this issue?

    I have that problem as well, have tried all the links as well as the one in the blog.

    I've added a mirror link.
    Download links will be kept updated here from now on - (single place):

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-extractor-and-trend-watcher-the-program-post-589839

    I was able to download now. Thank you so much :)
  • fat2strongbeth
    fat2strongbeth Posts: 735 Member
    Bump to read later. Thanks for posting this.
  • Barbonica
    Barbonica Posts: 337 Member
    Thank you, this is extremely helpful! I really appreciate the work you put into this - I really wanted to calculate my TDEE for real rather than using the calculators.

    You may want to remind people that they have to enable macros on Excel if they are getting an error message when downloading the data.
  • melham
    melham Posts: 233 Member
    You had me at Excel. Going to try this ASAP. You will now be known as Mr. U. Rock Awesomeguy. Thanks, Mr. Awesomeguy! :heart:
  • pyrowill
    pyrowill Posts: 1,163 Member
    I assume all you do to get it to apply to yourself is change username and info in the setup tab?
  • coucoudodo
    coucoudodo Posts: 6 Member
    bump
  • thebuz
    thebuz Posts: 221 Member
    Bump for later
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    New version! V.2.12

    Ran on Excel 2007

    New import method for Excel 2007 developed and tested. Added a debug function. Minor bug on index resolved, should no longer hang when import fails. Improved speed 10x for import methods 2, 3 & 4.
    If you have Excel 2007 - please try import method 4, first and then the others, should it fail.

    Available:

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-extractor-and-trend-watcher-the-program-post-589839


    -Diary must be set to public.
    -You must enable macros to get the file to work.
    -International settings in Windows for date and numbers need to be US settings (annoying, I know).
  • jofjltncb6
    jofjltncb6 Posts: 34,415 Member
    Minor nitpick: need to extend formatting on check-in tab col B past row 485.
  • samammay
    samammay Posts: 468
    Method 4 worked like a charm! (And FAST!)
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    New Version 2V13

    Now that this is stable and working on Excel 2010 and 2007 I will not be updating it for at least a few days maybe weeks.
    I think the next version will be a significant change - I'd like to include weekly anaylsis and make the calorie export just updates so it does not require a full reload each time.

    What this version does:

    V3.13 - Extended formatting in Check-In to 1000 cells, updated graph for TDEE and calculation sheet, now does ranges for dates up (30, 60, all) upto 1000 day, Weight method 3 update - end-values are cleanly imported. Calorie import updated with a small speed improvement

    And Q&A on some of the questions I've gotten:

    1- What does "Estimated TDEE vs Average Weight" mean? I'm not sure I understand what is being graphed here.
    Here are the values of TDEE vs Weight - it shows how TDEE might change at various weights. Since TDEE is activity level dependent the noise here is related to that. The calculation for TDEE uses calories consumed and exercise calories are not used as an element to try to evaluate an activity level.
    This graph appears is in kg instead of lbs for now as I am using the TDEE equation values, its a hassle to dynamically assign a different x axis. :)

    2- Is there a way to get the TDEE graphs extended to all of my data and not just the last 30 days. I wanted to see if my TDEE has gone up or down as I bulked and cut.
    The new version has this. However extracting down to your start date takes a lot of time! Note that I have not extracted that far and it's a) gonna take forever b) I'm not sure about how clean it will calculate when the number of weight days is few for the the smoothing. You might need to ignore the first days of data....

    3 - Minor nitpick: need to extend formatting on Check-In tab col B past row 485.
    Corrected, normally this should now work for extractions up to a thousand days.


    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-extractor-and-trend-watcher-the-program-post-589839
  • jofjltncb6
    jofjltncb6 Posts: 34,415 Member
    Awesome.

    Personally, I'd still like the ability to graph what I used to call NEAT, but have recently learned is actually TDEE less exercise calories. Whatever it's called, I find it useful as an indicator of that ever-elusive "metabolism". Said another way, it's the calories I burn when I don't intentionally exercise. It's something I've tracked in my own far-less-automated-and-more-clunky spreadsheet for a while now.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Awesome.

    Personally, I'd still like the ability to graph what I used to call NEAT, but have recently learned is actually TDEE less exercise calories. Whatever it's called, I find it useful as an indicator of that ever-elusive "metabolism". Said another way, it's the calories I burn when I don't intentionally exercise. It's something I've tracked in my own far-less-automated-and-more-clunky spreadsheet for a while now.

    Ok.

    So this would be either:
    a) TDEE - exercise calories - RMR(guesstimated from equation)

    or do you just want just

    b) TDEE - exercise calories

    I'm guessing b) would be sufficient. We can pull that data without additional queries, I think, so I'll add that to my to do list.
  • foodfastfit
    foodfastfit Posts: 154 Member
    Like. Thank you! Bump.
  • DapperKay
    DapperKay Posts: 140 Member
    Bumping for awesomeness. For a data geek like me this is incredible stuff!

    I am still confused about the observed TDEE though, can you explain a little more how that value is calculated? Sorry if you already mentioned this, but I couldn't find it. Particularly, it says TDEE is low, I am wondering this is low with respect to what?

    Thanks
  • DapperKay
    DapperKay Posts: 140 Member
    Ok not sure if this is a bug, but on the 'Calc' sheet, the formulas for N3 & J3 are the same, however on the Graphs!I21 you are comparing if Calc!N3 is > that Calc!J3, which will always be false since the formulas are the same?!
  • seniorbug2003
    seniorbug2003 Posts: 67 Member
    This is cool. Saves me time from doing it long hand. Thanks.
  • jofjltncb6
    jofjltncb6 Posts: 34,415 Member
    Awesome.

    Personally, I'd still like the ability to graph what I used to call NEAT, but have recently learned is actually TDEE less exercise calories. Whatever it's called, I find it useful as an indicator of that ever-elusive "metabolism". Said another way, it's the calories I burn when I don't intentionally exercise. It's something I've tracked in my own far-less-automated-and-more-clunky spreadsheet for a while now.

    Ok.

    So this would be either:
    a) TDEE - exercise calories - RMR(guesstimated from equation)

    or do you just want just

    b) TDEE - exercise calories

    I'm guessing b) would be sufficient. We can pull that data without additional queries, I think, so I'll add that to my to do list.

    Yes, b) is exactly what I'd like. We can leave RMR in there because it's a component of what I want to know anyhow...which is, without any extra exercise, what is maintenance? This seems like a good quantification of that ever-elusive thing called "metabolism".

Categories