,
 



PMG is the Official Grading Service of the Paper Money Forum
,
Dollarsavr

I have a second question that I would like this community to offer comments/opinions about.

I wish to establish my MS-excel spreadsheet Currency/Coin collection-data list to include scans of notes/coins. Can anyone help me with this project or offer names of software programs that already exist with this capability in it. Comments are appreciated.

Thanks, and you can also PM me for anonymity. dollarsavr@aol.com

SPMC  2676  PMCM  1116
Quote 0
 
MEC2
Currency Manage - I'd avoid Excel. It's not designed for this and will eventually become problematic as the spreadsheet gets larger with integrated images and such.
Quote 0
jdizzle
I agree with @MEC2...that would be problematic with Excel...I wouldn’t recommend going down that path. I don’t use any specific vendor solution for inventory tracking, so i can’t comment there. I’m still old school and had an Excel spreadsheet, but without pictures. 
Enamored with VF-35 and lower grade PPQ/EPQ notes!
Quote 0
Dan Cong

I use excel, but not images in it for currency. I have each registry set on a page with added column for cost and any notes or comments. this is not good for all notes I own. Only the top note for that FR#

I just Store pictures on hard drive with labels. However - if one has 500 1935 silver certificates, that might not work well. 


both are backed up to cloud. 


so it might depend on how many and what type you have, and how granular you want to
be. 


if I were a dealer, I’d use a database. That way you can have thousands of individual entries and create reports etc. 

in any case - you need to enter the data. You want something you can easily enter the data. What data is important to you ? Think about how you will use it and what you want out of it to determine how complex you want it. 

 

Quote 0
MEC2
Here's the link to CurrencyManage. No need to reinvent the wheel...

https://www.libertystreet.com/USA-Paper-Money-Software.htm
Quote 1
Dan Cong
That looks pretty complete. What info on nationals is there ? Anything like Kelly’s book ? 
Quote 0
MEC2
I use it for my entire collection. You can add your own data and categorizations. If you wanted to add other countries, you can. That part of it takes a little learning but once you play with it you figure it out. My entire collection is in it. And my entire collection spans almost everything - colonials, fractionals, obsoletes, large size, small size, nationals, confederate, world notes... I've had to add all of the world notes in the Type/Varieties area myself. But it has a good template once you add the country, type, denomination - if has fields for the Pick number and such.

It's not perfect, but it's good and not expensive. Best $40 I think you can spend. It also does a good job on holding your images, up to four per note.

On nationals it has a fairly complete list of charters and once you enter the charter it will pull up the (original, likely) bank name, city, and state, and display the year it was chartered. That's it though, it isn't a resource with things like outstanding population. But you can add all major types. And the pricing guide is like most of them - never up with the times. But you can record how much you paid, and change what it's worth yourself.

Strongly recommended.
Quote 1
Dollarsavr
First, I would like to Thank you all for the comments. They have given me insight. However, I do use excel for my collection and it does not cover many denom's or much other than the $1 & $2 FRN's that I have worked on for years. I let most, if not all of the other stuff go earlier in life.
Again Thank You all for the insight.
SPMC  2676  PMCM  1116
Quote 1
postalnotes
@Dollarsavr
If you intend on staying with Excel, you can place photos of your notes in a folder and embed a link to each photo in a corresponding cell in the spreadsheet. (Make sure you don't move or rename the folder after linking.) The only problem/annoyance I discovered was when I brought up the image, I could use the image viewer to move to other images in the folder. I did not like that  if there were images of multiple notes in the folder, but was OK as long as I knew not to browse to next photos.  You could avoid this by creating a folder for each note and placing only photos of that note in the folder. This could get cumbersome for a large collection though.

I'd avoid embedding the photos directly in the spreadsheet because it becomes too difficult to manage.

Good luck.

Researching United States Postal Notes 1883-1894.

Quote 0
Dollarsavr
Thanks @postalnotes   This was very thoughtful and helpful info.
SPMC  2676  PMCM  1116
Quote 0
BestestDad
Thank you for the link to Liberty Street Software. I am new to this forum but have been collecting for a few years. was looking for a way to inventory my currency. 
Quote 0
MEC2
I think you can download a free trial to see if you like it. I did and do, like I said not perfect but I know where it is, it can run alot of reports, you can run custom reports, show nationals by state, bank, city, etc... it's pretty good that way.
Quote 0
 
Forum Sponsors

 
 

,