User Tag List

  • Amused
  • Angry
  • Annoyed
  • Awesome
  • Bemused
  • Cocky
  • Cool
  • Crazy
  • Crying
  • Down
  • Drunk
  • Embarrassed
  • Enraged
  • Friendly
  • Geeky
  • Grumpy
  • Happy
  • Hungry
  • Innocent
  • Meh
  • Piratey
  • Sad
  • Shy
  • Sneaky
  • WTF!?
  • zzz
  • Results 1 to 18 of 18
    1. Back To Top    #1
      Ultimate VIP Member
      Life is Good
       
      Mood:
      Happy
       
      Davey Crockett's Avatar
      Join Date
      Apr 2015
      Location
      Boondocks
      Posts
      6,213
      NDA Points
      99,051
      NDA Level
      100
      Report Entries
      1
      Thumbs Up
      Received: 4,860
      Given: 4,829

      Spreadsheet question

      I'm wondering if any of you know of a windows compatible spreadsheet that would work good to inventory coins. I'd like to find one with some artificial intelligence type of thingy that I can just type date and series letter and it will automatically categorize it within the series along with the duplicates. I'm ok spending a few bucks if it will do what I want it to but freebies would be even better. Thanks.

      0 Not allowed!
      Life is Good

    2. Back To Top    #2
      Ultimate VIP Member
      No Current Status
       
      Mood:
      ----
       
      guywhofishes's Avatar
      Join Date
      Apr 2015
      Location
      Faaargo, ND
      Posts
      13,321
      NDA Points
      460,920
      NDA Level
      100
      Report Entries
      2
      Thumbs Up
      Received: 20,232
      Given: 17,675
      I'd take photos, then name the photo with a system such as Dime_1973_S_Blah_bla.jpg

      Then, in any modern windows file browser, you could see all your dimes (and how many) by searching the coin photo folder with "Dime_"

      You could see every dime from 1973 by searching with "Dime_1973"

      If you have dupes - every time a new one comes along you add a roman numeral to the end. If you already own it it will ask you if you want to overwrite the old file. Then you'd know you need to add another roman numeral to your new coin.

      I'm sorta lazy - so that's how I'd do it. Ha ha. How many coins? If just 100s then this'll work great.

      0 Not allowed!
      If people concentrated on the really important things in life, there'd be a shortage of fishing poles.
      ~Doug Larson

    3. Back To Top    #3
      Ultimate VIP Member
      No Current Status
       
      Mood:
      ----
       
      Allen's Avatar
      Join Date
      Apr 2015
      Location
      Lincoln, kinda...
      Posts
      4,429
      NDA Points
      77,180
      NDA Level
      100
      Report Entries
      11
      Thumbs Up
      Received: 5,271
      Given: 2,101
      I would use Excel if it were me, but that's just personal preference.

      You might be plenty happy with Google Sheets, though.

      0 Not allowed!
      "Suppose you were an idiot, and suppose you were a member of Congress; but I repeat myself." Mark Twain, speaking on Congress.

    4. Back To Top    #4
      Premium Member
      No Current Status
       
      Mood:
      ----
       

      Join Date
      Jul 2015
      Posts
      634
      NDA Points
      18,185
      NDA Level
      58
      Report Entries
      2
      Thumbs Up
      Received: 288
      Given: 43
      I would just use the filter and sort functions in excel. Create headers across the top for the various categories (series, year, etc.), and the input the data in the rows below. Then you'll be able to sort by any column and could also add filters to pull specific data from any of the columns.

      0 Not allowed!

    5. Back To Top    #5
      Ultimate VIP Member
      Life is Good
       
      Mood:
      Happy
       
      Davey Crockett's Avatar
      Join Date
      Apr 2015
      Location
      Boondocks
      Posts
      6,213
      NDA Points
      99,051
      NDA Level
      100
      Report Entries
      1
      Thumbs Up
      Received: 4,860
      Given: 4,829
      I'll have to try excel again, I used it in the past for expenses and inventory but I don't remember it jumping to the correct column when typing in the header. Last I looked some up a few years ago they weren't worth much over face value but I gave some old pennies to grandkids and they asked Alexa what they are worth and I was surprised of the collector values unless Alexa was pulling our leg. Mostly just a waste of time but I have extra during these cold months.

      - - - Updated - - -

      My goal is to not have to identify which columns and rows every time I make an entry if there is such a thing .

      0 Not allowed!
      Life is Good

    6. Back To Top    #6
      Ultimate VIP Member
      No Current Status
       
      Mood:
      ----
       
      guywhofishes's Avatar
      Join Date
      Apr 2015
      Location
      Faaargo, ND
      Posts
      13,321
      NDA Points
      460,920
      NDA Level
      100
      Report Entries
      2
      Thumbs Up
      Received: 20,232
      Given: 17,675
      Davey, working with Tables is what you need to do it with Excel. Watch some videos about searching/sorting Tables (vs cells)

      https://support.microsoft.com/en-us/...9-6c94334e492c

      0 Not allowed!
      If people concentrated on the really important things in life, there'd be a shortage of fishing poles.
      ~Doug Larson

    7. Back To Top    #7
      Ultimate VIP Member
      Life is Good
       
      Mood:
      Happy
       
      Davey Crockett's Avatar
      Join Date
      Apr 2015
      Location
      Boondocks
      Posts
      6,213
      NDA Points
      99,051
      NDA Level
      100
      Report Entries
      1
      Thumbs Up
      Received: 4,860
      Given: 4,829
      Quote Originally Posted by guywhofishes View Post
      Davey, working with Tables is what you need to do it with Excel. Watch some videos about searching/sorting Tables (vs cells)

      https://support.microsoft.com/en-us/...9-6c94334e492c


      Thanks, I'll give it a whirl.

      0 Not allowed!
      Life is Good

    8. Back To Top    #8
      Ultimate VIP Member
      No Current Status
       
      Mood:
      ----
       

      Join Date
      May 2016
      Location
      North Dakota
      Posts
      1,547
      NDA Points
      9,597
      NDA Level
      42
      Thumbs Up
      Received: 1,836
      Given: 669
      Classifieds
      1
      I've never been very good at a hobby related to collecting anything. I've often wondered how many dollars at today's values I've gone through using baseball cards in the spokes of my bike when young so it sounded like a motorcycle. Pretty sure I shredded some that would be worth something today. No patience was probably my biggest drawback.

      1 Not allowed!

    9. Back To Top    #9
      Ultimate VIP Member
      No Current Status
       
      Mood:
      ----
       
      Allen's Avatar
      Join Date
      Apr 2015
      Location
      Lincoln, kinda...
      Posts
      4,429
      NDA Points
      77,180
      NDA Level
      100
      Report Entries
      11
      Thumbs Up
      Received: 5,271
      Given: 2,101
      I am sure not a coin collector of anything worthwhile, but might I suggest a workbook containing an individual worksheet for each denomination? Cents in one worksheet, nickels in another, dimes, etc, etc. That way you would simply open up the Excel file, click on the tab for the respective denomination, and enter the details under some column headers that you choose. I don't know how Excel would be able to auto-fill any of the respective cells for you though, that seems like it would need to be able to read the coin.`

      Column headers could even be frozen so you can scroll around and still see the headers if you have enough of a given denomination.

      Maybe go something like "year", "mint", "condition", "est value"?

      I don't know, just kinda spitballing here.

      1 Not allowed!
      "Suppose you were an idiot, and suppose you were a member of Congress; but I repeat myself." Mark Twain, speaking on Congress.

    10. Back To Top    #10
      VIP Member
      No Current Status
       
      Mood:
      ----
       
      Sluggo's Avatar
      Join Date
      May 2015
      Location
      Bismarck
      Posts
      1,166
      NDA Points
      132,635
      NDA Level
      100
      Report Entries
      18
      Thumbs Up
      Received: 1,938
      Given: 2,508
      I have a couple jars of old coins. I imagine my kids will get them some day, will take them to the bank, pour them in the change counter machine and get face value for them.

      1 Not allowed!

    11. Back To Top    #11
      Premium Member
      No Current Status
       
      Mood:
      ----
       
      Wirehair's Avatar
      Join Date
      May 2015
      Location
      Bismarck
      Posts
      257
      NDA Points
      13,279
      NDA Level
      49
      Thumbs Up
      Received: 250
      Given: 818
      I have used Excel as well for organizing a coin collection. Found it helpful to have columns for mint location (D, etc.) as well as general condition. I organized a coin collection that I had received from a family member. I sort the list by coin type/ denomination. Have found it helpful when visiting with folks at coin shows and dealers. Condition is everything in any collection, but we are lucky enough to have a few 1909-S VDB Lincoln pennies etc which tends to get good discussion started. Excel worked well for me.

      1 Not allowed!
      Wirehair

    12. Back To Top    #12
      Premium Member
      No Current Status
       
      Mood:
      ----
       
      Shockwave's Avatar
      Join Date
      Sep 2015
      Location
      Bismarck
      Posts
      280
      NDA Points
      27,166
      NDA Level
      72
      Report Entries
      1
      Thumbs Up
      Received: 285
      Given: 50
      Quote Originally Posted by Sluggo View Post
      I have a couple jars of old coins. I imagine my kids will get them some day, will take them to the bank, pour them in the change counter machine and get face value for them.
      My Dad just gave me a bunch of coins that belonged to my Grandpa. There's some early 1900 coins in there and I've thought about taking them somewhere to get a value on them. I think the earliest was 1914 or something like that.

      0 Not allowed!

    13. Back To Top    #13
      Premium Member
      No Current Status
       
      Mood:
      ----
       

      Join Date
      Jan 2016
      Location
      NW ND
      Posts
      391
      NDA Points
      12,236
      NDA Level
      47
      Report Entries
      1
      Thumbs Up
      Received: 529
      Given: 1,299
      Quote Originally Posted by Shockwave View Post
      My Dad just gave me a bunch of coins that belonged to my Grandpa. There's some early 1900 coins in there and I've thought about taking them somewhere to get a value on them. I think the earliest was 1914 or something like that.
      Sluggo & Shockwave,
      My Dad had a pretty extensive coin collection that he worked on for years. I'm thinking since the early 70's. All his coins were kept in the coin books. I know pretty much nothing about it. He left it to my brother and myself. We haven't done anything with it at all. Not even dug them out and looked or even discussed what to do with them. No one in the immediate family collects coins. My question is, what the heck should a guy do or how to even start to figure out if it's worth anything??? Someone whose more in the know about this stuff and can give us a clue on how to start and with someone we can trust. Thanks
      Fish On!

      0 Not allowed!

    14. Back To Top    #14
      Premium Member
      No Current Status
       
      Mood:
      ----
       
      Shockwave's Avatar
      Join Date
      Sep 2015
      Location
      Bismarck
      Posts
      280
      NDA Points
      27,166
      NDA Level
      72
      Report Entries
      1
      Thumbs Up
      Received: 285
      Given: 50
      [QUOTE=TFX 186;339739]Sluggo & Shockwave,
      My Dad had a pretty extensive coin collection that he worked on for years. I'm thinking since the early 70's. All his coins were kept in the coin books. I know pretty much nothing about it. He left it to my brother and myself. We haven't done anything with it at all. Not even dug them out and looked or even discussed what to do with them. No one in the immediate family collects coins. My question is, what the heck should a guy do or how to even start to figure out if it's worth anything??? Someone whose more in the know about this stuff and can give us a clue on how to start and with someone we can trust. Thanks

      We have an Antique coin place here in Bismarck. I have been thinking about taking them there to see if they can give me a general idea of what I have.

      1 Not allowed!

    15. Back To Top    #15
      VIP Member
      No Current Status
       
      Mood:
      ----
       
      Sluggo's Avatar
      Join Date
      May 2015
      Location
      Bismarck
      Posts
      1,166
      NDA Points
      132,635
      NDA Level
      100
      Report Entries
      18
      Thumbs Up
      Received: 1,938
      Given: 2,508
      Quote Originally Posted by TFX 186 View Post
      Sluggo & Shockwave,
      My question is, what the heck should a guy do or how to even start to figure out if it's worth anything??? Someone whose more in the know about this stuff and can give us a clue on how to start and with someone we can trust. Thanks
      Fish On!
      I bought a book 20 years ago that had current prices for coins so I could look up a coin's value. The book is outdated now, of course, and we have the internet now. I would probably take, say 20 of the coins I think might be worth the most, to the Coin place in the Kirkwood mall as Shockwave suggested, and let them price them. If that goes well, you could always take more in after that. Nothing I have seems to be worth a whole lot. I actually stumbled across a 1905 indian head penny not that long ago and thought for sure that would be valuable. I did a little research and I am not going to get rich off of it. It's one of those things where it's only worth what you can find someone to pay.

      1 Not allowed!

    16. Back To Top    #16
      Bronze Member
      No Current Status
       
      Mood:
      ----
       

      Join Date
      Sep 2015
      Posts
      32
      NDA Points
      4,938
      NDA Level
      29
      Thumbs Up
      Received: 15
      Given: 0
      My dad sold some of his coins to a coin store in Bismarck before he passed away. I don't know the name, but he was happy working with the guy. I have the rest of his collection, which is huge, and I have been thinking about contacting the guy or possibly have a coin auction. I will check with my mom to see if she knows the name.

      1 Not allowed!

    17. Back To Top    #17
      Premium Member
      No Current Status
       
      Mood:
      ----
       

      Join Date
      Jan 2016
      Location
      NW ND
      Posts
      391
      NDA Points
      12,236
      NDA Level
      47
      Report Entries
      1
      Thumbs Up
      Received: 529
      Given: 1,299
      Quote Originally Posted by Davey Crockett View Post
      Thanks, I'll give it a whirl.
      Sorry to hijack your thread Davey.
      I messed around with excel spreadsheets enough to know I sucked at it and I found someone who could set up the sheet exactly how I wanted it....... and they made it look easy!
      Good luck Davey
      Fish On!

      0 Not allowed!

    18. Back To Top    #18
      Ultimate VIP Member
      Life is Good
       
      Mood:
      Happy
       
      Davey Crockett's Avatar
      Join Date
      Apr 2015
      Location
      Boondocks
      Posts
      6,213
      NDA Points
      99,051
      NDA Level
      100
      Report Entries
      1
      Thumbs Up
      Received: 4,860
      Given: 4,829
      Quote Originally Posted by TFX 186 View Post
      Sorry to hijack your thread Davey.
      I messed around with excel spreadsheets enough to know I sucked at it and I found someone who could set up the sheet exactly how I wanted it....... and they made it look easy!
      Good luck Davey
      Fish On!

      No hijack TFX , all good information. I'm a dummy when it comes to computer and software language. I used excel for business and didn't understand what table was by name but it's how I did my bids and invoices , only I did everything the hard way. I learned a bunch in the vids I watched on youtube , mostly time saving shortcuts. Also watched a couple vids on software for coin collectors that I'll learn more about. the ones I watched are able convert the results onto excel .

      What I was hoping for was voice command so I could be looking at the coin and verbally describe it instead of typing. I don't know how accurate Alexa is but it was pretty cool watching the grand kids get values on thier treasures in about 15 seconds , I know they would love to sit down with a spreadsheet and ask Alexa the values.

      2 Not allowed!
      Life is Good

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  


    About Nodak Angler

      NodakAngler is a community of outdoors enthusiasts. Our primary focus is to provide a great place for North Dakota sportsmen to gather, discuss, and participate. All are welcome.

    Business & Contact

    Follow us on

    Facebook Instagram Twitter YouTube