Seeking a Google sheets or Excel Inventory template

philatelia - I have made a few Excel inventories. One inventory for 'single' countries, inventory stamp-by-stamp. Another inventory for getting totals for a world-wide collection, this only goes 'country-by-country' (A single line in the database for each country). I presume you are looking for inventory of a single country? You can certainly have mine for free. 

Here's a sample of my Canada inventory. First and foremost it is obviously based on a database itself, one line for each major numbers and one for each variety. More detailed columns can be opened to register more data beyond the 'basics' shown here. Click the images for better resolution





The data entered for each single stamp is then used to generate several reports of consolidated data, example given a 'Total Collection report'





For better readability, here's the top and most important part of the collection report zoomed in





The consolidated data is also analysed and broken down into 'time periods, decades and even year-by-year, both for major numbers and varieties, as well as value of the same:





The data entered in the database is also used to generate a list of the areas most valuable stamps issued for that area - or a 'wish-list' if you will! 





Furthermore the database is used to generate a list of the best stamps you actually have:





For some reason I also prepared a set of graphs broken down into decades and years, to get the level of the collection 'visualized'





The data entered in the database can also be used to print automatically generated 'tags' for stock sheets, to denote each stamp and variety. 80 tags on a A4-sheet, to be cut appart by 'invisible' leading marks. These might be useful for anyone using stock sheets and like some write-ups to annotate missing stamps or varieties



I obviously have this also as a template, Canada was just shown to give you an idea of what it is and if it is what you are looking for. The downside is that data for stamps issued must be manually entered, which is quite cumbersome. There is selection in some columns to make this as swift as possible, but still it takes some love and labour. For now i have only prepared teh raw-data for a few countries (Canada, France, Austria, Luxembourg and partially Belgium), and obviously you can have these databases with raw-data of stamps issued already in there, if desired. The currency and catalogs etc can be changed to preference on a set-up page, so do not worry about the 'NKr' (Norwegian Kroner) currency indicated on the samples. It might look a bit complicated, but most is explained on the sheet by the terms of comments at various column headers, key-cells etc. See what you think.

If you are giving these away, I wouldn’t mind Canada and Luxembourg! Lots of data worked over in your sheets, blaamand !

Great work Jon blaamand - Excel.....I have never used except to keep Denise's "bird list" 
René

Jon, that's a h... Of a list, respect 👍👍👍

But i keep to the colnect where everything (data) is entred and i just tick what i have, want or have duplicate of. It saves a lot of time but are not so flexible as your ecelent spreadsheets.

Respect (I bow)

The challenge with an inventory file is how much time you want to type in and depends on what your goals are.  I use excel for my US but use StampManage for worldwide. StampManage reduces entry time for popular countries.

1. listing of stamps owned by catalog number
2. financial analysis (more information added to task 1)
3. Images?
4. Want list?
5. other unique information

 'Give-away' off the day ...
My 'Inventory database' on it's way to some of you good guys that raised their interest, the template itself and a copy Pre-populated for 'Canada' - more to follow. Hope it may be useful. No returns accepted  


philatelia - I've added/tweeked the template a bit for you with a separate column for Dups, also included in the report. Please send me a PM with your email if you want to have a closer look. 

Glad you got them Stan! Will send you a pm about the links

philatelia - was the inventory useful for yourself at all? Let me know if you'll need any further tips

blaamand - I would be very interested in copies of your sheets - the template and Canada if possible. I can set up an Australian sheet while during quiet moments while at the hotel in Perth, and I also want to set up Costa Rica, and perhaps see how it would work for a topical collection.

Thanks!
Dan

Holy moly, feebletodix, I didn't even know that forum existed, let alone what a great resource that thread will be. Thanks!

I want to publicly thank Jon blaamand for sending along the Excel sheets. What a tremendous amount of work and what a generous fellow.

Just wondering, do you have anything for Germany or states, you know me. LOL. You have given me so much lately, but if you don't have Germany, could you send me any template that I could change and make it Germany? I will gladly send back once I am finished.

mikeclevenger - Hi Mike, yes I know you and your ongoing involvement in Germany and states   Unfortunately I haven't built a database for Germany yet. I am happy to share my inventory template with you - and would be delighted if Germany data is entered and I can have a copy of that. Presume you'll be referring to Michel ? Will send this evening.
Jon