Excel VB/Macro creation - Random team selection based on multiple criteria

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

I help run a pick up soccer league in my hometown and we are always arguing about unfair/unbalanced teams so I am praying someone on here can help me come up with a macro to solve this. I have created the attached spreadsheet

What I am hoping is the following can be achieved:

1. A button can be pressed to randomly generate teams in Team 1, 2, 3 and 4 (depending on how many total players)

2. Teams should include a minimum of 4 defenders, 3 midfielders and 3 attackers (rest random)

3. Each Team should not exceed "Max Number of Players Per Team"

4. Team score should be an average of Player ratings for each team

5. Team Score should be as close as possible for each team

6. Only players with x in "Present" to be included in the Teams

7. Each time the button is pressed in step 1 the teams will regenerate

Procesamiento de datos Excel VB.NET Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #17106693

Sobre el proyecto

10 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

bouslimi1979

Hi, the project is well described. All is clear. I can code the macro to generate the 4 teams with respect of all the constraintes you mentionned. Thanks

$60 USD en 2 días
(300 comentarios)
7.7

10 freelancers están ofertando un promedio de $54 por este trabajo

schoudhary1553

Hello, I can help with you in your project Excel VB/Macro creation. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps. We have worked on several similar pr Más

$100 USD en 1 día
(361 comentarios)
8.0
mrbrave

HI, Couple of variables I have in mind to distribute players to team evenly. Half of the work already done by you for SKill/Age score. Distribution can be done this way. Based on all players skill, the minimum Más

$25 USD en 1 día
(279 comentarios)
6.8
dvcontact

Hi, You won’t select the right candidate without knowing what your project on building a macro to create random teams will look like. Fortunately, I can complete a part of your job before you award the project. I Más

$30 USD en 1 día
(55 comentarios)
6.5
avinav606lx

Hello there, I can try. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline Más

$88 USD en 1 día
(178 comentarios)
6.5
ANimesh996

Dear Client, I am a professional data processing expert, with over 1 years experience dealing with Microsoft office, web upload, data collected. I am ready to start your project right now & ready to do an example. I' Más

$25 USD en 1 día
(6 comentarios)
3.3
graphicdoll

Hi, I have Read Your Project Excel work . I am very Interested in your Project and also I am ready to Start Immediately. I assure you will like my Work very much and i will give you unlimited changes and I will delive Más

$150 USD en 2 días
(3 comentarios)
3.4
JorgeBece

Hello, I can help you in this Project. I have an idea a how the excel will work to randomize teams. I'd Like to continue talking about this Project so please Contact me. Thank you very much for your time.

$15 USD en 1 día
(11 comentarios)
2.8
ivavi

Hi team, I would love to take the opportunity to work as a freelancer. I am currently working as Finance analyst for big Pharmaceutical company (PPD), where I work with tons of data in excel. However I am now on mater Más

$15 USD en 1 día
(0 comentarios)
0.0