Talk amongst yourselves
02 Sep 2013
On 9-1 files, when I update the the file after updating the league scoring, the Yahoo Ranks and Yahoo Delta cell are wrong.
Posted by: gardner4145 on 02 Sep 2013
5 replies , Last at
04 Sep 2013, 3:08pm by
I also am experiencing this issue.
I had that problem and figured out what it is. A VLookup is being used to find the rank, and the key is is looking for is PlayerName|Team|Position. That key is created by various sheets.
The Yahoo Ranking sheet has a space (' ') after the name of the team, so the vlookup isn't matching it.
You can fix this by using an empty column and putting in =Trim(B2), then copying that all the way down the list. That will remove the extra space. Then copy the column you made and do a Paste Special -> Values over top of the Team column on the Yahoo sheet.
That fixed it for me. Moved Adrian Peterson from 790 to 1 :)
Yahoo ranks in KUBIAK seem to be old anyway. KUBIAK lists last update as 9/1. Yahoo now seems to rank David Wilson (for example) at 17, not 60.
Sorry. Fixed now.
© Football Outsiders, Inc. // Site powered by Stein-Wein // Partner of USA TODAY Sports Digital Properties