Coin inventories

Discussion in 'Coin Chat' started by John Skelton, May 26, 2021.

  1. John Skelton

    John Skelton Morgan man!

    When I started collecting back in the Dark Ages, I bought a little book that let me simply put a check in a box for the grade I thought it was. That was all the information it allowed.

    Since then, I got a nice app that let me put a lot of helpful info into it, but it still had some limitations. I also had bought a program for my laptop, but it proved to be clunky. So now I'm looking at creating my own custom spreadsheet.

    How many of you have made your own spreadsheet for your coins?
     
  2. Avatar

    Guest User Guest



    to hide this ad.
  3. SensibleSal66

    SensibleSal66 U.S Casual Collector / Error Collector

    Just written a crummy notebook is all I've gotten . There is a Program I've been wanting to try on another site .... I'l let ya know what the program is when I check it out . ;)
     
  4. expat

    expat Remember you are unique, just like everyone else

    If you want a plain front end database. Excel is just fine. Create your headings and fill in the rows. Right click on a cell and you can include additional info and a shortcut to an image or images. This appears when you hover the mouse pointer over the cell.
    If you want a relational database where you can group and sort by query tables then Access is required, but it is a steeper learning curve.
     
  5. Dave Waterstraat

    Dave Waterstraat Well-Known Member

    Mine is a simple Excel spreadsheet.
     
  6. Beefer518

    Beefer518 Well-Known Member

    Same as above.

    There are a couple of coin inventory spreadsheets online that are free, and you can modify them to your liking. That's where I started.
     
  7. PennyGuy

    PennyGuy US and CDN Copper

    I started out with Lotus123 then moved that to Excel where it sits currently. The main file resides on my desktop computer and I email it to my self so I can have a current copy on my iPad and phone.
     
  8. John Skelton

    John Skelton Morgan man!

    I should have looked there to see what there was. I'm going to see what works for me.
     
  9. Mountain Man

    Mountain Man Well-Known Member

    And you're not going to share? Shame on you. LOL

    Like many others, I have a self designed Excel spreadsheet.
     
  10. Publius2

    Publius2 Well-Known Member

    Excel spreadsheet. You can customize and change however and whenever you want. Mine is shown for a portion of my Capped Bust Half Dimes. The Comment column is as long as you want to make it and can contain whatever information that doesn't fit the defined column categories.

    Each of my collections is a separate page in one Excel file so everything is in one place. Each page is customized to that particular collection.

    upload_2021-5-26_14-59-45.png
     
  11. GH#75

    GH#75 Trying to get 8 hours of sleep in 4. . .

    I made a spreadsheet with a whole bunch of coins in it. Around 1500 have been put in so far. Although, it will take forever to finish it. I have thousands of coins.
     
  12. Dave Waterstraat

    Dave Waterstraat Well-Known Member

    Lotus 123 is showing your age now..:p
     
  13. Randy Abercrombie

    Randy Abercrombie Supporter! Supporter

    You guys are making me feel horribly disorganized. And that doesn’t suit my nitpicky standards very well.
     
  14. John Skelton

    John Skelton Morgan man!

    Yes, I'm looking to make my own spreadsheet, but I'm also going to look at the ones I found online. I don't have Excel but I do have Open Office, but I might find MS Works spreadsheet easier to work with.

    What columns do you have?
     
  15. John Skelton

    John Skelton Morgan man!

    Actually, the name of the app is Coin Collection. I used it on my Kindle, but didn't take in account that every entry ate up memory. So the memory filled up and that Kindle is a doorstop. I can pull data off it, but I can't port it into my new Kindle.

    I also lost access to all the coin related bookmarks I had, but over the next few months lurking around here managed to reclaim them all, thanks to everyone here!
     
  16. MIGuy

    MIGuy Well-Known Member

    I'm lame, I moved from a note pad last year to a Draft email in my yahoo account that I update whenever I get a new coin and sometimes print it off and mark it up - slabbed go in one of the PCGS or Intercept boxes and raw go into flips and boxes but are not broken out by boxes yet, just under the general heading "raw". The sad thing is I'm fine with Excel and have the latest version of Office, lol. On the plus side my system is super easy.
     
  17. PennyGuy

    PennyGuy US and CDN Copper

    LOL I thought about that when I wrote it. What I didn’t say is that the computer was an IBM running DOS 1.0. But it has a Hugh 10 Meg hard drive!
     
Draft saved Draft deleted

Share This Page