MAIN FORUM

Comments

  • sneakyb

    I’m trying to add a solver constraint that will force the solver to select players from a minimum or maximum number of teams. For example, on some NBA slates I would want the solver to select players from at least 6 teams. Anyone have any idea on how to do this? I’ve tried various formulas but Excel keeps giving me the Non-Linear message, and the Non-Linear solver doesn’t work for me.

  • stv1313

    • Ranked #74

      RG Tiered Ranking

    I’ve played with this for a number of years. As best I can tell, there is no way to select a minimum or maximum number of teams. I have seemingly tried every formula and get the same error message. If someone has figured it out, I’d love to hear how.

    Instead, I have “gotten around this” by tracking the number of players selected from any one team. In your example, if you sent a constraint that prevents your solver from selecting more than 2 players from a single team, you will essentially get a roster that consists of players from a diverse number of different teams. It doesn’t always work out perfectly, but it gets me close.

  • Jvanspro

    You are much better off to upload your projections and use lineupHQ. It’s so much easier and a much better lineup builder then excel will ever be.

  • stv1313

    • Ranked #74

      RG Tiered Ranking

    I agree with Jvanspro. LIneupHQ is a great tool.

    With that being said, I primarily use solver for the smaller sites that LineupHQ doesn’t support.

  • sneakyb

    Thanks for the replies… STV, the max player per team is a decent workaround, but I often end up with 4-5 teams when I want 6 or 7 teams. The Lineup HQ seems nice, but I don’t feel like paying that much for the stack/premium version. The minimum team constraint I’ve tried has sort of worked by just doing a lookup of the team and the binary column, but it doesn’t always provide the highest projected lineup. I’ll just keep plugging away at it.

  • Jvanspro

    Just so you know, you can come up with your own stacks and build then into the rules on LineupHQ and that is free. The paid version is quicker but personally I do just fine building stacks in HQ by setting parameters. Hope this helps you out.

  • X Unread Thread
  • X Thread with New Replies*
  • *Jumps to your first unread reply

Sites mentioned in this thread

Use our links to sign up and deposit on sites listed in this thread to get these bonuses:

Subforum Index

New RotoGrinders Sports Betting Section!

Are you a DFS player who wants to get into sports betting?

If you have access to New Jersey sports betting, then use our DraftKings Sportsbook promo code and our FanDuel Sportsbook promo code to get the best bonuses in the NJ industry.

Those who can take advantage of PA online sports betting should use our SugarHouse PA promo code to get the best sports betting bonus in Pennsylvania.

If you don't yet have access to an online sportsbook, check out Monkey Knife Fight, a prop betting platform available in 31 states. Use our Monkey Knife Fight promo code to get a fantastic bonus.

RotoGrinders.com is the home of the daily fantasy sports community. Our content, rankings, member blogs, promotions and forum discussion all cater to the players that like to create a new fantasy team every day of the week. Our goal is to help all of our members make more money playing daily fantasy sports!

Disclosures: All RotoGrinders content contributors are active DFS players. Contributor screen names can be found on their respective RotoGrinders profile pages. Contributors reserve the right to use players or strategies not discussed in their content on RotoGrinders.