Unofficial LotR Collectors Guide INDEX 10.0.0 ReleaseHi All,
I absolutely adore the guide made by Miniman!
I also do love me some spreadsheets to keep track of my collections.
So i just went through the utter total mental onslaught of copying the full list of miniatures to an excel spreadsheet.
And with copying i mean manually retyping it, because the PDF is protected, so export tools NOR CTRL+c/CTRL+v work even to the smallest extent. I hope miniman doesn't see this as an intrusion on his work (it wasn't meant as such), but rather as a tribute and an auxiliary tool to be used together with his awesome PDF guide.
.
It took me a few weeks and a fried brain, but oh well, here we are. I might as well save some other peeps from this pain.
Please find attached:
"unofficial_lotr_collectors_guide_INDEX_10.0.0.xlsx", packaged in a ZIP archive:
https://drive.google.com/file/d/1C1qrnhp8VsdOLPNDwk3gf3-osRm3zX5j/view?usp=sharing This file is based on revision 10.0 of the PDF guide, and you'll need to open both files side by side for the list to make some sense.
Use is pretty straightforward:1. Use "Sort from Smallest to Largest" on the "#ID" column (E) to display the models in the spreadsheet in the same order as in the PDF guide. This is the case by default, but after reordering based on some of the other collumns, you can always fix the order by sorting this one again.
2. You'll need to navigate the PDF guide on memory/intuition to find a certain model in the list, i was freaking fed up with all the typing and needed to go pet my cat
, so there are no page references in the spreadsheet. Feel free to release rev. 10.0.1 if you want an extra collumn with page references.
3. Use filters on collumn F-K to search what you are looking for. You are a smart human being, you'll figure it out.
4. Add any number greater or equal to 1 in the "Want" collumn (B) to indicate you want this model.
5. Add any number greater or equal to 1 in the "Collect" collumn (C) to indicate you have this model in your collection.
6. Add any number greater or equal to 1 in the "Paint" collumn (D) to indicate you have painted this model
(
YOU SHALL NOT PA... CREATE A PILE OF SHAME!!
)
7. The overview summary at the top will show you how freaking far you still have to go before you've caught them all.
8. Overflow/Doubles (eg, adding 2 or 3 in collumn B,C,D) will not affect the summary (it is based on a countif statement), so go wild. Numbers equal or higher than 2 in collumn C or D will be marked in a brighter green.
9. Better buy a bigger closet to display all that awesomeness.
Enjoy, and let me know if you have questions!
Kr
Bytas
{ PORTAL }
Print view
Top
