22 January 2017

Sunday Start Diary Inserts

I infrequently get requested for diary inserts with the start of the week on a Sunday rather than Monday. We also get some really odd requests for 5 day week (no weekend) or Thursday start inserts etc.

So we do not offer a customised service for one off inserts, and if you look at the list of inserts we already provide a large number of different inserts already and we are not going to start offering them with Sunday start as well as Monday start.

Hopefully with the help of this post you will be able to adapt our source files to create your own Sunday start files should you wish to have that feature.

The change over is relatively easy to do. But you need to follow the steps to achieve the end result shown here:

So we will be using this example. Firstly you need to download the two source files (Word and Excel)  the Word base file and the Excel data file you will need both.

First step is to open the Excel file.

You will see something like this:

We need to change the first row to look like this:

Things to note:
  1. The column headings are the same, they have just been reordered to move Sunday to the start of the week. No other row is changed. 
  2. The date for the Sunday in Cell A2 is obviously changed compared to the original. 
So having made those small changes save the file to the same folder as you have the Word file in. 

The next step is to open the Word file you downloaded. It will look something like this:

If you go in to the Mail Merge Manager (the location of this will vary depending on which version of Word/Office you are using)

If you toggle the 'Preview Results' the page should change to something like this: 

The merge labels are fairly clear as to which ones they are. We need to shuffle things around a bit to get things to a Sunday start, to something like this: 

Now if you toggle the preview button again you will see things are in the correct order but Sunday and Wednesday will not look quite right, this is because they have moved from one side to the other. And if you look at the earlier images you will see that on the left hand page it is date then day, and on the right hand page it is day then date. 

But there is an easy fix. Toggle the Preview Results again until you can see the Merge Fields again. 

Right click on <<datesu>> and click 'Toggle Field Codes'  Then change it to 
{MERGEFIELD DateSu \@ "d DDDD"\*lower } 
Basically you are just repositioning the lower case d to move the date to the beginning. And do a similar change to <<datewe>> and move the d to the other side of the DDDD part of the field code. 

Then do 'Update Field Code' then click on Preview Results and everything should look as you need it to be. 

Also note that the header fields are changed to <<datesu>> inplace of <<datemo>> and on the other page to <<datewe>> instead of <<dateth>> This just ensures the correct month is shown in the header. 

Then do 'Update Field Code' then click on Preview Results and everything should look as you need it to be.

If everything looks as it should, it is now time to do the mail merge as usual to create your new file.

Insert the blank page at the start of the new file and remove the section breaks (^B) and you have your file ready for printing. 

If all of the above was a little bit too much for you here are a set of files to help you get started:

The source files Word and Excel.

And I've also done some 2017 files as well in Word and PDF ready to be downloaded and printed in the usual way.

Oh and then I broke all the rules, so here is not only Sunday start... but Letter size or Half Letter size when booklet printed!

I've not been able to 'test' this variant because here in the modern world we only have ISO size paper!

However, if you want to play with the Letter size variant you will need to use:

The source Letter files Word and Excel.

And I've also done some Letter 2017 files as well in Word and PDF ready to be downloaded and printed in the usual way.

Converting other files to Sunday start is similar.


21 January 2017

Web Finds - 21 January 2017

So I hope you have had a good week

So now it is time to enjoy a great collection of blog posts from around the internet, so grab a drink and make yourself for our weekly round-up.

Here are some Philofaxy posts you might have missed this week:
  1. Web Finds - 14 January 2017
  2. Experience User - Maria
  3. Guest Post - John Rocha A5 size Binder in Black - Anthony
  4. Free For All Tuesday No 311
  5. Web Finds - 17 January 2017
  6. Reader Question - Help identify this vintage organiser
  7. The Hitchhikers Guide to the Plannerverse - Episode 46
  8. Free For All Friday no. 427 by Anita
So here are the latest Filofax and other brand blog posts from around the Internet. Don't forget to leave a comment on the posts you enjoyed reading, all bloggers enjoy getting comments.
  1. Transition… - Queen of Yarnia, Stuff & Things
  2. Marie S’s Beautiful Van Der Spek binder in Old Pink and 297 - This Bug's Life
  3. Filofax Set Up #2 - Mademoiselle
  4. Bloomin’ Beauty - Filofax Blog
  5. Stunning leather ring organiser by Bob Park - This Bug's Life
  6. Inspirational Quotes - Life with my Planners
  7. Nuovo set up nella mia Filofax Malden Fuchsia - A little trip in Flavia's world
  8. 2017 Goals and Planner Set-Up - Well Planned Life
  9. Meine Filofax-Bilanz 2016 - Filomaniac
  10. Planner Personalization - Life with my Planners
  11. Le classeur maison au format A5 - Accro à l'Organisation
  12. GTD - Casinha de taipa
  13. My Everything Binder - Tales From A Polk County Girl
  14. Neuheiten 2017 (3): Fan Floral - Filomaniac
  15. Sticker and Post It aids to productivity in journal and ring organiser - This Bug's Life
  16. Filofax Pocket Saffiano Review - Karens Obsessions
  17. Love affair with Saffiano - a ska loving geek
  18. Come creare calendari datati personalizzati per agenda fronte/retro - My Last Eureka
  19. Knit 1 Purl 1 for your Filofax - Queen of Yarnia, Stuff & Things
  20. Keeping track of game information - My Filofax Blog
  • We monitor over 400 blogs and sites, your Filofax/Organiser blog posts could appear in this list, just contact philofaxy at gmail dot com to be added to our monitoring list. 
  • We can not guarantee people will read your posts, but we know there is a higher chance of people reading your posts and returning to read other posts if you make them interesting with pictures and good hints and tips. Do not forget to give your posts a title... 
  • Your Filofax/Organiser posts could appear in this list, just contact philofaxy at gmail dot com to be added to our monitoring list. 
  • For some general tips on Filofax Blogging, please see this post
We are on the look out for more people to take part in Reader Under the Spotlight. If you would like to appear in this feature then please contact Steve : philofaxy at gmail dot com  Thank you.

And have you tried reading one of my Flipboard magazines yet? It works great on a tablet or smart phone, but you can view them on a desktop machine as well. Be sure to Follow the ones you like and you will get notifications when I update them.

View my Flipboard Magazine. View my Flipboard Magazine. View my Flipboard Magazine. View my Flipboard Magazine.

View my Flipboard Magazine. View my Flipboard Magazine. View my Flipboard Magazine. View my Flipboard Magazine.


20 January 2017

Free For All Friday no. 427 by Anita

I was away last weekend for my work's annual conference and as per normal, my Filofax and a book were in my bag. It occurred to me that these two simple and everyday items offer so much between them:
  • As an avid reader, I can easily lose myself in a good book for many hours and can travel anywhere in the world in my imagination
  • If I pack a non-fiction one, I can study and make notes in my binder
  • I didn't pack my laptop this time, so I found that it helped me focus on doing some project planning without the temptation of the internet
  • I could easily jot down random thoughts as they popped into my head for processing later into my action lists. 
Whilst there are other binder accessories that I own that are useful, I've realised that when I go away the book and planner have become part of my essential items. Somehow it also feels like a little bit of home, no matter where I am.  

What essentials do you pack to go with your planner when you go away?

And always as it's Friday, please feel free to discuss anything ring bound organiser related. Have a great weekend! 

19 January 2017

The Hitchhikers Guide to the Plannerverse - Episode 46

Buying and Selling 101

Have you wondered what the basics of buying and selling planners are in the various social media platforms?

Although the gruesome twosome mainly focus on Facebook, this week's episode gives us all basic guidelines for being successful whether you are a buyer or a seller.

If you have ideas for future episodes please send them to steve at philofaxy dot com

Show Notes (timings approximate)
00:00 - Introductions
01:00 - Why buy and sell if you only own one...
04:00 - Facebook groups
06:15 - Philofaxy Adspot
09:00 - Read the rules of the group before posting.
10:00 - Preparing to sell, good photographs
12:00 - Make sure the description is correct
13:20 - Pricing and differences due to taxes
15:30 - State your location
16:26 - Packing and insuring your package (also here)
18:00 - Fair market price
19:45 - Put in an offer if you think the price is a little high
20:30 - Hazards of running Adspot....
21:45 - Do your research, know the market, know the prices
23:00 - Seasonal changes?
25:00 - Set your price after researching
27:00 - Filofax Catalogues
27:40 - Communications
29:30 - Be civil...

Episode 46 - Buying and Selling 101

A direct download is also available here: Episode46.mp3

Show notes: A5 docx pdf  Personal docx pdf

NB: A5 is in A4 format so it can be scaled to suit A5 or A6 size. Personal is for printing direct on Personal size paper.

Presenters - Karine Tovmassian and Steve Morton
Editing and production - Steve Morton

Our Websites:
Karine: Plannerology, Karine Tovmassian (IG)
Steve: Philofaxy, Travellers Notebook Times, Mr Philofaxy (IG)

Naturally we would love to hear your feedback on the podcast. If you use iTunes please gives us your rating or reviews of the podcast.

If you want a quick link to all the podcasts remember: http://philofaxy.com/podcast/

Previous Episodes:

45 - A5 or A6 - A5 docx pdf  Personal docx pdf
44 - End of Year - A5 docx pdf  Personal docx pdf
43 - Digital Planning vs Analogue Planning - A5 docx pdf  Personal docx pdf
42 - Planning vs Organising - A5 docx pdf  Personal docx pdf
41 - Short and Long Term Planning - A5 docx pdf  Personal docx pdf
40 - Good and Bad Planner Habits - A5 docx pdf  Personal docx pdf
39 - Tackling Planner Size Change - A5 docx pdf  Personal docx pdf
38 - Self-Improvement or Personal Development - A5 docx pdf  Personal docx pdf
37 - What is productivity anyway - A5 docx pdf  Personal docx pdf
36 - The Planner Community - A5 docx pdf  Personal docx pdf
35 - Wellness Planner - A5 docx pdf  Personal docx pdf
34 - Listeners Question - A5 docx pdf  Personal docx pdf
33 - Pens and other writing instruments - A5 docx pdf  Personal docx pdf
32 - Proper storage, care and shipping of planners, rings etc - A5 docx pdf Personal docx pdf
31 - Guest Interview - Louise Umeki - Plannercon 2017 - A5 docx pdf  Personal docx pdf
30 - Form Following Function -  A5 docx pdf  Personal docx pdf
29 - Seasonal To Do Lists - A5 docx pdf  Personal docx pdf
28 - Making and keeping annual goals - A5 docx pdf  Personal docx pdf
27 - Organising the family - A5 docx pdf  Personal docx pdf
26 - Guest interview - Theresa Hall - A5 docx pdf  Personal docx pdf
25 - Guest interview - Ray Blake - A5 docx pdf  Personal docx pdf
24 - Defining the important things from the urgent things - A5 docx pdf  Personal docx pdf
23 - Guest interview with Rita Sedani - A5 docx pdf  Personal docx pdf
22 - Printing your own inserts - A5 docx pdf  Personal docx pdf
21 - How to derail your planning system by over thinking - A5 docx pdf  Personal docx pdf
20 - Digital devices/services and your analogue planner - A5 docx pdf  Personal docx pdf
19 - What To Keep In Your 'Others' Tab - A5 docx pdf  Personal docx pdf
18 - Zombie Apocalypse Preparation - A5 docx pdf  Personal docx pdf
17 - Managing Finances In Your Planner - A5 docx pdf  Personal docx pdf
16 - Planning for those of us who actually can't live without planning, with guest co-host Carie Harling - A5 docx pdf  Personal docx pdf
15 - Automation NirvanaA5 docx pdf  Personal docx pdf
14 - Work Life Balance and Your Planner - A5 docx pdf  Personal docx pdf
13 - GTD Productivity And Using Your Paper Planner - A5 docx pdf  Personal docx pdf
12 - Job Seeking and Keeping - A5 docx pdf  Personal docx pdf
11 - Planner Fail -  A5 docx pdf  Personal docx pdf
10 - Planner Hacks - A5 docx pdf  Personal docx pdf
9 - Planner Planning - A5 docx pdf  Personal docx pdf
8 - Choosing Inserts - A5 docx pdf  Personal docx pdf
7 - How do you carry your planner - A5 docx pdf  Personal docx pdf
6 - Planners on the go - A5 docx pdf  Personal docx pdf
5 - Why would you pay more than the price of a Filofax? - A5 docx pdf  Personal docx pdf
4 - Using Your Planner To Create Permanent Habit Changes - A5 docx pdf  Personal docx pdf
3 - Getting on with two or more planners - A5 docx pdf Personal docx pdf
2 - Where to start your planning journey and why - A5 docx pdf  Personal docx pdf
1 - What size and why....  - A5 docx pdf  Personal docx pdf
Related Posts with Thumbnails