| Author |
Replies: 11 / Views: 3,687 |
|
|
Valued Member
United States
55 Posts |
Hello all. I have been a casual collector most of all my life but have recently started to collect more seriously with my young sons to get them interested in the hobby. I have looked at a few software programs and haven't been overwhelmed by any of them. Most of the guys I speak with keep a paper log or keep track of everything in a spreadsheet. I have read a few forum posts on here about Excel spreadsheets as well. I am not Excel savvy so I was hoping that someone had something that they would be willing to share with a novice. Any help would be much appreciated.
Thanks,
Lee
|
|
|
|
Pillar of the Community
United Kingdom
2133 Posts |
I use an Access 2000 database that I created myself. It's pretty basic: Country, Denomination, Ruler, Date, Description, Condition, Price, Ownership.
I can send you a free copy but I won't train you or change it to suit you.
I would suggest you look at open source free/cheap databases and bear in mind, that if you want something that suits your exact requirements, you're going to need to pay.
Most of my small business clients are happier to buy a cheap database that does 80% of what they need rather than pay £000s for what they think they need. It's remarkable, often after a few weeks use, that functionality that they thought was essential, is never used.
Edited by Pertinax 02/11/2013 7:49 pm
|
|
Valued Member
 United States
55 Posts |
Hi Pertinax, I would like to see the database, thank you. I believe that you are correct about personalizing a database, however I am not really sure how or where to start. Hopefully your base will provide me with some guidance. On a separate note, where are you in the UK? I will be in London on business starting next month for 6 months.
Thanks,
Lee
|
|
Pillar of the Community
United Kingdom
2133 Posts |
Lee, If you enable your account to receive emails, I'll send the database. I'm in Scotland, a long way by UK standards from London. When you're in London, I recommend you go to the meetings of the Royal Numismatic Society, http://royalnumismaticsociety.org and the British Numismatic Society http://www.britnumsoc.org/ and consider joining.
|
|
Valued Member
 United States
55 Posts |
I enabled email. I appreciate you sending the database. I will certainly check out the two groups upon my arrival.
|
|
Valued Member
 United States
55 Posts |
Hi Pertinax, I can't send an email through this forum as I am a new member. My email address is Lee at DanhauerAuction.com. Thanks. LMD
|
|
Valued Member
Australia
64 Posts |
|
|
Valued Member
 United States
55 Posts |
ECS, This is perfect. Thank you!
|
|
Bedrock of the Community
United States
20753 Posts |
Here is an intesting thing. A long time ago I too asked about Excel being old and not a fantastic computer person. There was a simple solution. Many book stores have books on Excel. Many computer stores have books on Excel. Some are like those you hear about that say Excel for dummies. I didn't buy that one but did get a spiral bound, simplified version on how to use Excel. Never did read a lot of all the things it can do, I just wanted to make a spredsheet for coins. All you really need to do is open it up. Type in headings for what you want. To make colums wider, you just go to the top of the column and drag the line you want to the left. After a while, once you get those columns the way you want, just go down a line and add STUFF to each column. The really, IMPORTANT thing to always remember is to save your work to a file somewhere in your computer. You wouldn't believe how many times I've forgot to do that and lost hours of work. Once closed and not saved, POOF, gone by-by. To make line spacing larger, use your mouse to highlight the line number at the farthest lert. Then go to the to for format, then row, then a box will appear for size. I suggest you put 15 in there. I like large letters and numbers so need the room. As you play around with Excel, just pop in here and ask.
|
|
New Member
United States
24 Posts |
The NGC Collectors Society offers a Collection Manager coin database that is available with a free membership to the society. Scroll down to Membership Options and click on the Free join now box. I started using it a few weeks ago. Here's the link: https://coins.www.collectors-societ...shboard.aspx
|
|
Pillar of the Community
United States
1109 Posts |
I created my own sheet and just made columns for year and mint to catalog what I own, then made another one for condition based on denomination. I found it was cheaper than paying for a program, and I could put whatever I wanted in the data fields. BUT I am willing to look for a better option if I find one.
|
|
Pillar of the Community
United States
1088 Posts |
I just wanted to add that I recently made an account on numista.com (a free website) that allowed me to enter all of my coins, including grade, year, country, etc. It also gives you notes on the history of the coin, metal make up, and much more. I was pretty impressed with it. Just thought I would share. There is also a spot to trade coins if you are interested. Once you have entered all of your coins, they have a button to export them to excel and ways to print lists of what you still need. Pretty nifty
|
| |
Replies: 11 / Views: 3,687 |
|