In November, I posted about my perfect A4/A5 diary layout. This was a 2 pages per day layout I had designed myself. I made available a PDF of a full 2012 set of pages and shared the source files too.
I have now built a 1 page per day version which you can download.
If you're not interested in the techie stuff and just want to get the pages now, you can download and print this PDF file. Print straight onto A4 paper, double sided. If you have an A5 Filofax, print on A4 in booklet mode and cut down the output into A5 sheets. If you want to play with the source files, read on.
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. See my earlier post for some technical insight into the content of this file.
You'll also need the Word 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. 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 might also need to adjust the top and bottom margins until print preview confines the layout properly to single pages for your printer.
Of course, you can play with the layout to produce what works best for you. This approach is particularly useful to those switching mid-year because your pages can start and end on any date you like.
I have now built a 1 page per day version which you can download.
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. See my earlier post for some technical insight into the content of this file.
You'll also need the Word 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. 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 might also need to adjust the top and bottom margins until print preview confines the layout properly to single pages for your printer.
Of course, you can play with the layout to produce what works best for you. This approach is particularly useful to those switching mid-year because your pages can start and end on any date you like.
30 comments:
I love this format!! Do you know how I could scale it down to personal size please???
I really am loving your blog! Excellent!
Would you be printing straight onto Filofax paper, or are you looking to print on A4 and cut each page out? Either is technically straightforward, I think, but they require different approaches.
Hi again,
I would be printing straight onto pre-cut paper (either filofax own brand or equivalent).
Thank you for all your help.
Amanda
All done. One or two compromises were necessary to fit it all in. I'll post it this morning.
Thank you so much for this, it looks really good. As a teacher I think it could be handy, but I'm wondering if it is possible to remove Saturday and Sunday from the print out. I've looked at the Excel spread sheet and I'm worried deleting these will make other random days disappear.
Any suggestions?
That should be fine so long as you delete the entire rows each time. If you get into difficulty, give me a shout and I'll help.
Just worked that out. I am amazed at how easy it was to adapt it!! I've been struggling for a few months on a filofax diary that doesn't really work for me. This is perfect!!! I will be doing this again next year for sure!!!
After only one working day I am in love!!!! Ive had 4 colleagues ask me how to do it! 3 want them making for their folders and another has gone out tonight to purchase her first ever Filofax to have one in!!!
Thank you sooo much. I would like to do a blog post on this. Would you mind??
Of course I wouldn't mind! I'm delighted it's working so well for you.
Hi I am very interested in adapting your template. I have been looking for a tax year diary, and as I am a childminder would like to divide the pages for the kids in my care. Can you just tell me if I need to download the excel file and the word file, then just adapt the word file then merge it with the excel file, please? Also, is it possible to have different page layouts on different days, please?
This will be a great help to me and I am off to buy an A4 filofax asap. Thanks.
Yes, that's all you need to do. Different layouts for different days aren't possible in one file, but if you want to make multiple versions and then put them together when printed that might work.
Thanks Ray. I thought I may try doing a month at a time so that I can add or remove things as I try it out and see what works best for me, and as you say I could do multiple templates. I'm a bit wary of editing the datafile because of the 2 mini calendars at the top of each page, I'm afraid I'll mess it all up. Would I only have to adjust the dates in the first column without changing the other columns?
Yes, the other columns take care of themselves.
Thanks Ray will have a go. Always got the original if I mess it all up!!!
Hi Ray, sorry to bother you again but tried deleting the first column except for all the wednesdays in September, and the merge created over 600 form letters, the first 4 being the correct dates and the rest all 0 January. Could it be because I am on word for mac? Thanks
Try deleting whole rows.
Hi Ray any tips on putting sat and sun on one page please? my method isn't working !!! Thanks.
What is your method? I can't think of any easy way to do this.
Hi Ray thanks for the reply. I replicated the column headed ORD and relabeled it ORD2 and did the same with the weekday column. Then on the base file I added these separately as fields. I then filter for 'weekday = saturday and weekday2 = sunday' but it says the data file fields are empty.
Nice idea, and it sounds like it ought to work, too. I'll have a look when I can if you email me your files. ray DOT blake AT gmail DOT com.
Thanks Ray, files sent.
Hi, I just came across this as I was looking for a day to page diary I can print myself. However, I can't seem to get this to work at all. I have tried changing the dates in the Excel file and tried without changing them but the word document always opens a single page dated 5th January (whatever year I put in the Excel file), so when I change nothing it is 5th January 2012. It asks for the data file and I've pointed it to the right place but this still happens. I have Word and Excel 2007 but I feel I'm missing a step that would make this work!
Yes, you're missing a step. Full instructions and videos here: http://mylifeallinoneplace.blogspot.co.uk/p/free-diary-pages.html
Thanks for that Ray, that works great :)
Hello, i'm new to filofax, i just got my first one and where would i get the filofax paper to download?
You don't need special paper for this, just ordinary A4.
Hi Ray,
do you have a 2020 base data file for the page per day a4 Filofax diary? I would be immensely grateful if you could let me know where to find it on your site.
many thanks Simon
@SPJ, I'm a little behind, I'm afraid. You can either adapt the source files to make one or got to Philofaxy where they will have a 2020 ready-made version.
Source files won't download from BOX nothing happens even though box says it is downloading.
Pls can I get a fole where Friday Saturday and Sunday r together
Post a Comment