ProFSL: Pro Fantasy Sports Leagues
Fantasy Leagues => Armchair Fantasy Baseball => MLB Leagues => Armchair Fantasy Baseball: Archives => Topic started by: chrisetc21 on December 28, 2013, 01:58:22 PM
-
Problem. I don't have excel so updating these spreadsheets properly and having them display correctly is a problem. I'd like to see if I could get five or six people to help me post rosters on the board. If we can get the help we can probably be done within a week or two and be ready for free agency in January.
If we can get a consensus on that then I'll post an entire organization in the format we should use and everyone can copy the format and post rosters from the spreadsheet links. Perhaps we can divy up the divisions. Looking for feedback, thanks.
-
I can help out.... thinking it might be easier to have one person in charge of the entire process though. Finding one person to take on the entire responsibility is the problem there, though. I'd consider it, but need to brush up on the whole Google Docs side of things.
-
I'll take a division once we have the format how we want it.
-
I'll take a division once we have the format how we want it.
same from me
-
I've got fairly extensive knowledge of excel. No experience with google docs though. Always willing to help.
Sent from my iPhone using Tapatalk (http://tapatalk.com/m?id=1)
-
Here's a link to one roster that I've done.
http://www.profsl.com/smf/index.php?topic=20177.msg99174#msg99174
The information in parentheses for contracts is either the last year of the contract or the year of arbitration they're in.
Let me know what you think or if we should change anything there. Thanks.
-
here is what my personal roster looks like.
https://drive.google.com/file/d/0B_fh6DsIXtJ1S0dSZE9wSElNNEk/edit?usp=sharing
link should work now
-
here is what my personal roster looks like.
https://drive.google.com/file/d/0B_fh6DsIXtJ1S0dSZE9wSElNNEk/edit?usp=sharing
link should work now
Personally, I like this format better than Chris'
It is easier to read the contract/arb info and I like how it list things
like DOB, age, handedness, etc. It is not uncommon to encounter common
names and this info, especially DOB, helps identify players.
example - David Carpenter of the braves and angels systems.
I am not sure how I feel about organizing by position rather than minor league
level. I like it because it makes it easier to see where you have positional depth
in the minors but it also makes it harder to arrange players if we still have roster limits
at each level. This roster setup would be nice if we just had one general minor league roster
instead of different levels.
-
I like it split between the different A, AA, AAA levels as well. Makes promoting up through the levels easier. Makes some of the management functions easier as well.
-
I would like to add that the team counts on the top of my roster are done by a count formula. The roster limits are still easily counted this way while still adding an easier view of positional depth and simplifying promotion processing. To me just changing one cell's value when promoting is much easier than and leaves less room for error than cutting and pasting.
Also I have the ages self updating as well as hyperlinks to each players baseball reference page.
-
I would like to add that the team counts on the top of my roster are done by a count formula. The roster limits are still easily counted this way while still adding an easier view of positional depth and simplifying promotion processing. To me just changing one cell's value when promoting is much easier than and leaves less room for error than cutting and pasting.
Also I have the ages self updating as well as hyperlinks to each players baseball reference page.
Yeah I notice that now. I suppose I am fine with it how you have it in that regard. I love the self updating ages. I guess my only critique then is it is a bit hard to read. I am not very knowledgeable on these things but at least on my ipad and phone it is a bit grainy and hard to read. Also would prefer a vertical format like past rosters instead of individual horizontal pages.
Sorry if I am being nitpicky, just my opinion. I am thankful for everybody's hard work.
-
I think it's a matter of google drive, I need to find a way to upload the actual file without using one of the services.
Maybe this will work.
-
Either way, we need to come to a resolution of the roster issue. I don't have excel which makes my updating these sheets not possible. Things that aren't absolutely necessary to distinguish a player are just superfluous for these sheets in my opinion. I have no interest in looking up the birthdates of 6 or 700 draftees because 5 or 10 players in the whole league may have duplicate names. As long as the appropriate player is given to the appropriate team in FanTrax I think birthdates are a time consuming luxury.
This league has been in existence two seasons and the Commish role has been a revolving door. The reason for this is undoubtedly the large amount of time to maintain all of these types of things. So when there are things that take an extraordinary amount of time that don't have a significant impact then we can either ditch those things or we need more of a group effort to handle them. This is why I proposed the fixed arbitration and simpler rosters.
If we can't resolve this then free agency won't begin on time and the season may be pushed back.
-
Either way, we need to come to a resolution of the roster issue. I don't have excel which makes my updating these sheets not possible. Things that aren't absolutely necessary to distinguish a player are just superfluous for these sheets in my opinion. I have no interest in looking up the birthdates of 6 or 700 draftees because 5 or 10 players in the whole league may have duplicate names. As long as the appropriate player is given to the appropriate team in FanTrax I think birthdates are a time consuming luxury.
This league has been in existence two seasons and the Commish role has been a revolving door. The reason for this is undoubtedly the large amount of time to maintain all of these types of things. So when there are things that take an extraordinary amount of time that don't have a significant impact then we can either ditch those things or we need more of a group effort to handle them. This is why I proposed the fixed arbitration and simpler rosters.
If we can't resolve this then free agency won't begin on time and the season may be pushed back.
I agree. This is why I think it would make he most sense to delegate a lot of the tasks. I know we sort of had an executive committee for Fantrax but I think we need something like that for the league. For example a head commissioner to oversee everything and verify some peoples work from time to time to make sure nothing funny is going on and have a few tasks they do themselves (Chris) and then a group of people to handle different areas. For example, I already volunteered to do the extensions. Now that rosters are updated on fantrax we could have 1 or 2 people be in charge of updating fantrax rosters when trades/FA/Promotions happen. We could have one person in charge of updating the roster spreadsheets once that gets up to speed. 2 people in charge of updating draft, etc. Then get people to help on short term projects as needed like when a group of us helped with the fantrax rosters.
Identify the tasks and delegate them out to a group of 3-5 people that are on here fairly consistently and willing to help.
A sort of executive committee that is overseen by the commish would help a lot I think.
As far as the rosters, I like the DOB. it happens with more than a few players and not just duplicate names. A lot of names on rosters are something like billy jones when on bbref it is William jones and it helps to ensure it's the correct player.
Anyways, I'm all for the setup Jss0062 has going up. It's just hard to read. I agree the handedness is somewhat superfluous and I would understand if he didn't want to include it for workload.
-
Chris send me the rosters you have and I will be glad to handle them. Just title me Chief of Roster Operations.
Shane were you able to view the file I uploaded straight to the board for download?
-
Chris send me the rosters you have and I will be glad to handle them. Just title me Chief of Roster Operations.
Shane were you able to view the file I uploaded straight to the board for download?
Yes, I could.
They look great, good job.
-
I've got fairly extensive knowledge of excel. No experience with google docs though. Always willing to help.
Sent from my iPhone using Tapatalk (http://tapatalk.com/m?id=1)
Same here. I'm awesome with Excel, never worked with the GOOGLE suite. I can learn, let me know.
-
Chris send me the rosters you have and I will be glad to handle them. Just title me Chief of Roster Operations.
Shane were you able to view the file I uploaded straight to the board for download?
I will email them. Appreciate your help. The rosters will have to be viewable in some manner however whether it's posted on a web site, posted on this site, or through something like google drive.
-
Chris send me the rosters you have and I will be glad to handle them. Just title me Chief of Roster Operations.
Shane were you able to view the file I uploaded straight to the board for download?
Sent
-
Sent
I got them, they are really in pretty good shape. I will try to get the draft updated on them and do a few ownership corrections. I will email you the link to insert them into the site sometime Monday.
-
I got them, they are really in pretty good shape. I will try to get the draft updated on them and do a few ownership corrections. I will email you the link to insert them into the site sometime Monday.
Thank you.
-
test
https://docs.google.com/spreadsheet/ccc?key=0Avfh6DsIXtJ1dFA3V1phc3k4dUY2alJ3a3F2bkdLclE&usp=sharing
-
test
https://docs.google.com/spreadsheet/ccc?key=0Avfh6DsIXtJ1dFA3V1phc3k4dUY2alJ3a3F2bkdLclE&hl=en#gid=2
-
Only thing is they need to be locked to editing by users other than you so that nobody can alter them
-
You and I should be the only ones that can edit.
Someone else please confirm.
-
I cannot edit it.
-
its locked by me.
I am glad that we can search all pages again. nice work guys.
-
I also cannot edit the file.
One correction please. On the TOR tab, can you please change cell B2 to the correct team name (Toronto Blue Jays)? Thanks.
-
The new rosters are linked. Thanks to Jeremy for hosting them and updating them. It's a huge task.
-
I also cannot edit the file.
One correction please. On the TOR tab, can you please change cell B2 to the correct team name (Toronto Blue Jays)? Thanks.
I corrected it. You don't want to be known as the Rays? haha