Draft Oracle: Excel will help you Excel

RJY33

master of reality
Joined
May 2, 2012
Messages
4,075
Reputation
120
Daps
4,326
Thanks for this. I got til Saturday to finalize a plan and may use this a bit. Right now I use the RotoWire Ipad app, which I highly recommend, but this is hardcore. Those Vick projections are :wtf:, Im guessing he comes out somewhere in the middle with a few missed games.

Interesting on that chart that they have Peyton at #5. Most sites seem to have him bottom 10 or so.
 

Listen

Tell me moar
Joined
May 1, 2012
Messages
8,661
Reputation
1,477
Daps
22,810
Reppin
A few Floors Down from the Daily Grind
Thanks for this. I got til Saturday to finalize a plan and may use this a bit. Right now I use the RotoWire Ipad app, which I highly recommend, but this is hardcore. Those Vick projections are :wtf:, Im guessing he comes out somewhere in the middle with a few missed games.

Interesting on that chart that they have Peyton at #5. Most sites seem to have him bottom 10 or so.

Those rankings are my own, and they are based on a particular scoring method.

Depending on how your league scores, the rankings would move around, but their based off the average projections I combined.

So, just to keep up with my kindness, lets look at how I formulate projected points off the projected stats:

zxsguc.png



The highlighted shows my scoring formula to rank the QB's based on a a projected stat average from 4 websites.

So I just put in 25 passing yards = 1 point, 10 yards rushing = 1 point + Passing TD's = 4 points, Rushing TD's = 6 points and INT's = -2 points.

So you can put in your leagues scoring as a formula and then filter the results like I just did to rank QB's off 'average projections'.

:ooh:

Notice how the rankings are different? Different scoring values = different player ranking.

Eat up men.

rabbit-eating-animated.gif
 

South Paw

Superstar
Joined
May 5, 2012
Messages
35,003
Reputation
1,890
Daps
40,242
Reppin
CML
I like to make my own rankings, and I adjust them through pre-season.

Can't trust a formula.
 
Top