VBA OR M CODE FOR VENUE-TEAM ALLOCATION
Descrição da oferta de emprego
I have data including a list of venues, the distances between these venues, and their capacities, as well as a list of teams and their capacities.
The main goal of this project is to ensure a fair distribution of teams across venues.
The code should create two additional venue-team combinations based on an original one without repeating team IDs in the column and ensuring they do not duplicate in the row (at the same venue).
Key requirements.
- The venue capacity can be exceeded by no more than 25 and should not fall short by the same amount.
- There are specific distance limits that need to be adhered to.
- Maximum distance limit per venue-team combination is a critical constraint.
Ideal candidates for this project should have.
- Extensive experience with Excel, VBA, and Power Query.
- Proven track record of creating complex algorithms for data analysis.
- Ability to understand and implement specific constraints and requirements.
- Strong problem-solving skills, particularly in optimizing team distribution and venue allocation.
Excel Visual Basic Visual Basic para Apps PHP Processamento de dados ID do Projeto.
# Sobre o projeto 22 propostas Aberto para ofertas Projeto remoto Ativo em 31 minutos atrás
Detalhes da oferta
- Indeterminado
- Em todo Portugal
- Indeterminado - Indeterminado
- 14/11/2024
- 12/02/2025
Venha fazer parte desta equipa vencedora!!! a re/max® capítulo é uma agência imobiliária estabelecida em tomar no coração da região centro, que presta um serviço de excelência desde 2005, apoiada por ferramentas e métodos de trabalho atuais... a re/max® capítulo não discrimina por género, idade, religião......
Requisitos do trabalho requisitos preferenciais: - experiência em serviços externos sst; - experiência em prestação de serviços em atividades ligadas à construção civil; - experiência / formação em realização de map´s; - disponibilidade imediata / curto prazo... no âmbito da nossa estratégia de crescimento......
No âmbito da nossa estratégia de crescimento, estamos a recrutar técnico de segurança no trabalho m/f / técnico superior de segurança no trabalho m/f, a tempo inteiro, com ou sem experiência... requisitos do trabalho requisitos preferenciais: - disponibilidade imediata / curto prazo......
For employment beyond two years, a permanent contract may be offered... employment term: initial contracts of 12 months, extendable for another 12 months... accommodation benefit: for those staying in designated apartments, this benefit is tax-free... meal allowance: preloaded debit card for tax-free......
The candidates book their own transportation and we will reimburse them fully (up to 700€ for external relocators and up to 150€ for internals)... job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of......
Job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of inquiries generated via inbound activities such as chat and email... start: asap banking project: german on-siterole: as customer service agent (m/f/d)......
Job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of inquiries generated via inbound activities such as chat and email... banking project: german on-siterole: as customer service agent (m/f/d) for german......
Requisitos do trabalho and for a service that the customer won't forget, you need: - six months of relevant experience (prefered); - strong computer navigation skills and pc knowledge (you don’t need to be a pc nerd, don’t worry); - ability to effectively communicate, both written and verbally; - attention......
A empresa assume as despesas de alojamento quando deslocado, pacote de seguros em vigor e total apoio para demais assuntos relevantes... requisitos do trabalho artifel - s... outros dados de posição artifel - s... como resposta ao anúncio o candidato deve ligar ou enviar o seu cv actualizado......
We're selecting call center operator (m/f) for a company in the services sector located in porto... do you link speak several language? are you fluent in german? do you have good knowledge of english? then you could be perfect for our bilingual roles! as a result of the incredible growth of our client......
