Today, we are making available the source files that Ray and I used to create the 2012 diary sets. Equipped with these, you can tinker around and design exactly the diary page you want, then get your PC to calculate and print it for any date range you 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:
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 (I know that some of you already have, using the source files Ray provided in November for the Day on Two Pages and Day on A Page layouts.) 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.)
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 layout. 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 each 2-page spread has gutters in the middle for the holes.
Now, if you just read all that and understood at least some of it, get downloading and have a go.
You can download finished versions for this year from our diary inserts page.
Here are the source files.
Enhanced TM Week Per View
Download Word file and Excel file Version 1.0
Enhanced TM Week Per View Version 2
Download Word file and Excel file Version 2.0
Week Per Page
Download Word file or Excel file
Week Per View Journal
Download Word file and Excel file Version
Download Word file and Excel file Version
Vertical Week Per View
Download Word file and Excel file
Two Days Per Page unlined or lined
Download Word file (unlined), Word file (lined) and Excel file (same one works for both versions).
Have fun, and please share in the comments any interesting modifications you make. Post some pictures to the Philofaxy Flickr group.
Steve, you and Ray are ALL kinds of awesome. Thanks to Ray providing his templates and source files, I was able to fiddle and get a 2PPD A5 spread that will work perfectly for my WORK needs. Thanks so much again, both of you!
ReplyDeleteWell, inspired by all this, I spent some time today producing a very basic WO2P diary in pocket-size!
ReplyDeleteYour products are a) fabulous; b) inspiring!!
Do you think filofax has even noticed all this? I saw your comment that City organiser had.
wow!! i´m really impressed by all this work you guys are doing here.
ReplyDeletealso it makes me smile, because i imagine you and ray as(don´t get me wrong!!!!) little schoolboys invented a new game. there is so much enthusiasm, joy and love in all of the new template concerning posts!! i really can´t ignore those feelings in them. and that´s really really impressing.
thank you for all your work! i definately will have a closer look on the A5s ;)
Thank You from a long time reader of Philofaxy. I love that Steve and Ray have combined forces to provide these templates and made the source files available too.
ReplyDeleteOutstanding work by Ray and Steve - big thanks to you both!
ReplyDeleteOh, the enablement!
I noticed & adore all the sharing :-D
ReplyDeleteI am going to attempt to make a 2013 diary (2 days per page lined). As I don't work Sat & Sun I want the third page to have Fri at top and the bottom to be divided for Sat & Sun and I can write any notes there too This would cut down on number of pages. I am a total beginner so any help would be welcomed. We have a big fancy MFD printer in work which copies and scans so I need to know how to set it so diary prints on both sides.
ReplyDeleteI have downloaded A5 lined 2013 diary (2 days per page). How do I print it onto A4 paper to fit into A5 Filofax. I have purchased Filofax puncher. Any help would be appreciated. My email address is pamelaclarke24@hotmail.co.uk
DeleteHi, you will find the answer here http://philofaxy.blogspot.com/2010/08/printing-a5-pages.html
DeleteHi, I am struggling to print the A5 week view lined onto A5 or A4 in booklet form - what am I doing wrong?
ReplyDeleteI don't know what you are doing wrong Sam.... What is being printed out? Have you looked at the printing A5 in booklet mode post here:
Deletehttp://philofaxy.blogspot.com/2012/10/printing-your-own-diary-inserts-hints.html
This has other hints and tips on printing... if this doesn't help. Do contact us by email, possibly sending a photo of what is being printed out and then we might have a better guess at what the problem is... without seeing it I can't even hazard a guess at why you are struggling... no good me saying.. it works for me!
Steve
Hi, Great work, HUGE THANKS to YOU...
ReplyDeleteI have a question: Is it possible to add day number?!
if yes could you please help me with that, I need just 1 formula
Try this
Deletehttps://www.google.co.uk/search?hl=en&btnG=Google+Search&meta=&q=day%20number%20excel
Hello, great work, very impressed.. Thank you!
ReplyDeleteI have one question: Is it possible to add day number, week number? (like: 65-300, 8-week)
If yes can you help me with that? or how to write a formula?
Depending where you are in the World Week numbers aren't always the same... Once again the US seem to follow a different rule to the ISO standard. There is a week number function in Excel, check the Excel Help file, but it does follow the US rules on week numbers not the ISO standard.
DeleteThanks for your answer!
DeleteGot another issue, I guess, I wrote 12/28/2016 to the highlighted area, but february remains 28, (should end at 29) am I doing something wrong?
Thanks in advance.
Sorry for my English, (if I wrote something wrong) not a native speaker...
Google helped me to find, here is the formula for day number (in whole year) :
Delete=DATEDIF(DATE(YEAR(A2),1,1),A2,"d")+1
and here is opposite:
=1+(DATE(YEAR(A2),12,31)-A2)
Week numbers:
=WEEKNUM(A2)
P.S. If anybody needs it of course..
Best regards.
Hi there,
ReplyDeleteThank you all for the hard work put on preparing all these templates and kindly making them all available to everybody.
Now, quick question:
I downloaded the source files for the Enhanced TM Week Per View (v1.0) template. I did some changes, so the new template would fit my needs. But I can't save the source file with the modifications... :(
If I save it, it becomes a regular .doc file with only those 2 pages, and the mailing options do not work anymore to create the rest of the planner. I am missing something?
Appreciate any help!
- Marcia de Jesus
What are you editing the file with ? Which version of MS Office are you using?
DeleteSteve
Word 2007 - Windows. Thanks!
ReplyDeleteThat should work ok. The source file is only two pages. It's when you merge it it will become the full year.
DeleteSteve
Yeah, tried again with v1, but I really can't save the modifications and still be able to use it again to create other calendars. If I do, as I said, when I open the file again, it's not possible to merge so I get the rest of the calendar.
ReplyDeleteI just wanted to make sure I don't lose all the work and have to re-do it all next year.
:(
Alright, used v2 and it works! Great! Thanks again.
ReplyDeleteHi Steve, first of all thank you very much for the work that you put into these diary-files.
ReplyDeleteI'm having trouble changing data in the Excel files.
As soon as I open them in a german Office 2010, word is unable to use the =text() function, and gives out an error on every and all dates.
If I use your precompiled Excel file for the word source document everything compiles fine. However I'd like to have a german planner :)
Help would be greatly appreciated.
Do I need to format the cells in any special way?
Here's what it looks like initially, with Excel asking whether I'd like to work in that document:
http://s14.directupload.net/images/130402/4chckaov.jpg
I click yes:
http://s7.directupload.net/images/130402/orr6gu9o.jpg
and everything goes out of format.
We have seen this before from someone else, the fix is within Excel it self, I will try and find the email someone sent in and let you know the details.
DeleteHe found the answer looking around on line.
Steve
Try this:
Deletehttp://www.excelforum.com/excel-general/532898-english-date-format-and-compatibilty-with-others-excel-language.html
Replace "Mmmm" by "MMMM", "Yyyy" by "JJJJ" and "Dddd" by "TTTT"
WOOW! I just LOVE this. Thank you so much. But I cant seem to get the week nr to work. :(
ReplyDeleteNow I know whats wrong. If I open the sourcefile with my Excel 2010 and save it, the file gets screwed up. The month will appear as numbers instead of names.
DeleteI don't think any of these files have the week number included in them because of the issue with the USA and Excel using a different standard for week numbering compared to the ISO standard!
DeleteNo, i can't open and save it at all. It gets destroyed.
DeleteDo you perhaps have the 2013 source file? I can´t find it. Only the 2014. I would be so grateful.
ReplyDeleteThe source files aren't done for specific years. You change the year in the Excel file and then save it and reopen the word file and it will follow the new year start
Deleteaahh! Okey! Thank you! <3
DeleteTo bad I cant open the excel file without it gets damaged.
DeleteNot sure why the file is getting damaged like that. Email me both source files you have downloaded, I will change the excel file back to 2013 for you and email it back to you.
DeleteOh! Thank you <3 So nice. I read a little further up the history that someone else also had a problem with the file.. Changing "Mmmm" to "MMMM" helped me to get the Month right. But YYYY to JJJJ did not help and Dddd to TTTT is totally wrong. I get a number instead of weekday. So as it is now, this is what is shown in the following columns:
ReplyDelete1st of month: #VALUE
M1 to Su4: ###
NexMonth: Just a number between 100 to 1200
I will email you
ReplyDeleteHi there, so excited to be able to make a planner the way I would use it, but......
ReplyDeleteI downloaded the source files for the Enhanced TM Week Per View (v1.0) template and not merged it comes through as 4 (total) pages mumbly jumbly only showing one at a time, not side by side and then once merged it shows them only one at a time (not side by side) with a total of 108 pages. I've watched both tutorials and nothing seems to get them right. What am I doing wrong?Am I missing something?
After you have done the merge have you removed the section breaks? Are you viewing it preview mode.
DeleteAlso why are you using the version 1 file not the latest version?
I'm getting an error in my excelfile in the sections "1 of month" and the colums after that. I have a dutch version and it says #waarde (don't know the term in English). Any idea how I can solve it because it happens when I have to enable the editing.
ReplyDeleteThis might help: http://www.piuha.fi/excel-function-name-translation/index.php?page=nederlands-english.html
DeleteBut it sounds like you have made an error editing the Excel file. What are you trying to do?
Steve
Hi Steve, I wanted to change the date so I could use them from tomorrow. I found the problem, when I wanted to editing, my dutch version didn't recognise "YYYY" and I change it to "JJJJ" and it works! Thanks for your reply and your lovely inserts!
DeleteI just ordered the Malden A5 Filofax and want to print my own inserts. In my Personal sized Filofax I used the week on 2 pages for which I downloaded the source files and adapted it to my own needs / style. It is the week on 2 pages in CC-inspired layout.
ReplyDeleteI wish to use this style for my A5 and adapt it to my style / needs as well, but unfortunately here at Philofaxy I cannot seem to find week on 2 pages in CC-inspired layout and the source files which belong to these inserts. Ray of mylifeallinoneplace offers the Word and PDF_ files for the week on 2 pages in CC-inspired layout, but unfortunately he does not offer the source files. Is there any chance you can add week on 2 pages in CC-inspired layout and upload the source files (Word and Excel) for the A5- sized Filofax?
Ray's files and ours are exactly the same... common source. But have you looked at the Diary inserts page, but scroll down to the 2014 part of the page, the bit at the top is 2015 and not complete as yet, it's 'Work in Progress'
DeleteThanks very much for your time and patience to do these files. I found you last year and things worked like a charm for my DIY planner. This year I seem to be having a problem with the source files for DateSourceFiloMonthlyNew. When I enter my new date for 2015 calendar it gives me the correct date upon till the fourth week when I get this error =IF(ISERROR(DATEVALUE(AF2+1 & "/" & MONTH($D2) & "/" & YEAR($D2))),"∙",AF2+1). I then have to manually enter the dates after merging the document.
ReplyDeleteIs anybody else having this problem?
Try downloading a fresh copy of the source files.
ReplyDeleteSteve
I have A5 paper I'm trying to print the unlined Week Per View Journal on. When I change the paper size to A5, the page layouts get messed up and it's as if it zooms in. I've tried everything I can think of. It tells me it has something to do with margins, and I've tried fixing those. It feels like I have changed the paper size in every place possible. I know you recommend simply using A4 paper, but I'm trying to do my best with what I have.
ReplyDeleteHi Lisa,
DeleteIf you are printing on A5 paper, go in to Page Set Up and set it to A5 paper and Scale it to 70% it should then be ok.
Steve
I'm trying to print the unlined Week Per View Journal on A5 paper. I've changed the paper size in every place I can think of, and when I do so on Word, it almost zooms in on the page and only shows 2 days, instead of 4. I know you recommend printing on A4 in a booklet style, but I'm trying to make the best out of what I already have. When I try to print, it tells me the margins don't fit, which are set to mirrored. Any ideas? Thanks
ReplyDeleteScale the page to 70%
DeleteThe margins issue is a printer dependent issue, click on Fix and see what it changes them to, generally it will be the bottom margin that gets altered.
I'm sorry I didn't realize my first post went through.
DeleteThe only place I can find scaling to a percentage is in the printing preferences. I changed that to 70, and printed. It made it fit better on the paper, but not the layout. On Word, it's still zoomed in, so that's how it prints. On Word, I couldn't find a scale to percentage, only scaling to a certain size paper (legal, letter, A4) and A5 wasn't listed.
It will depend on which version of Word you are using. But try under File, Page Set up.
DeleteFunny how Filofax does not make cedilla for my agenda anymore.. they sent me to you! Lol
ReplyDeleteSo, I would love the dated calendar two days on one page for 2018 and 19
My agenda is OPEN: 8 1/4 x 5 1/2 Inches it has 6 consecuative loops in a row 1/2 inch in size
I wish I could send you a pic ....
Can someone help im in need of my refills and I love my agenda I hate to have to move on and retire it .
Kat1lady@aol.com
Hi There
DeleteYes I think we have what you are looking for for 2018 and 2019. Starting here:
https://philofaxy.blogspot.com/p/diary-inserts.html
And you will find inserts to download for 2019 here:
https://philofaxy.blogspot.com/p/diary-inserts-past-and-future-years.html
If you will, I don't know what happened here but, after merge I get this... https://1drv.ms/u/s!AqCpD50muRNwjdh5YOmAV2SeLjzNrg, please advise. Win 10, Office - latest version office 365.
ReplyDeleteGo to Mailing in Word, Click on Preview it will change.
Delete