DFS (Daily Fantasy Sports) MMA Lineup Optimizer in Excel

$30-250 USD

Ditutup

Dibuat

sekitar 5 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim

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.

Excel VBA

Python

ID Proyek: 18943017

Tentang proyek

5 proposal

Proyek remot

Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

5 freelancer menawar dengan rata-rata $148 USD untuk pekerjaan ini

@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 dalam 1 hari

4,8

(21 ulasan)

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 dalam 3 hari

4,9

(17 ulasan)

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 building. I would love to work on this project, happy to discuss in detail and can complete by the weekend. Thanks

$140 USD dalam 3 hari

4,0

(1 ulasan)

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 background. Choose me and your expectations will be exceeded.

$250 USD dalam 3 hari

0,0

(0 ulasan)

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 excel as well. My idea will be to write a script, that’ll auto pick 6 fighters for you that’ll maximize your odds of winning, while staying under 50k cap. Will need formula for the salary though, to be calculated on odds. All you’ll need to do is: 1. Daily, Enter/update fighter name if it isn’t in the list. 2. Daily, Enter/update the odds of winning. 3. Hit “pick my fighter” button. For above - $166 Update statement- i re-read the example you had sent, looks like you just want a list/roster of fights. Simple it is. I’ll lower the cost. $111i

$111 USD dalam 5 hari