/Spreadsheet and tracking general/

>>37454469
What does it matter? Do you think the structure of your spreadsheet correlates to better gains or what? You just include the bare mininum that you want to track.

>>37454484
Because I'm gonna be on this program for at least a few months, and I'd like to be able to look at my progress by the end of it.

Besides, excel is crazy powerful, and a lot of people on /fit/ use it for this exact reason. I wanna see what I can learn.

>>37454502

Yeah, but you're asking for the "best" way to track progress when it's really just a matter of writing down your lifts every day. How autistic are you? Just make a date column, exercise column, sets/reps column and a weight column. BAM, you're done. If you're doing the exact same exercises every workout you write them only once, vertically for example.

>>37454526
>How autistic are you?
He says, while getting angry at me making a fitness related thread on a fitness forum.

Spreadsheets have been a thing on /fit/ for ages. I'm curious as to how others track them. You need to calm down, and let people enjoy the board.

>>37454543

okay, we'll see how far this /spreadsheet and tracking general/ will go. good luck.

I use google docs, not excel, because it's convenient to use on my phone in the gym, but same same.

I just do a column per exercise, one row per lifting day. That way I can easily add new exercises and plot weight increase on all exercises. I usually collate exercises that happen at similar weight ranges (e.g. my squat and BP) into the same chart. Unfortunately google spreadsheet sucks balls at plotting.

I also track calories, macros, weight, waist circumference, bodyfat caliper measurements and medication dosages administered in the same sheet, so it's all in one place.

google spreadsheets allows you to write functions in javascript, which is handy, so I have the lookup-tables and formulas for e.g. the bodyfat results all automatically computed once I put in the numbers from the bodyfat caliper.

My best protip: if you're making any kind of macros or you need any kind of static data, learn to use a SECOND SHEET! This is so useful. Any kind of intermediate computations like running averages you can easily dump there, or you can put a column in the second sheet with stuff like your height etc that you can then reference in any computations, if you need it. You can also put only plots on the first sheet and actual data to be filled out in a second sheet, keeps things neat and tidy.

>>37454648

upload

>>37454849
too much personal info in it, sorry. I can give the source-code for the functions I use to compute bodyfat and such tho, if that helps you any.

>>37455069
(also, it's a bit shit and messy, with what I said, you can do better yourself anyway. The only hard part is beating the charts of google docs into submission, because they are fucking shite.)

>>37455084
Thinking about it, I think I will actually make a new, cleaned-up version and publish it on /fit/ at some point, with better ways to enter data and see stats (and maybe metric/imperial switching). Will be a few days tho, I have a deadline coming up on the 9th and the 15th.