Excel VB/Macro creation - Random team selection based on multiple criteria
$10-30 USD
S-au achitat serviciile după ce au fost prestate
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
ID Proiect: #17106693
Detalii despre proiect
Acordat lui:
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
10 freelanceri plasează o ofertă medie de 54$ pentru proiect
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 Mai multe
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 Mai multe
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' Mai multe
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 Mai multe
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.