I need a program (I am open on which plattform e.g. Excel) which matches teams and location together.
As explanation: We will have a single event in which people are signing up. We will match them in a team of 3 (randomly) and they will meet another 2 team in the first location. After a period of time each team will go to the next (each team to another one) location where they meet another two teams. This happens in total 3 times. Here an example
Location 1 - Team 1 / 2 / 3
Location 2 – Team 4 / 5 / 6
Location 3 – Team 7 / 8 / 9
Location 1 - Team 3 / 4 / 7
Location 2 – Team 1 / 6 / 9
Location 3 – Team 3 / 5 / 8
Location 1 - Team 9 / 4 / 2
Location 2 – Team 1 / 8 / 7
Location 3 – Team 3 / 6 / 5
What I would like to have is a program or an excel sheet which would be as follow as (I am open for other ideas)
1. sheet: Route like in the example
2. sheet: locations to enter as a data source to create the route
3. sheet: names to enter as a data source to create the teams
4. sheet: x/y table with the distances inbetween the bars
- program creates the groups
- program creates the route and mixes the teams in the bars
- double check if the m/w ratio is okay
- it will automatically adjust the number of bars and groups accoring to the number of participants (can be up to 200 or more)
- check how much each way is inbetween the bars for each team (optional)
I can be as simple as possible, we can also do some manual work while using it.
I am looking forward to hear from you and please do not hesitate to get to me for further questions.
42 freelance font une offre moyenne de €283 pour ce travail
Hello, I am John from AIS Technolabs. I have gone through your requirement and understand that you are looking for highly skilled, qualified, and experience Website development team for your project. Relevant Skills a Plus
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Plus
Hey Friend, Myself having has 10 + years experience of web site development. We have skilled programmer, We are 14 person team of developer, designer and tester provide you excellent services. Expert in Custom p Plus
I am highly qualified and experienced to work for you on this project. Relevant Skills and Experience I am a Software Developer. Proposed Milestones €200 EUR - Full Project.
Dear employee After Read your project, we are expert and completed many similar work and we have a team with 30+ highly skilled Designers and Developers with over 7+ years of experience. Relevant Skills and Experienc Plus
Hi, Fabian . I can do that via Ms Access GUI(if need with Excel automation) Relevant Skills and Experience access, excel, vba, ado, sql Proposed Milestones €555 EUR - default
I have more than 9 years of experience in web/mobile development. I have completed many mobile/web applications. We can discuss in detail further. Thanks Stay tuned, I'm still working on this proposal.
Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus
Hey, I am a coder and developer. I can make you a nice desktop app that has a nice graphic interface that will allow you to enter the data you need in an organized way and to see the results. Relevant Skills and Exper Plus
I'm from Valencia and just developed something similar for a guessing game of crime between participants by role. Very funny, I offer it in Acces and Php. So you can follow online Habilidades y experiencia relevante A Plus
I have an engineering degree in computer science. I teach graduates the advanced topics in Excel. I developed software systems in New Zealand for 15 years. I am interested to do your work.