Google Docs

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

Re: Google Docs

Post 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
CAM
PostsCOLON 3734
JoinedCOLON Fri May 24, 2013 5:42 pm

Re: Google Docs

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

Re: Google Docs

Post 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
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: Google Docs

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post by Mike »

I have allocated a page on the docs for picks, as we used last season.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: Google Docs

Post by Shoalzie »

Beautiful...
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post 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.
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: Google Docs

Post by Lee »

Had to request access
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post by Mike »

it is public now
Lee
PostsCOLON 16828
JoinedCOLON Tue Jun 15, 2010 12:29 pm

Re: Google Docs

Post by Lee »

Nice, going to assume the sheet you sent is the one I'll be using? Is it OK to start editing?
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

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

Re: Google Docs

Post by Mike »

http://bbkl.ca/google <- will be full directory of documents.

that's bbkl.ca/google
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: Google Docs

Post by Shoalzie »

Looks good, Mike. Thanks as always!
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Bruyns
PostsCOLON 7177
JoinedCOLON Wed Apr 10, 2013 10:18 am

Re: Google Docs

Post by Bruyns »

We need the email invite first right?
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post by Mike »

Yes, just want a few more testers before making 30 docs.
User avatar
Bruyns
PostsCOLON 7177
JoinedCOLON Wed Apr 10, 2013 10:18 am

Re: Google Docs

Post by Bruyns »

No problem
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post by Mike »

please copy and paste from old document WITHOUT formatting, only values, to avoid mangling the new document.
User avatar
Nick
PostsCOLON 16044
JoinedCOLON Tue Apr 13, 2010 1:15 am

Re: Google Docs

Post by Nick »

Exciting.
User avatar
Shoalzie
PostsCOLON 12673
JoinedCOLON Mon May 03, 2010 7:28 pm
LocationCOLON Portland, MI
CONTACTCOLON

Re: Google Docs

Post 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.
DETROIT RED WINGS | ROSTER | FANTRAX
User avatar
Mike
Test 2
PostsCOLON 11390
JoinedCOLON Thu May 06, 2010 7:08 pm

Re: Google Docs

Post by Mike »

Yup
BUTTON_POST_REPLY

Return to