I'm wanting to keep track of my cards with Excel, but I'm not sure how to go about. If you could show me some screenshots of yours or give me some tips on how to do so that would be great.
Liam, if are you wanting to use excel more for electonically storing a collection list rather than listing out collection values I would consider using Word instead. Way more user friendly or that type of thing.
If I buy a complete set, It's really easy to use the 'fill' tool, that way you don't have to type out each card # one by one. I'm that bad, I have one speadsheet for each letter of the alphabet, grouped by surname. (Probably a good thing, with nearly 120,000 cards to list)
I don't know how to post a screenshot, but I'll give you an example :
The Columns are headed :
Player, Team, Year, Set, Type, Card#
Here's 3 consecutive rows :
Jackson, Bo | Royals | 1987 | Fleer | Common | 369
Jackson, Bo | Royals | 1987 | Topps | Common - Future Star | 170
Jackson, Bo | Royals | 1988 | Donruss | Common | 220
And it goes on...
and on...
and on...
Well, you get the picture
It sounds like it would take a long time, but since I started it in the early 90's, when I had less than 5000 cards, it's been easy to keep it going. Just as long as you can keep adding your new cards in as soon as you get them, you'll have no trouble at all.
As I was saying earlier, the 'fill' tool is really helpful.
When I bought the complete set of 2012 Topps Update Baseball series, I knew there would be 330 cards in total, so I filled out 2 rows worth of this : 2012 | Topps Update | Common | 1
2012 | Topps Update | Common | 2
Then i just 'filled' that all the way down to row 330, so all i had to do was get the checklist, and input the player names and team names.
Hope this can inspire you to do the same thing I do!
Let me know if you want me to email you any of the spreadsheets i've made, just for fun.
There's a lot of cool stuff you can do with Excel for keeping track of yours cards.
One thing is, if you know the print run, or checklist of a team, set, or player, etc you can then use that and a filter (Have/Want) to work out what % you have, etc. You can then break them down into years of release, etc, etc. Works well for working out your wantlist as well!
^ Side note Nick, WOW 115,000+ baseball cards, OMG!!!
If I buy a complete set, It's really easy to use the 'fill' tool, that way you don't have to type out each card # one by one. I'm that bad, I have one speadsheet for each letter of the alphabet, grouped by surname. (Probably a good thing, with nearly 120,000 cards to list)
I don't know how to post a screenshot, but I'll give you an example :
The Columns are headed :
Player, Team, Year, Set, Type, Card#
Here's 3 consecutive rows :
Jackson, Bo | Royals | 1987 | Fleer | Common | 369
Jackson, Bo | Royals | 1987 | Topps | Common - Future Star | 170
Jackson, Bo | Royals | 1988 | Donruss | Common | 220
And it goes on...
and on...
and on...
Well, you get the picture
It sounds like it would take a long time, but since I started it in the early 90's, when I had less than 5000 cards, it's been easy to keep it going. Just as long as you can keep adding your new cards in as soon as you get them, you'll have no trouble at all.
As I was saying earlier, the 'fill' tool is really helpful.
When I bought the complete set of 2012 Topps Update Baseball series, I knew there would be 330 cards in total, so I filled out 2 rows worth of this : 2012 | Topps Update | Common | 1
2012 | Topps Update | Common | 2
Then i just 'filled' that all the way down to row 330, so all i had to do was get the checklist, and input the player names and team names.
Hope this can inspire you to do the same thing I do!
Let me know if you want me to email you any of the spreadsheets i've made, just for fun.
Oh yeah, I forgot to mention, the rows in bold means it's part of a multi-player card. In the 'Card Type' column, every insert has a * after the title, and every parallel has a (P) after the title.