(Office 2013) Excel spreadsheet to generate optimized Daily Fantasy football lineups:
Create VBA (Visual Basic for Application) coding to generate optimized team lineups (containing specific player positions and having the highest potential point total within a specific salary threshold) from a list of approx 225 players.
Spreadsheet must be able to calculate optimized lineups within a reasonable time (current code I created can take hours to complete calculations)
Allow Variable inputs which can be modified by user, including:
1) Salary threshold (maximum combined salary of all players on team lineup)
2) No. of players on each team.
3) Positions on each team (min and max number of each player position which can be contained in each team lineup)
4) Ability to assign specific players to the optimized lineup (spreadsheet would then generate the remaining players to create optimized lineup)
5) Specify NFL teams from which players in lineups can be drawn
6) Specify number of lineups to generate
I have attached an example spreadsheet which should help clarify what is needed.
17 freelance font une offre moyenne de $141 pour ce travail
The best way to optimize these kind of data is to use Linear Programming in Excel via Solver add in. I have done a very similar job recently. Can show you some samples. Lets discuss. Thanks..
Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Plus
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Plus
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Plus
Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your ins Plus
i have >15Y Access, Excel & VBA experience, please clarify the project details & deadlines .
Can do the player line up within the threshold value. Have done similar Heating design for mats which has threshold of current, voltage etc. Have good expertise in Excel automation, macros. - Have expertise in Exc Plus
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Plus
I see others over promise with timing. It would take at least 2 iterations between you and the supplier to ensure the outcome is correct. I am very fussy about speed of execution as well as fall over detection/handling Plus
I believe i am the best candidate for this project because i have more than enough hands on experience in entering and processing data using Microsoft Excel/VBA. I also pay good attention to speed, details and accuracy Plus
i have more than a decade experience working with excel and vba. i have also worked for investment banks for the last 5 years. i believe that the skills and experiences I've gained will be a great help to your project
I'm skilled and experienced when it comes to Excel, I feel fit to your project. I must give better service than others. Please feel free to contact with me anytime. regards, Linghueb Bacalla
Excellent vba skills, created dashboards in excel in past. Good hands on excel, advanced excel
In my 8 years of experience in financial institutions, I have created many tools in MS Office Excel, Word, Access individually or making integration between them, which have served as a model for more robust tools with Plus