Export and analyze your own data in Excel

FredDoyle

Diary. Public. Thanks.
It's not intuitive because you give your credentials to the script...

franknitty69

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

bump

Barbonica

Bump

LiftAllThePizzas

I tried version 9, it's not importing anything. I tried just doing October of this year.

nelinelineli

Bump to check it out later! Thank you so much for this OP!:)

ilessa

bump for later

CindyArlene

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

Bump

EvgeniZyntx

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

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

Thanks for sharing!

Spartan_1_1_7

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

Bump to read later. Thanks for posting this.

Barbonica

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

You had me at Excel. Going to try this ASAP. You will now be known as Mr. U. Rock Awesomeguy. Thanks, Mr. Awesomeguy!

pyrowill

I assume all you do to get it to apply to yourself is change username and info in the setup tab?

coucoudodo

bump

thebuz

Bump for later

EvgeniZyntx

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).