Roster Templates

[Mike]

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.

PM me if you need help

[Mike]

ALL EDITED AND FINISHED
https://docs.google.com/spreadsheet/ccc ... tSkE#gid=1

All players need a ROLE, still gotta assign some M's to your minors players and feed the waiver wire.

[kimmer]

done

[Mike]

Known Issues
- 78 slots by default instead of 90
- beware waiver eligilbility of goalies. they have a 75 game threshold rather than 150 like the others. I didn't program that properly, needs fixing.

[Shoalzie]

Without reading all the posts...does this Google doc reference a master doc or so we enter the data ourself?

[Mike]

Without reading all the posts...does this Google doc reference a master doc or so we enter the data ourself?

no master doc on google.

Your sheet has what was on CBS a couple weeks ago, which is taken from a master doc i compiled and have offline.

[CAM]

mo fo...I am blocked at work. I have excel spreadhseet all filled out that i use, with probably all needed info. im gonna pm you mike to get your email address so i can send my spreadsheet or should i just wait to get home and open link? Do i have to fill it all out? Can i do it on my phone once its online and good to go?

[Shoalzie]

That's what I figured...but once the data is on there, it's there so that's good.

[Mike]

mo fo...I am blocked at work. I have excel spreadhseet all filled out that i use, with probably all needed info. im gonna pm you mike to get your email address so i can send my spreadsheet or should i just wait to get home and open link? Do i have to fill it all out? Can i do it on my phone once its online and good to go?

I don't quite understand. You want to send me a spreadsheet? You need to use the template I'm providing.

You'll have to update it at home I guess. Or tell your boss their internet policy is ridiculous. Or use a VPN/tunnel

[kimmer]

mo fo...I am blocked at work. I have excel spreadhseet all filled out that i use, with probably all needed info. im gonna pm you mike to get your email address so i can send my spreadsheet or should i just wait to get home and open link? Do i have to fill it all out? Can i do it on my phone once its online and good to go?

old man, about 85% of the work is already done on the template. ALL roster player names (as of 2 weeks ago) + most of salaries/DOB are already entered in the cells. You have to fill out their ROLES (c1-4/w1-8/d1-6/bench (b1-3)/IR/LTIR/g1-2)and it automatically places coresponding players to appropriate lineup cells already again, made in the template. ur job is to do that and then fill out the rest of the missing DOB/salaries where appropriate. Place the letter 'M' for all minor players under the roles

[CAM]

Thank you young punk. I would have figured that out if i could open it. And my boss is the entire Government of New Brunswick Internal Services agency that develops internet policy. Im not changing nothing....lol Thank you both for the written explanation while i am at work. Hard to imagine things without a little describing.

[Mike]

fine i'll tell them next time i'm in nb.

[kimmer]

maybe once u tell ur boss how "famous" you've become in the hockey world and how BB fears ur opinion and almost put u in jail, maybe he will respect u and give u privilege

[Mike]

he's no poonerman

[CAM]

he's no poonerman

true dat....

http://www.youtube.com/watch?v=kc_bftkpXZE

[Nick]

It's wicked easy and quick to use.


Aside from adding missing pieces (that CBS lost) all I had to due was set the positions, or "Role" as the spreadsheet heading is called. Crosby = C1, Stamkos = C2, LW are odd W# (1,3,5,7) , RW are even # W (2,4,6,8)

[CAM]

excellent

[Nick]

To any haters. This is easier than your system, it does the cap for you. Mike has done some very nice work.

Step-by-step:

click the link -> "TEAM Abbreviation " spreadsheet should open, and it's an empty list of picks (add your picks that match to year/round).

Next at the bottom of the page (the bottom bar) reads "Picks" and just next to it is "Roster Submission", click it.

Now you should see a spreadsheet of your team (up to date with CBS about 10 days ago). To begin:
Under Column C " Role" next to Steve Stamkos, type "C2" (he's my 2nd line center)
Next to Sidney Crosby I type "C1" for first line center.


for someone in your minors like Nathan Beulieu, his role (in Column C) should be "M", repeat for other AHLers and other prospects (just M, no #). You'll get a !!! and red bar in column "I" if that player would require waivers to be in the minors (a very nice feature).

For Nik Kulemin who I'm guessing is my top line LW, under Role, in Column C type in "W1". RW will be W2.

#1 Left- dman spot (Tyler Myers) is D1.

Fill in C1-C4 (no repeats)
W1-W8 (no repeats)
D1-D6 (again, no repeats)
G1 & G2

If you want to dress a 7th dman, call their position W8, same story for a 5th Center (following the rule of no repeat positions - to be clear, with 5C & 7D, you'd dress one of the at W7 and one at W8 - as you have have 6 wingers dressed (W1-W6), and the C(1-4) D(1-6) are already full. This is a safe way to make sure you're dressing the correct # of players.


At any point, after entering a players position, you should see them appear on the right side of the spreadsheet - and you'll see the cap info update automatically.


you'll need to empty the cells of players you've traded away , and add players you've traded for (simple as entering his data in the right cells).


This sheet auto-calculates your cap situation, number of active players, number of contracts (assuming you enter the data correctly), it lets you know who requires waivers (under our rules - except for unsigned players), and really eases the burden of organizing your team. Try it with an open mind and you'll love it.


Just like many others here, I have a system I'm evolved since season one, it'd tidy and I trust it myself, but a common spreadsheet for all is a much superior option.

[kimmer]

^ TL;DR

[anton]

To any haters. This is easier than your system, it does the cap for you. Mike has done some very nice work.

Step-by-step:

click the link -> "TEAM Abbreviation " spreadsheet should open, and it's an empty list of picks (add your picks that match to year/round).

Next at the bottom of the page (the bottom bar) reads "Picks" and just next to it is "Roster Submission", click it.

Now you should see a spreadsheet of your team (up to date with CBS about 10 days ago). To begin:
Under Column C " Role" next to Steve Stamkos, type "C2" (he's my 2nd line center)
Next to Sidney Crosby I type "C1" for first line center.


for someone in your minors like Nathan Beulieu, his role (in Column C) should be "M", repeat for other AHLers and other prospects (just M, no #). You'll get a !!! and red bar in column "I" if that player would require waivers to be in the minors (a very nice feature).

For Nik Kulemin who I'm guessing is my top line LW, under Role, in Column C type in "W1". RW will be W2.

#1 Left- dman spot (Tyler Myers) is D1.

Fill in C1-C4 (no repeats)
W1-W8 (no repeats)
D1-D6 (again, no repeats)
G1 & G2

If you want to dress a 7th dman, call their position W8, same story for a 5th Center (following the rule of no repeat positions - to be clear, with 5C & 7D, you'd dress one of the at W7 and one at W8 - as you have have 6 wingers dressed (W1-W6), and the C(1-4) D(1-6) are already full. This is a safe way to make sure you're dressing the correct # of players.


At any point, after entering a players position, you should see them appear on the right side of the spreadsheet - and you'll see the cap info update automatically.


you'll need to empty the cells of players you've traded away , and add players you've traded for (simple as entering his data in the right cells).


This sheet auto-calculates your cap situation, number of active players, number of contracts (assuming you enter the data correctly), it lets you know who requires waivers (under our rules - except for unsigned players), and really eases the burden of organizing your team. Try it with an open mind and you'll love it.


Just like many others here, I have a system I'm evolved since season one, it'd tidy and I trust it myself, but a common spreadsheet for all is a much superior option.

do mine for me, im busy