Weightlifing spreadsheet

Question

Level 1

45 points

Weightlifing spreadsheet

Howdy!

I know there is a template in numbers for weightlifting, but I don't really like it. I was wondering if there is another one anyone has created that I could use? If so, would you mind sharing. Interested in any answers, so even if someone posts one they have created, please post more. I might not like the first one I get.

Thanks so much!

MacBook Pro, Mac OS X (10.6.3)

Posted on Jun 7, 2010 7:51 AM

Reply

Answer 1

Tim Foster1 Author

Level 1

45 points

Jun 15, 2010 11:51 AM in response to Jerrold Green1

Jerry,

What you are talking is similar to what I want to do. What you say about the way numbers charts the weight is not realistic. I don't want to see the how much I have improved in weight lifted, not the product of weight times reps. (would you be able to send me your spreadsheet?).

What we do right now in our workout is 3 sets of 10 reps on each type of lift (bench press, bicep curls, tricep curls, etc....). If I can do 3 sets of 10 pretty easily, I then up the weight by 5 or 10 lbs a side the next time I exercise (usually do upper body one day and lower body the next).

I would like to track that each day and be able to graph say each items weight over time (how has my bench press improved over the last month).

Does that make sense?

Thanks guys!!

Reply

Answer 2

KOENIG Yvan

Level 8

41,825 points

Jun 7, 2010 8:03 AM in response to Tim Foster1

The chapter 12 of *_Numbers User Guide_* is entitled :

*_Designing Your Own Numbers Spreadsheet Templates_*

It's the best way to get a spreadsheet fitting your exact needs.

This well done user guide may be downloaded for free from the Help menu.

Yvan KOENIG (VALLAURIS, France) lundi 7 juin 2010 17:03:47

Reply

Answer 3

Barry

Level 9

60,035 points

Jun 13, 2010 1:17 AM in response to Tim Foster1

Tim Foster1 wrote:
Really just something simple to track the types of lifting I do and the the weight and then be able to graph the progress over time.

Too general a statement of the goal to do much with, Tim. There's not much indication where to start.

Try again, and assume that no one here knows anything about what you want to track and how you want to track it.

Here's the top left corner of a really basic template for the task. What would you change on it to make it fit your needs?

You mentioned the Workout Tracker template supplied with Numbers. What revisions to that template are needed to fit your needs?

Regards,
Barry

Reply

Answer 4

Jun 13, 2010 6:32 PM in response to Tim Foster1

Tim,

As Barry suggested, you probably will want to have the Date in a Header. Then too, you will list your types of lifts. Beyond that, It depends on how you structure your workout. I normally do up to three sets of up to 15 reps for each lift type, so for each exercise I have three sets of rep/weight data per date. This is because I may change the reps or weight mid-stream and I want that recorded. I also have check boxes for Increase/Decrease to indicate if I want to change the resistance or reps on the next workout based on how I feel about the load during the current workout. I've never felt that I would be interested in charting the data because it's not clear to me what the best parameter for charting would be. If I recall correctly, the Numbers example calculates the resistance*rep products and charts them. To me, those numbers are not easy to relate to. Good luck with your project and if you need any help with programming specifics, let us know.

Jerry

Reply

Answer 5

Jun 7, 2010 8:19 AM in response to Tim Foster1

Hi Tim,

Welcome to the Numbers discussion.

What would your ideal weightlifting template look like? What don't you like about the template you looked at?

Jerry

Reply

Answer 6

Tim Foster1 Author

Level 1

45 points

Jun 12, 2010 9:10 PM in response to Jerrold Green1

Really just something simple to track the types of lifting I do and the the weight and then be able to graph the progress over time.

Reply