ProFSL: Pro Fantasy Sports Leagues

Fantasy Leagues => Armchair Fantasy Baseball => MLB Leagues => Armchair Fantasy Baseball: Archives => Topic started by: kenny on July 23, 2011, 04:31:43 PM

Title: Official Rosters & Transaction Log (3/23)
Post by: kenny on July 23, 2011, 04:31:43 PM
Updated 3/23:

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGJjbFp1VU96dE9Wd2ZuaDdxWnZxa3c&usp=sharing

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDBrY3FjY29NSEg2ME1leV9GNE5HOFE&usp=sharing



Updated 3/16:

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dEdZcmdjYTlnRDN1anM4SnJUUzdYalE&usp=sharing


AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGdNSm8tSk1HTVRtM1JiZFB1cDJYN2c&usp=sharing



Updated 3/3
AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHhJLUFIeXN5cG9sVTJkOE50bktsYXc&usp=sharing

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dFVFOXJ1QXVzY0l0MmRWN0RFNW5tWmc&usp=sharing



Updated 2/24/13
AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHREWV9kSS12WU9fYUx0T2U4U0M3UXc&usp=sharing

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDh5dThQNFhaNVZta05uYzNOeTg0Z2c&usp=sharing


Updated 2/18/13

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGpJVzduUXpVcTd3QzBEN3plRXpjOGc&usp=sharing


NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDQwOFM0Q2RJbGNzQldlLV9kSVhLM1E&usp=sharing



Updated 2/10/13

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dFhUUTZUNXR0MVdkaElsNk5iaFgtbHc&usp=sharing

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGlnZFZYMTNmaW43MWxRdWZYeDFFcnc&usp=sharing



Updated 1/13/13

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dEkzWm50NTRpT05xY3E0ZG1zUmJFclE

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGI1Z1N5ZkNXT3ZwOGVGdEFqUVVxUGc



Updated 12/23/12
NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDNMU21XcE5HRTB6REQ5Q3Q3Tm5MU0E

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHRyQXM4MTdvOFdpRmR1d25BMXpVRWc



Updated 12/16/12 for 2013 salaries (does not include draft picks and unprocessed transactions)

NL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dE5kQmNyQVVQa3hVc1JsZVZnN0ZPV3c

AL: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDZkdmRvOEVMM3B1SURmVVBMMjZVSlE

Sorry about splitting the file in two. Google has a 400,000 cell limit.


Updated 9/23/12
Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dFMwNDdFYjlHdWpPSE1saFZRU2hXQ2c

Had to take the forum code out of the uploaded version because Google couldn't process it. I have the version with the code locally.

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHdsbm1QZDk3RnR5MEUzZVhCQl9QZUE




Updated 9/8/12
Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dF9STEdzQVgtQ2RHTzZuZW0wQ0k3RVE

Transactions:

https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dEpOYjdWcTRtSmxpRU8zeldtaVp4Y2c



Updated 8/12/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDlIU1VOR20zSXd3ZXVpSzY3dHJOVkE

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDBPNGZ3NHpEd3E4WGRQcDNRMW10U0E


Updated 8/5/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dElzdmd3ak10SlpKdHhtSWJiQ1d1QXc

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dE5PT3JNVS1Xc2MtdnVRaXlJdVNTQWc



Updated 7/22/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dEVTcm42X2Q5cDdRLWNPR01oZ0VXcVE

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGVqQ1hRWDFNZ0FjSEhPREV1WTdLTnc

I will probably do another update mid-week due to the number of transactions pending due to waiver periods and trade review periods.


Updated 7/15/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dF9UOUFya1dHOWpWVFF3dTZLVC1qY3c

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dDFJY3IxTmR6VUtGd3VzM241TjBmVEE




Updated 7/8/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHZ1ekVSV3piNXRCdjBxdWxvWlo3bEE

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGFKSnNaS0RlQUlwc0NlS09sVWkzOWc




Updated through transactions processed by 7/1/12 8:25am ET.

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGNhUk9OeUxMS0hNOW5DZ09NdlN1TkE

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGVfQU80R0l0NS14bVJLWXBXWkUyNXc



Updated 6/9/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dEttQVd0QTdXMmFab2IybkNTRFJlZ2c

Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGZmNjYxTU9FSEZFNWh3YklIbkJvc0E



Updated 5/25/12

Rosters: https://docs.google.com/open?id=0BwOowJnfifk6TG1qNG1pUWhXajg

Transactions: https://docs.google.com/open?id=0BwOowJnfifk6UmxfYm42OVVPUWs


Updated 5/11/12

If you see any code next to you roster, don't mind it. I'm trying to program something into the spreadsheet that will automatically give me forum code to post the rosters on the forum. It's a work in progress.

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dGZFaV8wN0tXSnZrdTd1NXlpTUE3WkE


Transactions: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dENzdmZLaXo4ZjdVTnVnODFCcmIyUGc




Updated 4/28/12

Rosters: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHdhek9LSkV5eVJuZlJ4SkRLSFhlSHc

Transaction Log: https://docs.google.com/spreadsheet/ccc?key=0AgOowJnfifk6dHNsZDVDbTVnbGp6d1hyMHdXelN5YWc


While I tried my best to not make any mistakes, it is a big spreadsheet with thousands of players, so there is a chance that are errors. Please check your own teams and if you see something that may be incorrect, please let me know and i'll look into it.

Excel files also attached.
Title: Re: Master Spreadsheet (7/23/11)
Post by: mcmccullough on July 23, 2011, 04:40:09 PM
Looks great Kenny; I really appreciate all the hard work.
Title: Re: Master Spreadsheet (7/23/11)
Post by: Shelby on July 23, 2011, 07:59:13 PM
amazing work Kenny !
Title: Re: Master Spreadsheet (8/21/11)
Post by: jackdaniels on August 23, 2011, 04:49:26 PM
W O W kenny! Just simply W O W!!!  :toast:

And there I was trying to pull my own roster lists together from the web. Thanks for the hardwork dude!
Title: Re: Master Spreadsheet (8/21/11)
Post by: kenny on August 23, 2011, 11:03:03 PM
The reason I didn't go the route some leagues do with having the GM's put together the rosters is that then there's a good chance it'll produce inconsistencies. Inconsistencies doom leagues like these.

FYI, salaries for arbitration eligible players and 1st-3rd year players for 2012 will be added to this spreadsheet over the next week or so. I'm going to do a little bit each night.
Title: Re: Master Spreadsheet (8/28/11)
Post by: E.J. on September 15, 2011, 08:05:36 AM
WOW I am impressed, very nice work!
Title: Re: Master Spreadsheets (12/11/11)
Post by: kenny on December 11, 2011, 09:02:54 AM
Updated 12/11/11.
Title: Re: Master Spreadsheets (1/12/12)
Post by: kenny on January 12, 2012, 02:17:52 PM
Updated 1/12/12.
Title: Re: Master Spreadsheets (1/12/12)
Post by: ClueHaywood on January 12, 2012, 06:53:39 PM
What will make this league good is all the hard work you and anyone else who has a hand in it puts into it. 
Title: Re: Master Spreadsheets (1/12/12)
Post by: kenny on January 12, 2012, 07:29:29 PM
It really is a big group effort. There's absolutely no way one person can run a league like this by himself. I always appreciate any help I can get here.

On another note, I will be updating the rosters spreadsheet again for any errors and for aesthetics this weekend. If you notice anything wrong on your roster, or anybody else's, please let me know.

Thanks.
Title: Re: Master Spreadsheets (1/12/12)
Post by: kenny on January 14, 2012, 07:48:43 PM
Rosters updated 1/14/12. Added amateur draft picks as of 1/14/12 and made minor adjustments to spreadsheet.
Title: Re: Master Spreadsheets (2/12/12)
Post by: kenny on February 12, 2012, 12:11:49 PM
Interim update 2/12/12.
Title: Re: Master Spreadsheets (2/26/12)
Post by: kenny on February 26, 2012, 08:30:47 AM
Updated 2/26/12
Title: Re: Master Spreadsheets (3/4/12)
Post by: kenny on March 04, 2012, 09:41:46 AM
Updated 3/4/12.
Title: Re: Master Spreadsheets (3/5/12)
Post by: kenny on March 05, 2012, 07:22:23 PM
Updated 3/5/12.
Title: Re: Master Spreadsheets (3/5/12)
Post by: kenny on March 06, 2012, 07:51:04 AM
I noticed the roster counts don't work on google spreadsheets. If you don't have access to Excel and would like the counts, let me know and I'll give you the numbers.
Title: Re: Master Spreadsheets (3/18/12)
Post by: kenny on March 18, 2012, 05:43:11 PM
Updated 3/18/12
Title: Re: Master Spreadsheets (3/24/12)
Post by: kenny on March 24, 2012, 05:20:52 PM
Rosters updated 3/24/12
Title: Re: Master Spreadsheets (3/31/12)
Post by: kenny on March 31, 2012, 04:12:11 PM
Updated 3/31/12
Title: Re: Master Spreadsheets (4/14/12)
Post by: kenny on April 14, 2012, 10:05:54 PM
Updated 4/14/12
Title: Re: Master Spreadsheets (4/28/12)
Post by: kenny on April 28, 2012, 09:26:52 AM
Updated 4/28/12
Title: Re: Official Rosters & Transaction Log (5/11/12)
Post by: kenny on May 11, 2012, 10:30:38 AM
Updated 5/11/12
Title: Re: Official Rosters & Transaction Log (5/11/12)
Post by: kenny on May 22, 2012, 06:26:50 PM
Kind of under the weather... Unless somebody really needs an update, I'd like to put it off until the weekend. Anything Fantrax related, I'll take care of ASAP.
Title: Re: Official Rosters & Transaction Log (5/25/12)
Post by: kenny on May 25, 2012, 06:20:29 PM
Updated 5/25/12.
Title: Re: Official Rosters & Transaction Log (7/1/12)
Post by: kenny on July 01, 2012, 09:30:22 AM
Updated 7/1/12
Title: Re: Official Rosters & Transaction Log (8/12/12)
Post by: kenny on August 12, 2012, 10:19:38 AM
Updated 8/12/12
Title: Re: Official Rosters & Transaction Log (9/8/12)
Post by: kenny on September 08, 2012, 09:47:08 AM
Updated 9/8/12. Will likely have another update to catch up before next weekend.
Title: Re: Official Rosters & Transaction Log (9/23/12)
Post by: kenny on September 23, 2012, 12:13:14 PM
Updated 9/23/12.

Out of town next Saturday... update unlikely.
Title: Re: Official Rosters & Transaction Log (12/16/12)
Post by: kenny on December 16, 2012, 10:51:30 AM
Updated 12/16/12. Roster file had to be split in 2 due to 400,000 cell limit imposed by Google. Anybody that wants the Excel spreadsheet should email me bklyn.kenny [at] gmail.com
Title: Re: Official Rosters & Transaction Log (12/16/12)
Post by: kenny on December 21, 2012, 11:31:30 AM
I've updated the roster file on my computer. Will post on Sunday after I clean up a bunch of loose ends. If you need it in the meanwhile, I can email you the Excel copy now.
Title: Re: Official Rosters & Transaction Log (12/23/12)
Post by: kenny on December 23, 2012, 09:09:24 PM
Updated 12/23/12
Title: Re: Official Rosters & Transaction Log (2/10/13)
Post by: kenny on February 18, 2013, 06:52:05 AM
Update coming later today. I'm taking advantage of the long weekend to catch up on a few things.
Title: Re: Official Rosters & Transaction Log (3/23)
Post by: yahoolando on July 22, 2013, 04:50:15 PM
Working on uploading the spreadsheets.