Find Jobs
Hire Freelancers

Excel - VBA code to create optimized team lineups

$30-250 USD

Cancelado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
(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. Requirements: 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.
ID del proyecto: 11569768

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
15 freelancers están ofertando un promedio de $139 USD por este trabajo
Avatar del usuario
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..
$250 USD en 4 días
5,0 (142 comentarios)
7,3
7,3
Avatar del usuario
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 regards
$200 USD en 3 días
4,9 (305 comentarios)
7,3
7,3
Avatar del usuario
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 your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$65 USD en 3 días
5,0 (98 comentarios)
6,5
6,5
Avatar del usuario
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 Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent projects completed. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$120 USD en 4 días
4,6 (51 comentarios)
6,2
6,2
Avatar del usuario
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 have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details.,
$166 USD en 5 días
5,0 (54 comentarios)
4,8
4,8
Avatar del usuario
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 (error). The trick to this is not to work with the cell object in excel, but to load the data into memory directly using .values2 properties. Then the algorithm must be chosen to ensure you get something like a O(logn). I am an engineer who does complex automation of process units, and programming is something I do for "fun". Please check my profile. Yes I am in South Africa, and I do this work after hours (I am actually a well paid specialist-so I do not really do this for money, I love the challenge) . I can work with VBA/Java/Python+ various others if needed. In your case I would stick to VBA, but streamline the object use, and memory structures to address speed.
$70 USD en 5 días
5,0 (13 comentarios)
3,6
3,6
Avatar del usuario
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 when working with data (i.e. data conversion, entry or processing).
$72 USD en 5 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
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
$166 USD en 5 días
4,0 (1 comentario)
0,9
0,9
Avatar del usuario
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
$100 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Excellent vba skills, created dashboards in excel in past. Good hands on excel, advanced excel
$133 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 within these institutions. The development of lightweight applications with MS office became a passion and now I want to offer my services as a freelancer, beyond coding or create formulas, developing in excel requires a thorough analysis to create efficient and functional tools.
$150 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Hinsdale, United States
5,0
3
Forma de pago verificada
Miembro desde sept 20, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.