What's on your spreadsheet?

MrsLannister

I saw that some of you are using a spreadsheet to track your progress and the accuracy of the BMF. I'm curious what data you are tracking?

I just set one up for 2014. Obviously, I am tracking calories in, calories out, and weight. I am also keeping a column of "expected" weights, based on the previous day's data (I weigh daily). I have a column for sodium and a column tracking my menstrual cycle. I'm looking for accuracy, as well as seeing if there are patterns to my weight fluctuations. I already kind of know the patterns, but I want to see it more clearly.

kelleybean1

I would love to set up a spreadsheet like yours. Can you share the template? I'm a data idiot, and wannabe data nerd. ;-)

Duck_Puddle

I track macro g's, and subsets of macros (specifically saturated & trans fat & sugar for my MD) as well as sodium. I also track "workout" activity vs total activity measured by BMF (the difference being "unintentional" activity). I also have a rolling average for weight and a few columns set up to attempt to measure expected vs. actual results (which is what has eventually yielded that my BMF reads high by 15-ish %). This is all combined with the stuff that outputs from BMF activity manager. So all that is rolled in as well.

MrsLannister

I just threw this together really quickly with some dummy data. I am tracking other stuff, but it's pretty customized. This just takes the previous days data, calculates the deficit and uses it to project what today's weight should be. It's never, ever accurate, but at least it gives me an idea where I should be. Each day's weight projection is based on the previous day's actual weight, so it doesn't get too far off track.

https://docs.google.com/spreadsheet/ccc?key=0AvmgwvwA-Qf9dHNCNm1DUXE1blloRHp3YWNheGhSdEE&usp=sharing

Guamybear

I drive a school bus so I am tracking my calories burned during those runs and what the burn in is on days that I lift weights before I afternoon run.

Morgaath

I just threw this together really quickly with some dummy data. I am tracking other stuff, but it's pretty customized. This just takes the previous days data, calculates the deficit and uses it to project what today's weight should be. It's never, ever accurate, but at least it gives me an idea where I should be. Each day's weight projection is based on the previous day's actual weight, so it doesn't get too far off track.

https://docs.google.com/spreadsheet/ccc?key=0AvmgwvwA-Qf9dHNCNm1DUXE1blloRHp3YWNheGhSdEE&usp=sharing

A suggestion on something to add in: last 7 day average of your deficit.
It would be something like =AVERAGE(D1:D7) in cell G8, and then just drag it down. It is great for those times you go over (OK...my average is still where it needs to be), and also helps you realize when you keep always being way under (I am aiming for 1000...so why is my average 1337 for the week? No wonder I am always hungry)