Roster Templates

[Nick]

anyone who would like a hand walking through their spreadsheet just shoot me a PM. the chat box on the top right in google docs (1 other viewer ->click) can make it easy. Plus you'll be able to see where I am selecting on the spreadsheet via a different colour outline for other viewers. Really is a very quick and user friendly process.

[Tony]

[Nick]

Even he still made it to the top.

[Mike]

I'd say about a third of you are insisting on copying and pasting the players and their salaries onto the right hand side. Your positions will all be lost when I make the first update to the spreadsheet.

Please read the instructions: http://bbkl.ca/viewtopic.php?f=8&t=9920

[Tony]

Is copy/paste for the left list okay then?

[Nick]

for names and salaries and such left of column H, yes you can. Column H and right to are messing with the glory of this spreadsheet. super easy to use if you take the 1 minute to read instructions

[Mike]

Is copy/paste for the left list okay then?

Copy + paste special -> Data only, so you're not screwing with formatting. Also only columns A->G. Everything H->over is dynamic and should not be touched.

[Mike]

Known Issues

- Non-contracted old-ass players are shown as waiver eligible. Will be fixed in next version. (Thx Nick)
- 78 slots by default instead of 90
- beware waiver eligibility of goalies. they have a 75 game threshold rather than 150 like the others. I didn't program that properly, needs fixing.

All fixed in v2. Live in Cliff's spreadsheet now. Will add it to all as I verify your submissions.

[CAM]

Can someone just take a peak at mine and verify i didnt screw up any formatting before proceeding.

[Mike]

Your formatting is pretty screwed up, as you didn't follow the instructions. You should not copy and paste, only place the roles next to the player as you want them.

[CAM]

lovely....nice waste of time...

[CAM]

sorry

[CAM]

If possible can you copy and paste from blank template the formulas in the starting lineup part and i will reassign properly...

[Mike]

yes

[Mike]

Replaced with v2 spreadsheet.

[CAM]

TY. I wont mess it up anymore. Once Wed comes, this is just the roster that is submitted for asset tracking purposes, correct? Like i can make changes to my active roster? for example, players on PTO's...

[Mike]

I don't know that I understand your question. Once you submit I will duplicate your Roster Submission sheet and name it Week 1. Roster submission will be locked and no longer editable. You will then be able to edit week 1.

[CAM]

Ok, i can then edit Week 1 as I see fit. That fine. Oct 1 is first games. I know there will be changes after Wed for alot of teams with cuts and contracts for PTO's. I will edit Week 1 roster submission and track transactions.

[The BBKL Insider]

what if i make a trade after the 25th? am i allowed to re-set my roster? or say one of the guys i submit gets hurt and i want to use a bence player before opening night, can i make that move?

[Mike]

Once you submit I will create a sheet called week 1 you can then edit..