Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:13 pm
I fixed the functions alsoMike wroteCOLONnot just formatting, as I said in pm it will break certain functions. Please just dress 7th dmen as wingers.
Page 2 of 6
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:14 pm
i appreciate you know what you're doing, but let's please not make this more complicated than it has to be.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:23 pm
Mike wroteCOLONDirectory of BBKL Team Spreadsheets [link]
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:24 pm
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:30 pm
I think he sorted the header as well? easy typo to make!
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:32 pm
Yah, if you don't know what you're doing in excel please ask me to sort your list for you once you input the rest of your guys.Nick wroteCOLONI think he sorted the header as well? easy typo to make!
I gave Steve a fresh copy to try again.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:42 pm
ya. i f'ed it up
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:56 pm
Guys some suggestions from me:
1. Make sure your players, salaries, birth dates and GPs are correct.
2. Roles:
C1-C4 for Cs. If you have a 5th C, assign a W spot
W1, W3, W5, W7 are the LW spots
W2, W4, W6, W8 are the RW spots
If you have a 7th D, assign it the W8 spot
3. In the "REL" column, you are supposed to list anyone who is going to be on your IR. If you put REL1 in that column, the cap of the player on LTIR won't count towards your cap.
4.In the same "REL" column, put "Active" beside players you have on your active roster and "Extra" as players on your bench. Then Select Columns A-I and at the top of Google Docs go to Data > Sort Range... > Check off "Data has a header row" > Sort by Column B "A-Z" > Click Sort. This will sort put all your active players at the top.
5. Change the order of the spreadsheets (this is a matter of preference) at the bottom. Right now if someone clicks the link, your Picks sheet opens up first. Instead click and drag the Roster Submission sheet to the far left so that it is the first sheet people see.
1. Make sure your players, salaries, birth dates and GPs are correct.
2. Roles:
C1-C4 for Cs. If you have a 5th C, assign a W spot
W1, W3, W5, W7 are the LW spots
W2, W4, W6, W8 are the RW spots
If you have a 7th D, assign it the W8 spot
3. In the "REL" column, you are supposed to list anyone who is going to be on your IR. If you put REL1 in that column, the cap of the player on LTIR won't count towards your cap.
4.In the same "REL" column, put "Active" beside players you have on your active roster and "Extra" as players on your bench. Then Select Columns A-I and at the top of Google Docs go to Data > Sort Range... > Check off "Data has a header row" > Sort by Column B "A-Z" > Click Sort. This will sort put all your active players at the top.
5. Change the order of the spreadsheets (this is a matter of preference) at the bottom. Right now if someone clicks the link, your Picks sheet opens up first. Instead click and drag the Roster Submission sheet to the far left so that it is the first sheet people see.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 12:59 pm
Down with the first two pointsSuperMario wroteCOLONGuys some suggestions from me:
1. Make sure your players, salaries, birth dates and GPs are correct.
2. Roles:
C1-C4 for Cs. If you have a 5th C, assign a W spot
W1, W3, W5, W7 are the LW spots
W2, W4, W6, W8 are the RW spots
If you have a 7th D, assign it the W8 spot
3. In the "REL" column, you are supposed to list anyone who is going to be on your IR. If you put REL1 in that column, the cap of the player on LTIR won't count towards your cap.
4.In the same "REL" column, put "Active" beside players you have on your active roster and "Extra" as players on your bench. Then Select Columns A-I and at the top of Google Docs go to Data > Sort Range... > Check off "Data has a header row" > Sort by Column B "A-Z" > Click Sort. This will sort put all your active players at the top.
5. Change the order of the spreadsheets (this is a matter of preference) at the bottom. Right now if someone clicks the link, your Picks sheet opens up first. Instead click and drag the Roster Submission sheet to the far left so that it is the first sheet people see.
Point 3/4: it's there so you can add LTIR replacements (not the actual player on LTIR, but the replacement), but if that's how you want to sort it go nuts. I made the default sort priority:
1. C - W - D - G
2. Waiver eligibility
3. Cap hit
4. Age
Point 5: I'd prefer if people didint move their sheets around so we all have: [picks] [submission] [week 1] .... [week 5]
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 1:03 pm
Google docs went ape shit shen I tried to open on my phone ... not sure why. I'll see what it does later when I can get on my laptop.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 1:07 pm
Care to explain how to sort the left side? From what I see as my options on google doc's I cannot tell it to sort C-W-D-G
My process was tedious, if there's a simple process I'm sure others would appreciate it.
My process was tedious, if there's a simple process I'm sure others would appreciate it.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 1:10 pm
You're right, google docs prob doesn't allow for sophisticated sort functions. I created this in Excel proper and a bit of functionality was lost in the translation to google docs.Nick wroteCOLONCare to explain how to sort the left side? From what I see as my options on google doc's I cannot tell it to sort C-W-D-G
My process was tedious, if there's a simple process I'm sure others would appreciate it.
That said you can still have tiered sorting, but not my preferred method.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 10:32 pm
Done. Pretty spiffy there, Michael. This should help quite a bit ... especially with lackadaisical GMs.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 10:34 pm
can someone do mine for me, im busy.
Re: Roster Templates
PostedCOLON Thu Sep 12, 2013 11:37 pm
anton wroteCOLONcan someone do mine for me, im busy.
Re: Roster Templates
PostedCOLON Fri Sep 13, 2013 7:49 am
8 of 29: BUF, CAR, CGY, LAK, NSH, NYI, PIT, and TBL have sent me their addresses.
Re: Roster Templates
PostedCOLON Fri Sep 13, 2013 8:37 am
hello?
just out of curiosity here, when is this template roster current upto? Ennis isn't in this one
just out of curiosity here, when is this template roster current upto? Ennis isn't in this one
Re: Roster Templates
PostedCOLON Fri Sep 13, 2013 8:59 am
Hi. A couple weeks ago.gooker wroteCOLONhello?
just out of curiosity here, when is this template roster current upto? Ennis isn't in this one
Re: Roster Templates
PostedCOLON Fri Sep 13, 2013 9:02 am
ALL EDITED AND FINISHED
https://docs.google.com/spreadsheet/ccc ... tSkE#gid=1
https://docs.google.com/spreadsheet/ccc ... tSkE#gid=1
Re: Roster Templates
PostedCOLON Fri Sep 13, 2013 9:09 am
Humm, I guess I have to google Google Docs. I have no idea what the hell you are talking about...lol...I may need some extra help. I am far from a computer guy.