BB Card Setbuilder Software- Excel - 67-78
jskirwin
Posts: 700 ✭✭✭
Hello
I'm building 12 years of sets and have developed my own spreadsheets to track them.
Each year has its own inventory worksheet with card #, First Name, Last Name, Own, Need, Pending, Relative Rarity (1-10)
All you need do is enter in the Own or Pending columns and Excel does all the rest. It calculates how many you have, how many you need, and the percent complete your set is.
Another sheet, the Countsheet, allows you to paste in a list of numbers taken from an auction. It then tells you how many of the numbers you need, and shows their rarity.
Here are some screenshots:
Data entry is kept to a minimum, and since it is in Excel format, you can autofilter the data easily to show which cards you need or which you have.
If you are interested in this spreadsheet, email me at skirwin (at) itpaa.org and I'll send you a copy for just $10 - Paypal.
For that you will get the 12 years from 1967-78 plus the tradeds sheets, plus software support for the spreadsheet.
In lieu of the $$$ I will take baseball cards. Email and we'll deal.
Thanks!
I'm building 12 years of sets and have developed my own spreadsheets to track them.
Each year has its own inventory worksheet with card #, First Name, Last Name, Own, Need, Pending, Relative Rarity (1-10)
All you need do is enter in the Own or Pending columns and Excel does all the rest. It calculates how many you have, how many you need, and the percent complete your set is.
Another sheet, the Countsheet, allows you to paste in a list of numbers taken from an auction. It then tells you how many of the numbers you need, and shows their rarity.
Here are some screenshots:
Data entry is kept to a minimum, and since it is in Excel format, you can autofilter the data easily to show which cards you need or which you have.
If you are interested in this spreadsheet, email me at skirwin (at) itpaa.org and I'll send you a copy for just $10 - Paypal.
For that you will get the 12 years from 1967-78 plus the tradeds sheets, plus software support for the spreadsheet.
In lieu of the $$$ I will take baseball cards. Email and we'll deal.
Thanks!
0