Creating an Annual Time Block

Stephen Covey tells the story in First Things First of attending a seminar, in which the instructor pulled out a wide-mouth gallon jar. He sat it on the table next to some fist-sized rocks.

A Jar of Rocks“How many of these rocks do you think we can get in the jar?” he asked.

The students made various guesses. The instructor then proceeded to fill the jar with the rocks. It looked like it was full. He asked the class, “Is this jar full?” Everyone looked at the jar and agreed that it was indeed full.

He then reached under the table and pulled out a bucket of gravel. He then dumped the gravel into the jar. The gravel went in between all the little places left by the big rocks.

Then he grinned and once more asked, “Is the jar full?” By this time, the class was on to him. “Probably not,” several of the students said.

“Good!” he replied. He reached under the table and brought out a bucket of sand. He poured it into the jar. It went into all the spaces left by the big rocks and the gravel. Again, he asked the class, “Is this jar full?”

“No,” the class shouted.

He said, “Good!” He then grabbed a pitcher of water and poured almost a quart of water into the jar. Then he said, “What’s the point?”

Someone said, “If you really work at it, you can always squeeze more stuff into your life.”

“No,” the instructor responded. “That’s not the point. The point is this: if you hadn’t put these big rocks in first, would you ever have gotten any of them in?”

I would make an additional point. The big rocks are a metaphor for the important stuff. If you don’t make room for the important stuff, it will be overwhelmed by the less important stuff.

With this in mind, I decided last week that I wanted to plan out the next three years. I am not talking about all the little details. My life is too dynamic for that to work. But I wanted to make sure that I scheduled the most important things, so that I wasn’t overwhelmed by the urgent.

I decided I would “put the big rocks” into my calendar for the next three years. Unfortunately, I didn’t have a good tool to do this with.

What I really wanted to see was the whole year at a glance. Unfortunately, Entourage for Mac doesn’t offer this kind of view. The most you can see is a one-month view. The same is true of Outlook for Windows.

So, I created an Annual Time Block Tool in Excel. I have included my own calendar as an example with a blank sheet, which you can copy. You can enter the year you want to schedule in cell A5, and the calendar will automatically recalculate. It even takes into account leap years.

I began by scheduling the most non-discretionary things and moving to the most discretionary things. So I scheduled in this order:

  1. Company Holidays
  2. Church Holidays
  3. Industry Events
  4. Vacations
  5. Board Meetings
  6. Business Review Meetings
  7. Special Trips
  8. Time with Friends

Your list may differ. The issue is to grab the dates while you can before someone else does. Frankly, I would rather have other people plan around my priorities than be forced to plan around theirs. Remember: if you don’t have a plan for your life, someone else does.

The key is balance. Make sure you schedule time for the things that are important to you. If you don’t, you will find yourself scrambling to find time for the things that are important. If you are not careful, you will wake up one day and discover that you have spent your life living for other people’s priorities.

Disclosure of Material Connection: Some of the links in the post above are “affiliate links.” This means if you click on the link and purchase the item, I will receive an affiliate commission. Regardless, I only recommend products or services I use personally and believe will add value to my readers. I am disclosing this in accordance with the Federal Trade Commission’s 16 CFR, Part 255: “Guides Concerning the Use of Endorsements and Testimonials in Advertising.”

This space is currently available, but it won’t last long! Click here to find out how you can advertise in this space.

Print This Post Print This Post

Posted on 19 January 2009

Your Comments

100 Comments so far

  1. Susan Martin says:

    Hi Michael,

    Love the big rock image – I’ve often recommended this type of activity to clients who are overwhelemed by all the things they have to do, and tend to overlook their most important priorities; but never created a tool to help them actualize that -thanks!

    I agree with Maurilio, you have to figure out what your big rocks are first. Looking at your own values is a great place to start sorting that out.

    Thanks again for a great read, useful tool and tapping into a subject that’s so vitally important.

  2. Susan Martin says:

    Hi Michael,

    Love the big rock image – I’ve often recommended this type of activity to clients who are overwhelemed by all the things they have to do, and tend to overlook their most important priorities; but never created a tool to help them actualize that -thanks!

    I agree with Maurilio, you have to figure out what your big rocks are first. Looking at your own values is a great place to start sorting that out.

    Thanks again for a great read, useful tool and tapping into a subject that’s so vitally important.

  3. Mike Zimmer says:

    Dear Michael,

    Thank you for the formatted spreadsheet. As a strong adherent of Dr. Charles Hobbs and his Time Power system, I do all my daily, weekly and monthly planning in my Day Timer paper planner. That being said, I never really do any yearly blocking out of time. However, many of my intermediate term goals (the next 2-3) should have blocks of time alloted to them, to ease up potential scheduling overload in the future. I can see how this technique could really empower me to better reach my goals.

    Now I consider myself quite a computer savvy guy. However, I must admit that I never thought about just formatting an excel file to do the job! I plan on transferring my intermediate & long term goals (both with my business and my family/personal life) onto your template this PM, and tonight begin working on 2010 & 2011 with my wife.

    Thanks again!

    Sincerely,

    Mike

  4. Mike Zimmer says:

    Dear Michael,

    Thank you for the formatted spreadsheet. As a strong adherent of Dr. Charles Hobbs and his Time Power system, I do all my daily, weekly and monthly planning in my Day Timer paper planner. That being said, I never really do any yearly blocking out of time. However, many of my intermediate term goals (the next 2-3) should have blocks of time alloted to them, to ease up potential scheduling overload in the future. I can see how this technique could really empower me to better reach my goals.

    Now I consider myself quite a computer savvy guy. However, I must admit that I never thought about just formatting an excel file to do the job! I plan on transferring my intermediate & long term goals (both with my business and my family/personal life) onto your template this PM, and tonight begin working on 2010 & 2011 with my wife.

    Thanks again!

    Sincerely,

    Mike

  5. Thank you very much for the information. Very useful!

  6. Thank you very much for the information. Very useful!

  7. Ron says:

    Hi Mike,
    As always, brilliant and amazing wisdom. Thanks for sharing your valuable life tools with the world. I was a bit surprised to see only one weekend a month dedicated to family or friends. Do you have a standing weekly date or time with your wife?
    I’d love to know how you keep your marriage strong while accomplishing everything else you manage! Thanks for sharing as always.
    Ron

  8. Ron says:

    Hi Mike,
    As always, brilliant and amazing wisdom. Thanks for sharing your valuable life tools with the world. I was a bit surprised to see only one weekend a month dedicated to family or friends. Do you have a standing weekly date or time with your wife?
    I’d love to know how you keep your marriage strong while accomplishing everything else you manage! Thanks for sharing as always.
    Ron

  9. @Ron,

    My one weekend a month dedicated to friends is actually a dinner party at our home. It requires prior planning and is very intentional. However, we get together with friends every weekend and sometimes during the week on an impromptu basis. We have a very rich social life.

    The same is true of my marriage. I have certain things like vacation that must be planned out and coordinated. But, as nearly empty nesters, Gail and I eat dinner together almost every night. Friday is our standard “date night,” but this can fluctuate based on our circumstances. For example, she is going to be out of town this Friday night, so we went out for dinner last night.

    I hope that helps.

    Thanks,

    Mike

  10. @Ron,

    My one weekend a month dedicated to friends is actually a dinner party at our home. It requires prior planning and is very intentional. However, we get together with friends every weekend and sometimes during the week on an impromptu basis. We have a very rich social life.

    The same is true of my marriage. I have certain things like vacation that must be planned out and coordinated. But, as nearly empty nesters, Gail and I eat dinner together almost every night. Friday is our standard “date night,” but this can fluctuate based on our circumstances. For example, she is going to be out of town this Friday night, so we went out for dinner last night.

    I hope that helps.

    Thanks,

    Mike

  11. Karin says:

    Thank you so much for this excellent gift! I’ve used the story of the jar as an object lesson! Very effective and I enjoy it every time. The commenter who wanted a blank copy needs to look again and see your blank template! I nearly missed it too!

  12. Karin says:

    Thank you so much for this excellent gift! I’ve used the story of the jar as an object lesson! Very effective and I enjoy it every time. The commenter who wanted a blank copy needs to look again and see your blank template! I nearly missed it too!

  13. TenTen says:

    Excellent!
    Thanks so much for the calendar too – I’m sending thisl link out to my friends right now!

  14. TenTen says:

    Excellent!
    Thanks so much for the calendar too – I’m sending thisl link out to my friends right now!

  15. My Father took great pride all his life in creating tools and widgets to do a specific job, or to manage various aspects of his life. Not only am I using this for myself, but I am sharing this with him. I thinks it’s great, and I know he he will agree! Thanks!

  16. My Father took great pride all his life in creating tools and widgets to do a specific job, or to manage various aspects of his life. Not only am I using this for myself, but I am sharing this with him. I thinks it’s great, and I know he he will agree! Thanks!

  17. GREAT tool! I *love* Excel. …maybe *too* much.

    Teensy bug though. I fiddled with a couple leap years in A5 and it kept moving the last day of any month after January to the *next* month. (I’m using Excel 2003 in WinXP [SP2] on a MacBook Pro, if it matters.) I wish I knew Excel well enough to fix it myself.

    You are clearly a master of the art, sir. Thank you for sharing your wealth of knowledge AND practical tools for applying it.

  18. GREAT tool! I *love* Excel. …maybe *too* much.

    Teensy bug though. I fiddled with a couple leap years in A5 and it kept moving the last day of any month after January to the *next* month. (I’m using Excel 2003 in WinXP [SP2] on a MacBook Pro, if it matters.) I wish I knew Excel well enough to fix it myself.

    You are clearly a master of the art, sir. Thank you for sharing your wealth of knowledge AND practical tools for applying it.

  19. Venice says:

    Thanks for the advice Mike.
    Unfortunately I am unable to open the xcel sheet.
    Any advice??

  20. Venice says:

    Thanks for the advice Mike.
    Unfortunately I am unable to open the xcel sheet.
    Any advice??

  21. Mark Kordic says:

    I appreciate the article. Can you give directions on how to access the excel tool?

  22. Mark Kordic says:

    I appreciate the article. Can you give directions on how to access the excel tool?

  23. Kent says:

    When I click on the link to your "Annual Time Block Tool", I get this message: "Oops! This link appears broken." I'd love to have access to your excel spreadsheet.

  24. Kent says:

    When I click on the link to your "Annual Time Block Tool", I get this message: "Oops! This link appears broken." I'd love to have access to your excel spreadsheet.

  25. Whakate says:

    Great post and calendar. Having a long term plan and outlook it essential for making best use of your time.

  26. Whakate says:

    Great post and calendar. Having a long term plan and outlook it essential for making best use of your time.

  27. Scott Meyer says:

    Michael,
    Thanks for sharing this insight and this tool that you created. We (the ministry staff) took the spreadsheet and have now been planning more than 1 year out. Know that your tool is having an impact on one ministry team and a church in Texas.

    Grace & Peace
    Scott

  28. Scott Meyer says:

    Michael,
    Thanks for sharing this insight and this tool that you created. We (the ministry staff) took the spreadsheet and have now been planning more than 1 year out. Know that your tool is having an impact on one ministry team and a church in Texas.

    Grace & Peace
    Scott

  29. Brian York says:

    wow…thanks for this. You just saved my sanity!!!

    "if you don’t have a plan for your life, someone else does." – how true is this!!

  30. Brian York says:

    wow…thanks for this. You just saved my sanity!!!

    "if you don’t have a plan for your life, someone else does." – how true is this!!

  31. @johnataylor says:

    Mike,

    Thanks for sharing. This came just in time. I'm working through the same process right now, and was just considering creating something in Excel for the same reasons you described.

    You've saved me some much-needed time.

  32. @johnataylor says:

    Mike,

    Thanks for sharing. This came just in time. I'm working through the same process right now, and was just considering creating something in Excel for the same reasons you described.

    You've saved me some much-needed time.

  33. Mike says:

    Totally just watched Bill Hybels teach and use this illustration (stones and sand) at willowcreek.org in his message "The Forgotten Way" Hmmm.. maybe the Lord is trying to teach me something.

  34. Mike says:

    Totally just watched Bill Hybels teach and use this illustration (stones and sand) at willowcreek.org in his message "The Forgotten Way" Hmmm.. maybe the Lord is trying to teach me something.

  35. Mike says:

    Great tool. I made three modifications to this that others may find useful. First, I aligned the days of the week horizontally (so that all of the Mondays in a quarter show up in the same line). I realize that the dates at the beginning of the month or end of the month end up being in the wrong column (e.g., August 31 may actually show up in the September column), but being able to see the days of the week aligned far outweighs that.

    Secondly, I formatted the cells to "wrap text". Just a simple way to give myself more room on a line if I need it (without having to add in another row).

    Finally, because of the wrap text feature, I decided to put each quarter on a seperate Excel tab. That way, if I have a row whose height is 4 lines tall (for example), it only affects that row in that quarter and not all the rows in other quarters. This might not make sense unless you you are more than a novice at Excel.

    Overall, great help. Thanks for sharing.

  36. Mike says:

    Great tool. I made three modifications to this that others may find useful. First, I aligned the days of the week horizontally (so that all of the Mondays in a quarter show up in the same line). I realize that the dates at the beginning of the month or end of the month end up being in the wrong column (e.g., August 31 may actually show up in the September column), but being able to see the days of the week aligned far outweighs that.

    Secondly, I formatted the cells to "wrap text". Just a simple way to give myself more room on a line if I need it (without having to add in another row).

    Finally, because of the wrap text feature, I decided to put each quarter on a seperate Excel tab. That way, if I have a row whose height is 4 lines tall (for example), it only affects that row in that quarter and not all the rows in other quarters. This might not make sense unless you you are more than a novice at Excel.

    Overall, great help. Thanks for sharing.

  37. Jeremy McGarity says:

    Great post-How long did it take to get this mapped out? a day? or two?
    thanks for the help.

  38. Jeremy McGarity says:

    Great post-How long did it take to get this mapped out? a day? or two?
    thanks for the help.

  39. Daniel Tardy says:

    I use this all the time now and I LOVE it! Great tool! Especially if you travel a lot.
    My recent post No one cares about your snow.

  40. Daniel Tardy says:

    I use this all the time now and I LOVE it! Great tool! Especially if you travel a lot.
    My recent post No one cares about your snow.

  41. Great perspective! My version for the less tech savvy or those using paper day planners… Flag that page usually found in the back for future year plan and put your "big rocks" there. ____This has been so helpful to me and this year marks the first I've attended a couple of annual events that I always really wanted to go to and somehow they always just slipped by due to lack of planning and/or overcommitting. Whenever I missed such an event last year or did something that I definitely wanted to repeat again, I posted it into the future year calendar immediately and it is working!! Thanks Michael!

  42. Mark Andrews says:

    Thanks again for another great post. I will be printing this out and using it for our young church and my family. People already thought we were cutting edge for planning preaching out a year in advance, this will be quite interesting. After 15 years of marriage my wife and I are adopting two brothers from the Phillipines, and this will be an interesting tool to use.
    In case anyone is wondering, I’ll be planning for the family first, then the church. I know what my biggest rocks are.

    Again, thanks a ton!

    • Michael,

      Perhaps a bit of irony, but in my attempt to be efficient, I have tried using your spreadsheet, but am unable to successfully change the date in cell A5. Is there a simple solution to this?

  43. Michael,

    Perhaps a bit of irony, but in my attempt to be efficient, I have tried using your spreadsheet, but am unable to successfully change the date in cell A5. Is there a simple solution to this?


Share your view

Post a comment

I am the Chairman & Chief Executive Officer of Thomas Nelson Publishers. More...

Upcoming Speaking

How to Book Me …

Michael Hyatt Avatar

Michael Hyatt

Hi, my name is Michael Hyatt and I am the Chairman and CEO of Thomas Nelson Publishers, the world’s largest Christian publisher. In my free time, I enjoy my family, writing, speaking, running, and occasionally playing golf. Learn more about me »

Speaking

I speak on topics related to leadership, productivity, and social media. I have been speaking publicly for more than 25 years and have keynoted more than 100 events. I have also appeared on more than 1,500 television and radio shows, including all three major networks.

I would love to make a presentation to your group!

Have Me Speak or view my upcoming events

Top Blog Awards

  • PostRank Top Blogs 2009 - Leadership #1
  • PostRank Top Blogs 2009 - Publishing #3
  • PostRank Top Blogs 2009 - Productivity #7
  • PostRank Top Blogs 2009 - Leadership #20
Start tracking your own blog with PostRank

Write Winning Book Proposals

I have held many things in my hand and I have lost them all. But whatever I have placed in God’s hands, that I still possess.”

— Martin Luther

©2009 Michael Hyatt