Results 1 to 1 of 1

Fantasy Baseball Optimal Lineup - Problem With Multiple Player Positions

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Fantasy Baseball Optimal Lineup - Problem With Multiple Player Positions

    I am using Opensolver to create an optimal fantasy baseball lineup using projected points under the constraints of a salary cap. I have everything working, but the one problem that I am running into is when players have multiple position listings. For example, in the attached screenshot, you can see the player Todd Frazier is listed as both a 1B and 3B, and accordingly, the optimal lineup solution includes him being used in both positions. I need to figure out how to limit the use of Todd Frazier (or any player who has multiple positions) to be used for either one position or the other.

    The attached screenshot shows the model and output.

    Thanks in advance for your help.

    Clint
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Scalable baseball lineup from stats
    By lavudyar in forum Excel General
    Replies: 17
    Last Post: 08-03-2020, 04:22 PM
  2. Replies: 1
    Last Post: 01-07-2015, 03:36 PM
  3. formula for fantasy baseball!
    By drnick in forum Excel General
    Replies: 8
    Last Post: 09-19-2014, 07:04 PM
  4. Replies: 0
    Last Post: 08-02-2014, 03:22 PM
  5. Optimizing a fantasy baseball lineup
    By zigzagman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2014, 06:43 PM
  6. Replies: 11
    Last Post: 10-30-2013, 02:11 PM
  7. Replies: 11
    Last Post: 02-18-2011, 07:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1