Monday, 28 November 2011

Make your own diary - source files

Last week I wrote about making your own diary layout if you couldn't find one commercially available that you liked. I also made available a PDF file of my 2012 layout.

Today, I am making available the source files so the more geeky of you can have a play. You'll need this excel file which does all the hard work. You can adapt this to give you any date range you want; simply change the dates in the first column. Have a look at the formulae, which mostly extract elements from the date and are relatively simple. Over towards the right, though, where dates are calculated for the mini calendars, there are some more complex formulae. Importantly, these columns must stay formatted as text, even though the data are numerical in nature; otherwise Word can't cope with them properly.

Speaking of Word, you can also grab the layout template I merged the data into to make my layout. You can adapt this to produce pretty much any layout you could imagine, then merge into a document you can print and punch. A couple of words of warning, though (pun semi-intentional). Firstly, depending on what version of word you're using, Word may put section breaks between every record, which will throw out the mirrored gutter formatting in the format. If it does, the solution is quite simple; do a find and replace on section breaks (^b) to remove them all. You'll also need to add a single page break to the front of the merged document so that a 2-day spread has gutters in the middle. Of course, this isn't an issue on 1-page layouts. You might also need to adjust the top and bottom margins until print preview confines the layout properly to single pages for your printer.

That's it really. If you want to roll your sleeves up you can create the perfect layout that is unique to your own needs. And you need never pay for a diary insert again. Switching mid-year? No problem. Your pages can start and end on any date you like.
Post a Comment


Related Posts Plugin for WordPress, Blogger...