DFS (Daily Fantasy Sports) MMA Lineup Optimizer in Excel

$30-250 USD

ปิดแล้ว

โพสต์

ประมาณ 5 ปีที่ผ่านมา

$30-250 USD

ชำระเงินเมื่อส่งงาน

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

รหัสโปรเจกต์: 18943017

เกี่ยวกับโปรเจกต์

5 ข้อเสนอ

โปรเจกต์ระยะไกล

ใช้งานอยู่ 5 ปีที่ผ่านมา

กำลังมองหาการสร้างรายได้ใช่ไหม?

ที่อยู่อีเมล

ประโยชน์ของการประมูลกับ Freelancer

กำหนดงบประมาณและกรอบเวลาของคุณ

รับเงินจากการงานของคุณ

อธิบายข้อเสนอของคุณในภาพรวม

ลงทะเบียนและเสนอราคาฟรี

5 ฟรีแลนซ์กำลังเสนอราคาโดยเฉลี่ย $148 USD สำหรับงานนี้

@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 ใน 1 วัน

4.8

(21 รีวิว)

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 ใน 3 วัน

4.9

(17 รีวิว)

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 ใน 3 วัน

4.0

(1 รีวิว)

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 ใน 3 วัน

0.0

(0 รีวิว)

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 ใน 5 วัน