Coin Community Family of Web Sites Join Thousands of Coin, Bullion, & Money Collectors
Coin, Banknote and Medal Collectors's Online Mall Specializing in Modern Numismatics Shop for APMEX Bullion on eBay!Vancouvers #1 Coin and Paper Money Dealer Join Thousands of Coin, Bullion, & Money Collectors Royal Canadian Mint products, Canadian, Polish, American, and world coins and banknotes. 300,000 items to help build your collection!








Username:
Password:
Save Password
Forgot your Password?


This page may contain links that result in small commissions to keep this free site up and running.

Welcome Guest! Registering and/or logging in will remove the anchor (bottom) ads. It's Free!

Excel Spreadsheet Help

To participate in the forum you must log in or register.
Author Previous TopicReplies: 11 / Views: 3,687Next Topic  
Valued Member
fasttalker27's Avatar
United States
55 Posts
 Posted 02/11/2013  4:35 pm Show Profile   Bookmark this topic Add fasttalker27 to your friends list Get a Link to this Message Number of Subscribers
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
Pertinax's Avatar
United Kingdom
2133 Posts
 Posted 02/11/2013  5:56 pm  Show Profile   Bookmark this reply Add Pertinax to your friends list Get a Link to this Reply
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
fasttalker27's Avatar
United States
55 Posts
 Posted 02/11/2013  7:30 pm  Show Profile   Bookmark this reply Add fasttalker27 to your friends list Get a Link to this Reply
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
Pertinax's Avatar
United Kingdom
2133 Posts
 Posted 02/12/2013  06:03 am  Show Profile   Bookmark this reply Add Pertinax to your friends list Get a Link to this Reply
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
fasttalker27's Avatar
United States
55 Posts
 Posted 02/12/2013  08:48 am  Show Profile   Bookmark this reply Add fasttalker27 to your friends list Get a Link to this Reply
I enabled email. I appreciate you sending the database. I will certainly check out the two groups upon my arrival.
Valued Member
fasttalker27's Avatar
United States
55 Posts
 Posted 02/14/2013  09:34 am  Show Profile   Bookmark this reply Add fasttalker27 to your friends list Get a Link to this Reply
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
 Posted 02/14/2013  3:44 pm  Show Profile   Bookmark this reply Add ECS to your friends list Get a Link to this Reply
i use this simple excel spreadsheet

http://www.aussie-coins.com/links.htm

its for Australian coins but it would not be hard to change it to whatever you want
Valued Member
fasttalker27's Avatar
United States
55 Posts
 Posted 02/14/2013  4:01 pm  Show Profile   Bookmark this reply Add fasttalker27 to your friends list Get a Link to this Reply
ECS, This is perfect. Thank you!
Bedrock of the Community
United States
20753 Posts
 Posted 02/14/2013  4:06 pm  Show Profile   Bookmark this reply Add just carl to your friends list Get a Link to this Reply
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
RichH's Avatar
United States
24 Posts
 Posted 02/15/2013  12:38 pm  Show Profile   Bookmark this reply Add RichH to your friends list Get a Link to this Reply
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
skyshark124's Avatar
United States
1109 Posts
 Posted 02/24/2013  1:20 pm  Show Profile   Bookmark this reply Add skyshark124 to your friends list Get a Link to this Reply
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
stud722's Avatar
United States
1088 Posts
 Posted 02/24/2013  2:54 pm  Show Profile   Bookmark this reply Add stud722 to your friends list Get a Link to this Reply
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
  Previous TopicReplies: 11 / Views: 3,687Next Topic  

To participate in the forum you must log in or register.



    




Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2026 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us  |  Advertise Here  |  Privacy Policy / Terms of Use

Coin Community Forum © 2005 - 2026 Coin Community Forums
It took 0.34 seconds to rattle this change. Forums