lazzeri Posted September 11, 2018 Share Posted September 11, 2018 Hello, I´ve created an Excel spreadsheet some time ago to organize my Atari 2600 collection (thread can be found here: http://atariage.com/forums/topic/280064-atari-2600-games-checklist-excel-file/ ) So I was planning to do the same thing for the Intellivision. Do you guys find it an useful thing? Or I´m just wasting my time? Here´s what it would eventually do when ready: Games are divided by companies to make it easier for the completionists out there. You can mark if you have a game, manual, box and overlays. Also you can add assorted comments and all extra materials you game have (catalogs, registration and such). If you check a cart it will became light green; If mark a game as complete (cart + box + manual + overlays) it will turn dark green. See pic below. I´ve also planned to divide games into two distinct categories (when applies): "Original 125 games" and "Repacks". Please let me know what you guys think. Thank you! 6 Quote Link to comment Share on other sites More sharing options...
colormesticky Posted September 11, 2018 Share Posted September 11, 2018 This looks like it would be useful for people who don't collect variant packaging. And if there's one thing I love, it's having everything on a tidy spreadsheet. 2 Quote Link to comment Share on other sites More sharing options...
+KylJoy Posted September 11, 2018 Share Posted September 11, 2018 I use spreadsheets for all of my videogame collections. I find it very useful for tracking what I have and what I am still hunting for. I'm sort'of a spreadsheet nut, I guess. My Intellivision collection spreadsheet tracks all sorts of info like: Whether it is the original release Box, Cart, Manual, Overlays, etc. Whether the item is in my hands, on order or I'm still looking for it Title that is a hyperlink to the game's INTV Funhouse page Publisher Year of release Programmer and company Gaming Network (Sports, Action, Arcade, etc.) Version of Box, Cart, Manual, Overlays, etc. Condition of Box, Cart, Manual, Overlays, etc. How many overlays originally came with the game and how many I have with it Catalog version and condition that is included with the game Extras that are with the game (manual addendums, etc.) Type of box (flip-top, flip-bottom, gatefold, Imagic, Sega, Parker Bros., Activision, etc.) My cost for the item, shipping cost and totals A notes field for decribing history related to the game like where I got it, etc. Total number of games, how many I have on hand, how many are in the mail, how many I need. Total costs and averages for each game and shipping of each game Some calculations based on components and their quality to automatcally color the items to signify how complete each item is for my collection Overkill? No way! 4 Quote Link to comment Share on other sites More sharing options...
Utopia Posted September 11, 2018 Share Posted September 11, 2018 Love the layout Lazzeri. I'm in if you get it done. (I suck at spreadsheets) Quote Link to comment Share on other sites More sharing options...
+eebuckeye Posted September 11, 2018 Share Posted September 11, 2018 Looks great to me!! I'd use them! Quote Link to comment Share on other sites More sharing options...
+intvsteve Posted September 11, 2018 Share Posted September 11, 2018 At some point I tried using a mobile phone app for this kind of thing, but gave up - too tedious to maintain. KylJoy's got a great idea w.r.t. keeping track of useful info like prices, what came with the item, and condition -- something I wish I'd done. (Or maybe not... knowing how much $$$ has been poured into the hobby would likely be depressing.) A few others around here also track expenditures / income (such as it is) from sales / trades. Though I don't track condition, etc. at INTV Funhouse, there are fields in the database I use for tracking items in my personal collection. That way the data's always backed up offsite. Quote Link to comment Share on other sites More sharing options...
Intymike Posted September 11, 2018 Share Posted September 11, 2018 Looks great! Quote Link to comment Share on other sites More sharing options...
Atari_Bill Posted September 12, 2018 Share Posted September 12, 2018 Yours looks a bit more fancy than mine, but Ive tracked my collection for years using individual spreadsheets. I can keep track of my excess inventory in addition to my primary collection. Ive also built in a % complete for each to see how close to 100% I am for carts, boxes, and instructions. Of course everyones definition of complete is different so thats more of a personal setting to each their own I guess. Quote Link to comment Share on other sites More sharing options...
lazzeri Posted September 12, 2018 Author Share Posted September 12, 2018 (edited) So here´s the first draft of the spreadsheet: http://www.lazzeri.online/pub/Checklist_Intellivision_v1.xlsx Halfway trough, "only" missing the Mattel games now. Please take a look. I´ll hide all the control tags ("TRUE" / "FALSE") later. Also I´ll remove the "Overlay" field on the games that don´t have it packed in. About original Intellivision games: Should I keep a single list, or group them by series? Any suggestions? Now´s the time. :-) Thank you! Edited September 12, 2018 by lazzeri 2 Quote Link to comment Share on other sites More sharing options...
+Steve Jones Posted September 12, 2018 Share Posted September 12, 2018 What about variations, are you doing those? Sears, Digiplay, Mattel French-Canadian, CBS, Imagic International, Bandai, etc etc Plus all sorts of Mattel variations... Way more than 125, more like 500 or so Not to mention new releases Quote Link to comment Share on other sites More sharing options...
lazzeri Posted September 12, 2018 Author Share Posted September 12, 2018 What about variations, are you doing those? Sears, Digiplay, Mattel French-Canadian, CBS, Imagic International, Bandai, etc etc Plus all sorts of Mattel variations... Way more than 125, more like 500 or so Not to mention new releases Probably not. I was planning to list the original 125 + repacks (like Sears). Should stick with USA / NTSC releases. Variations only matters for a smaller percentage of users. Thats not what Ive planned, I dont even know it enough. New releases are impossible: It would mean a new spreadsheet version every time someone releases a game - and users having to fill everything from scratch every single time. Quote Link to comment Share on other sites More sharing options...
Punishermark Posted September 12, 2018 Share Posted September 12, 2018 Spreadsheet looks good. There is also the CLZ Games app on Android that has everything and you can add to it. Which then goes to other users of the app. Quote Link to comment Share on other sites More sharing options...
VectorGamer Posted September 12, 2018 Share Posted September 12, 2018 It would be easier to use RFgeneration.com - desktop and app. Quote Link to comment Share on other sites More sharing options...
CharonPDX Posted September 13, 2018 Share Posted September 13, 2018 Well, attached is my hand-made spreadsheet. Columns for count of the various 'bits' of each game, a column for a description of them (to note different variation boxes/manuals,) etc. At the bottom, a couple auto-calculated that shows how many physical games, how many duplicates, etc, etc.Note that the system won't let me upload an .xlsx file - it is actually an Excel spreadsheet, not a plain text file. Rename it to put .xlsx on the end, not .txt. Intellivision Games.txt Quote Link to comment Share on other sites More sharing options...
+JasonlikesINTV Posted September 13, 2018 Share Posted September 13, 2018 I am a big fan of spreadsheet tracking, but didn't really have a plan when I originally started Intellivision collecting. My collection sort of spiraled out of control as my scope creeped. Consequently, my collection isn't well logged and I never kept track of useful details of my acquisitions (original components, condition, price paid, etc). It's a bit of a mess at the moment. Then I started collecting Wii and Wii U. The Wii game library is substantial, so I started with a plan and used a spreadsheet. I track the following: Title Completeness Included Extras (catalogs, inserts, adverts, etc) Date of purchase Price paid Where I bought it (GameStop, eBay, thrift store, yard sale, etc) Tested? Yes/No Cleaned? Yes/No I'm not sure which is worse, the unknown amount I've invested in Intellivision or the known amount I've invested in Wii 2 Quote Link to comment Share on other sites More sharing options...
nick3092 Posted September 15, 2018 Share Posted September 15, 2018 I use Access to track mine. But then again, I'm a data guy. Hardware in a single table, and each system gets its own table for games. I can query and sort however I want. And it's all in one tidy package. 1 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.