School holiday dates into Google Calender - csv import

Just thought I would share this, as I have uploaded the school holiday dates into my calendar for 2012/13 and 2013/14, should be fine for most schools in England (just double check yours) but is definitely correct for schools in Waltham Forest - dates taken from the WF website.  Note though that they do not have any dates from Spring Break 2014.

So first of all for those who don't want to continue reading find the csv files to upload for the school holiday dates, one for 2012/13 and one for 2013/14, click here
Import these files into your calendar and you will have the school holiday dates "just like that"

The other side to this is if you want to be able to import in bulk to your calendar using csv.  The following is true for most calendar but is reliable for Google calendar.  If you think I have made a mistake please point it out.
First of all you will need to open a new spreadsheet, you can use the two as above as a template instead of creating from scratch.

You will need the first row of your spreadsheet to have the following fields,
Subject, Start Date, Start Time, End Date, End time, All Day Event, Reminder On/Off, Reminder Date, Reminder Time, Meeting Organizer, Description, Location, Private

The first two fields are mandatory. Ensure that your Date columns are formatted as date (dd/mm/yyyy) and your Time column formatted as time (hh:mm:ss)
If you want to insert a date range then Subject, Start Date and End Date are mandatory and either Start Time and End Time or All Day Event = TRUE

Note if you use All Day Event then your end Date must be "your end date" + 1, otherwise your event will finish a day earlier than you want it to.
Thus for range 1/1/2013 - 20/1/2013, I would acutally enter 21/1/2013 as my End Date if I want the event to finish on the 20/1/2013 in my calendar. This is only an issue if you use All Day Event, otherwise just use Start Time 00:00 and End Time 23:59 and copy this down through all of your events.

Why we had a white wall

When our eldest was younger, much younger than today ;)   we went through a period, as many a parent will recognise, of the walls of the house being marked with a pen.  Child is in the other room, they are too quiet and you go to see what they are doing, to be greeted by markings on the wall. Always seems worse if you have just papered or painted the wall.

So we gave our boy a writing wall.  The wall in his bedroom by the bed was painted bright white and he was given the go ahead to write on it as much as he desired.  The flip side was that he was not allowed to write on any other wall in the house, ever.

It served its purpose brilliantly.  He took to his wall with gusto, pens/pencils/colouring pens.  It stayed for about 18 months until he no longer was writing on the wall.  We painted over and the wall was restored to its  previously unmarked state.  He, as they all do, grew out of writing on walls, seemed to grow out of writing altogether at one stage.
Mainly though the rest of the house was pen free and he kept his artistic licence within the domain of his room.

It's not because I'm lucky

Do you recognise the line "you are so lucky with your kids".

Really? So nothing to do with the fact that the kids get all our attention; read with them every night, visit the library once a week, work with them on their homework and not least talk with them all the time, about all sorts of subjects, nothing is of limits if they bring up the subject.

Now when the person who throws the above phrase is not choosing to do the same and their off-spring and expect their kids to just turn out 'right', then please don't compare my kids with yours because it has nothing to do with luck.