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








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!

Coin Software Question

To participate in the forum you must log in or register.
First Page  Showing last 15 replies.
Author Previous TopicReplies: 18 / Views: 5,264Next Topic Page 2 of 2
Pillar of the Community
United States
819 Posts
 Posted 02/07/2009  10:09 pm  Show Profile   Bookmark this reply Add basicbob101 to your friends list
is there any way to post an image/photo in an excell cell?
Valued Member
United States
377 Posts
 Posted 02/07/2009  10:22 pm  Show Profile   Bookmark this reply Add wif99 to your friends list
I use Coin Manage and Love it
I used Coin Keeper for a couple years but wasn't happy with data input especially new coins not in the data base.
Coin Manage is Basically An Access program so if you know your way around access you can modify any thing
I do enjoy the ease of importing data and pictures
New coins can be added with ease
Coin manage includes US and Foreign plus Commeratives
Moderator
Learn More...
United States
188924 Posts
 Posted 02/07/2009  10:40 pm  Show Profile   Bookmark this reply Add jbuck to your friends list
Count me as another vote for the spreadsheet method.


Quote:
Excel...the price is right!
OpenOffice.org, the price (free) is even better!
Edited by jbuck
02/07/2009 10:42 pm
Valued Member
United States
141 Posts
 Posted 02/07/2009  11:34 pm  Show Profile   Bookmark this reply Add hawkeye to your friends list
For those of you that are using Excel...what fields do you set up? Anyone mind attaching a template of their spreadsheet?

Also, here's a link to another thread that talks about software that other have used. https://goccf.com/t/14678

Edited by hawkeye
02/07/2009 11:38 pm
Bedrock of the Community
United States
19961 Posts
 Posted 02/08/2009  12:07 am  Show Profile   Bookmark this reply Add BadThad to your friends list
Here's mine, keep in mind it's set up for my muliples, so there's some extra rows. This is my life blood of my collection. It allows me to keep track of everything with my Lincolns. I have multiple sheet tabs that I use for other coins in my collection.

http://www.badthad.com/coin/lincoln.xls
Lincoln Cent Lover!
VERDI-CARE™ INVENTOR
https://verdi.care/
Edited by BadThad
02/08/2009 12:09 am
Pillar of the Community
United States
2669 Posts
 Posted 02/08/2009  12:27 am  Show Profile   Bookmark this reply Add xshift to your friends list
I have one that has a first page that (a) gets the tab names (countries of course ), (b) places those names into a row, gets the number of coins listed on that page, then totals them. For the other pages, I'm going to set them up to get average price based on past certain criterion and put that into a FMV column (based on country name, year, denomination, and grade columns, in a background internet search hopefully resulting in some parse-able data). That part isn't finished yet as I haven't had time. When I get it done I'll post it.

Yes, Excel spreadsheets can either include the picture or a link to the file, whether it's local to your computer or on the internet.

Thanks for posting your spreadsheet, BadThad. The "comments on year" would come in especially handy
Valued Member
United States
392 Posts
 Posted 02/08/2009  01:53 am  Show Profile   Bookmark this reply Add kceb10 to your friends list

Quote:
is there any way to post an image/photo in an excell cell?



Yes you can inset photo's in a cell but by the time you do and entire collection the spreadsheet takes for ever to load because of all the pics.

I have my spreadsheet set up to automatically update prices everytime it is opened. I pull the prices from the numismedia website. But it could be set up to get prices from any price guide that is online.


I put together a sample spreadsheet here that will update your price list

http://www.mediafire.com/?sharekey=...75f6e8ebb871
Edited by kceb10
02/08/2009 02:02 am
Bedrock of the Community
United States
19961 Posts
 Posted 02/08/2009  02:30 am  Show Profile   Bookmark this reply Add BadThad to your friends list
If you want pictures, the solution is to put a LINK in the cell. I've played around with it, but it would be a LOT of work for a Lincoln collector. I've debated taking the project on many times. If I was smart, I would have started doing that as I built the sheet.
Lincoln Cent Lover!
VERDI-CARE™ INVENTOR
https://verdi.care/
Bedrock of the Community
United States
19961 Posts
 Posted 02/08/2009  02:36 am  Show Profile   Bookmark this reply Add BadThad to your friends list

Quote:
Thanks for posting your spreadsheet, BadThad. The "comments on year" would come in especially handy


You're welcome! The comments on year are a work in progress. It's kind of like writting a book. When I observe or read a fact, I update my comments. Sorry if you find spelling/grammer errors, I tend to just slap stuff in there.

Here's another handy one I made. It lists all the Memorial cents by mintage. Comes in handy as I identify the "key dates" for the series. Another topic for discussion.

http://www.badthad.com/coin/memorial_mintage.xls
Lincoln Cent Lover!
VERDI-CARE™ INVENTOR
https://verdi.care/
Pillar of the Community
United Kingdom
1077 Posts
 Posted 02/08/2009  07:20 am  Show Profile   Bookmark this reply Add QuickSilver to your friends list
I've used excel for years and it is still my main piece of software for recording my collection. It's so much more versatile than proprietary software. You can do so much with it using formulas and so on.

I have, however, just started playing around with MS access. This is better for having a one page per coin type of record including photos of obverse and reverse etc. In fact it's excellent.

And you can import your data from excel "fairly" easily. Takes a little learning though!
Valued Member
United States
104 Posts
 Posted 02/10/2009  08:21 am  Show Profile   Bookmark this reply Add MArainman to your friends list
Hey. Check out this topic. I left a link to the MS Access database I made.

https://goccf.com/t/41627
Pillar of the Community
United States
1745 Posts
 Posted 02/10/2009  09:24 am  Show Profile   Bookmark this reply Add The_Duke to your friends list


Quote:
I put together a sample spreadsheet here that will update your price list

http://www.mediafire.com/?sharekey=...75f6e8ebb871


kceb10,

Your link didn't work. I would like to update my spreadsheet to do this too. Can you send me the link?
Valued Member
United States
227 Posts
 Posted 04/10/2009  3:37 pm  Show Profile   Bookmark this reply Add coinsrus to your friends list
For pics you can have a OBV column and REV column write the abbreviation highlight then insert hyperlink. Put all your photos in one folder for convenience. You then can click on the link and it will pull up the pic if you need it tedious process, but might be worth it for higher priced coins or something.
Valued Member
United States
177 Posts
 Posted 01/09/2010  12:34 am  Show Profile   Bookmark this reply Add ClearwaterCoins to your friends list
I am using Exact Change version 3.8.4.80; I really think it is a worthwhile program. Very easy to use, very intuitive controls etc. It's reports feature is great and customizable. I am still in the process of adding my coins and this will take a considerable amount of time but I think it is great overall. I have used Coin Manage and other program in the past. Coin Manage is a nice program but I would only caution you about changing the coins they have already in their database. I deleted several coins and moved coins from one category to another. Then I did there update and it re-added the coins that I deleted and or moved. So all the time I spent getting the database the way that I wanted it was lost. I have also tried Coin Collector's Assistant Plus (Carlisle Development Corp) but I found that it had a very large learning curve.

Exact Change comes on a DVD, primarily because the program contains over 21,000 images. It is suited for both U.S. and World coin collections.

Exact Change has the capability of its users adding categories and customs reports (along with many pre-defined ones). It has all the bells and whistles of the major programs plus more.

To top it all off Exact Change has customer service that I believe is second to none. They answer your questions promptly and usually the next day. They have frequent updates which by the way are FREE forever! They are also very receptive to their customers suggestions for improving the software. At $79.95 including free updates I don't believe there is a more reasonably price Coin Collecting Software program out there. Recently Wildman Software (Exact Change) signed an agreement with Krause Publications authorizing Wild Man Software to include KM numbers in the Exact Change database. Exact Change is the only software package for coin collectors that is currently authorized to include these catalog numbers.


Wildman Software has also recently released a feature called ebooks. This feature allows users who have the Krause Publications Standard Catalog of World Coins on DVD. They can view the catalog right in Exact Change. When you click on a coin type, Exact Change takes you right to the correct page in the correct catalog. It doesn't go just to the country, it goes right to the page on which that particular coin type is listed!
The next version of the software will also allow you to track your paper money collection. This is a great feature for those of us that collect both coins and paper money.

Give Exact Change a look, I don't believe you will be disappointed but you will have a little less money in your wallet. Also they now have a trial version that you can download to try for free. Website http://www.exactchange.info/Downloads.htm
Bedrock of the Community
United States
14454 Posts
 Posted 01/09/2010  03:01 am  Show Profile   Bookmark this reply Add Bryan1315 to your friends list
this was posted by a member awhile back, it has US Coin Excel templates and world coin templates also that you can download http://typesets.wikidot.com/free-coin-templates
Page 2 of 2   Previous TopicReplies: 18 / Views: 5,264Next Topic Page 2 of 2
First Page  Showing last 15 replies.
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.38 seconds to rattle this change. Forums