Muscle and Brawn Forums
 

Go Back   Muscle and Brawn Forums > Training > Training Logs
Mark Forums Read
Register Articles Members List Search Today's Posts

Notices

Training Logs Keep your training and supplement logs here

Reply
 
Thread Tools Search this Thread Display Modes
Old 10-06-2014, 08:15 PM   #1
engineeredspreadsheets
Junior Member
Points: 1, Level: 1 Points: 1, Level: 1 Points: 1, Level: 1
Activity: 0% Activity: 0% Activity: 0%
 

Join Date: Oct 2014
Location: IA
Posts: 3
Training Exp: 5
Training Type: General Fitness
Fav Exercise: Back Squat
Fav Supp: Coffee
Reputation: 10
engineeredspreadsheets is off to a bad start
Question Excel Based Lifting Journal

Hello All,

Following up on my intro; I am working on developing an Excel based Lifting Journal, and I am trying to gauge interest in using Excel to log lifting performance. It is more power and flexible than an ‘App’ but generally has a stepper learning curve and access limitations.

Are people interested in spreadsheet based tools for tracking performance? If so, what kind of features are people using today or wish they had in their personal journal?

Any feed back would be greatly appreciated.
engineeredspreadsheets is offline   Reply With Quote
Sponsored Links
Old 10-07-2014, 07:58 PM   #2
engineeredspreadsheets
Junior Member
Points: 1, Level: 1 Points: 1, Level: 1 Points: 1, Level: 1
Activity: 0% Activity: 0% Activity: 0%
 

Join Date: Oct 2014
Location: IA
Posts: 3
Training Exp: 5
Training Type: General Fitness
Fav Exercise: Back Squat
Fav Supp: Coffee
Reputation: 10
engineeredspreadsheets is off to a bad start
Default

To give some more background I have already started an Excel Journal that I started using this year.

Works by simply selecting Muscle Group and then Exercise from a pull down list, and then entering Reps, Sets, and Weight in a single Journal Table.

Using what is entered in the Journal table the results can be displayed in Summary Pivot Table.

The results can filtered by Year, Month, and/or Day. The layout of the Summary table can be changed on the fly without any impact on the Journal.

The results can also be displayed in chart format.

The benefit of this approach is that the data is always entered the same way irregardless of what exercise program is being followed, and it is fairly easy to make changes to the layout without having to rewrite a lot of excel formulas.
Attached Thumbnails
Click image for larger version

Name:	Journal.jpg
Views:	7
Size:	392.8 KB
ID:	16136   Click image for larger version

Name:	Summary.jpg
Views:	4
Size:	216.3 KB
ID:	16137   Click image for larger version

Name:	Muscle_Group.jpg
Views:	5
Size:	129.4 KB
ID:	16138  
engineeredspreadsheets is offline   Reply With Quote
Reply

Bookmarks


Similar Threads
Thread Thread Starter Forum Replies Last Post
Evidence-based recommendations for natural bodybuilding contest preparation BendtheBar Muscle Building and Bodybuilding 6 07-02-2014 07:37 PM
Incentives Based Performance BendtheBar Mind and Motivation 0 06-17-2013 01:25 PM
OR Jr Journal Off Road Training Logs 60 12-02-2012 09:45 PM
big val's journal big valsalva Training Logs 361 02-09-2010 08:48 PM

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:28 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2014, vBulletin Solutions, Inc.