| Author |
 Replies: 37 / Views: 10,184 |
|
|
|
New Member
Canada
23 Posts |
I have a Web site that I track everything. I can have groups of items for categories I have few items; and areas of focus I create checklists. I can have as many photos of the items I want and track any information I want. I used to use Quatro Pro about 22 Years ago and switched to Excel and stopped using Excel about 17 years ago, it could not handle the volume of data that I wanted. It would be too slow to be useable. So I switched to a proper database with a php web front end to access it about 10 years ago. I can access it from any internet capable phone or computer. it is currently 8.2 Gigs in size, 27000+ photos. (I had to severely reduce the size/quality of the list image to be able to upload it.) Chris   |
|
Valued Member
 Australia
146 Posts |
hey Chris - impressive looking database - post a link as it would be great to have a look through your collection
|
|
Rest in Peace
United States
9104 Posts |
 , Chris! Great contribution. |
|
Valued Member
United Kingdom
55 Posts |
I catalogue my collection with excel like the others have posted here. But I am also using facebook to upload pictures, and will soon add information about each note, and possibley the country depending how much time I have.
|
|
Valued Member
United Kingdom
129 Posts |
I catalogue my collection using Microsofts dated by useful Frontpage programme, so in other words - is formed as an unpublished website that I edit and update in the programme and browse using IE. I've written up the collection using sections, pages and tables, ordered by Country, type (government issuers, provincial, commercial, etc), issuing bank or other entity, and then by order of year. For example within my China section, there is a page for Provincial Banks which contains tables for each bank/issuer. Each table has the details, history if any of the issuer at top, sometimes with a map and other related images, and then a list of the notes in order of issue with various details, and an image of the note. Two printscreen images of this:   |
|
Valued Member
United States
484 Posts |
I track my collection with excel spreadsheet. I used Word and tables until it got too large. Excel is much nicer, once you have your set-up the way you want it.
I also have a website where I exhibit a few notes from my collection. It gives historical information on the notes and the persons/vignettes, etc. I can't do this for each note, unfortunately, as I have to work all day in order to pay for more banknotes. A vicious cycle that I can't seem to stop.
On my excel, I track country, denomination, serial #, price paid, catalog #, and a comments field. I keep a scan on my computer and also to a free banknote image hosting site. I just stated tracking the catalog #. I'm not sure if I'll keep it going or not, as they are known to change, which would be a lot more work for me later.
|
|
Pillar of the Community
United Kingdom
2624 Posts |
When I was a kid I catalogued and valued my collection from 2 books (one called "coins of Great Britain" and the other a very thick book on World Coins)
Over time these valuations became obsolete and as the coins moved around (were added to, replaced with better examples, were separated into different albums for different countries) I ended up discarding this catalogue as it hadn't kept up with my collecting.
When I grew up and started to work I then had the money to start collecting some more expensive pieces (like silver proof sets, proof sets, gold coins and items that had their own display boxes/folders/etc) and when my work changed I was able to travel and pick up world coins and notes which I used to fill more albums organised by country and type.
At this stage there is no comprehensive catalogue of my collection, I have scans of the majority of my banknotes and there is a spreadsheet of the serial numbers somewhere but I have it all to do really.
The thing for me though is that I like to processes of pen and paper, to see the rows of neatly written information...yet I know I am better to do it on computer where it can be cut and pasted and moved around as necessary.
Also add to it that I am not so interested in the value of many of the pieces that I have no intention to part with and I am not so motivated. Recently I have been writing pages and pages of coins that I need, and I can cross them off if I aquire them, its actually more useful to me than having a list of what I have!
|
|
Bedrock of the Community
Australia
21788 Posts |
The only write ups I do with my coins are noted on the 2x2's, which carry all of the purchase information and a brief descritption of the coin, when it is not self evident.
If the coin gets re located into another area of the collection, that information moves with it. That can happen often with the management of 4,000 different coin types, ancient to modern, all centuries, all cultures.
Maintaining a computer database under these conditions would just add an extra layer of complication. No one computer database is really set up to handle the needs of such a diverse collection.
This helps to explain why I am able to comment on so many sub forums here in the CCF. The CCF is the ONLY site that is able to do this. Also helps to explain why I have so much to learn, despite nearly 50 years of collecting, starting from age 12.
The collection as a whole documents the development of coinage through history, since the invention of coinage. The coins just don't tell the story; they ARE the story in such a collection.
|
|
Pillar of the Community
United States
1812 Posts |
I used to keep a running inventory of all my coins when I was doing Coin Shows and selling on ebay (that ended in 2006 & I would never sell their again)... Anyway, what was then my inventory, became my Granddaughters future collection to help pay for her education.. Currently everything listed is World Errors and varieties... A few days ago I just completed uploading all the error coins & currency photos on facebook under 26 different photo folders (listed by Country) and added the necessary information... Next comes the non-errors (that may be done by the end of the month)! I was thinking of posting some of the folder links on this forum instead on individual photos... |
|
Valued Member
United States
458 Posts |
I write everything down by hand.
|
|
Pillar of the Community
United States
3184 Posts |
I should do it, would be fun and can help me keep track of things.....hmmm maybe I will start now!
|
|
Valued Member
Australia
218 Posts |
I try to maintain an excel spreadsheet which shows all the information about the note or coin, such as where I purchased it, the price I paid, and when. It's too hard to remember, since I like to trade and sell here and there. Makes it easier to remember when the time comes. Also my notes are in display holders, which on the back, show all the information about the actual note, such print figures, signatories, design information, specs, etc. Lot of work, but fun.
|
|
Valued Member
United Arab Emirates
242 Posts |
I catalog & track all my Banknotes collection through a Collection DB software (after you enter the data, you may export it to Excel, HTML or even ASCII) ... There are several Collection DB "freeware" you could Google where it is easy to classify your collection and alter software's tabs/options based on your needs. My banknote collection is classified to 3 categories: - Worldwide Banknotes - Banknote Specimens & Proofs - Banknote Specialized Issues Then, each category does have the following fields: * Country * Issue Date * Catalog # * Grading * Certified By * Buy Date * Bought From * Scarce Signature? * Depiction ( since I only collect scarce-rare notes which depict Allegorical Figures, Statues, Sculptures & Mythical Gods, this field is VERY important to me) * Buy Price * Catalog Value * Sell Price * Sell Date * Remarks I scan my banknotes as well & upload them in the DB software ... In the future, if I want to look one banknote up, simply, I use the "Search" option with its multiple search varieties in the software & one click & that's it!  Cheers |
|
Pillar of the Community
United States
3546 Posts |
Hello,
Since this thread attracts members that tend to inventory and price their findings, I would like to know if anyone could suggest a reliable and 'free' on-line web site that supplies both photographs and corresponding updated retail prices for foreign(outside of the USA) currencies.
Thanks,
mdpmedia
|
|
New Member
United States
2 Posts |
I enjoyed this post because it is interesting to see how differently we treat the same things. I usually circle the Pick number in my SCWPM. I then underline the condition my note is in. I also take notes and research in the margins of my catalogs.
|
| |
Replies: 37 / Views: 10,184 |
First Page
Posted 04/19/2012 7:22 pm
