Closed

DFS (Daily Fantasy Sports) MMA Lineup Optimizer in Excel

I'm looking for someone who can write me a script in Excel to create a Daily Fantasy Sports MMA lineup. Here's how it works. Every fight (think UFC) you get a $50,000 salary cap. Each fight has an average of 12 fights, so 24 fighters. Each fighter is given a salary based on their odds of winning. You can only pick 6 fighters but you have to stay within the salary cap of $50,000. The salaries range from $6000 to $9600.

Here are the rules:

1. Stay under the $50k salary cap

2. All lineups are unique

3. You cannot have two opponents fighting each other on the same card.

Below is an example of what it could look like. I would be entering the fighters and the salaries, I just want to hit a button and it populates different lineups. Preferably highest salary cap to lowest salary cap maxing out at the most lineups possible.

Skills: Excel VBA, Python

See more: dfs excel solver, lineup optimizer excel, nfl dfs spreadsheet, dfs lineup generator, fanball lineup optimizer, yahoo fantasy football lineup optimizer, daily fantasy football algorithm excel, draftkings excel spreadsheet, start daily fantasy sports site, daily fantasy sports software, daily fantasy sports spreadsheet, daily fantasy sports lineup builder, spreadsheet daily fantasy sports, daily fantasy sports marketing, daily fantasy sports, nba fantasy lineup optimizer, daily fantasy sports writers, newest daily fantasy sports sites, best daily fantasy sports apps, daily fantasy lineup optimizer python

About the Employer:
( 0 reviews ) San Diego, United States

Project ID: #18943017

5 freelancers are bidding on average $148 for this job

lightingdavid

Hello. As a Excel VBA expert, i 'm interest to your project. I have read your project description carefully and i 'm sure i can do your project perfectly. Contact me please. Thank you.

$140 USD in 1 day
(21 Reviews)
4.8
rinabuoy13

Hello, I am experienced excel optimisation expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$100 USD in 3 days
(17 Reviews)
4.2
arvindronin

Hi, I’ve done a similar project on Airtasker for NFL. I can build the required spreadsheet for you. I’m a Data Analyst and have been working with excel for over 13 years. I specialise in Automation and complex formula More

$140 USD in 3 days
(1 Review)
1.1
josephmanseau

I've been building spreadsheets for over 20 years in a range of applications; I know it inside and out, including VBA. Moreover, I have a command over several optimization techniques thanks to my mathematical backgroun More

$250 USD in 3 days
(0 Reviews)
0.0
Work4hire88

I am assuming that you also want to maximize odds of your winning as well. So, this sounds like a linear optimization problem to me. Luckily, I have done several challenges like this. And I happen to be very good with More

$111 USD in 5 days
(0 Reviews)
0.0