Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: CBS excel question

  1. #1

    CBS excel question

    Does anyone know if it's possible to create a custom report or otherwise get an Excel sheet going that would enable me to sort by minor leaguers? We have a minor league draft coming up and there are more than 100 minor leaguers being kept, so I thought some sort of reference sheet would help me figure out who's available and who's kept. Anyone tried something like this?

  2. #2
    Administrator revo's Avatar
    Join Date
    Jan 2011
    Location
    fuggedabboutit
    Posts
    24,431
    What I do for RJEL is go to Teams>All Teams, then at the bottom of the page there is a button to export to excel. While it will have space breaks for the different teams, if you take a few minutes to delete those, you'll then have every player rostered, and one of the columns is [presumably] contract, which [hopefully for you] is a minor league designation.

  3. #3
    I tried what you suggested and we do have contracts but they're not showing in the Excel download. I don't see salary or contract when I do the export. Am I missing a button somewhere?

  4. #4
    Administrator revo's Avatar
    Join Date
    Jan 2011
    Location
    fuggedabboutit
    Posts
    24,431
    Quote Originally Posted by Bene Futuis View Post
    I tried what you suggested and we do have contracts but they're not showing in the Excel download. I don't see salary or contract when I do the export. Am I missing a button somewhere?
    Hmmm, I don't think so. When I go to a team page in RJEL and export it, it includes the Salary & Contract columns. But I would suppose it would depend on what page you're showing when you do the export.

  5. #5
    Quote Originally Posted by revo View Post
    Hmmm, I don't think so. When I go to a team page in RJEL and export it, it includes the Salary & Contract columns. But I would suppose it would depend on what page you're showing when you do the export.
    Ah, I was just doing it from the wrong page. I was trying to do it from the custom reports but it works great from the team page ("all teams"). Thanks for the help, amigo!

  6. #6
    This could be a little clunky, but if you have a list of the minor league prospects you'd consider drafting, and the names are in the same format as the CBS export (First Last), (Last, First) etc, you could paste that list onto the same Excel page and then use Conditional Formatting

    1. Highlight one of the columns by clicking in the Letter above the column
    2. While holding down the CTRL key, highlight the other column
    3. Conditional Formatting -> Highlight Cells Rules -> Duplicate Value -> Choose your color pattern

    The colored cells are drafted. You will want to verify the others aren't drafted, but with a different name (Bobby Witt, Bobby Witt Jr.) etc.
    Follow me on Twitter @ToddZola

  7. #7
    Quote Originally Posted by Todd Zola View Post
    This could be a little clunky, but if you have a list of the minor league prospects you'd consider drafting, and the names are in the same format as the CBS export (First Last), (Last, First) etc, you could paste that list onto the same Excel page and then use Conditional Formatting

    1. Highlight one of the columns by clicking in the Letter above the column
    2. While holding down the CTRL key, highlight the other column
    3. Conditional Formatting -> Highlight Cells Rules -> Duplicate Value -> Choose your color pattern

    The colored cells are drafted. You will want to verify the others aren't drafted, but with a different name (Bobby Witt, Bobby Witt Jr.) etc.
    Awesome, thanks! I was going to do exactly that. This league will roster ~180 minor leaguers so it'll be nice to have a reference list to compare with.

  8. #8
    Administrator Ken's Avatar
    Join Date
    Feb 2016
    Posts
    9,709
    Quote Originally Posted by Todd Zola View Post
    This could be a little clunky, but if you have a list of the minor league prospects you'd consider drafting, and the names are in the same format as the CBS export (First Last), (Last, First) etc, you could paste that list onto the same Excel page and then use Conditional Formatting

    1. Highlight one of the columns by clicking in the Letter above the column
    2. While holding down the CTRL key, highlight the other column
    3. Conditional Formatting -> Highlight Cells Rules -> Duplicate Value -> Choose your color pattern

    The colored cells are drafted. You will want to verify the others aren't drafted, but with a different name (Bobby Witt, Bobby Witt Jr.) etc.

    I just do a vlookup (or xlookup these days) and then sort by the lookup column.

    --- for those unfamiliar with vlookup you'd click on the top empty cell immediately to the right of your list of players, type =vlookup( then click the cell you are looking up (the top name in your list), then click on the LETTER of the column you are searching in (the list of minor league players already taken), then type ,1,false)
    Then use the bottom right corner of that cell to copy down to all the players.

    That gives you the name of each player that is taken in that column, or "N/A" if they werent in the list.

    The N/A values are the ones you want, they are "not available" in your list of taken players.

  9. #9
    All Star heyelander's Avatar
    Join Date
    Jan 2011
    Location
    Sactown
    Posts
    9,758
    xlookups rock
    I'm not expecting to grow flowers in the desert...

  10. #10
    All Star TranaGreg's Avatar
    Join Date
    Jan 2011
    Location
    The County
    Posts
    5,256
    you know you're in the right forum when there's posturing about which lookup function is best
    It certainly feels that way. But I'm distrustful of that feeling and am curious about evidence.

Posting Permissions

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