TOOLS FORUM

  • Klemmentine

    I’m trying to put together a solver spreadsheet for captain modes on DK, but haven’t figured out how to code it so it doesn’t duplicate the same player in a captain and flex spot. Anyone have a solution for this?

  • B_Edelman

    Use lineup HQ

  • swedishchef

    Use a sumproduct function to check for duplicates, you can’t use an IF formula with solver or it errors out. Then add the duplicate check as another constraint in your solver setup.

  • Klemmentine

    Thanks! I’ll see if I can get that to work

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

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.

If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537) (IL). Gambling problem? Call 1-800-GAMBLER (NJ/WV/PA/MI), 1-800-9-WITH-IT (IN), 1-800-522-4700 (CO), 1-800-BETS OFF (IA), 1-888-532-3500 (VA) or call/text TN REDLINE 1-800-889-9789 (TN).