printable tier sheet

[DUB]

Hi fellas,

What has happen to all the free printable tier sheets online? Everything I searched pulled up pay for membership....

Anyone have a free source so I can easily adjust it via excel?

Good luck to all and to all get that SHIP!!!!

-DUB-

 

[FaCe-LeE-uS]

FantasyPros consensus ranking are free... should be able to print it too

Exporting it to excel may take some wizardry, but should be possible.

 

[SmokingMonkey]

Fantasypros - there's an easy export button - choose .csv if possible, it'll pop up in excel and just give you the data, no pictures or links

you can even filter out the "experts" that you don't like/agree with for improved accuracy to your own rankings, and easily adjust from there once in excel

literally just did this last friday for my work draft and printed them out

 

[eaglesnut]

Hi fellas,

What has happen to all the free printable tier sheets online? Everything I searched pulled up pay for membership....

Anyone have a free source so I can easily adjust it via excel?

Good luck to all and to all get that SHIP!!!!

-DUB-

Make your own.

I make it in Word.

 

[SmokingMonkey]

Make your own.

I make it in Word.

You should really switch to excel, word sucks

 

[averagejoe]

Love my custom EXCEL spreadsheet:

 

[eaglesnut]

You should really switch to excel, word sucks

It's just got names in 5 columns. Word is easy for that.

 

[SmokingMonkey]

It's just got names in 5 columns. Word is easy for that.

It's all about sorting, slicing, and dicing that data, and you can make pretty charts and graphs too.

@averagejoe - did you create all of that from various websites yourself or data dump from 1 site?

 

[DUB]

@averagejoe once again not your averagejoe! Nice setup!

-DUB-

 

[averagejoe]

did you create all of that from various websites yourself or data dump from 1 site?

First thing I do is pull the yardage stats from ProFootball Reference.
Then I pull the snap % from Football Outsiders.
Forgot where I got the redzone percentages? Maybe Outsiders there too.
Salary info I pulled from Sportrac.
The columns you don't see have the ECR and ADP rankings from FantasyPros.

All I do is copy the stats and paste them in their own worksheet.
Then I use the VLOOKUP program in excel the reference the data on the other sheets.
This way (like rankings) if they change, I can just paste the new rankings in the worksheet and it doesn't really affect the main page combining all the data.

Using the filter, you can then separate each team to see who they may be competing with on their own team for touches.

 

[SmokingMonkey]

First thing I do is pull the yardage stats from ProFootball Reference.
Then I pull the snap % from Football Outsiders.
Forgot where I got the redzone percentages? Maybe Outsiders there too.
Salary info I pulled from Sportrac.
The columns you don't see have the ECR and ADP rankings from FantasyPros.

All I do is copy the stats and paste them in their own worksheet.
Then I use the VLOOKUP program in excel the reference the data on the other sheets.
This way (like rankings) if they change, I can just paste the new rankings in the worksheet and it doesn't really affect the main page combining all the data.

Using the filter, you can then separate each team to see who they may be competing with on their own team for touches.

live action footage of me stealing joe's spreadsheet set up:

 

[averagejoe]

live action footage of me stealing joe's spreadsheet set up:

The only frustrating part for me is any data from the Football Outsiders. They have unique stats I haven't found anywhere else. But frustrating part is they don't list the player's first name, just his first initial.
So I have to fix that for VLOOKUP to work. Good news is I have all off season to fix it.

 

[Barilko]

live action footage of me stealing joe's spreadsheet set up:

Smoke my friend plain and simple That is freakin awesome