Ikrananka Posted January 21, 2020 Share Posted January 21, 2020 ColecoVision Collectors Database – v3.00 (2019) Greetings ColecoVision collectors! After an over four-year absence, the ColecoVision Collectors Database is finally back!!! Name Change and Rarity Values First I should clarify that it's back but with a name change, as it was previously known as the ColecoVision & ADAM Computer Rarity List. The reason for the name change is so that it more accurately reflects the current content and format. The original text "list", that NIAD created and updated through to the end of 2014 (v2.11), has since only been updated and maintained by me and only in an Excel spreadsheet in more of a "database" format. Additionally, I removed the words "ADAM computer" and "rarity" from the name as the database does not cover anything specific/unique to the ADAM computer and the rarity values have not been updated since before 2014. In fact, I have only made a few changes to rarity values since 2014 and I have no real intention of updating rarity values going forward. If anyone would like to volunteer to develop a reasonable rarity criterion and provide me with updated rarity values, then I’ll be happy to incorporate that into the database. Just let me know. v2.11a (2014) to v3.00 (2019) An enormous number of changes have occurred to the database over the past four to five years. Aside from many corrections and additions to the historic portions of the database, I am amazed at the sheer number of additions that the homebrew publishers and community have created, since 2014, and continue to create. A word of caution. Since 2014 I have worked on the database sporadically and without those updates being particularly planned or coordinated. Over the past few months I have gone back over the changes I made and the various posts and PMs on AA since the last release (v2.11a) and have done my best to check and verify everything. Nevertheless, due to the sporadic nature of the updates I made I really cannot guarantee that the database is free of errors or omissions. As such, I would be extremely grateful if anyone spots something wrong that you report it here and I will ensure that it is incorporated into the next update. Changelog Rather than produce a long changelog between releases, I simply highlight cells in the spreadsheet with a colour, in this case blue, to indicate where a change has occurred. Where an entry has been deleted, I highlight a cell in Column A in the row below the deletion. The last version of the Excel database that I released was back in November 2015 (v2.11a) and so the highlighted changes in the current release are those that have occurred between versions 2.11a and v3.00. Now, if you plan on using this database to catalogue your ColecoVision collection, as I do, then I not only provide a copy of the database with changes highlighted, but one that has the highlighting removed and is ready for use. So, attached to this post are two versions of the database, (i) with changes highlighted, and (ii) with change highlighting removed. Cataloguing Feature To use the cataloguing feature simply do the following for each item that you have in your collection: 1. In the "My Col" (short for "My Collection") column, enter ANY character to signify that you own part or all the items in that row or that you simply want this item for your collection. You will notice that after entering a character, all the cells containing a checkbox will turn a red colour. This is to highlight that these are still items wanted for your collection. 2. 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 (it uses Excel's conditional formatting feature). Future Release Schedule My plan going forward is to release a new version of the database once every quarter (3 monthly). This should allow me to keep on top of changes in a more efficient manner than I have to date. Each update will be posted in a new thread to allow the comments to remain relevant to that version. Feedback Please post any comments, suggestions, additions/deletions and/or corrections in this thread and I will incorporate them into the next release as appropriate. Help Wanted I really want to expand this database to include a lot more information about individual games, e.g. developers, cheats, Easter eggs, cart PCB, rom size etc. It would also be great to be able to include items such as box art, manuals etc. These would be things I would add slowly over time, but the major issue is that Excel really isn’t the best way to store and present this information as it will starts to become too large and unwieldy. Interrogating the database in Excel is also very clunky compared to “real” database applications. What I really would like is to transition the Collectors Database over to a decent database application with perhaps a nice web style user interface for presenting the data and with simple forms for searching/filtering the data. This also must be a standalone offline database, one that is free to use and distribute and is still being actively worked on. Does such a thing exist? So, I’m looking for help from anyone with a good knowledge of databases and their user interfaces. Any database gurus out there??? Prior Releases v2.11a (Nov 2015) v2.11 (Dec 2014) - List (last list version) v2.10 (Aug 2014) - Excel v2.10 (Jan 2014) - List v2.09 (Jan 2013) - List v2.08 (Oct 2012) - Excel v2.08 (Jul 2012) - List v2.00 (Sep 2011) - List v1.75 (Aug 2011) - List v1.5 (Apr 2011) - List v1.0 (Apr 2011) - List v0.7 (Mar 2011) - List v0.4 (Dec 2010) - List v0.3 (Dec 2010) - List v0.2 (Nov 2010) - List v0.1 (Nov 2010) - List ColecoVision Collectors Database v3.00 (2019).xlsx ColecoVision Collectors Database v3.00 (2019) - Changelog.xlsx 7 1 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.