lazzeri Posted October 10, 2019 Share Posted October 10, 2019 Hello, Since I´m a control freak I´ve being using for a while now an Excel spreadsheet tailored to catalog & control my A2600 collection (You can check it in this AA thread.) Now I´m finally sorting my (pretty small, actually) 5200 collection so I decided to make a similar spreadsheet for my personal use. I plan to add it here when ready in case someone want to give it a try. ? SO, what does it do? - Separate companies, all 69 games listed; - Checkbox to mark if you own a cart, box, manual, overlays (when apply) and a field for "extras" like catalogs and pamphlets. Also a "comments" field for noting a torn manual or sealed box, for example; - It automatically counts how many games you have for each company and how many of those are complete; - Also, on each company it automatically colors the game in light green if you own a cart or in dark green if your copy is complete. Here´s the main page, listing all companies, how many released games, how many you own and how many are complete (everything is autofilled) Here´s an example, Sega. Note the light green for the uncomplete games that you own and the dark green for the complete games you have. All you have to do is click the checkboxes, everything else is automatic. I plan to finish it later this week. And I was wondering if you guys have any suggestions, something you´d like to add or something I oversaw. Thank you in advance! 1 Quote Link to comment Share on other sites More sharing options...
kiwilove Posted October 10, 2019 Share Posted October 10, 2019 If you're not a purist - you could add all of the homebrew titles released for the 5200? Should be around adding another 25 titles? maybe? 400/800 conversions to 5200 would be another 25? Harvey Quote Link to comment Share on other sites More sharing options...
rayik Posted October 10, 2019 Share Posted October 10, 2019 Also not all games had overlays. Might want to have Overlay column to help you note which games are complete Quote Link to comment Share on other sites More sharing options...
MrMaddog Posted October 10, 2019 Share Posted October 10, 2019 Here's another suggestion, adding a field that shows if the game is trackball compatible or not...or even if the game can be play with a digital joystick (via Mastertronic) or needs the full 360 degree analog controller. Trust me it feels like a different system with each game having their own control scheme. Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 10, 2019 Author Share Posted October 10, 2019 6 hours ago, kiwilove said: If you're not a purist - you could add all of the homebrew titles released for the 5200? Should be around adding another 25 titles? maybe? 400/800 conversions to 5200 would be another 25? Harvey Would love to! Is there a complete list somewhere? Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 10, 2019 Author Share Posted October 10, 2019 1 hour ago, rayik said: Also not all games had overlays. Might want to have Overlay column to help you note which games are complete Already planned! Thank you! When no overlay exists it will be written “N/A”, just like in the Sega picture. When available there will be a checkbox like the rest. Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 10, 2019 Author Share Posted October 10, 2019 30 minutes ago, MrMaddog said: Here's another suggestion, adding a field that shows if the game is trackball compatible or not...or even if the game can be play with a digital joystick (via Mastertronic) or needs the full 360 degree analog controller. Trust me it feels like a different system with each game having their own control scheme. Does this info exists already? If so I can try adding that somewhere! Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 12, 2019 Author Share Posted October 12, 2019 Version 1.0 is here! Feel free to give it a try. Please let me know if you found any errors, wrong info, typos. Also, suggestions are still appreciated. Checklist_A5200_v1.xlsx Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 12, 2019 Author Share Posted October 12, 2019 I am unable to edit first post. ? So here´s how´s looking so far: - Index page, with all companies and all autofilled data: . - A company page showing some possibilities, some checkboxes marked to show how it looks. Please note all color tags automatically filled. Quote Link to comment Share on other sites More sharing options...
lazzeri Posted October 12, 2019 Author Share Posted October 12, 2019 Version 1.1 - Added "Sealed", just like in the A7800 spreadsheet. Also added "Golden" color for sealed games. Checklist_A5200_v1.1.xlsx Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.