How to organize a Player collection

excel_B · Nov 27, 2009

Good morning to y'all...

I am wondering how do you organize a specific player's collection in paper? Do you do a spreadsheet of all the cards you have? And how do you get all baseball cards of this specific player? I am curious how you the FCBers do with their own player's collection.

Any information is greatly appreciated!

Happy Belated Thanksgiving!
Bobby

cmixer · Nov 27, 2009

now that I have a high percentage; I just download the Beckett all-card checklist; and check off the ones i have -

Russ S. · Nov 27, 2009

Excel in my friend.

Have one for Ripken, and one for other O's stuff, and Prospects.

I have my Ripken set up into different tabs.

1 tab for the Premium cards. $10 and up.
2nd tab for the commons. $9 and below.
3rd tab listing doubles available for trade.
4th tab listing oddball items such as SLU's, Bradford Plates, ext.
5th tab of items sold/traded.

My Premiums colums are set up like this:

Player Year, Card Type, and Number HIGH BV Paid From
Ripken Jr., Cal '82 Donruss #405 RC $40.00 Trade ilovemesomeme

://

VizquelCollector.com · Nov 27, 2009

excel_B said:
I am wondering how do you organize a specific player's collection in paper? Do you do a spreadsheet of all the cards you have? And how do you get all baseball cards of this specific player? I am curious how you the FCBers do with their own player's collection.

I get most of the list of cards available from Beckett's website and enter them into an Excel spreadsheet. The columns I use are Year, Brand/Card, Card #, Have?, Serial #, Notes (other players, patch, auto, etc.), and book value. Cards are sorted by year then alpha by card/brand.

Fandruw25 · Nov 27, 2009

Here's how I have mine set up. I keep my auto/GU/1/1's stored seperately so thats what the type on the far left is. I also color code the gu/auto's.

subpop77 · Nov 27, 2009

I have my Frank Thomas and Ryan Sweeney both on my HP pocket pc(iPAQ). That way hen I go to a card store I can pull it up.

docdw25 · Nov 27, 2009

I use an Excel spreadsheet. Downloaded the list from beckett. I use two tabs. First tab has my collection that includes how many of each card I own and book value. Second tab is the master list from beckett.

gracecollector · Nov 27, 2009

I use Excel too. It got so long that I wanted an easy way to print it and keep it to minimal pages, so I set it up two columns. I keep a .pdf file of it online so I can access it from any internet equipped computer. I don't worry about values anymore since everything was permanent collection.

http://www.markgrace.com/museum/GRACECHECKLIST.pdf

ffgameman · Nov 27, 2009

Russ S. said:
Excel in my friend.

Have one for Ripken, and one for other O's stuff, and Prospects.

I have my Ripken set up into different tabs.

1 tab for the Premium cards. $10 and up.
2nd tab for the commons. $9 and below.
3rd tab listing doubles available for trade.
4th tab listing oddball items such as SLU's, Bradford Plates, ext.
5th tab of items sold/traded.

My Premiums colums are set up like this:

Player Year, Card Type, and Number HIGH BV Paid From
Ripken Jr., Cal '82 Donruss #405 RC $40.00 Trade ilovemesomeme

://

Dedication. I had Beckett My Collection but accidentally deleted it after the Beckett change.

Dunno if I have the patience to do an Excel inventory, especially since my cards aren't physically organized right now.

Russ S. · Nov 27, 2009

ffgameman said:
Russ S. said:

Excel in my friend.

Click to expand...

Dedication. I had Beckett My Collection but accidentally deleted it after the Beckett change.

Dunno if I have the patience to do an Excel inventory, especially since my cards aren't physically organized right now.

Yes it is. But without it, it would be really hard to keep track of what I have and I don't have.
So if I get a PM saying, do you need this or that...it's real easy to just pull it up and see if I have it.

Once you put in the hard work, it's well worth it and it's very easy to maintain.

jay1065 · Nov 27, 2009

I use Excel, as well. Everything is kept on a single sheet. Color codes: Green=Minor League Card, Yellow=Auto, Orange=GU, and Blue=GU/Auto.

Philip J. Fry · Nov 27, 2009

http://spreadsheets.google.com/ccc?key= ... KQhBX93MNQ

predatorkj · Nov 28, 2009

I have a printed list I cross items off of when I get them.Bad thing is I am too lazy to make a separate list for items that aren't on the official list(oddballs and whatnot).So I have a lot of unaccounted for items.Good part about that is for some weird reason my memory on those seems to be a lot sharper.I have a hard time remembering which cards I have but I guess since I like oddballs a lot more...I have an easier time remembering which ones I have and don't have of those.

Kudos to Russ and jay1065.Pretty cool feature you guys have showing what you paid for the item.I think that kind of info would be invaluable if someone wanted to create an actual pricing guide with 1/1's and low numbered cards included.It gets pretty crappy knowing that if you pull anything or even buy anything numbered lower than /25 that you will not have a BV or even an approximation to go by.Info like that could show what people are actually paying for these cards.It seems beckett should try to contact a few of you guys who do this because you could make their price guides a little more relevant and keep them from giving the classic "no pricing due to scarcity" copout.

pigskincardboard · Nov 28, 2009

You guys all use spreadsheets rather than databases? That's pretty interesting.

If you're collections large enough, I'd recommend spending the 5 hours it takes to get a working knowledge of SQL.

You should be able to export your collection straight into the database without any problems -- or even connect it directly to Microsoft Access (i don't really use access & excel together)

Then you're collection will be easily accessible:

SELECT * FROM RIPKEN WHERE OWNED=TRUE & GU>2 & AUTO=TRUE & BOOKVALUE > 25
(display all of the ripkens that you own, have 2 pieces of game used or more, and an auto, with a bookvalue over 25)

You can basically perform terrific searches to find stuff very quickly. In addition to that, you'd be able to connect your website to it with no problem. Then, with a couple dropdown menus, you'd be able to navigate and display your entire collection to the world!! World!

Welcome to our community

Be apart of something great, join today!

How to organize a Player collection

excel_B

Active member

cmixer

Active member

Russ S.

New member

VizquelCollector.com

Active member

Fandruw25

Active member

subpop77

New member

docdw25

Member

gracecollector

Well-known member

ffgameman

New member

Russ S.

New member

jay1065

New member

Philip J. Fry

Well-known member

predatorkj

Active member

pigskincardboard

New member

Similar threads

Members online

Latest posts