search

jbholden / cdcpool_google

0 stars 1 forks source link

excel data import defaulters #7

Closed jbholden closed 10 years ago

jbholden commented 10 years ago

When exporting prior years results from the excel spreadsheet, I believe that players that had defaulted before (pick value blank) now have a value of "-d-" for their pick in the pool standings excel worksheet.

Is this assumption correct? What is this "-d-" value?

blreams commented 10 years ago

That was something that I started when we first came up with the default rule, because I thought there might be a situation where we would want to be able to look up that information. However, not all of the other commissioners adhered to this "unwritten rule".

But all is not lost. I believe that you can depend on the fact that a player has picks but does NOT have a tie-break score entered as an indication that they defaulted.

jbholden commented 10 years ago

A few clarifications to make sure this is correct.

jbholden commented 10 years ago

One more comment, in 2012 week 4 the value of "D" was used to mean default, not "-d-". This value will not always be the same, right?

jbholden commented 10 years ago

In 2012 week 5, Chris C. did not enter a pick for game 9, but entered picks for the rest of the games. Therefore this assumption does not hold:

jbholden commented 10 years ago

Sorry for the larger number of posts, but I ran across some corner cases.

2012 week 6 Rob N:

2012 week 12 Jason H., Rob N., Moises P, Van S.

blreams commented 10 years ago

I believe your clarifications are correct...namely:

Both of the above assumptions are True.

It is true that default picks were marked using a variety of symbols (d, D, etc.). You should make no assumptions about the symbol used implying default.

You specifically mentioned 2012 Wk05 Chris Carter...He did actually make all 10 picks. One of his picks (Game #9) used the symbol, so it may be getting filtered when you read it in. There are many cases where a player (Simon Chan in particular) used to make all of his picks. This was done in an attempt to obscure his picks so other players couldn't easily see it.

In 2012 Wk06, Rob Nance's picks represent a typo on the part of the commissioner. Let me explain how I normally would handle defaults...and how Bill did it differently. For weeks where I was the commissioner and there were defaults, I would enter all the scores and figure out which player had the lowest non-default score. I then used that player's picks as a template to enter default picks for the defaulters (using 'D' or something similar as the symbol). I purposefully left the tie-break score blank. Bill, OTOH, would simply hard-code the value in Row 25 with the default score, blowing away the formula in the process. For Rob's picks that week, he didn't enter template picks...he just put '3' in the score row. But it looks like he made a typo and inadvertently entered '3' in Row 24 such that it looks like half of a tie-break score. You should manually override that pick.

In 2012 Wk12, Bill did the same thing overriding the formula that calculates the defaulting players' scores without also entering template default picks. You should manually override these, too.

blreams commented 10 years ago

If it will help, I would recommend that we add the 2012 and 2013 spreadsheets as collateral for this project. As you find discrepancies like this, I can modify/correct the spreadsheets to meet the assumptions outlined above.