I had a couple of questions/comments last week about setting up my spreadsheet. I spend a lot of time in real life dealing with spreadsheets, and I know how massively interconnected and arcanely complex they can get. Usually to the detriment of their utility. The best spreadsheets are the ones that are simple and easy to understand at a glance. Next, they should be easy to update without breaking.
It all goes back to utility. If the sheet doesn't help you do what you want it to do without being a pain in the ass, why use it?
My sheet has 2 main goals:
- Quantify the mountain of miniatures I’m trying to chip away
- Track my progress at chipping away at the mountain
Bones II was easy, since I don’t have any painted yet. Bones I took a little bit of time, but not much. Then I added the totals at the bottom. The formula for this one is easy. Type the following into the cell you want the total showing: =sum( then highlight the cells you want to add up, and hit enter.
Getting back to the simple, take a look at my Lord of the Rings tab. It’s a much smaller sheet since many of the minis are all the same type. I don’t need to spell out which warriors of gondor have spears, swords, or bows. I don’t really care for this sheet. Sure, I’ll want to know if I’m playing Lord of the Rings, but honestly the answer is “enough” for whatever I want to field. On the flip side, it’s good to know that I have only 1 Gimli to paint versus 3 Legolas minis. Characters are far more important to note, since they get a far greater level of attention and effort.
If I were focusing on an army specific project, say a space marine battleforce, I might set up my sheet listing each squad & vehicle, and keep track of it that way. My Mantic sheet is kind of like that, especially since I included an “assembled” column. The Misc. tab is for those random minis that aren't part of a specific force or manufacturer. I plan on adding more sheets as I continue my inventory. I know there will be a Battlefleet Gothic sheet, probably 40K and WHFB sheets, and I might even do a Chainmail sheet since I have a lot of those minis too.
The totals sheet was created by listing out each of the tabs, and then pulling the totals for the challenge. The totals are linked to the individual sheets, so as I update my progress on each sheet, the totals page updates automatically.
And now, for this week's progress!
October is in full swing. I've assembled 7 skeletons, 10 zombies, and 10 ghouls from mantic, and primed them. I also worked on some of Reaper's Bone Zombies and Mummy.
Once again, crappy cell phone pictures. I really need to rig up a light box. They were all pretty simple to paint up, but that's 6 more minis done!