Reaper Bones Wishlist/Tracker

[JDizzO]

So I got bored at work the last month and made a Bones wishlist/Tracker that I wanted to share with everyone.  On the left you can mark how many you want of each miniature and on the right you can track what you have.  It should total the cost in both columns at the bottom as well.  Let me know what you think.  Also let me know if I did not share it correctly, you should be able to make your own copy to edit. 

 

Here

[amuller33]

Nice but for the total have you thought about using SUMPRODUCT function? It multiplies 2 cells along a range and then adds.

=SUMPRODUCT(D2:D484,E2:E484)

 its a lot easier to deal with and you can expand easily when Bones 3 hit the market

 

Also a "painted" column would be nice... just saying

 

AJ

[Dilvish the Deliverer]

Nice but for the total have you thought about using SUMPRODUCT function? It multiplies 2 cells along a range and then adds.

=SUMPRODUCT(D2:D484,E2:E484)

 its a lot easier to deal with and you can expand easily when Bones 3 hit the market

 

Also a "painted" column would be nice... just saying

 

AJ

Bwahahahahahaha!  Like I need reminding how few of the Bones I have are painted!  It better to just forget about that and buy more!

[SirDibblet]

As someone who loves organization and would utterly collapse in a heaping mess if he wasn't so I certainly appreciate this nifty sheet.  I will use it to keep track of my orders cause I am now a firm friends of Reaper Minis and expect to be purchasing more in the future...if i had the money now I'd have totally bought into the Kickstarter.

[wargamer]

SirDibblet, it isn't too late, and the pledge manager should stay open until just before the product ships some number of months in the future

[JDizzO]

@amuller33- TY that will help loads when I have to update for Bones 3!

[etherial]

A couple of constructive criticisms:

 

1) Swap the Want and Price columns

2) Add absolute price references (use dollar signs) to the Total Owned entry so it can be copy/pasted easily into new columns for keeping track of subcollections like "painted" or "have in metal" or "in my Warlord Army" or whatever

3) Add a couple of locked sheets with the lists from the Vampire/Core/Expansion sets so people can copy/paste the bulk of their Kickstarter purchases in.

4) estimate the SKUs for the currently discontinued minis like Juliette, Wizard (should be 77057)

[mrxak]

This is quite handy. Thanks!

 

I downloaded the spreadsheet and edited it to tally up the number of number of minis on the wishlist, as well. A while ago I made my wishlist in a text file, but now I can go through and figure out just how monumental a task I have ahead of me  . I'm nowhere near done filling out my list (I made up my list by race, not in numerical order, so it's taking a while to convert over to the spreadsheet) and I'm already at over a hundred minis I want to paint. I do sort of know my priorities, though, so for example a lot of the elves I don't really need to paint any time soon.

[etherial]

Any plans on updating this for Bones III?