Page 3 of 8

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:02 am
by Mike
CAM wroteCOLONThx Mike, wish i could help except i am blocked. yeehaa.

For future reference:

Do you share each document individually or to the entire league?
Folder including all docs: shared to entire league for viewing

Individual docs: shared to individual GMs with editing permissions

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:14 am
by CAM
So, can you give me a coles notes on procedure on if i need to login into to google Drive, or what...All i have is a BOS doc that is shared to me that i edited the last tab to OFFSEASON and updated all my players. Is that a seperate version from the with editing rights to the individual? Does the individual one automatically copy to the one shared for league?

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:18 am
by Mike
You will get an email bringing you to a new sheet. Copy columns A through G from your old document (that's Position through GP) and paste it (right click, paste special, paste values only) in the new spreadsheet. Edit values (GP updates, etc).

There is only one document for each team. The collection is a sum of all the documents.

BBKL Folder [ all have view access ]
- Boston [ all have view access, only you and I have write access ]
- Toronto [ all have view access, only I have write access ]
- etc

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:40 am
by Shoalzie
Where are we keeping track of our picks? I've got everyone's links to their draft picks from their current sheets that I keep track of.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:49 am
by Mike
I have allocated a page on the docs for picks, as we used last season.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 9:59 am
by Shoalzie
Beautiful...

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:07 am
by Mike
Preview of new sheet: https://docs.google.com/spreadsheets/d/ ... 1558145770

To have a contract slide set their role to Sx (x can be 1 through 20). Note that I have elected to make both eligible sliders slide. Keep their contract in there and it will be automatically subtracted from the total.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:08 am
by Lee
Had to request access

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:09 am
by Mike
it is public now

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:10 am
by Lee
Nice, going to assume the sheet you sent is the one I'll be using? Is it OK to start editing?

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:12 am
by Mike
Lee wroteCOLONNice, going to assume the sheet you sent is the one I'll be using? Is it OK to start editing?
No let me replace it, a few changes made.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:16 am
by Mike
http://bbkl.ca/google <- will be full directory of documents.

that's bbkl.ca/google

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:18 am
by Shoalzie
Looks good, Mike. Thanks as always!

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:23 am
by Bruyns
We need the email invite first right?

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:25 am
by Mike
Yes, just want a few more testers before making 30 docs.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:25 am
by Bruyns
No problem

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:27 am
by Mike
please copy and paste from old document WITHOUT formatting, only values, to avoid mangling the new document.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:28 am
by Nick
Exciting.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:35 am
by Shoalzie
I started a "Players" page on my last Google sheets I should be able to copy over to this new one. I use it so all I have to do is type in the players name and it gives me salary and birthdate and GP.

Re: Google Docs

PostedCOLON Mon Oct 06, 2014 10:36 am
by Mike
Yup