[IBL] Card Sorting Aid (Maybe)

[D G]

All, I'm through the batters spreadsheet so finished quality
control.  Three changes in the attached "v3-FINAL" spreadsheet:

-  I had Gennett and Schebler both as CIN for their IBL team.
Have corrected to SLG and POR respectively.
-  I had DET Jones as SJG rather than SLG.  Typo corrected.
-  SF d'Arnaud appeared alphabetically sorted as starting with "d" on the
spreadsheet, but he appears last of the SF players on the PDF, after
Williamson.  So I put an "x" before his name so he would sort to the end of
SF players and match up with the PDF order.
-  I updated one designation to reflect batter transactions Sean circulated
this afternoon, So ARI Brito is now a LAD player.  The others in the 3/27
transactions were pitchers, so not listed in the attached spreadsheet.  The
attached should reflect all batter designations current through today.

Thanks much all.

- David





On Wed, Mar 27, 2019 at 1:47 PM D G <genny429 at gmail.com> wrote:

> 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/e71e61fe/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v3-FINAL Carded Batters with IBL Team Designation.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 23570 bytes
Desc: not available
URL: <http://lists.ibl.org/pipermail/members/attachments/20190327/e71e61fe/attachment.xlsx>