Roster Templates

[Mike]

Directory of BBKL Team Spreadsheets [link]

I am going to provide all 30 teams with Google Docs spreadsheets for their rosters. This roster will be editable by the team's GM and myself. They will be viewable by anyone with a link. These spreadsheets will provide a standardized format for asset management. They will be required for roster submissions.

How they work

The first thing I need all of you to do is PM me the e-mail address you will use to login to Google Docs. I suggest a gmail account, but any will work as long as you sign up for a Google account if you do not already have one. Once I have this I will upload your team's barebones spreadsheet. It will include all your players that were on your CBS page (minus placeholders) dating back a couple weeks ago.

I have auto-added as many dates of birth, GP numbers, cap hits, and positions as I could. There will be errors. Some of these errors are due to the data sources I've used having different names (ie Mike for Michael, PA for P.A.), salaries are taken from CBS so any that aren't resolved down to a whole $1,000 are rounded. Many birthdays are not available, same with GP numbers. Many of my wingers were listed as centers!!! Double check all your positions. Please add all these in manually. You will need to verify all your players are listed.

Once you have all your players added with all their info please take a look at the first tab in your spreadsheet. This will house your picks. Please make sure your picks are consistent with Shoalzie's List.

Now: you've got all your assets entered. If you want them sorted neatly (Cs-Ws-Ds-Gs) you can select the range and sort them yourself or ask me for help.

Assets on the left, a blank roster on the right. To fill this roster in you simply need to assign a ROLE to all your players. It's pretty straightforward, at least I think it is. Who do you want to be your number 1 center? Put C1 next to his name. 2nd line left wing? Put W3 down. Minors? put M next to it. Short term injury? IR1 through IR5.

Long Term Injured Reserve is a bit more complicated, but still fully automated within this spreadsheet. You still need to report it in the LTIR thread as per usual. Say the injured player is Jonathan Toews on my team. I replace his C1 tag with LTIR1. This opens a spot on my top line and I adjust accordingly. To make use of the space he provides I'll start by calling up Zack Kassian. I'm gonna slot Kass into the 3rd line wing slot (W5). But there's another step here so I can get a rebate for his cap hit. Next to his ROLE slot I'm also gonna list him as REL1. This will automatically remove his cap hit.

----------------------------------------------------------------------------------------------

Ongoing Use

When you take over your spreadsheet there will be just two tabs: Picks and Roster Submission. For archival purposes we will duplicate the most recent sheet every week to do our weekly roster submission. The first time we do this it will be like this:
- click the arrow on the Roster Submission tab/sheet at the bottom.
- click Duplicate, this will create a new sheet
- Rename the new sheet (double click it) from "Copy of Roster Submission" to "Week 1"

Bam, you're ready to make your roster adjustments for the upcoming week.

----------------------------------------------------------------------------------------------

Example One: Toronto

This is my sheet, completed, with all my picks/players added. I have also put an example LTIR scenario in there. Unfortunately for all of you Brad Marchand is indeed healthy.

Example Two: Anaheim

Due to alphabetical priority. This is the raw workbook I will give you access to as soon as you PM me your e-mail address.

----------------------------------------------------------------------------------------------

Random Notes

- This sheet will automatically calculate waiver eligibility
- It will warn you if you try to send down a guy that needs to clear waivers
- It tracks your contracts and player totals
- Once a week begins I will lock that "tab" in the spreadsheet. This is to maintain a pristine record of the weeks previous.
- IF you want a 7th d-man instead of 8 wingers please put him in a wing slot. Adding another row of D will break the spreadsheet.

----------------------------------------------------------------------------------------------

Known Issues
- none, if you still have issues it's because you haven't had your sheet upgraded (because you haven't submitted it)

v2 Changelog
FIXED - Non-contracted old-ass players are shown as waiver eligible. Will be fixed in next version. (Thx Nick)
FIXED - 78 slots by default instead of 90
FIXED - 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.

[Nick]

This is seriously epic work, and should ease the burden of roster organization around the league.



Do we all just keep the Weekly rosters in the spreadsheets? So we'll have

Picks, Roster Submission, Week 1, Week 2, ... Week X (Current)


and secondly -> what tab should be our current roster (if different from what's submitted during a weekly roster lock).

[kimmer]

what if I already have a Google doc roster (detailed)

[Mike]

what if I already have a Google doc roster (detailed)

You are welcome to keep your own and use it but for roster submissions this one is required.

I'm gonna keep using my website one I think.

[Mike]

Do we all just keep the Weekly rosters in the spreadsheets? So we'll have

Picks, Roster Submission, Week 1, Week 2, ... Week X (Current)

^--- that is correct.

and secondly -> what tab should be our current roster (if different from what's submitted during a weekly roster lock).

If we're in the middle of week 9 just make changes to the week 10 roster.

[Nick]

makes sense. I just set all the positions & my lineup in less then 2 minutes - this is a dream.

Will update the missing birthdays, GP and salaries when i can (well before roster submission).

[Mike]

- Once a week begins I will lock that "tab" in the spreadsheet. This is to maintain a pristine record of the weeks previous.

Also we already have about 5 teams up and running. Looking good guys.

[The BBKL Insider]

does a hotmail account work mike?

i've never registered for anything under google before

[Mike]

does a hotmail account work mike?

i've never registered for anything under google before

Yep, but you'll need to register for a google account to edit it.

[The BBKL Insider]

does a hotmail account work mike?

i've never registered for anything under google before

Yep, but you'll need to register for a google account to edit it.

ok, i'll do this after work.

[Robin Hood]

Great work Mikey. PMed my gmail acccount

[Mike]

Known Issues

- Non-contracted old-ass players are shown as waiver eligible. Will be fixed in next version. (Thx Nick)

[Mike]

Great work Mikey. PMed my gmail acccount

This'll be an easy one

[Robin Hood]

Great work Mikey. PMed my gmail acccount

This'll be an easy one

Haha.

[Mike]

IF you want a 7th d-man instead of 8 wingers please put him in a wing slot. Adding another row of D will break the spreadsheet.

[Sensfanjosh]

Hey Mike, maybe an easy fix but my sheet only has 4 defensive spots

[Mike]

Hey Mike, maybe an easy fix but my sheet only has 4 defensive spots

on second, i'll re-upload your file.

Note to all: please don't touch the right-hand side of your spreadsheet!

[Mike]

Josh, new file: https://docs.google.com/spreadsheet/ccc ... sp=sharing

I saved your work and replaced the template with the standard.

[Robin Hood]

Hey Mike, maybe an easy fix but my sheet only has 4 defensive spots

on second, i'll re-upload your file.

Note to all: please don't touch the right-hand side of your spreadsheet!

Unless you know formatting you mean right? Lol because I already altered it.

[Mike]

not just formatting, as I said in pm it will break certain functions. Please just dress 7th dmen as wingers.