This is an addendum to an earlier post. This is a little more technical and includes a link to a sample Excel file.
[Update: A more recent Google Docs link is available in a later post.]
To review, I wanted a simple flexible method exercise diary that can:
[Update: A more recent Google Docs link is available in a later post.]
To review, I wanted a simple flexible method exercise diary that can:
- Track my exercises and related information in sequence as they were performed
- Provide user definable entry types for different kinds of information
- Allow later analysis
- Be online, easy-to-use and free
Be aware that you have to be a bit geeky to use it. The purple column on "The Diary" is an index into the "Entry Type" sheet. Green cells are for user data, blue cells contain formulas. You create a new entry by copying an existing row with its formulas into a new row, then enter data into the green cells.
A simple "one sheet" approach would have propagated columns endlessly so instead I emulated a key indexed database so that each column represents a different type of information depending on the "Entry Type" index. This approach allows the user to add, delete or change the types of information in the columns for that type by editing the "Entry Types" sheet. There is a help sheet and if you're not familiar with the technique you may find many other uses for it.
Here's an image of a sample "Entry Types" sheet.
[Update: I removed the comment about not being able to distribute this directly from Google Docs.]
Finally, I appreciate comments.
