Export and analyze your own data in Excel
Replies
-
Bumping to show to my noobs.0
-
Very cool. Thanks for sharing.0
-
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?
Bump, anyone else having this issue? Is this a know issue for people who have less than 30 days of data? I'm on Windows 7 (64 bit) and Excel 2010.0 -
Only Question is how do we import like once a week and not have to reimport all the old dates. Each time I click the Calories button it erases all the old data?0
-
Oh man, just found this.
I have been requesting this sort of info from MFP for ages. Will play around with it now
Thanks a lot! (from another excel nerd :happy:)0 -
Bump....for science.0
-
bumping for the awesomeness!0
-
Bump for later0
-
BUMP0
-
I don't have Excel, but if I ever get it, I'll be coming back to give this a go! It looks fantastic!0
-
Bump for later0
-
I may be missing something but this did not work for me. Downloaded spreadsheet. Changed things in settings tab. Clicked on Get Weight Data. Took me to MFP login. Logged In. Hit OK on spreadsheet pop-up. No data downloaded. Change from requesting last 365 days to last 15. No difference.0
-
I may be missing something but this did not work for me. Downloaded spreadsheet. Changed things in settings tab. Clicked on Get Weight Data. Took me to MFP login. Logged In. Hit OK on spreadsheet pop-up. No data downloaded. Change from requesting last 365 days to last 15. No difference.
I just tried this right now and it worked for me. Perhaps you have security settings set in excel to prevent non-local data download? Not sure.0 -
I've published a major update to the tool - details can be found here:
http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
preview...
0 -
Awesome.
I know I'm just being picky, but might be useful if you had a "new user setup" button that prompted the user for their necessary data. Also, would it be possible to pull the meal names and other setup information directly from the diary? Finally, it may make sense to lock the cells on the setup tab (or other tabs) where you wouldn't want the user to be able to change the data in the cell (like calculations, headers, etc.)
Also, LOL:Avr. observed TDEE (30 days): 2893 + 306
Observed TDEE is low, try to be more active, or evaluate a possible diet pause
#REF!
My TDEE of 2893 is low and I should try to be more active, huh? :laugh: (I suspect your model doesn't like those with a goal weight > current weight.)
ETA:
On the "Graphs" tab, cell I2 indicates " To change values, go to "config" tab, do not modify them on this tab. Use "Days" option box to update graphs. " There is no "config" tab.
ETAM:
I would also love an option to exclude the current day from the analysis as it skews the data if you run it before the day is fully logged.0 -
Bump! I can't wait to try this out! Thanks for posting!0
-
Awesome.
I know I'm just being picky, but might be useful if you had a "new user setup" button that prompted the user for their necessary data. Also, would it be possible to pull the meal names and other setup information directly from the diary? Finally, it may make sense to lock the cells on the setup tab (or other tabs) where you wouldn't want the user to be able to change the data in the cell (like calculations, headers, etc.)
Also, LOL:Avr. observed TDEE (30 days): 2893 + 306
Observed TDEE is low, try to be more active, or evaluate a possible diet pause
#REF!
My TDEE of 2893 is low and I should try to be more active, huh? :laugh: (I suspect your model doesn't like those with a goal weight > current weight.)
ETA:
On the "Graphs" tab, cell I2 indicates " To change values, go to "config" tab, do not modify them on this tab. Use "Days" option box to update graphs. " There is no "config" tab.
ETAM:
I would also love an option to exclude the current day from the analysis as it skews the data if you run it before the day is fully logged.
Thank you for your great comment, please be picky!!
I'll do those corrections.
Good catch, Jof. Seriously. I just posted a new update to the update because of this.0 -
bump0
-
Corrected the latest issues. Please let me know if you have any problems with it.
http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-6599270 -
Tool has been updated again.Added calorie burns to scoring, removed some old code, corrected status reporting msg, added trend last 14 days to weight graph, corrected TDEE graph x axis.0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.9K Introduce Yourself
- 43.7K Getting Started
- 260.1K Health and Weight Loss
- 175.8K Food and Nutrition
- 47.4K Recipes
- 232.5K Fitness and Exercise
- 415 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.9K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.6K MyFitnessPal Information
- 23 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.5K MyFitnessPal Tech Support Questions