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.
5 freelancers are bidding on average $148 for this job
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.