Excel VB/Macro creation - Random team selection based on multiple criteria
$10-30 USD
着払い
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: #17106693
プロジェクトについて
アワード：
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人のフリーランサーが、平均$54 で、この仕事に入札しています。
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 もっと
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 もっと
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' もっと
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 もっと
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.
