Excel - VBA code to create optimized team lineups

(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.

Compétences : Codage, Excel, Visual Basic

en voir plus : protect vba code excel dll, extract vba code excel, vba code excel create clock, vba code excel 2007, simplex method vba code excel, create account code excel based tables, view vba code excel, vba code excel ftp download, ftp user vba code excel, vba code excel increment, create vba project excel, vba code excel data analysis, financial vba code excel, optimisation vba code excel, compare vba code excel workbooks

Concernant l'employeur :
( 1 commentaire ) Hinsdale, United States

Nº du projet : #11569768

17 freelance font une offre moyenne de $141 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(254 Commentaires)

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..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(142 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(28 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(185 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(67 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(60 Commentaires)

i have >15Y Access, Excel & VBA experience, please clarify the project details & deadlines .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(41 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(49 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(22 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(13 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

Excellent vba skills, created dashboards in excel in past. Good hands on excel, advanced excel

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)