Friday, August 9, 2019

Figuring out exactly how many cards I've scanned

A couple of days ago, I filled up the cases that comprise a "wave" of scanning. Since then, I've been entering them into my Excel charts where I track what I've got of each person.

While I do have a chart of what I have overall for each person, and one for each sport, I've never tied it together and figured out everything...although it turned out to be super easy, since all I had to do was type it up and let Excel do the math. Total time to figure out this information? About 10 minutes spread out over the course of the past week, as I created it before I typed in NASCAR, NHL or NBA for the this wave. Now I wish I had thought to do it sooner- and keep much better records. It would have been so cool if I had done it right, right from the beginning. You can see I got better with the record keeping in 2018. Not a coincidence, as I finished scanning what was needed for the Database in December 2017 and thus had more time to work on my various Excel projects.

I'm glad that I thought to create this at this wave, because it's the wave where I hit the 10 year anniversary in my scanning project. And I'm very clearly now in the home stretch. I hit 70,000 NBA card scanned in this wave, and then some, meaning I "only" have about 21,000 cards left ahead of me. NHL still has a ways to go and NASCAR is only about 2000 away from completion. Non-sport still needs a lot of work because I did not count the cards that are not fully scanned- the ones I did the fronts of, only poorly, back around 2010-11. They won't get counted (or uploaded to the Cardboard History Gallery) until I either fix the scans I made, or, if they are too terrible, rescanned.

This is the first time I've ever figured out how many non-people non-sports cards I've scanned. I thought it would be more. I got this number by going through my scans and adding the total number of files in the albums, then subtracting out the number of cards that were listed as people cards. That's certainly not a foolproof way to do it- I surely lost some scans when my remote hard drive crashed that never had a chance to be put in the right place, and I may have made some mistakes in sorting the fixed vs to be fixed files (scans), so at some point- possibly not soon- I will need to get them all out, sort them, and recount them. I am considering pulling them out and sorting them NOW, but I am not sure I can find them all right now. I am really dubious of the number and want to know what it really is. So...I might be working on that soon. Perhaps as soon as tonight. Or I might wait until I finish scanning everything and sort everything back together. More likely to be done soon, though. If I can find everything...I really do want to do it though, because I would create the usual Base/Parallel/Insert/etc charts that I have for all my people cards and should have created for my non-people cards in the first place. I'll have to see if I can get my brother to help me get them out.

It was also the first time I added up all the other sports, and the other basketball as well- that is, International leagues, CBA and of course the Harlem Globetrotters.

I do still have to enter this entire 15th wave into my overall person chart, but that shouldn't take me all that long, since I don't have to sort anything. Just type the numbers in. I expect that to take me an hour or two, so I should get it done tonight.

I hope I remember to enter the next wave into the chart when I finish it. I finish about 2 waves per year, and I probably won't get another wave ready to be entered until sometime in later winter or spring 2020. Hopefully by writing about it I'll remember.


  1. I can't even imagine scanning the amount of cards that you have, or the records that you've kept track of. Keep it up, and I hope all goes well as you keep working on it.

    1. I just wish I could do it as well as I make it seem like I'm doing it, LOL! I truly love's really enjoyable to me. I have not done any this month (and am still a few days away) and I truly miss it. I didn't do any real card stuff this weekend, but for good reason, all family visits.

  2. It's crazy the amount of cards you've scanned. It hurts my head even thinking of it.