Writers of Pro Football Prospectus 2008

02 Sep 2013

Yahoo Rank Projection

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 Aaron Schatz

1
Re: Yahoo Rank Projection
by molivares1980 :: Mon, 09/02/2013 - 11:29am

I also am experiencing this issue.

2
Re: Yahoo Rank Projection
by tannerlindsay :: Tue, 09/03/2013 - 12:00pm

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 :)

3
Re: Yahoo Rank Projection
by molivares1980 :: Tue, 09/03/2013 - 7:47pm

Thanks tannerlindsay!

4
Re: Yahoo Rank Projection
by Zheng :: Tue, 09/03/2013 - 11:17pm

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.

5
Re: Yahoo Rank Projection
by Aaron Schatz :: Wed, 09/04/2013 - 3:08pm

Sorry. Fixed now.