Google Docs Draft Pick Errors (Updated: 1/25)

[dave1959]

Fixed mine

[Shoalzie]

I'll do another review in the next week or so. This morning, I'll get the picks updated from the deals leading up to the deadline.

I'll also get a "Lottery Watch" thread up today...basically tracking what the first round order will be as our season winds down and how teams missing on GP may affect the final standings.

[kyuss]

that's nice.. thx Scott!

[Fraser]

Thanks Scott been keeping a bustardized McDavid watch myself but it will be good to see some official tallys

[The BBKL Insider]

I believe im missing dallas 1st rd pick from my spreadsheet

[Shoalzie]

that's nice.. thx Scott!

You've got a trade to correct...

http://bbkl.ca/viewtopic.php?f=4&t=12117

[lightupdadarkness]

I believe im missing dallas 1st rd pick from my spreadsheet

You and 20 some other teams I believe but that can all be arranged

[The BBKL Insider]

Whomever gets the top pick im gonna go balls deep for it.

[kyuss]

my guess is you won't be alone

[The BBKL Insider]

My guess is I'll offer the most

[kyuss]

I doubt it.

[Arian The Insider]

I hope I get McDavid

[bills09]

I'll be going balls deep for pick #2

[lightupdadarkness]

They are all mine

[CAM]

What date do i need to fix on my spreadsheet? this is the cell value for calculating waivers:

=IF(F2="","",IF(AND($F2>=DATE(1986,10,1), $H2<120), "Exempt",""))

What do i change it to?

[Shoalzie]

There also needs to include something for goalies and 60 games. I've got a new formula in my off-season sheet.

[Bruyns]

I believe Mike will be providing new spreadsheets this offseason at some point

[Tony]

Oct 6th...

[Shoalzie]

We chose October 1 as an evergreen date.

[CAM]

I cant wait till october. That is my everyday working sheet now. Waiver eligibility is quite important. I want to fix my formulas to reflect new dates.