Challenge #111: Make a Weekly Challenge Dream Team!

[LordNeilLord]

Thanks god for the Fantasy football workflow otherwise I never would have figured out how to use the optimisation tool!

Sucks that i didn't even make the cut for my own team!

スポイラ

[LordNeilLord]

Thanks god for the Fantasy football workflow otherwise I never would have figured out how to use the optimisation tool!

Sucks that i didn't even make the cut for my own team!

スポイラ

[jezknee]

Solution attached.

[JosephSerpis]

Challenge Completed

[PhilipMannering]

Loving Linear Programming and the optimization tool now that I know they exist. I managed to get a team that could solve 685 problems between them. 

See my team below

スポイラ

jamielaird
SeanAdams
samN
jasperlch
LandonG
nick_ceneviva
CHarrison
alex

Here's my workflow

スポイラ

[danilang]

I used a value per player model and simply added them up until I reached $1.5M.  It's interesting that this method and the optimisation method that several others have used, generate the same team.

スポイラ

Dan

[DavidP]

My team got a total of 685 challenges. Fun challenge!

[JoBen]

This was a fun one! I attempted to come up with a greedy approximation algorithm. Cheers!

スポイラ

Here was the batch macro I created to solve for each author. I then brought this back into my workflow and took the top record with the most challenges completed. 

[pasccout]

My top team was 675 challenges...

[jssandom]

685 combined challenges... of course if this was more recent, then yours truly would be included :)

スポイラ