Advantages of a Spreadsheet

jefferyepayne · #1 01-18-2013, 07:31 PM

I've been using spreadsheets for years and years. I've looked at pretty much every card collecting software package out there and cannot find something that I like better. A couple of other great points about using spreadsheets:

1. I download them to my phone so I can take them to shows with me in electronic form. No more carrying around a binder full of paper sheets
2. They are automatically backed up with my backup software so there is no risk I will lose or misplace my lists
3. A large collection can be maintained easily. I put each year on a separate tab with each set of a given year on a different page within a tab
4. You can easily build summary pages that track how many cards you still need across the sets you are building

jeff

Jlighter · #2 01-18-2013, 07:33 PM

Is there some way to link cards to their scans? Or would a seperate type of software be needed?

Wayward99 · #3 01-18-2013, 07:43 PM

Quote:

Originally Posted by Jlighter

Is there some way to link cards to their scans? Or would a seperate type of software be needed?

There are a couple of ways to do this; easiest is to add a hyperlink to the location in a separate column (you could also hyperlink another field, such as your card name field). The link can point anywhere - your hard drive, thumb drive, web location, etc.

wazoo · #4 01-18-2013, 08:02 PM

Exactly. That's the way I'd do it.

Abravefan11 · #5 01-18-2013, 08:21 PM

Quote:

Originally Posted by jefferyepayne

I've been using spreadsheets for years and years. I've looked at pretty much every card collecting software package out there and cannot find something that I like better. A couple of other great points about using spreadsheets:

1. I download them to my phone so I can take them to shows with me in electronic form. No more carrying around a binder full of paper sheets
2. They are automatically backed up with my backup software so there is no risk I will lose or misplace my lists
3. A large collection can be maintained easily. I put each year on a separate tab with each set of a given year on a different page within a tab
4. You can easily build summary pages that track how many cards you still need across the sets you are building

jeff

Jeff's post sums up exactly how I use spreadsheets. I haven't found a better way, but to be honest I'm not really looking as this works really well.

wazoo · #6 01-18-2013, 11:15 PM

Quote:

Originally Posted by jefferyepayne

I've been using spreadsheets for years and years. I've looked at pretty much every card collecting software package out there and cannot find something that I like better. A couple of other great points about using spreadsheets:

1. I download them to my phone so I can take them to shows with me in electronic form. No more carrying around a binder full of paper sheets
2. They are automatically backed up with my backup software so there is no risk I will lose or misplace my lists
3. A large collection can be maintained easily. I put each year on a separate tab with each set of a given year on a different page within a tab
4. You can easily build summary pages that track how many cards you still need across the sets you are building

jeff

I use mine through Google Docs, which allows me to make a detailed spreadsheet, as well as access it from my phone and computer.

aquarius31 · #7 01-19-2013, 07:47 AM

I have been using spreadsheets for years to organize my collection and have found it to be my #1 go to resource. I've also saved it on my phone, and usb stick in case my computer dies on me.

My recommendation (and I'm sure most of you are doing this anyway) is to update the spreadsheet as soon as you receive an item. It is quite a painful task to have to go back through emails, auction sites etc. to figure out the details of a given transaction several months back. That said, if you used Paypal to purchase an item you can typically find the auction description even ones from several years back.

jefferyepayne · #8 01-19-2013, 08:38 AM

Quote:

Originally Posted by aquarius31

My recommendation (and I'm sure most of you are doing this anyway) is to update the spreadsheet as soon as you receive an item. It is quite a painful task to have to go back through emails, auction sites etc. to figure out the details of a given transaction several months back.

Absolutely! And if you go to a show and are digging around in boxes and/or binders looking for cards you need, updating your spreadsheet immediately will make sure you don't purchase the same card several times. One day at a large show I got lazy and didn't do this and ended up purchasing three of the same card! It was only a common but annoying just the same.

jeff

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
t206 spreadsheet	cbrandtw	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	3	12-27-2011 10:33 PM
OT: The advantages of having your own television show.	slidekellyslide	Net54baseball Sports (Primarily) Vintage Memorabilia Forum incl. Game Used	12	02-16-2011 06:48 AM
T205 Spreadsheet	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	5	09-17-2008 12:19 AM
Spreadsheet suggestions?	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	66	04-24-2007 12:20 PM
T206Museum.com Spreadsheet database...	Archive	Net54baseball Vintage (WWII & Older) Baseball Cards & New Member Introductions	5	02-07-2007 11:31 AM