CapFriendly Community Mock Draft

Here's what I did, I threw the data from 25 CapFriendly MockDrafts that were uploaded in the past 2-3 days into an excel spreadsheet, there's 58 players on the sheet. I put each players ranking across the 25 mock drafts. Obviously, not all 58 players were ranked in the top 32 on each list so I took how many times a player was drafted into account and added a ranking of 40 to empty cells, not a perfect system but only players later into the draft were impacted by that. Funniest account name goes to DongLord23.

Wanted to do this to look at after draft and try and determine any biases fans have about prospects, maybe right a lil article or something.

If anyone wants to see the spreadsheet for fun or to see if ur on it lmk.

Very cool idea

a lot higher consistency than i thought there would be. seems according to the past 2 days of mock the top 17 are set player wise.

As I was filling in cells I began to notice some consistency