Cataloging the Collection

This time last month, I detailed my collection of miniatures, which has since been added to. I know most of what I've got in my collection but I thought it would be useful to have a system to identify my painting progress with them.

With that in mind, I've started building a spreadsheet.

The sheet consists of an overview tab (as above) showing a breakdown of each game system or company and a tab for each game or company, along with an "Others" sheet for those companies that I might only have one or two minis from. The breakdown shows the number of miniatures still boxed, built, PIP (Paint In Progress), finished and total miniatures, followed by a completion percentage.

Each line on the overview expands to show the different factions or grouping within each game.

The completion percentage on the right hand side has a conditional formula on it, which is set to change colour depending on how many miniatures I have finished. As you can probably tell, 0-25% is red, with 25-50% in orange, 50-75% in yellow and 75-100% is an elusive green.

The individual sheets all show each individual model type, split between their factions.

It looks a little silly having the totals showing one mini per line but the idea is that once I get to a sheet with multiples of certain types - Space Marines with bolters, for example, it will look a little better.

This is going to be a slow burning project - I've so far only added in my Guild Ball and Knight Models collections. The sheer number of miniatures that I'd need to sort out is something I don't really want to think about. I do plan on slowly adding to it from the current collection, but I think the main way to do things is to add all new miniatures as they arrive with me and go from there.