Have you tried GLP1 medications and found it didn't work for you? We'd like to hear about your experiences, what you tried, why it didn't work and how you're doing now. Click here to tell us your story
Export and analyze your own data in Excel
Replies
-
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 year0
-
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 time0 -
Still tragically broken.
#theliteralworst0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.8K 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
- 413 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