User Tag List

Results 1 to 9 of 9

Thread: Seeking help creating/finding spreadsheets of rosters

  1. #1
    Member Anthony's Avatar
    Join Date
    Nov 2008
    Location
    San Diego area
    Posts
    673
     anthonyrdevine
    Mentioned
    33 Post(s)
    Tagged
    0 Thread(s)

    Seeking help creating/finding spreadsheets of rosters

    Hey everyone,
    I think I made a post like this last year, but I'll try again. Every year a friend and I go to Spring Training in AZ. I come back with a little over 100 signed rookie cards for my collection. Anyway, to prepare for the trip I:
    1. put together rosters of the teams we will see
    2. comb through my ~5,000-8,000 rookie cards to pull out rookie cards of the guys on the rosters
    3. decide how much of a sportslots.com/COMC/eBay order I want to put in so that I have cards of most/all of he guys I would want to add to my collection
    4. use photo corners to add all my pulled cards to notebooks separated by team and put in alphabetical order


    Arguably, the biggest hassle each year is getting team rosters. I have my cards organized, roughly, by alphabet. I like to be able to have a spreadsheet of ALL of the guys on all the different team rosters so that I can sort by last name and pull my cards as I go through the alphabet. But such a spreadsheet doesn't exist, as far as I can tell. And each year I have to make one myself. I copy and paste the different rosters I find. I usually just put on the 40 man rosters, the non-roster invites, the coaches, and most/all of the team's top prospects. I don't get much more detailed than that. Each year I end up with something like this:

    Making that spreadsheet takes a lot of time. Lots of clicking and copying and pasting. And, sometimes, I end up writing names in the spreadsheet because the top prospect information I find isn't in spreadsheet/table form. On top of that, I sometimes need to use spreadsheet formulas to separate cells from having an entire name to split into a first name and a last name... It's not the most enjoyable part of my hobby. Even when I do all this I'm sure i make mistakes and leave people off the list or mis label a player.

    Any advice? Are there more accurate/efficient ways of doing what I do each year?

    Thanks,
    Anthony
    Collecting in-person, ttm and PSA/DNA autographed rookie cards.

  2. #2
    Senior Member
    Join Date
    Aug 2008
    Location
    DC/StL
    Posts
    1,960
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Always looking for rare 2001 Albert Pujols cards.

  3. #3
    Member Anthony's Avatar
    Join Date
    Nov 2008
    Location
    San Diego area
    Posts
    673
     anthonyrdevine
    Mentioned
    33 Post(s)
    Tagged
    0 Thread(s)
    That might be useful, thanks!
    Collecting in-person, ttm and PSA/DNA autographed rookie cards.

  4. #4
    Senior Member 19braves77's Avatar
    Join Date
    Oct 2008
    Location
    Pensacola, FL
    Posts
    3,444
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Anthony View Post
    That might be useful, thanks!
    Why don't you you just the day before you visit a teams complex get the official roster from the team ? They are are updated every so often thru the week as players are released. They have versions in both alphabetically and numerical order. For example, I will go to the Pirates complex the day before and ask them roster. That night I will organized the cards in my book.
    https://diamondvisits.blogspot.com/- My Minor League Stadium Visits.

  5. #5
    Member Anthony's Avatar
    Join Date
    Nov 2008
    Location
    San Diego area
    Posts
    673
     anthonyrdevine
    Mentioned
    33 Post(s)
    Tagged
    0 Thread(s)
    Click image for larger version. 

Name:	Autograph Book.jpg 
Views:	12 
Size:	49.7 KB 
ID:	45070
    Collecting in-person, ttm and PSA/DNA autographed rookie cards.

  6. #6
    Senior Member WCTYSON's Avatar
    Join Date
    Nov 2014
    Posts
    7,087
    Mentioned
    65 Post(s)
    Tagged
    0 Thread(s)
    Good luck on your quest SDcardguy.
    "...it just sounded to me like he felt like he did not do it."

  7. #7
    Member Anthony's Avatar
    Join Date
    Nov 2008
    Location
    San Diego area
    Posts
    673
     anthonyrdevine
    Mentioned
    33 Post(s)
    Tagged
    0 Thread(s)
    Thanks?

    Quote Originally Posted by WCTYSON View Post
    Good luck on your quest SDcardguy.
    Collecting in-person, ttm and PSA/DNA autographed rookie cards.

  8. #8
    Senior Member WCTYSON's Avatar
    Join Date
    Nov 2014
    Posts
    7,087
    Mentioned
    65 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Anthony View Post
    Thanks?
    Really? Or should I count out the ways for you?
    "...it just sounded to me like he felt like he did not do it."

  9. #9
    Member Anthony's Avatar
    Join Date
    Nov 2008
    Location
    San Diego area
    Posts
    673
     anthonyrdevine
    Mentioned
    33 Post(s)
    Tagged
    0 Thread(s)
    I don't get it. Are you simply wishing me luck on my quest, or do you feel that "SDcardguy" is another name I post under?
    Quote Originally Posted by WCTYSON View Post
    Really? Or should I count out the ways for you?
    Collecting in-person, ttm and PSA/DNA autographed rookie cards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •