Writers of Pro Football Prospectus 2008

27 Jul 2013

2 QB Leagues

Hello. I am new to this and if it has been answered I apologize in advance.

I am in a league where you can flex the QB. That means they fly off the board. I think 15 went in the first 2-3 round of a 12 team league last year. One guy carried 5 QBs at one time last year...

Anyway, how do I enter that in the scoring tab? Thanks.

Posted by: bolhead on 27 Jul 2013

13 replies , Last at 19 Aug 2013, 2:06pm by wickerman

Re: 2 QB Leagues
by jayhawkco :: Sun, 07/28/2013 - 8:50am

I would say just make the roster requirements that you start 2QBs. Because with most scoring systems, you'd be crazy not to..


Re: 2 QB Leagues
by super.mighty :: Mon, 07/29/2013 - 2:59pm

I have the same issue, and scoring in my league has been modified to equalize the contribution of offensive players, so it isn't a no-brainer that you would start a second QB. Is there any way to add the QB as a flex option?

Re: 2 QB Leagues
by jayhawkco :: Mon, 08/05/2013 - 5:48pm

You have to do it manually as follows:

1) Fill out the scoring tab as required, making sure to at least have one flex position selected.
2) Generate your KUBIAK.
3) Sort by Dynamic FF Points.
4) Calculate the number of "Flexable" players that start in your league, i.e. # of QB, WR, RB, and TE x # of teams in your league. That number is x.
5) Find out how many Dynamic FF Points the xth player scores.
6) Type that number on the "Baselines" tab in cell C10.
7) Go back to the Projections tab and sort by Position.
8) On the top QB (and TE if applicable), go to column CO and delete the "QB" letters at the end of the formula and replace it with "Flex".
9) Click the small box in the bottom right hand corner of the cell selection box and drag down to copy that formula to all the rest of the QBs.
10) Then sort by Fantasy Points over Baseline then by Dynamic Fantasy Points (can be done in one step).

There ya go.


Re: 2 QB Leagues
by bolhead :: Tue, 07/30/2013 - 8:17am

Wow thanks!

I was told there was going to be no math... :-)

Re: 2 QB Leagues
by Zheng :: Tue, 07/30/2013 - 8:07pm

You're on the wrong football site if you don't like math... ;)

Re: 2 QB Leagues
by super.mighty :: Mon, 08/05/2013 - 3:39pm

Thanks for this! Question - should the same adjustment be made to the TE position in step 8 above?

Re: 2 QB Leagues
by jayhawkco :: Mon, 08/05/2013 - 5:48pm

Yep. If TE is included in the flex. Sorry I left this out above. I will edit.


Re: 2 QB Leagues
by jurassicxi :: Mon, 08/12/2013 - 6:46am

Just to make sure I understand the instructions for altering the FLEX concept and and am applying them correctly:

- my league has 12 teams
- we start 1QB, 2RB, 2WR, 1TE, 1FLEX (RB/WR/TE), 1DST, 1K
- re point 4) of your list, I am assuming I count 5 "flexable" players (then multiplying by 12)? i.e. I do not include the flex spot itself, which would mean counting 6 flexable players
- then I count down to the 60th RB/WR/TE (I ignore the QBs) and use their Dynamic Fantasy Points as the new baseline.

That's what I've done, and it increased the FLEX baseline by 1 point. That had the effect of dropping TEs further down the rankings, which is not what I was expecting, since I still have to start at least 1...

Re: 2 QB Leagues
by wickerman :: Tue, 08/13/2013 - 1:42pm

@jrassicxi, I am far from an expert in excel, or in particular this "fix", but I would guess that you would count SIX "flex" players and multiply by 12. Really you're trying to find what the replacement level, or worst positionally appropriate player should score for a team and then measure each other player against that "Baseline". So I would think you should be looking for the 72nd RB/WR/TE.

@jayhawkco I'm sorry to pile on to your generous support, but do you have any idea how I would implement 2 distinctly defined flex's? My league requires 1RB 1WR 1TE 1WR/RB Flex and 1WR/TE Flex making using KUBIAK accurately very difficult. Additionally the commish's have tried to "normalize" the scoring (e.g. only TE get PPR, only WR get 50% more pt/RcYd). I posted my own topic but haven't gotten any responses and realize its likely that this is too complicated to fix without access to the macros but was hoping maybe you had an idea.

FYI: Currently my settings are for 1 starting RB and 3 starting WR/TE with the Tight End Method set to 2 (this will work for now but its far from perfect and I think undervalues TE's)

Re: 2 QB Leagues
by jayhawkco :: Fri, 08/16/2013 - 11:16am

I think what I'd do is set the roster requirements to 1 RB, 1 WR, 1 TE, and 2 Flex, include TEs in the flex and do not have the waiver baseline drop include TEs. Since scoring has been normalized to try and make positions more equal or whatever, I think you'd get the same approximate player mix as you'd see in your actual league this way. YMMV.


Re: 2 QB Leagues
by wickerman :: Fri, 08/16/2013 - 3:02pm

Cool, thanks Chris! I'll give that a shot and probably use a hybrid of the two...

To Clarify: I'm replacing the position listed in column D for ALL RB, WR and TE to FLEX right?

Edit: Just realized this will screw up the fixes I put in to account for the weird individual positional scoring the commish's put in to normalize (i.e. my modifications to column W (Rec) and Q (Rush).

Edit: NM, I edit column CO. Reading is FUNdamental!

Re: 2 QB Leagues
by jayhawkco :: Sat, 08/17/2013 - 8:02am

So that sounds like you got it to work? Kinda?


Re: 2 QB Leagues
by wickerman :: Mon, 08/19/2013 - 2:06pm

I did get it to work, just fine. Thanks for your help. As expected, the results are very similar to my previous method. Thanks again.

Login or register to post comments