I was checking out Charles Staley's site and noticed that they have a program that you can buy to help track your logs.
It looks like you could probibly make something very simular using MS Access. My question is
A: "has anyone ever tried to make something along these lines"
B: "would anyone be interested in something like this"
I was thinking about putting a "create a database" project on the back burner, if anyone's interested let me know. It might be quite some time before I actually get around to doing it!
Someone is selling that as a professionally designed application? Yikes! What's with the purple?
I know that wasn't the topic but I had to get that out. Frankly, I prefer good ol' paper and pencil, but I'm an application developer by profession so if you want any advice I'll be happy to help.
Access is a great application, and if you were able to create a workout log in Access, I think a lot of folks could benefit. I think it's a great idea!
__________________
"It's what you've got inside that matters. The details and technological things will take you only so far. You still have to pedal the bike. Some people are always looking for the magic secret. There's no secret. Just bust your ass." -Dave Zabriskie
Oh yeah, I could use something along those lines. I can think of a lot of functions to add; Recommend weight based upon past experience, or planned increases ie 2% per week. Or maybe show volume and work by plane or muscles worked.
Originally posted by Torque: ...I can think of a lot of functions to add; Recommend weight based upon past experience, or planned increases ie 2% per week. Or maybe show volume and work by plane or muscles worked.
I think it's a cool idea if you can do it.
That's something along the lines of what I'd like to try to do. I'm not sure really how to apply but I wouldn't think it'd be TOO hard to figure out...if nothing else create a button to figure out what a projected Xrm would be...or possibly reverse it where you apply your workout and 1RM and it'd give you your #'s over time. Food for thought.
Just as an FYI I know absolutely nothing about Access other than "it can be done". Once I start working on it, I'll probibly harrass upnorth frequently!
I could do something like that in vb, shouldn't take more than a a couple of days...
If there are enough people who would actually use this type of thing I'd be more than happy to. It's not like I have anything BETTER to do with my free time :/
__________________
Weight: 155lbs
Age: 18
Height: 5'9
Bodyfat: ~12%
Max squat: ?
Max deadlift: 225x5
Max bench: 115x5
Originally posted by gobbla: Once I start working on it, I'll probibly harrass upnorth frequently!
Harass away -- jnorthrop@gmail.com. And even if you don't harass me, take this one piece of advice: Stay away from colors and pictures. Use Microsoft Office applications, Google or Mac OSX as design inspiration. These are companies that have spent millions on usability and design efforts. Learn from the best and your design will stand the test of time.
This is a cool idea. I currently use an Excel spreadsheet, and that's mainly because my current plan (BoM) doesn't have the handy chart like TAP has. The little 3x5" notebook I keep notes in at the gym gets kind of raggedy after going in and out of my pocket and gym bag for weeks, so I like having an easy way to look back at my progress.
I'd like to see features like graphs showing your strength increases over time, too, if you want some additional selling points.
__________________ The trick is in what one emphasizes. We either make ourselves miserable, or we make ourselves happy. The amount of work is the same. -- Carlos Castaneda
Baby steps...I'm trying to learn to use excell a little better and made up a good portion of CW's programs in it, automatically calculating 1RM %'s and increases per week.
I'll probiby spend some time either tonite or tommorrow working out individual workout days with it automatically calculating Sets and Reps as the weeks progress also.
Once I get that stuff down I'll move on to Access...and then the world!!
O-HAHAHAHAHA!!!!!
Hey I wonder if you can display excel spreadsheets in Visual Basic or Access. That way we can avoid the clumsy report making tool they've got there [img]redface.gif[/img]
so gobbla, if you're serious about this maybe we could work together? [img]tongue.gif[/img]
I think VB is a better option than Access though...
__________________
Weight: 155lbs
Age: 18
Height: 5'9
Bodyfat: ~12%
Max squat: ?
Max deadlift: 225x5
Max bench: 115x5
you can import your Excel spreadsheets into Access, makes the data entry a little easier. Then you just have to make the fields, tables, etc to your liking. I'd go into greater detail, but I just started the class 2 weeks ago.
You can incorporate either Excel or and Access database into a VB application, but I'm not sure why you want to do that. You really have very similar capabilities with VBA (Visual Basic for Applcations) that are provided with VB. VBA is built into all versions of Office applications and gives you the ability to do forms and alike in additional to all the functionality of the application.
However, if you want to go the VB route, see if your version has the Crystal Report add-in. That will give you a very powerful reporting engine.
Simon> I deffinately wouldn't mind colaborating, but like I said before it's going to be a while before I can actually devote time for sure. We're getting ready to make an international move next month so things are relatively hectic right now. It'll probibly be about three months before I'll *really* be able to commit to working on it in a serious nature.
The only reason I'm shooting for Access, is because I have it and I think it'll do what I'm shooting for. Or at least close enough for govt. work. [img]smile.gif[/img] I really don't know much of anything about databases!
Alextown> that's what I was shooting to do\learn right now (excell). it's alot easier than I thought it would be...of course now my knowedge falls at the 3% of what's out there but STILL!
**
Latest spreadsheet is "Full Body Fat Loss", *slightly* more aggressive...4 weeks, with two workouts incorperating 3 work sets at a 10% difference per set and a 5% increase per week.
Access is the buggiest piece of software I've ever worked with. ever. EVER. I never want to touch that thing again in my life.
I just feel more comfortable working with VB, where everything is set in the form of code and I can manipulate it as much as I want to...
I'm a control freak.
Any of you guys who are willing to program, if you can take our input and feedback (but not loss of control :-D, you could come up with a top-notch useable/useful program/log. We can all be development team and beta testers. That's be pretty cool.
If you're going to write this in VB then check out the Data Reports functionality (part of VB6). This will save you from using an external application such as Crystal Reports for the reporting..
Linear Mode
