Updated Set Registry Spreadsheets

Virtualizard · April 26, 2003 4:53AM

It's a rainy day here in South Florida, so I spent some time adding sets to my web site. I've mainly added new player sets: Yastrzemski, Stargell, Banks, Munson, & Schmidt.

If anyone is interested, go to Set Registry Spreadsheets.

JEB.

FB · April 27, 2003 10:33PM

Thanks Jason,

Although Weighted GPA is easy - I've always had trouble calculating the rating.

JeffVN · April 27, 2003 11:07PM

Nice work! Can we make set requests for you to create spreadsheets, or weill you get bored again and continue the fine effort on your own?

Virtualizard · April 28, 2003 1:27AM

I will take any requests. Not a problem.

JEB.

qualitycards · April 28, 2003 2:32AM

JEB - How 'bout everones favorite LOU BERBERET!

...jay

Virtualizard · April 28, 2003 7:45AM

<< <i>JEB - How 'bout everones favorite LOU BERBERET!

...jay >>

Once PSA lists the set (has anyone requested it yet?) it will be listed immediately!

JEB.

Virtualizard · April 28, 2003 7:48AM

By the way, if anyone downloaded the 1970 Topps list from my site, rbeaton was kind enough to point out an error. If you did download it, please download the corrected version.

Sorry for any inconvenience.

Thanks Robert.

JEB.

Basilone · April 28, 2003 11:46AM

Jeb-

Great Job on the spreadsheets...and a special "Thank You" for doing a Willie Stargell spreadsheet as well. Your work is an asset to these boards!!

Thanks again,

John Basilone

BillBob · April 28, 2003 1:05PM

Thanks Jeb. Although I currently only have the 1954 and 1960 cards, I downloaded the Banks spreadsheet. I hope to revive my Banks collection after my Dodger & Colavito sets peak.

Virtualizard · April 29, 2003 10:11AM

Thanks for all the great responses. As I said before, feel free to email me with any requests. More will be added soon.

Good luck to everyone on their sets. I really enjoy the set registry and I'm glad to help anyone share my enjoyment in any way possible. I've thought about adding some visual basic enhancements to the spreadsheets, but I don't want to make them into something that only a few people will find useful. In my experience, some programming tends to get too invasive, reduces the opportunity for users to customize, and generally turns off a lot of end-users. I'd like to keep it as simple as possible, but easy to use for everyone. Any suggestions would be welcomed.

Thanks again for all of the feedback so far. I'm looking forward to more.

JEB.

invader73 · April 30, 2003 1:19AM

Great work. A couple of those are really going to help me track my sets.

If you are taking requests:

1964 Giants
1968 topps
1976 Topps Traded.

Thanks a lot and keep up the good work.

Matt

Virtualizard · April 30, 2003 9:46AM

I have added the 3 Nolan Ryan sets - Basic, Master, & Topps Player Sets. I have also added the 1966 Topps Baseball Set.

Matt,

I will get your sets up in the next few days (hopefully tomorrow).

JEB.

Virtualizard · May 1, 2003 8:25AM

Matt,

As promised, the 1964 Giants, 1968 Topps, and 1976 Topps Traded sets have been added.

Set Registry Spreadsheets

JEB.

invader73 · May 1, 2003 4:55PM

WOW!!

Thanks a lot,

You have now been added to my list of Gods to be worshipped on a daily basis.

Matt

sjjs28 · May 1, 2003 9:33PM

When you have the time ....
Could you provided a speadsheet for the 1967 and 1965 sets -

Thanks -

Virtualizard · May 1, 2003 9:38PM

No problem, Steve.

Look for them this evening.

JEB.

Virtualizard · May 2, 2003 9:30AM

Steve,

The 1965 & 1967 Topps Baseball sets have been added. I also added the 1964 Topps Baseball set.

Set Registry Spreadsheets

JEB.

Virtualizard · May 3, 2003 4:48AM

I just added a few more: 1961, 1962, & 1963 Topps Baseball, and the 1911 T205 Gold Border sets.

JEB.

BillBob · May 3, 2003 9:29AM

Thanks Jeb. Your efforts are genuinely appreciated.

Virtualizard · May 3, 2003 12:35PM

Thanks Bill.

Your response is genuinely appreciated. Glad to help.

JEB.

mrc32 · May 3, 2003 10:37PM

Thanks Jeb for taking a look at my attempt...I appreciate you taking the time to make a couple changes...

You are an asset to this board
Michael

braves72078 · May 4, 2003 12:38AM

Jeb,

If you get a chance could you do 1981 and 1982 Donruss Golf sets.

Thanks man you are awesome for the registry

Braves

Virtualizard · May 4, 2003 8:06AM

Braves,

Your wish is granted! The '81 and '82 Donruss Golf Sets have been added. Set Registry Spreadsheets

Those were the easiest two I've done so far. PSA's database was perfect on that one with no manual adjustments necessary. I would have had them posted for you literally within minutes of your request if I hadn't been out enjoying a beautiful sunny day in South Florida on the motorcycle - nice little 150 mile ride.

Glad to help anyone. I believe that I am caught up with all of the requests I have received. If I've overlooked one, I apologize. Please send it again and I will get it posted right away. jeb@virtualizard.com

Good luck to everyone with their sets.

JEB.

sjjs28 · May 4, 2003 10:05PM

JEB -

You are as good as your word -
Much appreciated -

Thanks, Steve "sjjs28"

Virtualizard · May 5, 2003 9:36AM

Steve,

No problem. Let me know if you need any more.

JEB.

Virtualizard · May 10, 2003 12:14AM

<< <i>Jeb-

Great Job on the spreadsheets...and a special "Thank You" for doing a Willie Stargell spreadsheet as well. Your work is an asset to these boards!!

Thanks again,

John Basilone >>

John,

Thanks for the nice comments.

I thought you might be interested to know that PSA has finally reworked the Stargell sets into a basic and master. I have updated them accordingly.

JEB.

Virtualizard · May 17, 2003 7:50AM

The Steve Carlton Master Set has been updated to include a recently added card.

I've updated my Set Registry Spreadsheets to reflect the change.

As always, let me know if you are collecting a set that is not listed. I'd be glad to add it.

JEB.

braves72078 · May 17, 2003 9:59AM

<< <i>Braves,

I would have had them posted for you literally within minutes of your request if I hadn't been out enjoying a beautiful sunny day in South Florida on the motorcycle - nice little 150 mile ride.

JEB. >>

JEB

Thanks and I hope you had a great ride. I just got back from a nice ride as well.

Braves

OhioTaz · May 17, 2003 11:14AM

Jeb

Those sheets are great. We have ones that add columns for registration #, date of purchase, seller, and amount paid but never had the set weighting available. This was a big help!!

We always used the countif function to count the number of cards entered (for instance (=COUNTIF(D8

594,">0") for your 1964 Topps sheet). I see what method you used but I don't understand how you make cell C4 work. In other words, how did you add the x of y to the cell?

Taz

Virtualizard · May 17, 2003 12:06PM

In excel there are many ways to accomplish the same thing. The "countif" function is one I have rarely used because a "dummy" column does the same thing. As far as the "x of y", that is my secret.

Hint: check out the formatting of the cell. The value never changes, so why make it complicated with functions or multiple cells?

JEB.

OhioTaz · May 17, 2003 9:13PM

Custom formatting. I did not even know you could do that. That's great! Thanks.

Taz

Virtualizard · May 18, 2003 12:30AM

RobE,

I have added the 1980 Topps Set. Let me know if you need any more help.

JEB.

BigKidAtHeart · May 18, 2003 1:47AM

THANKS!

You have put in a lot of work here
and I know many many of us very much
appreciate your constant contributions
to these boards!

~jeff

Mykabota · May 20, 2003 6:45AM

Thanks for the excel file. Completing my 68 Topps.

baseballfan · May 21, 2003 2:33AM

jeb,
how about the 1951 topps red and blue and the 1968 topps game.
do you just do baseball and some golf?
you are truly a great help to these boards and collecting in general
keep up the good work.
fred

Virtualizard · May 21, 2003 8:07AM

Fred,

Thanks for the nice words. I have added the '51 Topps Blue & Red Back sets and the '68 Topps Game set. Enjoy!

JEB.

baseballfan · May 22, 2003 4:02AM

thanks jeb
do you only do baseball in the spreadsheets?
again great job thanks
fred

Virtualizard · May 22, 2003 9:07AM

Fred,

I'll add any set in any sport if you request it. Other than the two golf sets, no one has requested anything else. That's why it's just baseball (and because that's all that I collect graded right now). Maybe I didn't specify it in my previous posts, but I will gladly add any set, even non-sport if it's requested.

JEB.

baseballfan · May 23, 2003 12:31AM

thanks jeb
your the best keep up the good work
i'll have to see if there anything in other sports worth doing
fred

Virtualizard · June 1, 2003 2:15AM

I've updated my site again to include several requests that I've received as well as some updates PSA has made, specifically:

Nolan Ryan Master set has been updated to include several additions

The Roberto Clemente Player set has been changed to the Master & Basic sets - both have been added

Willie Mays Basic & Master sets have been added

Set Registry Spreadsheets

If anyone knows of any other updates that I've missed or if you have a set you would like me to add, please let me know.

Thanks.

JEB.

Updated Set Registry Spreadsheets

Comments