Now that my schedule is a bit more flexible, I'm hoping I can be more regular about my running. To help me do this, and give me a chance to dabble with my new found spreadsheet skills, I've created a Google Spreadsheet based Running Journal.
Some features I got to practice with while creating the spreadsheet include:
- More fun with vlookup and countif - I'm becoming a pro at these
- Date math combined with countif. This allows me to count only my miles for the given week or month
- Embedding a URL in a cell, which provides 1 button access to it
- Making use of if(isblank(...),...,...) so I can pre-copy formulas ahead of time and not have them give errors
- The ability to publish the spreadsheet on an arbitrary web page
If nothing else, this spreadsheet can hopefully serve as a more real example of what you can do with Google Spreadsheets.
Here's what it looks like:
When I have more data in the spreadsheet, I think I'll try playing with graphs.
No comments:
Post a Comment