Research hacks #20: Why it pays to plan your ideal week, and an Excel workbook to help you

In my last post I pointed out how time logging can help you build an accurate picture of how much time you are really spending on different tasks. That is only half the battle of taming your timetable however. The other half is working out how you want and ought to be spending your time, and that is where an ideal week planner comes in.

Before you laugh out loud at the very idea of an “ideal week”, remember Dwight D. Eisenhower’s wise words: “In preparing for battle I have always found that plans are useless, but planning is indispensable.” Sticking rigidly to pre-conceived weekly plans no matter what is the royal road to anti-social selfishness and perpetual frustration, to be sure. But there is also an equal and opposite danger: If you don’t have an idea of how you want to be spending your time, someone else (or more likely multiple other people, each with their own agenda) will spend it for you.

Another reason to have an ideal week plan is that, as I argued in a previous post, if things don’t get planned they tend not to get done.

To help my own planning I’ve developed an “ideal week” Excel workbook. I use it to sketch out how I want to be spending my time, bearing in mind that no real-life week will resemble the plan in anything like a photo-realist way.

To read all the research hacks posted to date, please click here.

Here’s how to use the workbook:

When you open it you are presented with an empty grid showing every hour of the week, and an empty table with eight categories and corresponding colours (sleep, work, family, exercise, travel, grooming, eating, and workflow). The week is broken down into half hour chunks.