Roster Templates

Anything goes here OT stuff is OK too!
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Roster Templates

Post by 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.
User avatar
Nick
PostsCOLON 16044
JoinedCOLON Tue Apr 13, 2010 1:15 am

Re: Roster Templates

Post by 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).
User avatar
kimmer
PostsCOLON 18090
JoinedCOLON Thu Sep 02, 2010 2:25 pm
LocationCOLON Ontario, Canada

Re: Roster Templates

Post by kimmer »

what if I already have a Google doc roster (detailed)
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

gooker wroteCOLONwhat 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.
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

Nick wroteCOLONDo 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.

Nick wroteCOLONand 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.
User avatar
Nick
PostsCOLON 16044
JoinedCOLON Tue Apr 13, 2010 1:15 am

Re: Roster Templates

Post by 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).
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

Mike wroteCOLON- 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.
User avatar
The BBKL Insider
PostsCOLON 22628
JoinedCOLON Mon May 03, 2010 8:46 pm
LocationCOLON San Juan, Puerto Rico

Re: Roster Templates

Post by The BBKL Insider »

does a hotmail account work mike?

i've never registered for anything under google before
Image
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

Big Fun wroteCOLONdoes 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.
User avatar
The BBKL Insider
PostsCOLON 22628
JoinedCOLON Mon May 03, 2010 8:46 pm
LocationCOLON San Juan, Puerto Rico

Re: Roster Templates

Post by The BBKL Insider »

Mike wroteCOLON
Big Fun wroteCOLONdoes 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.
Image
User avatar
Robin Hood
PostsCOLON 13589
JoinedCOLON Mon May 03, 2010 5:09 pm

Re: Roster Templates

Post by Robin Hood »

Great work Mikey. PMed my gmail acccount
Image
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

Mike wroteCOLONKnown Issues

- Non-contracted old-ass players are shown as waiver eligible. Will be fixed in next version. (Thx Nick)
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

SuperMario wroteCOLONGreat work Mikey. PMed my gmail acccount
This'll be an easy one
User avatar
Robin Hood
PostsCOLON 13589
JoinedCOLON Mon May 03, 2010 5:09 pm

Re: Roster Templates

Post by Robin Hood »

Mike wroteCOLON
SuperMario wroteCOLONGreat work Mikey. PMed my gmail acccount
This'll be an easy one
Haha.
Image
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by 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
PostsCOLON 4043
JoinedCOLON Sun Nov 06, 2011 5:09 pm

Re: Roster Templates

Post by Sensfanjosh »

Hey Mike, maybe an easy fix but my sheet only has 4 defensive spots
Image
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

Sensfanjosh wroteCOLONHey 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!
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

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

I saved your work and replaced the template with the standard.
User avatar
Robin Hood
PostsCOLON 13589
JoinedCOLON Mon May 03, 2010 5:09 pm

Re: Roster Templates

Post by Robin Hood »

Mike wroteCOLON
Sensfanjosh wroteCOLONHey 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.
Image
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Roster Templates

Post by Mike »

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

Return to