Forum Discussion
Problem with Logic
Thank you for responding. My data spreads like ivy over seven worksheets and there are several dozens more to the formulas than what I'm giving you in this spreadsheet (like how weight factors in, other health issues, recording meal nutrient and calorie numbers, exercise, sleep, and so much more). Out of all of that, I created a simplified Workbook consisting of just one Worksheet with just one week of data.
The effort was tedious and lengthy, but worth it! By bringing the various variables together onto a single sheet, I discovered two things. First, I uncovered some errors, which, when corrected, made the data make a lot more sense to me. Second, I discovered the cause of the circular logic. It was indeed circular -- in my head, spinning around and around! I hadn't taken into account the fact that "Day 1" of tracking is very different logically than days 2, 3, 4..., 3658, etc.
So, I solved my own dilemma, but I wanted you to see the data as you requested. I've tried to include as much documentation (or explanation, however you want to think about my comments) as possible.
Enjoy! (If such a verb can be applied to spreadsheets.)
Bruce Younggreen