- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Would anyone be interested in some excel tracking tools?
Posted on 2/8/24 at 11:38 am
Posted on 2/8/24 at 11:38 am
I like to track all of my metrics in excel and look at daily averages over a week period so I've set up a pivot table dashboard to roll everything up.
I have it set up to track daily calories, protein, steps, and weight, but could easily modify the sheet to add more functionality and find somewhere to host it where anyone can grab it.
Open to any input or ideas that any of you may like to see. Wouldn't take me long to set up something for anyone to use.
I've found this to be helpful for me to figure out where I need to make adjustments and figured why not use it as a resource for anyone else that would like to get more useful information.
I have it set up to track daily calories, protein, steps, and weight, but could easily modify the sheet to add more functionality and find somewhere to host it where anyone can grab it.
Open to any input or ideas that any of you may like to see. Wouldn't take me long to set up something for anyone to use.
I've found this to be helpful for me to figure out where I need to make adjustments and figured why not use it as a resource for anyone else that would like to get more useful information.
Posted on 2/8/24 at 1:44 pm to Powerman
One thing I do is track my weight in excel and graph it over time. Then I add a trend line so I get a good idea of when I’ll reach my goal weight, or what my weight will be around beach vacation, etc. Has worked pretty well for me
Only other thing I track in excel is my workouts. I found a year calendar online and I highlight the days I worked out, color coded with the program I ran. I have all my workout history in the Strong app but this is kind of a good visual. Use it for planning as well, figuring out when an 8 or 12 week program would end, etc.
Only other thing I track in excel is my workouts. I found a year calendar online and I highlight the days I worked out, color coded with the program I ran. I have all my workout history in the Strong app but this is kind of a good visual. Use it for planning as well, figuring out when an 8 or 12 week program would end, etc.
Posted on 2/8/24 at 3:54 pm to Powerman
I have an old one from 2019 that I've shared before. Helped me get to my lowest ever weight and stopped using it and never got back there lol. There's a script to poll MFP for tracking data that is busted now, guessing mfp changed their API.
LINK
Looks like I was experimenting with all sorts of macro ranges lol
LINK
Looks like I was experimenting with all sorts of macro ranges lol
This post was edited on 2/8/24 at 3:58 pm
Posted on 2/9/24 at 7:22 am to Powerman
There has to be an app for this...Excel is horrible.
Posted on 2/9/24 at 8:50 am to Powerman
I’m a CPA and was in mid 30’s in 2014 when I decided to start tracking things in Excel. It started with goal to do as many different things each month. I had always done mostly basketball and weight room to that point with other sports sprinkled in.
The Excel file evolved to add injuries, sickness, intermittent fasting (goal of one 24 hr/month), and stats from basketball leagues.
Current goal is to aim for 10+ different things each month. Weight room and basketball average about 6x/month each with others 1-2 times. Such as Group Ex classes, Volleyball, Disc Golf, Golf, Tennis, Yoga, running hills.
Just realized recently I now have 10 full years in this Excel file.
The Excel file evolved to add injuries, sickness, intermittent fasting (goal of one 24 hr/month), and stats from basketball leagues.
Current goal is to aim for 10+ different things each month. Weight room and basketball average about 6x/month each with others 1-2 times. Such as Group Ex classes, Volleyball, Disc Golf, Golf, Tennis, Yoga, running hills.
Just realized recently I now have 10 full years in this Excel file.
Posted on 2/12/24 at 11:20 am to Powerman
Well? You gonna share the spreadsheet baw?
Popular
Back to top
Follow TigerDroppings for LSU Football News