Writers of Pro Football Prospectus 2008

03 Aug 2012

modification ideas to allow 2 different types of Flex's?

My league has 2 flex's: one that can be a RB/WR and one that can be WR/TE. Does anyone have any suggestions for modifying some of the formulas to account for this? (TE and WR have drastically different scoring as well...)

Posted by: wickerman on 03 Aug 2012

8 replies , Last at 18 Aug 2012, 1:18pm by Zac

1
Re: modification ideas to allow 2 different types of Flex's?
by Zac :: Fri, 08/03/2012 - 5:13pm

Depends on those scoring settings. Do you have a dedicated TE position in addition to the TE/WR position? Is your TE scoring high enough that it's worth putting TE into the TE/WR flex?

Here are some suggestions:

1. If you don't have a dedicated TE position, then you can choose the option to combine TE with WR. Then the TE/WR flex becomes a straight WR spot, and the other one stays a RB/WR flex. Downside: this technically makes all your WR spots into TE/WR flex, and technically the RB/WR flex is a RB/WR/TE flex. This may or may not matter depending on how your TE scoring is. For instance, in my league's scoring, only 8 TEs score well enough to qualify as starters under this system. I would try this out, then look at how many TEs get drafted, and see if it seems to make sense.

2. If you have a TE position and a TE/WR flex, then you've got to do some thinking. At the end of the day, all you're trying to do is tell KUBIAK how many starters you're going to have at any given position. Think about that TE/WR position in the past, or look at the projected points once you've got the scoring settings entered (remember that you're probably going to want to use Waiver Adjustment method 3 in this case). Do TEs suck, such that basically everyone is going to put a WR there anyway? Or is it more balanced? Then use decimals for the WR and TE position numbers. If you expect WR and TE to be represented evenly in that spot, that's 0.5 WR starters, and 0.5 TE starters (plus the dedicated TEs and WRs in the other spots). I don't have a version of the spreadsheet where the macros work because of my refusal to use Excel, but I believe it can handle those decimals.

2
Re: modification ideas to allow 2 different types of Flex's?
by alien1rock :: Fri, 08/03/2012 - 5:40pm

"I don't have a version of the spreadsheet where the macros work because of my refusal to use Excel, but I believe it can handle those decimals."

So what do you do instead? Do you just build all of the macro calculations into the spreadsheet somehow? Or sort them by hand?

I end up using my work computer rather than my home computer for Kubiak spreadsheets because it has Excel, which is not ideal.

3
Re: modification ideas to allow 2 different types of Flex's?
by Zac :: Sat, 08/04/2012 - 1:18pm

I update all the numbers in the baselines tab by hand. This is hardly optimal, but it works for me.

If you can get your league settings entered at the office and the Generate the KUBIAK projections, you should be able to save it and then send it to another computer where you can open it with OpenOffice or what have you.

4
Re: modification ideas to allow 2 different types of Flex's?
by alien1rock :: Mon, 08/06/2012 - 9:38pm

Is that all that the macro does? Set the baselines and then sort the list? Or is there more to it than that?

5
Re: modification ideas to allow 2 different types of Flex's?
by Zac :: Tue, 08/07/2012 - 3:46am

The formula in the FPoints Over Baseline column can change based on your settings, and the macro does the changing.

1. If TEs have their own position then the formula will use the TE baseline. If they are combined with WR it will use whatever baseline the WR use (see #2).
2. In leagues with a Flex, both RB and WR will use the Flex Baseline. In a league with no flex, RB will use either RB1 baseline or RB2 baseline depending on the baseline method you choose. WR will use WR baseline.
3. DBs in IDP leagues will either have an overall DB baseline or separate baselines
for CBs and SAFs.
4. Likewise, DL in IDP leagues will either have an overall DL baseline or separate DE and DT baselines.
5. The formulas for TEs, K, and DEF will change based on what Waiver Adjustment method you use. Though this could easily be integrated into the formula the same way that Playoff Adjustment and Risk Adjustment are.
6. And columns CZ, DA, and DB get hidden if you tell it to ignore auction values.

And of course the things we've already mentioned: calculating the baselines and sorting by column CO.

I should also mention that the hardest baseline to manually set is the Waiver Baseline.

6
Re: modification ideas to allow 2 different types of Flex's?
by wickerman :: Tue, 08/07/2012 - 3:40pm

Whoa, @Zac thanks so much for your suggestions. First I'll get a few of your questions out of the way:

1) There is a dedicated TE position. There is (1) RB, (1) WR, (1) TE, (1) RB/WR Flex and finally (1) WR/TE Flex.
2) The scoring does make TE's quite valuable because they are the only position to get a PPR, though they only get 1 pt/15yards as opposed to 1pt/10yards receiving for WR/RB, but this is an adjustment I've already made in column W of the spreadsheet (added an extra if statement).
3)I am in fact using Waiver Adjustment 3.

On another note, last year was the first year that these new rules were in place (allowing for a second flex at WR/TE, it used to be (1)RB, (2) WR, (1) TE and (1) RB/WR, but its also the first year that TE got less points per yard receiving than WR/RB). And I was the ONLY team that EVER played more than one TE in a week. SO though I don't think there is an abundance of need to value TE separately I think considering TE's are not properly valued by the rest of the league there may be an opportunity...

Again, thanks for the ideas...

Edit: Well I started playing around with values from 1.5WR/1.5TE in the starting player column and worked all the 1.9WR/1.1TE. Seems like 1.7WR and above yields one player layout and 1.6WR and below yields another so I seem to have run into a truncation issue. I'd like to manipulate the actual macro to make sure its accurately calculating baselines but there doesn't seem to be a way to edit the actual macros and this should certainly serve its purpose. Thanks again

7
Re: modification ideas to allow 2 different types of Flex's?
by jayhawkco :: Fri, 08/10/2012 - 2:41pm

It's been a while since I tried, but I'm pretty sure OpenOffice allows you to edit the macros. Just can't run them. =)

Chris

8
Re: modification ideas to allow 2 different types of Flex's?
by Zac :: Sat, 08/18/2012 - 1:18pm

Yeah, you're right. I just looked at the macros and I see it pulls all the information in as integers so that's not going to work quite the way you want. I'm hoping you haven't had your draft yet. Once I realized that, I devised a new strategy to compensate at http://www.footballoutsiders.com/discussion/qb-flex-question .

Login or register to post comments