Hi all,
This is my first post and I'm seeking some help from you excel gurus! I have some raw data that I'd like to turn into some meaningful graphs. I've tried playing around with the pivot chart and pivot table but I can't quite get it to make sense to someone who may look at it casually. Basically, I started a lifting program called StrongLifts 5x5 and finally have enough data to begin drawing up some visual data.
Here's the raw data.
<tbody>
</tbody>
To make things a little easier, here's how it is broken down per the program
Workout A
Squat
Bench
Row
Workout B
Squat
Overhead Press
Deadlift
Rinse, repeat.
Squats occur every workout and the remaining two exercises just rotate. I do my workouts in LBs so the KG column isn't too important but would be nice to keep when comparing to other users who measure in KG. 5x5, for those not familiar, is 5 sets of 5 repetitions. The program accounts for failure and allows you to change up the amount of sets/reps if the weight gets too heavy. The information in these cells probably isn't too important right now because I'm able to complete every set & rep and should be OK for the short term. Once these weights get a lot heavier I may see failure.
Anyways, this is a hefty first post and I'm sure it's a lot to ask but what would be the best way to go about creating visuals that make sense. Like I said, I've played around with the pivot charts and pivot tables but was having a difficult time getting labels to show where I wanted or just having the graphs make sense, period. Some other things I'd like to see on the graph. Ideally I'd like to get some pointers on the best way to approach this!
Thanks all!!
This is my first post and I'm seeking some help from you excel gurus! I have some raw data that I'd like to turn into some meaningful graphs. I've tried playing around with the pivot chart and pivot table but I can't quite get it to make sense to someone who may look at it casually. Basically, I started a lifting program called StrongLifts 5x5 and finally have enough data to begin drawing up some visual data.
Here's the raw data.
| Date | Note | Workout | Body Weight | Exercise 1 | Weight (KG) | Weight (LB) | Set 1 | Set 2 | Set 3 | Set 4 | Set 5 | Exercise 2 | Weight (KG) | Weight (LB) | Set 1 | Set 2 | Set 3 | Set 4 | Set 5 | Exercise 3 | Weight (KG) | Weight (LB) | Set 1 | Set 2 | Set 3 | Set 4 | Set 5 |
| 4/4/2016 | A | Squat | 57.5 | 127.5 | 5 | 5 | 5 | 5 | 5 | Bench | 35 | 80 | 5 | 5 | 5 | 5 | 5 | Row | 30 | 65 | 5 | 5 | 5 | 5 | 5 | ||
| 4/6/2016 | B | 179LB | Squat | 57.5 | 130 | 5 | 5 | 5 | 5 | 5 | OHP | 27.5 | 60 | 5 | 5 | 5 | 5 | 5 | Deadlift | 60 | 135 | 5 | |||||
| 4/9/2016 | A | 179LB | Squat | 60 | 135 | 5 | 5 | 5 | 5 | 5 | Bench | 37.5 | 85 | 5 | 5 | 5 | 5 | 5 | Row | 32.5 | 70 | 5 | 5 | 5 | 5 | 5 | |
| 4/11/2016 | B | 179LB | Squat | 62.5 | 140 | 5 | 5 | 5 | 5 | 5 | OHP | 30 | 65 | 5 | 5 | 5 | 5 | 5 | Deadlift | 65 | 145 | 5 | |||||
| 4/12/2016 | A | 179LB | Squat | 65 | 145 | 5 | 5 | 5 | 5 | 5 | Bench | 40 | 90 | 5 | 5 | 5 | 5 | 5 | Row | 35 | 75 | 5 | 5 | 5 | 5 | 5 | |
| 4/15/2016 | B | 179LB | Squat | 67.5 | 150 | 5 | 5 | 5 | 5 | 5 | OHP | 32.5 | 70 | 5 | 5 | 5 | 5 | 5 | Deadlift | 70 | 155 | 5 | |||||
| 4/18/2016 | A | 179LB | Squat | 70 | 155 | 5 | 5 | 5 | 5 | 5 | Bench | 42.5 | 95 | 5 | 5 | 5 | 5 | 5 | Row | 35 | 80 | 5 | 5 | 5 | 5 | 5 | |
| 4/20/2016 | B | 179LB | Squat | 72.5 | 160 | 5 | 5 | 5 | 5 | 5 | Overhead Press | 35 | 75 | 5 | 5 | 5 | 5 | 5 | Deadlift | 75 | 165 | 5 |
<tbody>
</tbody>
To make things a little easier, here's how it is broken down per the program
Workout A
Squat
Bench
Row
Workout B
Squat
Overhead Press
Deadlift
Rinse, repeat.
Squats occur every workout and the remaining two exercises just rotate. I do my workouts in LBs so the KG column isn't too important but would be nice to keep when comparing to other users who measure in KG. 5x5, for those not familiar, is 5 sets of 5 repetitions. The program accounts for failure and allows you to change up the amount of sets/reps if the weight gets too heavy. The information in these cells probably isn't too important right now because I'm able to complete every set & rep and should be OK for the short term. Once these weights get a lot heavier I may see failure.
Anyways, this is a hefty first post and I'm sure it's a lot to ask but what would be the best way to go about creating visuals that make sense. Like I said, I've played around with the pivot charts and pivot tables but was having a difficult time getting labels to show where I wanted or just having the graphs make sense, period. Some other things I'd like to see on the graph. Ideally I'd like to get some pointers on the best way to approach this!
- Total weight lifted that day
- Total weight lifted that week
- Theoretical 1RM (1 rep max) - I have my original 1 rep maxes so if it would make sense to provide that, I can.
- Any other good numbers to show progression
Thanks all!!
