- 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.
5
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:13 pm to whiskey over ice
I graph with trend lines as well
I don't have enough data in the current iteration of the file to pay much attention to it but it's another good thing to look at
Meaning to implement this as well. For right now I just have a brief description of the lifts/muscle groups work so I can manage rest days and keep on a good rotation.
I don't have enough data in the current iteration of the file to pay much attention to it but it's another good thing to look at
quote:
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.
Meaning to implement this as well. For right now I just have a brief description of the lifts/muscle groups work so I can manage rest days and keep on a good rotation.
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/8/24 at 4:05 pm to Hulkklogan
My main problem with that sheet is it's just way too much
Sometimes you need to simplify things. You're trying to track basic health information, not put a cruise missile through someone's window on the other side of the planet.
Sometimes you need to simplify things. You're trying to track basic health information, not put a cruise missile through someone's window on the other side of the planet.
Posted on 2/8/24 at 4:09 pm to Powerman
Yeah when I geek out I can really geek out lol. But once I got MFP integrated it wasn't bad, I just logged stuff in MFP and had a better view of things.
Nowadays MFP is shite
Posted on 2/8/24 at 4:10 pm to Hulkklogan
I never did like Mike from Plaquemines
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/9/24 at 8:55 am to RocketTiger
quote:
Excel is horrible.
Uncultured
Posted on 2/9/24 at 12:20 pm to RocketTiger
quote:
Excel is horrible.
I find it very easy to use and since I'm at a desk at work, I'd rather view my data on a decent sized monitor instead of looking at some restricted web app on my phone. Having your own file allows the flexibility to track everything that interests you and not worry about what you don't care about.
Posted on 2/9/24 at 1:00 pm to Powerman
He prob has a liberal arts degree. Never heard that from a STEM major
This post was edited on 2/9/24 at 1:00 pm
Posted on 2/9/24 at 1:46 pm to RocketTiger
quote:
Excel is horrible.
:shots fired:
Posted on 2/9/24 at 8:30 pm to Hu_Flung_Pu
I'm a college dropout and only average in excel
Believe me these aren't jambalaya calculator type of spreadsheets going on
My motto is keep it simple
Believe me these aren't jambalaya calculator type of spreadsheets going on
My motto is keep it simple
Posted on 2/12/24 at 11:20 am to Powerman
Well? You gonna share the spreadsheet baw?
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News