Of spreadsheets and results tracking and such...

Other than @heybales (whom I consider THE original purveyor of MFP spreadsheets), and @EvgeniZyntx (who hasn't been around much this past year), do we have any interesting (semi) automated spreadsheet users in this crowd?

I used to use the following spreadsheet to track my trending and scale weight results against my calories in and calories out logging. It displays the results as a % of TDEE error.
https://docs.google.com/spreadsheets/d/1VDmqNpLPu7sbQSochUJNXdp2F7AN15AGgkvS3zLw1GU/edit?usp=sharing (nope, the sample data are not my own ;-)

These days I am more curious about my total calories consumed.

Even non-pay Fitbit users such as myself can use https://www.fitbit.com/export/user/data while logged in to their fitbit accounts to get a month's worth of reports at a time and compare them to their corresponding http://www.trendweight.com and scale weight results.

For total calories consumed I use the http://www.myfitnesspal.com/reports/printable_diary report function (which now only returns a maximum of 45 days instead the 365+ it used to) and usually display a month's worth of data making sure to only select the "food diary".

I then "select all" and copy and paste "as is" into a new Excel spreadsheet with a minimum of two blank sheets (by default Excel launches with enough)

A couple of semi manual clean up macros later (and after a sanity check that I have extracted the correct number of days given that my first macro will keep circling through indefinitely if I don't pay attention) I extract the "TOTALS" lines to Sheet2 and calculate quick averages in case that's all I want!

But, more often than not, I then select all the daily result lines in Sheet2 and paste them to the right of the appropriate starting date in this google sheet: https://docs.google.com/spreadsheets/d/1vwjCcATCzhU1IFTufaM2OphSqLsGbJqQxNHYpch43L8/edit?usp=sharing

Any "gimme's" on improvement would, of course, be very welcome indeed! In the meanwhile, based on my currently rudimentary Excel macro skills, these are the clean-up macros I've come up with:

Sub MFP()
'
' MFP Macro
'
' Keyboard Shortcut: Ctrl+t
'
Cells.Find(What:="TOTAL:", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Rows(ActiveCell.Row).Select
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
Selection.Offset(1, 0).Select
Sheets("Sheet1").Select
Selection.Offset(1, 0).Select
End Sub

AND

Sub MFP_Second_Clean()
'
' MFP_Second_Clean Macro
'
' Keyboard Shortcut: Ctrl+Shift+T
'
Range("A1").Select
Application.CutCopyMode = False
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range("A1:I5000").Select
Selection.Replace What:="g", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="m", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B1").Select
ActiveCell.FormulaR1C1 = "=AVERAGE(R[1]C:R[5001]C)"
Range("B1").Select
Selection.Copy
Range("C1:I1").Select
ActiveSheet.Paste
Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "AVERAGE"
Range("B1").Select
End Sub

Anyway, would love to see other people sharing their own spreadsheets and/or suggesting how to implement improvements!

**and thanks to this thread I discovered an incorrect September 7 entry! One that had increased my carbs for the day by about 4,000g, giving me THE re-feed that never was!