Export and analyze your own data in Excel
Replies
-
Upon import I'm getting an error that says:
"ERROR: the most recent error is 5. It's message text is: Invalid procedure call or argument in function ImportConfig. Error location 10. Please report to EvgeniZyntx."
I assume this is related to the fact that it's saying I'm a woman (I'm not), am 0 years old, and have 0 for all macro goals.
Not sure what I did wrong.0 -
FletcherLoder wrote: »Upon import I'm getting an error that says:
"ERROR: the most recent error is 5. It's message text is: Invalid procedure call or argument in function ImportConfig. Error location 10. Please report to EvgeniZyntx."
I assume this is related to the fact that it's saying I'm a woman (I'm not), am 0 years old, and have 0 for all macro goals.
Not sure what I did wrong.
MFP updated a few sheets - So I've had to update the tool. The new tool is version 6.00B
As usual, the latest version can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-data-export-tool-the-overview-659927
It has significant rewrites due to MFP updates. Note it does NOT support the paid version of MFP with daily macro goals, nor do I plan to do that in the future at this time.
Please let me know of any issues. Enjoy!0 -
New version.
Update on the data extraction tool: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-data-export-tool-the-overview-659927
It now has a "manual mode" - by setting it to manual (and not pressing any buttons) one can enter the diary and weight data by hand and get the analysis on TDEE, macros targets, weight, etc. Manual mode works on Mac, too! The auto extraction won't be developed for the mac at this time.
Let me know if you have any questions or issues.
0 -
Newer version just posted.
Minor bug corrected and the tool now provides the "MFP Net Cals" - it provides both the calories to eat when you eat back exercise or the cals to eat including exercise based on your own observed TDEE and expected weight loss per week.
Same location as above.0 -
Nice work look forward to checking it out tonight.0
-
This macro library is awesome! It helped me immensely with determining an eating goal to maintain/lose/gain weight. Thanks for the work you've done on it, @EvgeniZyntx0
-
Love this tool, thank you so much!0
-
Welcome!
Glad you are finding it useful!0 -
Updated the tool V6.5 - it now includes a new macro analysis tab to look into the macronutrient distribution on the few days prior to a high calorie days. The idea is to help answer, for example, is binging or high calorie days perhaps influenced by a particular macro - eating too much carbs or not enough protein on the few days prior to the event...
http://www.myfitnesspal.com/blog/EvgeniZyntx/view/mfp-data-export-tool-the-overview-659927
Sample graph.
1 -
First, thank you for this great tool, I was gonna set out to make one like it but not nearly as ambitious and feature-rich! Not sure if this has already been requested in the last 14 pages, but any chance you could add support for net carbs, as a configurable option maybe? Just a simple carbs-fiber. So that this can be used in macro trends and analysis? I know this can be a problematic figure for many people, especially in countries that track net carbs as the carb count on food labels, but I know there are a great number of people this would help.0
-
First, thank you for this great tool, I was gonna set out to make one like it but not nearly as ambitious and feature-rich! Not sure if this has already been requested in the last 14 pages, but any chance you could add support for net carbs, as a configurable option maybe? Just a simple carbs-fiber. So that this can be used in macro trends and analysis? I know this can be a problematic figure for many people, especially in countries that track net carbs as the carb count on food labels, but I know there are a great number of people this would help.
Sent you a PM to discuss this.0 -
I have a question about the graph "Max observed TDEE vs. Weight" on the "Weight and TDEE Graphs" tab.
The bottom axis of the graph is labeled "average weight (kg)" but my data points go from 1 to about 45 which is definitely not my range of weight. Is this correct?
I love this tool that you created. It's really cool to see all the data analyzed like this!0 -
I have a question about the graph "Max observed TDEE vs. Weight" on the "Weight and TDEE Graphs" tab.
The bottom axis of the graph is labeled "average weight (kg)" but my data points go from 1 to about 45 which is definitely not my range of weight. Is this correct?
I love this tool that you created. It's really cool to see all the data analyzed like this!
There was an issue with the lb/kg selector box, working on it and another issue based on an MFP update. I'll publish a new version in the next days.0 -
I have a question about the graph "Max observed TDEE vs. Weight" on the "Weight and TDEE Graphs" tab.
The bottom axis of the graph is labeled "average weight (kg)" but my data points go from 1 to about 45 which is definitely not my range of weight. Is this correct?
I love this tool that you created. It's really cool to see all the data analyzed like this!
I've got this issue too.
EvgeniZyntx, this excel document is really bloody impressive. Thanks a lot.
I had a quick question though: on the Overeating Analysis tab, are any calories listed here "Net Calories" (Cals - burnt) or "Calories" (just cals eaten)?
Thanks,
Sam.
0 -
New error message today:
"ERROR: the most recent error is 5. It's message text is: Invalid procedure call or argument in function ImportConfig. Error location 6. Please report to EvgeniZyntx."0 -
Is there a way to change the date max from 365 days to more?
I, too, am curious of this. I see that the field with 365 can be updated, but what are the parameters to not get an error when changing to say 730 or 1460?
Edit: I was able to set the export up to 1100 days, but no matter what (default 365 or more) the information does not appear to export to the Check_in tab before 7/26/17 so it throws all of the data out of whack, saying I am 600% under my protein numbers, etc.0 -
I think it's broken.
1 -
jofjltncb6 wrote: »I think it's broken.
Indeed. fileswap was not found.1 -
However, sadly, Eugene has not been around MFP this past year
0 -
Noting a couple of recent questions:
MFP USED TO provide up to 365 days of data in a single query so you would NOT have been able to get more than a year's worth of data no matter what you tried.
**BUT, as of a couple of months ago, MFP is limiting data to just 45 days per query**, at least for me.
Support claimed that this was not by design. I sent them a video demonstrating the problem 3 weeks ago.... and the problem continues today.
I would say that the existence of MFP Premium and the processing cost of these back queries MAY (in my own mind) have something to do with this "new" 45 day limit, even though support told me that they've "asked the developers to look into this".
I haven't run the spreadsheet for a while, but I would suggest that you guys try for 45 (or even 44) days instead of 365 or longer and see if it works...1 -
Noting a couple of recent questions:
MFP USED TO provide up to 365 days of data in a single query so you would NOT have been able to get more than a year's worth of data no matter what you tried.
**BUT, as of a couple of months ago, MFP is limiting data to just 45 days per query**, at least for me.
Support claimed that this was not by design. I sent them a video demonstrating the problem 3 weeks ago.... and the problem continues today.
I would say that the existence of MFP Premium and the processing cost of these back queries MAY (in my own mind) have something to do with this "new" 45 day limit, even though support told me that they've "asked the developers to look into this".
I haven't run the spreadsheet for a while, but I would suggest that you guys try for 45 (or even 44) days instead of 365 or longer and see if it works...
Tried 30 days. Still borked.0 -
jofjltncb6 wrote: »Noting a couple of recent questions:
MFP USED TO provide up to 365 days of data in a single query so you would NOT have been able to get more than a year's worth of data no matter what you tried.
**BUT, as of a couple of months ago, MFP is limiting data to just 45 days per query**, at least for me.
Support claimed that this was not by design. I sent them a video demonstrating the problem 3 weeks ago.... and the problem continues today.
I would say that the existence of MFP Premium and the processing cost of these back queries MAY (in my own mind) have something to do with this "new" 45 day limit, even though support told me that they've "asked the developers to look into this".
I haven't run the spreadsheet for a while, but I would suggest that you guys try for 45 (or even 44) days instead of 365 or longer and see if it works...
Tried 30 days. Still borked.
The MFP Reports and View Full Report (Printable) functions on the web version only go back 25 days right now; I have reported this to Customer Support three weeks ago and it is still not fixed. Maybe they are related. Try 25 or fewer days and see if that works?1 -
jofjltncb6 wrote: »Noting a couple of recent questions:
MFP USED TO provide up to 365 days of data in a single query so you would NOT have been able to get more than a year's worth of data no matter what you tried.
**BUT, as of a couple of months ago, MFP is limiting data to just 45 days per query**, at least for me.
Support claimed that this was not by design. I sent them a video demonstrating the problem 3 weeks ago.... and the problem continues today.
I would say that the existence of MFP Premium and the processing cost of these back queries MAY (in my own mind) have something to do with this "new" 45 day limit, even though support told me that they've "asked the developers to look into this".
I haven't run the spreadsheet for a while, but I would suggest that you guys try for 45 (or even 44) days instead of 365 or longer and see if it works...
Tried 30 days. Still borked.
The MFP Reports and View Full Report (Printable) functions on the web version only go back 25 days right now; I have reported this to Customer Support three weeks ago and it is still not fixed. Maybe they are related. Try 25 or fewer days and see if that works?
Nope, still broken. It's imported, but something is screwy in the calculations. I didn't dig too deeply into what that might be though.0 -
I can export all my data....is that what is 'broken' for everyone (am I missing something in the post)? It gives me all my data since I started, which was only 7 months ago.0
-
I can export all my data....is that what is 'broken' for everyone (am I missing something in the post)? It gives me all my data since I started, which was only 7 months ago.
When you say you can export your data, are you talking about the MFP Premium feature, or the Excel spreadsheet that the OP created?
I have never used the OP's spreadsheet to export my data. However, as a Premium member, I have used the MFP Premium feature to export my MFP data to three CSV files going back four years to the beginning. However, when I did that a few days ago with the MFP Premium feature, many of the days are missing information for some of the Meal slots. Perhaps that is the root cause (or at least an indicative cause) for the errors being experienced by previous posters who are having issues with the OP's spreadsheet?0 -
I can export all my data....is that what is 'broken' for everyone (am I missing something in the post)? It gives me all my data since I started, which was only 7 months ago.
As a non-premium member I am accessing my data manually through the same mechanism the spreadsheet was attempting to use.
Namely the printable diary feature.
That feature used to return data for any arbitrary consecutive time period not exceeding 366 days.
Currently, at least for myself, it returns at most 45 days (and according to @CyberTone no more than 25 days)0 -
@Cybertone I used the export and it provided all my information with nothing missing.
@PAV8888 I tried the print function (thanks I didn't know I could do that) and I got results 4 months back for meals, exercise back when I started in June.
I have premium if that makes a difference.1 -
download link is broken can you re-post please0
-
xx8josh9xx wrote: »download link is broken can you re-post please
Not sure which download link you used, but I just tried Eugene's link from his profile and it works: https://www.dropbox.com/s/hptx0n3ma8w17dx/mfp6v8.xlsm?dl=0
However, I would caution you that you not only require Excel 2010/2013/possibly 2017 installed on your computer, but you require at least 60 days of MFP data for good results, preferably more (we used to happily use a year)
Last I checked MFP was refusing to spit out more than 45 days of data at a time 0 -
Still tragically broken.
#theliteralworst0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 393.4K Introduce Yourself
- 43.8K Getting Started
- 260.2K Health and Weight Loss
- 175.9K Food and Nutrition
- 47.4K Recipes
- 232.5K Fitness and Exercise
- 424 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 153K Motivation and Support
- 8K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.7K MyFitnessPal Information
- 24 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.6K MyFitnessPal Tech Support Questions