Massive Player Collections

[doug.goodman]

Use excel.

My Topps cards file has 12 worksheets, a couple of them have nearly 30,000 lines of info (one for each card), with as many as 12 columns of info per card I make changes to it in moments.

I have various other files helping me to keep track of various things, and all of them have multiple pages with many thousands of rows.

Sounds like "Numbers" isn't much of a spreadsheet program.

Doug

[Julz24]

No, its actually amazing but it isn't built for large amounts of data. The problem is definitly made worse by the size and amount of images in my file.

So do you have photos in Excel?

I've been researching databases like Filemaker and Bento only because they will accept an import from my Numbers file. I have tried exporting from Numbers to Excel and the text moves over fine. But the photos won't go.

[doug.goodman]

I don't have photos in my files, I keep them separate,

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.

Doug

[Julz24]

Originally Posted by doug.goodman

I don't have photos in my files, I keep them separate,

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.

Doug

Ok, so all your photos ate stored separately. That's helpful in that I want to keep both photos and text together.

As far as the Numbers spreadsheet: I can only relay what Apple told me... Spreadsheets are basically for sorting ,organizing and number manipulation. Anytime one is dealing with massive amounts of information, a database is necessary.

Either way, there's no doubt Excel is superior between the two of them.

[Zach Wheat]

I mainly a set collector but also have a side collection of Mantle cards. I don't collect modern Mantle cards so the card management issue isn't too significant. I keep my cards stored graded by year in an ammo box which is water and fire resistant in a secure spot.

I keep digital images of each card on my PC staing year, maker, name, grade, price, description. I use the same format for name each picture for each photo. This makes it easy to sort and find what I am looking for.

I have started but not completed using ACT database to sort and catalogue cards and images. I imagine using Access would have worked the same but am familiar with ACT.

Z Wheat

[bsuttonosu]

Originally Posted by doug.goodman

I respectfully disagree that a spreadsheet / data base program can qualify as "amazing" if it's not built for large amounts of data. Seems to me that large amounts of data are the main reason for those programs to exist.
Doug

Agree with Doug, but I think it's the images weighing down your file not the data elements. Spreadsheets aren't made to handle image storage. Also, and I don't know the technical aspects of it, but functionally Apple products are not built the handle spreadsheets the same way. I have both Apple and PC computers and work with spreadsheets alot. The PCs are always faster with them.

I use an Excel spreadsheet for my lists but I don't store images of everything.

[brookdodger55]

I have a massive collection of 1800 Mike Piazza cards , I use excel spread sheet
with. pictures of each card. I used what is called the cell hovering technique.
You place the mouse over the corner of he cell (small ear flap in corner and picture appears, double click it disappears. Using office Xp for many years and have never had a performance problem with excel with a massive amount of pictures.
Mike

[JLange]

With regard to displaying the cards, I am a big fan of using card saver 1s and placing them in 4 pocket sheets (postcard size pockets) the card savers easily slip in with a little room to spare,but don't slip around or turn in the pockets. This is the best of both worlds because you can put roughly 240-250 cards in a binder (single sided) but then easily remove ones you want for some other project, and they are always protected. It beats keeping the in a box.

[brookdodger55]

Never thought of that, great idea thinking about doing that with my 1952-57 Brooklyn dodgers team sets, that solves the problem of the sheets fitting the
52-54's.
Mike

[brewing]

Originally Posted by brookdodger55

I have a massive collection of 1800 Mike Piazza cards , I use excel spread sheet
with. pictures of each card. I used what is called the cell hovering technique.
You place the mouse over the corner of he cell (small ear flap in corner and picture appears, double click it disappears. Using office Xp for many years and have never had a performance problem with excel with a massive amount of pictures.
Mike

Never knew this. Absolutely love this method. Thank You

[Julz24]

The cell hovering technique is definitely intriguing. I'm not that savvy with Microsoft Excel yet but I have started the research process. I've also heard about hyperlinking the photos to the spreadsheet as well as inserting images into a comment box, (which may or may not be the same as cell hovering)??

I wonder if cell hovering will decrease the size of the saved file? If it does, that might help increase my speed.

This weekend I'm planning on downloading Griffeys entire card checklist from Beckett. Apparently you have to subscribe to Beckett for at least one month in order to save the checklist as a pdf or download it into Excel. I think for nine bucks it's worth it. He has over 14,000 baseball cards so it might take a minute!