The Only Calendar You'll Ever Need

[latestart]

Hi all,

I, like many of you I'm sure, used the calendar that the Anderson Brothers made available last year (my first year on the program). I liked the concept, but felt that it could be a bit easier to work with. Many of my seasons end up being the same - they have the same workouts, the same rest between workouts, etc. - so I wanted something that would allow for easy duplication. I also wanted to have my planning and tracking consolidated into a single document. Finally, I wanted a document that could be used from season to season year to year. It doesn't make sense to start from scratch each year.

With these considerations in mind, I adapted a workbook based on a template I found online. There are two sheets, described below, and a link to the workbook with my first season of 2016 provided as an example.

12 Months:

This is the second sheet in the workbook, but it probably makes the most sense to start here. The worksheet displays each day of the year, along with up to four activities that you have scheduled for that day. The sheet has conditional formatting set up to color code a number of different activities I thought might be typical to RPTM trainees.

The calendar is set up to be completely dynamic. Enter a month (Full Name), year, and the day you'd like to have as the first day in the week. The entire calendar, and all of your planned activities, then shift accordingly.

Planning & Tracking:

Working from left to right, the datapoints should be mostly self-explanantory. The key columns are "Date", "Category", and "Description". In order for your entries to appear (in any meaningful way) on the 12 Months worksheet, each of these key columns will need to be populated.

Date - You'll have to populate this so the calendar sheet knows which data to display.

Category - The color coding is based on the information in this column. Each option has its own display color.

Description - A short description of the workout. Only so many characters will display on the calendar.

You can populate the rest of the table, or add columns to the right of "Complete?" to facilitate your tracking and number crunching. It seemed best to start with a simple template and let you all customize to your own needs. 

www.dropbox.com/s/nijj6k6udolsype/Example%20Climbing%20Calendar%20and%20Tracker.xlsx?dl=0 

Hope some of you find this useful! Happy training.

[MarkAnderson]

This looks really cool! I'm about to start planning my winter season, so I'll give this a try. The schedule we've been using is embarrassingly lo-fidelity, so this will surely be a huge upgrade.

[tradmike]

Hey was looking at the calorie tracker you have also.  Am i looking at this correctly and seeing that you are trying to achieve a 2000 calorie a day deficit.  with the goal of loosing 4 pounds a week.

Mike

[latestart]

Hey Mike, I don't have a calorie tracker - you must have me confused with someone else!

[tradmike]

Yep old file i had.  but i was thinking a 2000 calorie deficit sounds like way to much.

[tango]

For whatever it's worth, I posted these in another thread. They are also training calendars, in particular for 2016. I have left them without formatting, so that they can be edited at the preference of whoever uses them. I split the year up into two calendars, and left some overlap to cover any differences.

January - July: docs.google.com/spreadsheets/d/18jVIINu1N52wDfam1KCcxIAvtFgQczF4zF7JLw6SUww/edit#gid=531457651
June - December: docs.google.com/spreadsheets/d/1ANUJffMN4UC1eWCz9mRCp8OammA7EcRra0S4JiayJ1I/edit#gid=531457651

[latestart]

Edited for: Spelling

Thanks Tango for taking the initiative to put those calendars together. I did make some assumptions and chose some of the formatting for the user, but I'm open to feedback and revision of my calendar. My goal was to put together a file that could be used indefinitely so that you don't need a new file/calendar for each calendar year.

If you're interested in 2015, you simply enter the year as 2015. Interested in 2016? Enter the year as 2016. Have a wonky schedule so you like to see your calendars starting on Tuesday? Go for it, enter Tuesday as your start day. Ditto for month of year.

Obviously, this will work for some people and others will probably hate it. I'm just lazy and like to have everything in one place