Export and analyze your own data in Excel

What happens with incomplete entries, e.g. I filled in lunch but left the other meals? Can the spreadsheet detect that, or do I need to manually remove those days? Also, is there a way I can manually enter the weight data, as I haven't entered it on MFP but do have the info on an excel sheet. Thanks

The formulas in P14 and S14 on the Weight and TDEE graphs tab need a tweak. They're trying to call from cells that have text, without trimming the text out (P7 and P8 respectively). I noticed it when it didn't give me expected goal dates because it said I had no loss when the table above clearly showed loss! When I tweaked them to remove the units from P7 and P8 they came up with a goal date range spot on for what I'm expecting based on other tracking.
Thanks a huge bunch for this though! I'm going to start looking at the vba to see if I can isolate some of the things that want to include in another tracking spreadsheet I've got going.

ephphy wrote: »

The formulas in P14 and S14 on the Weight and TDEE graphs tab need a tweak. They're trying to call from cells that have text, without trimming the text out (P7 and P8 respectively). I noticed it when it didn't give me expected goal dates because it said I had no loss when the table above clearly showed loss! When I tweaked them to remove the units from P7 and P8 they came up with a goal date range spot on for what I'm expecting based on other tracking.
Thanks a huge bunch for this though! I'm going to start looking at the vba to see if I can isolate some of the things that want to include in another tracking spreadsheet I've got going.

Please explain how you tweaked because mine is doing the same thing.

tsawrie wrote: »

Please explain how you tweaked because mine is doing the same thing.

Hi tsawrie, sorry for the delay in the reply, I forgot to check the thread!
Probably the easiest way to do it is as follows:
In P7 (weight change since a week ago), which should have the formula

=IFERROR(ROUND(IF(ignoretoday=TRUE,Weight!B34-Weight!B41,Weight!B33-Weight!B40),2),"")& " " & units

Edit it to remove everything after the last closing brackets- this is what is adding the text after the loss values. It will now look like

=IFERROR(ROUND(IF(ignoretoday=TRUE,Weight!B34-Weight!B41,Weight!B33-Weight!B40),2),"")

Repeat for cell P8 - edit to remove after the last closing brackets, don't copy paste!
You shouldn't need to do it for the other values in the weight change table as they don't feed through to the goal dates, but you may want to for aesthetics. And if you really want reminding what units you're using, add it to the header.

That seems to be linked with what @ckt873 mentions above. I'm consistently getting the same 'error', but haven't had the time to look closely at it yet.

This is incredible!

Same here, only getting 2013 data.

edit: nevermind

ephphy wrote: »

With the wrong year error, try this quick fix (it worked for me, and also cleared up the wrong logging error that @ckt873 brought up that I was experiencing).

• With the spreadsheet open, go to Visual Basic (Alt+F11, or under the developer tab, hit the button for Visual Basic).
• If it doesn't start you there, open the Module1 module - in the side menu under VBAProject (mfp5v10.xlsm), Modules, Module1 and double click.
• You should then see something that starts like this:

  'Updated and majority work by evgenizyntx 2013, 2014
  'EZ version 4.20
  'inspiration from orginal input by gavins, 2012
  

• Do a search for 2014, and find next until it shows you this line:

  ddd(i) = DateSerial(2014, imm, idd)
  

• Change the 2014 to 2015
• Save
• Close Visual Basic.
• On the first/main tab of the spreadsheet, hit the reset button to clear anything that was there for a 'fresh start'
• Run as usual and fingers crossed you get the data you should.

As I said, it worked for me (I don't proclaim to be an expert at VB), so hopefully it does for you too.

Awesome. That plus changing the finish date seems to have worked. Still displays the wrong dates at the end in the date boxes but the data seems correct far as I can tell.

First off, thank you for this, it looks like a great tool. The problem I'm having is that it's not importing any of my logging data. When I look at the import data table it has all the correct dates but all the data is blank... anyone have any suggestions? Thanks again.