[IBL] Card Sorting Aid (Maybe)

[D G]

All, in starting to sort cards, one change to the spreadsheet I attached
with IBL team assignments.  The carded players spreadsheet I used for IBL
team assignments had Preston Tucker with MLB team CIN, but Sean's cards
have him with ATL (which I think is right based upon him finishing with ATL
last season).  I have changed Tucker from CIN Tucker to ATL Tucker on the
attached version 2 of the spreadsheet I sent.  That will have Tucker in the
right spot if you use the spreadsheet to sort.

If I come across any other adjustments, I'll pass them along.

When I attached the spreadsheet, I had the names sorted first by MLB team
then alphabetically by last name, because that's how the players appear in
the PDFs.  If that sorting is not evident when you opened the attached,
you'll have to "custom sort" to accomplish that.

I have found the spreadsheet to speed up card sorting quite substantially
over the methods I have used before, but YMMV.  If send to printer for
cutting, just need to be sure the cards come back to you in a way that is
easy to reconstruct them back into Sean's PDF row/columns.

One owner commented favorably, and I'll send him and anyone else who would
like a copy of the same spreadsheet for pitchers when I compile that this
week.  A number of you don't sort at all but just play via PDFs on multiple
monitors, so that is a nice work-around to sorting!

Thanks all!

- David



On Mon, Mar 25, 2019 at 5:23 PM D G <genny429 at gmail.com> wrote:

> Hi all --
>
> When I was in the league last, I never stumbled upon a particularly
> efficient way to sort cards into IBL teams after the PDFs had been
> printed.  My approach this year is to use Rusty's spreadsheet of carded
> players and add a column for IBL team designation.  When Rusty's
> spreadsheet is sorted alphabetically by MLB team, it sorts into the order
> the cards are laid out in the PDFs.  Rather than taking a card and finding
> it within the IBL rosters, or taking one IBL roster at a time and finding
> all the cards for that team, I think this will allow a one-stop shop to
> match card-to-team in the order that the cards appear on the PDFs.
>
> I've attached the spreadsheet for batters.  If no team designation appears
> by the batter's name, he is a free agent.  I've probably made some errors,
> but hopefully not too many.  Designations are current as of today.
>
> Two questions:
>
> Is this of help?
> Has anyone found a better way to approach sorting cards?
>
> Is of help to anyone, happy to provide pitchers after I get to them in
> next day or two.
>
> Thanks much all.
>
> - David (OXY)
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ibl.org/pipermail/members/attachments/20190327/daf05d71/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v2 Carded Batters with IBL Team Designation.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 23598 bytes
Desc: not available
URL: <http://lists.ibl.org/pipermail/members/attachments/20190327/daf05d71/attachment-0001.xlsx>