Rob McKee Posted September 13, 2012 Share Posted September 13, 2012 I think it is time for me to get a little more organized. Cleaning out my model room today I came across many duplicate kits stashed away in the back of my storage cabinets. So I decided it is time to get all of this information onto my computer so I can track what I have better. Has anyone come across a good free inventory program designed to manage model inventories? I have been searching the net and found a few but I thought I would seek the advice from those who are using something today. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Dr. Cranky Posted September 13, 2012 Share Posted September 13, 2012 Wow, Rob, how many kits do you have that you need "tracking" software? Quote Link to comment Share on other sites More sharing options...
martinfan5 Posted September 13, 2012 Share Posted September 13, 2012 Rob, I have been thinking about this is as well, but with less the 20 kits, I can use a napkin , but to answer your question, I think one program you could use would be a spread sheet I think. I do know there are a lot of members on here that use computer programs do keep an inventory Quote Link to comment Share on other sites More sharing options...
Rob McKee Posted September 13, 2012 Author Share Posted September 13, 2012 Wow, Rob, how many kits do you have that you need "tracking" software? I knew that question would come up. Honestly I really don't know how many I have at this point. I boxed up 100 kits today and moved them to the basement for storage. Even that didn't make a dent in my collection. I think I need to join plastic anonymous or something. Quote Link to comment Share on other sites More sharing options...
oldnslow Posted September 13, 2012 Share Posted September 13, 2012 My daughter's after me to do the same thing, using a word document, haven't started yet. I've got the inventory sheets, everything is in boxes, but there's 78 pages and I just can't bring myself to start that project yet. Quote Link to comment Share on other sites More sharing options...
Rob McKee Posted September 13, 2012 Author Share Posted September 13, 2012 Rob, I have been thinking about this is as well, but with less the 20 kits, I can use a napkin , but to answer your question, I think one program you could use would be a spread sheet I think. I do know there are a lot of members on here that use computer programs do keep an inventory I thought of a spreadsheet as well Jonathan but I think there are some good programs out there that would make it a little easier to search. Quote Link to comment Share on other sites More sharing options...
martinfan5 Posted September 13, 2012 Share Posted September 13, 2012 I thought of a spreadsheet as well Jonathan but I think there are some good programs out there that would make it a little easier to search. I am sure you are right, that was the first thing I thought of Quote Link to comment Share on other sites More sharing options...
Manic Mechanic Posted September 13, 2012 Share Posted September 13, 2012 Plastic Anonymous??? Don't like quitters! Quote Link to comment Share on other sites More sharing options...
DAYTIME Posted September 13, 2012 Share Posted September 13, 2012 I would use Excel. that way you can sort, search, and put in pricing if you wanted to. Quote Link to comment Share on other sites More sharing options...
Rob Hall Posted September 13, 2012 Share Posted September 13, 2012 I've used Excel spreadsheets for mine for years...I've heard of other people using an Access database. I give each I kit I buy an inventory id, a box id and storage unit id (when they get transferred from the house to offsite storage), etc... Quote Link to comment Share on other sites More sharing options...
Der Bugmeister Posted September 13, 2012 Share Posted September 13, 2012 Check this one out. It was originally intended for inventorying tools and workshop items, but seems pretty adaptable. http://www.thegaragegazette.com/index.php?topic=11.msg19#msg19 Quote Link to comment Share on other sites More sharing options...
vypurr59 Posted September 13, 2012 Share Posted September 13, 2012 Google docs has a free spreadsheet program. Quote Link to comment Share on other sites More sharing options...
jcbigpaw Posted September 13, 2012 Share Posted September 13, 2012 Should be real easy to set up an excel spreadsheet for this. Quote Link to comment Share on other sites More sharing options...
ChrisR Posted September 13, 2012 Share Posted September 13, 2012 I use an Excel spread sheet for my collection of over 2 200 models. I list them under model manufacturer, kit number, description, date of purchase, cost price and for interest current value (from actual sales on auctions or model shop catalogues). The search facility makes it easy to find anything you look for. Quote Link to comment Share on other sites More sharing options...
58 Impala Posted September 13, 2012 Share Posted September 13, 2012 Like several of you, I did an inventory a few years ago on paper and transferred it to an Excel spreadsheet. I came up with my own way of categorizing everything. Once you get one set up it's easy to keep it updated. Quote Link to comment Share on other sites More sharing options...
mikemodeler Posted September 13, 2012 Share Posted September 13, 2012 I would use Excel. that way you can sort, search, and put in pricing if you wanted to. This is what I have done for the last 15 years. I categorize them and use the filter function to sort them in several different ways to identify duplicates, kits that are opened vs. sealed, sell vs. keep, etc. Quote Link to comment Share on other sites More sharing options...
crazyjim Posted September 13, 2012 Share Posted September 13, 2012 I just keep track of my kits in a MS Word file. Quote Link to comment Share on other sites More sharing options...
bbowser Posted September 13, 2012 Share Posted September 13, 2012 I made up an Excel spreadsheet for mine, a little over 200 kits not counting partials. Like others have said it's pretty easy to set up and filter/sort for what you want. Quote Link to comment Share on other sites More sharing options...
darquewanderer Posted September 14, 2012 Share Posted September 14, 2012 That's an interesting program Clay. Now if only someone would do one in OpenSource or OfficeLibre. Quote Link to comment Share on other sites More sharing options...
vypurr59 Posted September 14, 2012 Share Posted September 14, 2012 openoffice.org is an open source word/excell program software. Free and easy, all docs are compatable with microsoft produsts as well Quote Link to comment Share on other sites More sharing options...
Rob McKee Posted September 14, 2012 Author Share Posted September 14, 2012 Thanks everyone for all of the tips. It sounds like Excel would be the best solution. Quote Link to comment Share on other sites More sharing options...
mopar68 Posted September 14, 2012 Share Posted September 14, 2012 You might already be aware, but if you do use Excel, a template might make it easier http://www.gcflearnfree.org/excel2007/14.2 Quote Link to comment Share on other sites More sharing options...
my66s55 Posted September 14, 2012 Share Posted September 14, 2012 That's an interesting program Clay. Now if only someone would do one in OpenSource or OfficeLibre. You want to use LibreOffice? It's simple. Just make your own. If you want to add pictures, just drag and drop. Here's mine: Quote Link to comment Share on other sites More sharing options...
moparmagiclives Posted September 15, 2012 Share Posted September 15, 2012 I guess I never though about having enough to need to Inventory, you guys are pretty intense !! Cool info ! Quote Link to comment Share on other sites More sharing options...
Fabrux Posted September 16, 2012 Share Posted September 16, 2012 I keep an inventory of my kits in Excel. So far I only have for columns manufacturer, kit number (easier to track reissues), series (ex. Streetburner), title (## stock car), make, model, and year. I do like your system, my66s55, of keeping track of what condition its in, missing parts, etc. I think an overhaul of my inventory may be in order... 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.