25 February 2012

Download source files for the new Personal-size diary layouts

As we did with the new A5 layouts, Steve and I are making available source files for our Personal-size ones, too.

We're releasing them so that those of you who want to can tinker and tweak to get the unique layout that is perfect for you. These are the source files Steve and I built to produce the 2012 sets. The same ones will also produce sets for any year you care to choose. In each of the data source files, you just need to change one date - the starting date - and the file will calculate all the other dates for you. I've highlighted the cell with the date you need to change in each of the files like this:

Look for the red-outlined cell - that's the only date you should change

If you want fewer dates, delete full rows at the bottom end. If you want more, drag the formulae down into more rows. If you mess up, you can always download the file again and start over.

As long as you have some basic Word and Excel skills, you should be able to give this a go. You'll need to be able to set up a basic mail merge file link, and there are plenty of web tutorials that show you the way - Google using the search terms: Word Excel Mail Merge 20xx (where 'xx' is 02, 03, 07 or 10, depending on your version.)

You can download and print finished versions for this year from our diary inserts page.

Here are the source files.

1. Personal TM Week Per View

Download Word file and Excel file

2. Two Days Per Page unlined, lined or lined with icons

Download Word file (unlined), Word file (lined), Word file (lined with icons) and Excel file (same one works for all three versions).

Have fun, and please share in the comments any interesting modifications you make.

Next on our list are Month Per Page and Month Per View layouts, both for A5 and Personal sizes. And, by popular request, we'll be releasing some Pocket-size layouts soon, too.


  1. I'd like to add the whole month calendar in the bottom of task tamplet in Personal TM Week Per View. Is that possible to combain two source files for that?

    1. Not easy to do, it's best to do it on the merged files and copy and paste in the section you want each time.

  2. Is there any way I can remove the lines from the pocket Do1p please?

    1. Sure grab the source files and edit it as you wish... or a big bottle of white out !

    2. May have to be the tippex then! I have been trying to delete the lines but it just keeps deleting dates. x

  3. Thanks so much for these. I am trying to print Personal 2017 Day on 2 pages from the source files but seem to be running into a problem: The merged document is overlaying 2 sets of pages per page and I can't work out why. Any ideas?