search

scipio314 / draftKnight

draftKnight is an excel sheet that generates optimized fantasy football lineups for DraftKings
GNU General Public License v3.0
31 stars 13 forks source link

OpeSolver - Error #28

Open billjaq65 opened 3 years ago

billjaq65 commented 3 years ago

While trying to generate lineups I get the following error:

The cell 'z14' in constraint 'z10:z14 <=AB10:AB14' has a divide by zero error or has a problem with the function used.

KrazyEyes125 commented 3 years ago

I am also having the issue. I will do some digging on what's happening hopefully we can find a solution.

scipio314 commented 3 years ago

I believe what is happening is that there is an error in Washington Football Team point projection.

Easy fix: Go to the "All Players" tab and enter a custom projection for Washington Football Team. (Must be greater than 0).

BTW, for some reason my point projections formula doesn't automatically fill in on the "All Players" tab. To fix I just opened that tab and dragged the formula down in column K.

KrazyEyes125 commented 3 years ago

Got it to work! Thank you for the fix scipio! Fingers crossed for this weekend.