An Exciting Idea

I was talking to a relative who gave me this idea. That the spreadsheet could have pages where I store stats from the collection and display them as charts, for example:

I imagine more ideas will come from this. I'm wondering how achievable it is at the moment though considering new data could be added at any time.

Starting with a plan? Part 2 (More Pictures)

Message Box Example

List Sources DiscNo and Genres

Starting With A Plan?

Let's start with my oversized (and starting to seem a little old fashioned) CD collection. (Link to a picture http://thisisourhovel.blogspot.co.uk/2014/07/cd-collection.html). I really want to make my own system in excel to record everything in my collection. I'm not really sure why, only I obviously really love both excel and my CD collection*, perhaps, equally.

I have existing skills in excel only I think I need to brush up and get a little more familiar with the latest versions of the software. I have, let's say, a dormant passion for the subject.

It started when I took an A level in applied IT about five years ago. I only really decided to do it as a secondary thing to my Art A levels, however in the end the art didn't go as well in comparison.

So this is how I'm going to begin my experimentation, although evidently the colour scheme needs a lot of work.

Note: I can't remember off the top of my head when the album is from.

Above: I tried to think of all the categories I wanted to record about each item here. So this would be my enter a record page or form. (I'm only really scraping the tip of the iceberg today with this). And I've done a little data validation with input messages and drop down boxes. Which is actually really fun. I wrote the lists for the drop down boxes below the form so I can always hide them and lock them later, as it just seems simpler to have them on the same page for now. I named each list as DiscNo and Genres. So I can just refer to them easily when I'm doing the validation.

I'm aware I should really be doing a nonworking plan on some other software or paper, but I'm finding this easier at the moment and a way to try and dive into the experience.

I have input messages also even though this isn't really necessary as it will be me who is using the system. Although I might find a way of somehow recording the formulae and code I will be using during construction. Even this blog?

Anyway, here are some more pictures of what I've done:

Input Message

A-Z ordered list