How to Organise your DVD's

Or maybe I should say

How many Dvds can one Room have?

Now I know that some people buy Dvds watch them and then sell them on ebay.
I buy them on Amazon or ebay and we watch them but we do not generally get rid of them.
Most of them are kept, especially the boxsets and they are stored in The Office

So this was the first thing I tackled in Fred's Office.   

Firstly because he would not ever consent to sorting them.
Secondly because he would not have done it properly - ie. in an organised fashion, noting what collections were complete and which series or episodes we had watched.

We had a little notebook which the kids & I had started some years back trying to keep track of the Dvds we were watching, who was watching and where we have got to in each series etc.

You see our problem was that in a family of five who were not always together it was hard to keep track of what we could watch depending on who was there.  Then it was the combinations of the five of us and what some of us could watch after Fred had gone on to bed (the kids and I are night-birds but Fred is not).  After that it was which series and which episode so we could end up wasting a lot of time looking through to see which episodes had been watched or not.

Nice little notebook and we kept it up to date for quite some time but then the same as everything else we got lazy about it.

I had a look through the apps for my iPad and found a free collections app to try out.
BUT!!! It would only take one collection and if you wanted more collections then the paid version was required.
I took Dvds as my one collection and I started to put in my box sets but after filling in several of them and then trying to put in further details I found that the app just did not give me the flexibility I needed just for the more general info and definitely would not be able to go into the finer detail I would need for noting which series of each set had been watched, which series I still needed to get, which sets had not been started yet etc.

So I came to the decision that a 
 was the only way to go.

At first I was disappointed as I thought I would have preferred to have that info in an app and so be able to access it easily via the iPad anytime I was out shopping but on second thought I realised that this would not be a great advantage as I rarely buy Dvds in the shops but mostly online so the spreadsheet would be fine for checking for that.

Hence a lot of time this week was spent getting this set up and filled in and some sort of logical system and Colour Coding thought out to suit me.

Of course this is only one section of the spreadsheet as it is quite long, it is in Alphabetical order and this only shows from A - F so is about one one quarter of my list of box sets.

As you can see from the Key I am noting which
  • series are still to be bought
  • series are bought but still to be watched
  • series are watched
  • titles are started/ongoing
  • titles are all bought and all watched
  • titles are all bought but not started yet
  • titles are not all bought and not started yet

I have also included the years of production and the initials of the members of the family who have watched them.

The only thing I think has not yet been included is exactly which episode was the last one watched in each of the incomplete Series.  That will simply be done by typing in the number of the last watched episode in the coloured cell of the correct series, and then can easily be changed each time.  Some of that info will come from the little notebook before I scrap the used pages and keep the rest of the notebook for something else and for some of them I will have to guess roughly and look at some episodes to see what I remember and don't remember.

I think I have mentioned that I have the app "Things which has now been changed to "Things3" and it is even better for projects now as well as for lists so I am now thinking of putting this info into it as well.
However it did cost me money - it was the first app I ever got because my husband Fred insisted I did so as soon as he bought me my first iPad - and it is even more expensive now and so as I am always thinking of cost as well as best suiting my needs I would still recommend a spreadsheet for this.

Do you remember from my Not the Office!! Post just how bad the 2 bookcases with the Dvds were because they had so much else piled on top and in front of the Dvds and the Dvds were all mixed up?

Well if not here is a reminder

Now those two bookcases look like this

I am so pleased with them but Fred is not so pleased because some of the things I moved away have to be sorted out by him!!!

Now of course the inventory of these two bookcases has been made so much easier as well so a good few days work overall and I am very happy with the way things are going around here.

Do you have as many Dvds to keep in order?

Have you made a list of your collection in an app or spreadsheet?