ColecoVision & ADAM Cartridge Collector Rarity List v2.11a - Excel Version
At long last I am pleased to announce that the latest Excel version of NIAD's superb CV & ADAM collector list is ready for prime time. This was a major undertaking, partly due to the extensive updates in NIAD's list going from v2.10 to v2.11, but also due to my adding additional information and a new cataloging feature to the spreadsheet to allow you to more easily catalog your own collection. This new feature is described below.
Note that I have adjusted the version number of this release to v2.11a. The "a" reflects the fact that I have included all of the 2015 games released (to date) including those additions listed by NIAD in the posts above. The "a" also signifies that I have incorporated a large amount of additional data such as the languages of manuals (where known) in the Non-US / Foreign section as well as a lot of part numbers that were missing. This additional data has been sent to NIAD for the next release of his list as he sees fit.
New Cataloging Feature
To use the new cataloging feature simply do the following for each item that you have in your collection:
- In the "My Col" (short for "My Collection") column, enter ANY character to signify that you own part or all of the items in that row or that you simply want this item for your collection. You will notice that after entering a character, all of the cells containing a check-box will turn a red colour. This is to highlight that these are still items wanted for your collection.
- If you own any of the items in the row, then grade the condition of the item (e.g. box, manual etc.) on a scale of 1 to 10. Either type this number into the respective red coloured cell, or select the value from the drop-down selection in that cell. Note that the cell colour changes based on the condition value selected as follows:
1 to 5 = red (poor condition - replace)
6 to 7 = yellow (okay condition - possibly replace)
8 to 10 = green (very good condition - keep)
The colours help signify if you are happy with the condition of what you have or if you want to try and "upgrade" it by buying another.
Simple as that ! If you want to change the automatic colouring of cells then please feel free to do so (uses Excel's conditional formatting feature). I have some VBA code that helps automate this tedious process so let me know if you want this.
I welcome and encourage any constructive feedback. I'm sure there are ways to greatly improve the Excel version of this database so please let me know if you have any suggestions.