| Author |
 Replies: 18 / Views: 5,258 |
|
Valued Member
United States
129 Posts |
Ok not sure if I'm posting this in the right section, if I'm not, moderators- please move it or PM me lol.
Anyway the question is what is the best software to have so you can keep track of the coins you have?
[red]Moved to Software forum[/url] Edited by Sap
02/08/2009 07:32 am
|
|
|
|
Valued Member
United States
81 Posts |
excel spread sheet is what I use
|
|
Pillar of the Community
United States
671 Posts |
I think most people here, myself included, use MS Excel for this purpose.
|
|
Bedrock of the Community
United States
19935 Posts |
Excel...the price is right!
|
|
Pillar of the Community
United States
819 Posts |
is there any way to post an image/photo in an excell cell?
|
|
Valued Member
United States
377 Posts |
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
 United States
187702 Posts |
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 |
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/14678Edited by hawkeye
02/07/2009 11:38 pm
|
|
Bedrock of the Community
United States
19935 Posts |
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.xlsLincoln 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 |
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 |
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=...75f6e8ebb871Edited by kceb10
02/08/2009 02:02 am
|
|
Bedrock of the Community
United States
19935 Posts |
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.
|
|
Bedrock of the Community
United States
19935 Posts |
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.xlsLincoln Cent Lover!VERDI-CARE™ INVENTOR https://verdi.care/
|
|
Pillar of the Community
United Kingdom
1077 Posts |
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 |
|
|
Pillar of the Community
United States
1745 Posts |
|
| |
Replies: 18 / Views: 5,258 |
Posted 02/07/2009 9:43 pm
