Closed Thread
Page 2 of 2 FirstFirst 1 2
Results 31 to 54 of 54
  1. #31
    Registered User infornet's Avatar
    Join Date: Oct 2010
    Age: 36
    Posts: 1
    Rep Power: 0
    infornet has no reputation, good or bad yet. (0)
    infornet is offline

    Smile

    Great tool!!! Thanks!!!


    Originally Posted by goghua View Post
    Ok, so I already posted this in the Misc section, but I got some positive feedback and a suggestion to post it here as well...

    So, I thought I would share the spreadsheet that I put together to track my workouts, you will find it attached to this thread.

    On the first tab of the workbook you will a set of instructions on how to use it.

    I would love to hear some feedback, comments, suggestions, etc. on how I can improve it.

    Thanks!

  2. #32
    Form>Weight DYTrainer's Avatar
    Join Date: Jun 2010
    Location: Strongsville, Ohio, United States
    Age: 35
    Posts: 1,609
    Rep Power: 882
    DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500) DYTrainer is a jewel in the rough. (+500)
    DYTrainer is offline
    Very nice op. Just a couple of things:

    1) Make sure you protect your worksheets/workout books. Dont want people changing formulas and such
    2) Use conditional formatting and data validation. IE, only numbers allowed when entering weight and reps
    3) The "0" everywhere can be overwhelming, and they aren't really needed. Like on the "Week" Sheets, a simple formula could be "=IF(OR(D5="",E5=""),"",D5*E5)"
    4) If not all 12 weeks of data is inputted, it can look like the charts "Fall off a cliff". Couple ways to fix this:
    a) XL wont plot "NA()", so if you put in your formula "if (whatever data)="", NA(), whatever data
    b) use the offset function to have xl plot a growing list of numbers.
    -Formulas-Name Manager-New
    -Create a name
    - in the "Refers to"
    =OFFSET(Progress!$V$3,0,0,COUNTIF(Progress!$V$3:$V $14,">0"),1)
    -this will make the "Total Weight per week" chart only show when the data has values>0
    -Just go to Edit series, and add the name of your new formula after the sheet name and you are good
    5) Hide unused rows and columns. Go to last col and hit "ctl+shift+right arrow", right click hide. Go to last row of data, "Ctl+shift+down arrow" right click and hide. Make it look much cleaner.
    6) Turn off grid lines and headings.

    Perhaps alot of this is just my nitpicking, because the sheet is really nice. Though I have found the offset function to be one of the most useful functions
    My Workout Log:
    http://forum.bodybuilding.com/showthread.php?t=146169983&pagenumber=

    "It is while struggling against the heaviest weights a human body can move that the demand for courage is incessant."
    -Mike Mentzer

  3. #33
    Registered User PolH94's Avatar
    Join Date: Dec 2012
    Location: Torshavn, Faroe Islands
    Age: 23
    Posts: 12
    Rep Power: 0
    PolH94 has no reputation, good or bad yet. (0)
    PolH94 is offline
    This may be one old ass post, but I LOVE this ! awesome job Goghua!!!
    "Can't" is not in my vocabulary!!!

  4. #34
    Registered User PolH94's Avatar
    Join Date: Dec 2012
    Location: Torshavn, Faroe Islands
    Age: 23
    Posts: 12
    Rep Power: 0
    PolH94 has no reputation, good or bad yet. (0)
    PolH94 is offline
    I have one question about this sheet... If I want to add one more set, so there will be 6 sets instead of 5, how do I do that ? Can anyone tell me that ?
    "Can't" is not in my vocabulary!!!

  5. #35
    Registered User natedummelow's Avatar
    Join Date: Jan 2013
    Age: 25
    Posts: 1
    Rep Power: 0
    natedummelow has no reputation, good or bad yet. (0)
    natedummelow is offline

    Updated Workout Template with 10 Sets and Seperate Pages for Graphs

    Originally Posted by PolH94 View Post
    I have one question about this sheet... If I want to add one more set, so there will be 6 sets instead of 5, how do I do that ? Can anyone tell me that ?
    Here you go dude, i just finished the formulas to complete the workout template. Will probably improve it more for usability and will post again.

    Hope this helps
    Attached Files

  6. #36
    Banned JTswole's Avatar
    Join Date: Apr 2013
    Posts: 68
    Rep Power: 0
    JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10) JTswole is on a distinguished road. (+10)
    JTswole is offline
    Thanks so much!! This is seriously one of the best tracking programs I've found!

  7. #37
    Registered User wadsee's Avatar
    Join Date: Jul 2014
    Age: 29
    Posts: 2
    Rep Power: 0
    wadsee has no reputation, good or bad yet. (0)
    wadsee is offline

    Red face

    Reviving this thread again!

    I'm from the UK so we use kilograms, which often means counting in .5 increments. The spreadsheet automatically rounds the number up when I use decimals. Is there an easy way to stop this? This would be really useful, as I can see this being a great tool for me!

  8. #38
    Registered User wadsee's Avatar
    Join Date: Jul 2014
    Age: 29
    Posts: 2
    Rep Power: 0
    wadsee has no reputation, good or bad yet. (0)
    wadsee is offline

    Also

    Does anyone know how to adapt the equation for the charts so the lines ignore "0" values?

  9. #39
    Registered User kd8ov's Avatar
    Join Date: Oct 2014
    Age: 45
    Posts: 1
    Rep Power: 0
    kd8ov has no reputation, good or bad yet. (0)
    kd8ov is offline

    More rows for each day

    Wondering if there is a way to add more rows per day?

    Currently the sheets are built to handle 8 Exercises per day. Can I get 10 exercises per day?

    Can I just add 2 more rows?

    Thanks

  10. #40
    Registered User saddamonline's Avatar
    Join Date: Oct 2014
    Age: 31
    Posts: 1
    Rep Power: 0
    saddamonline has no reputation, good or bad yet. (0)
    saddamonline is offline
    thanks for the template.
    Originally Posted by goghua View Post
    Ok, so I already posted this in the Misc section, but I got some positive feedback and a suggestion to post it here as well...

    So, I thought I would share the spreadsheet that I put together to track my workouts, you will find it attached to this thread.

    On the first tab of the workbook you will a set of instructions on how to use it.

    I would love to hear some feedback, comments, suggestions, etc. on how I can improve it.

    Thanks!

  11. #41
    Registered User BoulderManiac's Avatar
    Join Date: May 2015
    Age: 35
    Posts: 1
    Rep Power: 0
    BoulderManiac has no reputation, good or bad yet. (0)
    BoulderManiac is offline

    Lightbulb Phenomenal

    Absolutely a fantastic training log! Easy to use and extremely user friendly, good job!

    A great addition to it would be a way to log cardio or other time based workouts or success/failure workouts. A lot of what I do for workouts is body weight exercises designed for climbing. Workouts I do include things like hanging on three fingers to failure.

    My suggestion to implement something like that would be to have a second set of dropdowns (like what you've done with the exercise page) except applied to the reps/weights section. So if the user selects a cardio workout, the reps/weight changes to intervals/duration for example. I'd implement that myself but my excel skills aren't the greatest. I'm also at a bit of a loss on how to show that on the tracking page.

    Also one question is there a way to add in more workouts per day? For climbing training you end up having to do a lot of different similar groups meaning a workout can include up to 30 or 40 different exercises per day.

  12. #42
    Registered User RealRob's Avatar
    Join Date: Oct 2012
    Posts: 29
    Rep Power: 0
    RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10) RealRob has a little shameless behaviour in the past. (-10)
    RealRob is offline
    Originally Posted by kd8ov View Post
    Wondering if there is a way to add more rows per day?

    Currently the sheets are built to handle 8 Exercises per day. Can I get 10 exercises per day?

    Can I just add 2 more rows?

    Thanks
    BUMP, wondering this aswell. Anyone?

  13. #43
    Mod Negged in Halo 2 Pastier911's Avatar
    Join Date: Jun 2010
    Location: United States
    Age: 27
    Posts: 8,465
    Rep Power: 4215
    Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500) Pastier911 is a glorious beacon of knowledge. (+2500)
    Pastier911 is offline
    Awesome!!
    I'm gonna make it brahs.

  14. #44
    Registered User PauloJJalmeida's Avatar
    Join Date: Sep 2014
    Age: 38
    Posts: 1
    Rep Power: 0
    PauloJJalmeida has no reputation, good or bad yet. (0)
    PauloJJalmeida is offline
    great for weights , i would like to add cardio (things like bleep test rower distance etc) to this but not sure to go about it?

    thanks

  15. #45
    Registered User iliad5000's Avatar
    Join Date: Sep 2015
    Age: 48
    Posts: 2
    Rep Power: 0
    iliad5000 has no reputation, good or bad yet. (0) iliad5000 has no reputation, good or bad yet. (0) iliad5000 has no reputation, good or bad yet. (0) iliad5000 has no reputation, good or bad yet. (0) iliad5000 has no reputation, good or bad yet. (0)
    iliad5000 is offline
    This is great, however, there is a formula error that makes the actual data incorrect. In the X,Y,Z columns you multiply X (Total Reps) by Y (the total sum of the weights lifted) to get your total weight combined lifted. The problem is, if you do 50 reps of 10 pound flys, and 2 reps of 100 pound chest press, the total would then be 5,720 lbs, according to your spreadsheet. The reality is, it is 500 lbs. To fix it, you can change the total in column Z to =SUM(X5:Y5,F5,J5,N5,R5,V5) for example, then drag that to the other cells so they are the same.

  16. #46
    Registered User jessejames3ball's Avatar
    Join Date: Nov 2015
    Age: 46
    Posts: 2
    Rep Power: 0
    jessejames3ball has no reputation, good or bad yet. (0)
    jessejames3ball is offline
    Fantastic tool! Great work on this. Six years later and people still find it and bring it back up, me included.

    I'm having an issue with the exercise selection. For example, if I select "Biceps" only "Smith machine drag curl" shows up as an option to use. It seems like the exercises aren't all transferring over. Does anyone else have that issue? Or am I doing something completely wrong?


    Thanks.

  17. #47
    Registered User jessejames3ball's Avatar
    Join Date: Nov 2015
    Age: 46
    Posts: 2
    Rep Power: 0
    jessejames3ball has no reputation, good or bad yet. (0)
    jessejames3ball is offline
    Originally Posted by jessejames3ball View Post
    Fantastic tool! Great work on this. Six years later and people still find it and bring it back up, me included.

    I'm having an issue with the exercise selection. For example, if I select "Biceps" only "Smith machine drag curl" shows up as an option to use. It seems like the exercises aren't all transferring over. Does anyone else have that issue? Or am I doing something completely wrong?


    Thanks.
    Never mind, I figured it out. Thanks again.

  18. #48
    Antihero AlexTheNewbie's Avatar
    Join Date: May 2013
    Location: Switzerland
    Posts: 3,022
    Rep Power: 10233
    AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000) AlexTheNewbie is a splendid one to behold. (+10000)
    AlexTheNewbie is offline
    bump since it was helpful to me and might help others.
    Remorse is for the dead

  19. #49
    Registered User CCDavies1986's Avatar
    Join Date: Dec 2016
    Age: 32
    Posts: 1
    Rep Power: 0
    CCDavies1986 is on a distinguished road. (+10)
    CCDavies1986 is offline
    This workout log is amazing. I can't imagine how long you must have spent working on it. I'd never have been able to create such a comprehensive excel doc. Thank you for this!

    I'm having some trouble editing the exercises available for selection in the B column. It keeps giving me error messages when I try to type a new exercise into the blank space. A message pops up saying "A user has restricted values that can be entered into this cell". Am I doing something wrong? The only way I've been able to get around this is by changing the data validation settings to allow any value, rather than a list. I'm not sure if this is the right way to go, because it means I have to manually type in every exercise rather than selecting it from a list. How can I edit list items? I'm using Microsoft 365.

  20. #50
    Registered User BSOLES25's Avatar
    Join Date: Jan 2017
    Age: 30
    Posts: 2
    Rep Power: 0
    BSOLES25 is on a distinguished road. (+10)
    BSOLES25 is offline

    Thank you

    Originally Posted by goghua View Post
    Ok, so I already posted this in the Misc section, but I got some positive feedback and a suggestion to post it here as well...

    So, I thought I would share the spreadsheet that I put together to track my workouts, you will find it attached to this thread.

    On the first tab of the workbook you will a set of instructions on how to use it.

    I would love to hear some feedback, comments, suggestions, etc. on how I can improve it.

    Thanks!
    THANK YOU!!
    been looking for one of these all day and hate all of them was dreading having to make my own. cant add any categories though want to add cardio and lower back
    Last edited by BSOLES25; 01-26-2017 at 03:34 PM.

  21. #51
    Registered User BSOLES25's Avatar
    Join Date: Jan 2017
    Age: 30
    Posts: 2
    Rep Power: 0
    BSOLES25 is on a distinguished road. (+10)
    BSOLES25 is offline
    i cant figure out how to add a category anytime i highlight the whole row and type it in it doesnt do anything. trying to get lower back, upper back, cardio

  22. #52
    Registered User krierst's Avatar
    Join Date: Jul 2017
    Age: 48
    Posts: 1
    Rep Power: 0
    krierst is on a distinguished road. (+10)
    krierst is offline

    Thumbs up

    Thanks for a great spreadsheet!

    I have a little bit of a challenge; how can I get the table in the "Progress" sheet to summarize if the same type of exercise is carried out several days in the same week? As of now, it appears like the formula only includes single days (i.e. if I, for example, choose "Chest" and "Bench Press" monday and tuesday, only the monday values appears to be counted in the formula.

    I'd be very thankful if someone could help out with this

  23. #53
    Registered User 3173yaelelie's Avatar
    Join Date: Aug 2017
    Location: Camarines Sur, Philippines
    Age: 28
    Posts: 1
    Rep Power: 0
    3173yaelelie is on a distinguished road. (+10)
    3173yaelelie is offline
    I was about to make my own workout log in excel, then a thought came into my mind, Why not google it I'm sure there's some awesome dude who already made it. AND YES YOU'RE THAT AWESOME DUDE! Thanks for this! Save me from time and effort!

  24. #54
    Registered User reddice86's Avatar
    Join Date: Aug 2018
    Age: 48
    Posts: 1
    Rep Power: 0
    reddice86 is on a distinguished road. (+10)
    reddice86 is offline

    Great tracker!

    Originally Posted by goghua View Post
    Ok, so I already posted this in the Misc section, but I got some positive feedback and a suggestion to post it here as well...

    So, I thought I would share the spreadsheet that I put together to track my workouts, you will find it attached to this thread.

    On the first tab of the workbook you will a set of instructions on how to use it.

    I would love to hear some feedback, comments, suggestions, etc. on how I can improve it.

    Thanks!
    Hi,

    This is just a great tracker! Thanks a lot for sharing it, it is definitely useful.

    I'd like to ask you how did you create the dropdown selectors in the Weeks Sheets. I know how to create the one where we can select the body part, but what about the second one that changes based on the selection we apply in the first one?

    I'm learning Excel and this would be an interesting feature for many other fields.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts