Summarize

MindManager Year Planner for 2009 created with Excel

I normally post something to help MindManager Users plan for the new year. I struggled to find something and then I thought about getting the whole year on a map!

It was a challenge but on the way I discovered a useful way of cutting and pasting from Excel. If you structure your spreadsheet like this you can create the dates quickly in Excel and then paste to MindManager.

The first column becomes the main topic. Offset the content of the next column by one row and it becomes a subtopic. The third column creates seven sub-subtopics.

The good thing about Excel is you can quickly create these groups by starting a series e.g. 1, 2 and then dragging it down to fill to 7.

The third column was formed by combining columns 4 and 5.

I then pasted the first three columns on to the map. Hey presto the year appeared.

The organigram format created a compact map to the second level. Increase the level of detail to see the days in a week, month or year.

Download the MindManager map and the Excel 2007 spreadsheet.

It would be interesting to hear if anyone finds these of use.

About Andrew Wilcox

Andrew is an experienced user of MindManager who shares his knowledge and advice for free here. And provides commercial training and consulting on how to exploit MindManager and other mind mapping software applications in business, organisations and for individuals at Cabre For more information about Andrew please visit his Google + profile.

Tags: ,

Leave a Reply