Excel VBA, All possible combinations given certain criteria

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

I am need of someone to create an Excel VBA script that produces all of the possible combinations given certain criteria.

I will provide a list in excel that will include 3 columns: name, salary, and position.

This is related to the National Basketball Association (NBA), so it helps if you are familiar with it, but not a requirement.

Criteria:

Every lineup/combination will consist of the same positions (see below)

Point Guard (PG)

Shooting Guard (SG)

Small Forward (SF)

Power Forward (PF)

Center (C)

Forward (Any SF or PF)

Guard (And PG or SG

Utility (Any position)

The total salary for each lineup combination cannot exceed $50,000.

A player cannot be used more than once in the same lineup. Even though they may fall into multiple positions. I.e. a shooting guard can be available in the shooting guard position and the guard position in the lineup above. If he has been chosen for the shooting guard position then he may not be chosen again for the guard position in the same lineup.

I will provide the list to the winning bidder. I want this to be something that I can easily run on my own for any list of players.

Excel Visual Basic для додатків

ID Проекту: #7199724

Про проект

10 заявок(-ки) Дистанційний проект Остання активність Feb 25, 2015

Доручено:

aarifakhtar

Hi: I understand that you want to all possible line ups, for a particular set of players, that satisfy a particular criteria of salary. Please confirm. Here's an example of similar project that I have done: https://www Більше

$133 USD за 3 дні(-в)
(51 відгуків(-и))
5.6

10 фрілансерів(-и) готові виконати цю роботу у середньому за $116

gokulanand

Hello, I had worked on similar kind of project for another employer before. The other project is also for selecting the players for NBA based on some criteria. I can tweak that a bit and get you the modified excel s Більше

$200 USD за 2 дні(-в)
(45 відгуків(и))
5.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

$122 USD за 4 дні(-в)
(41 відгуків(и))
5.2
blazyyy

Hello! We are a team of programmers (VBA, Java, C#, SQL, MySQL, .NET) and we would love to approach your problem. I am positive we can provide you with an awesome outcome. Our experiances so far on Freelancer is onl Більше

$155 USD за 4 дні(-в)
(6 відгуків(и))
3.1
gabrielkfc

Hi, i have full-time availability to work on your project and i can start right away. Im a skilled excel user with knowledge of VBA programming if needed. I can sure help you out in no time. I´ve done automated spre Більше

$30 USD за 2 дні(-в)
(6 відгуків(и))
2.4
vw6897639vw

Just send me "Ok" message and i will complete a sample without been initially awarded, if somthing goes wrong you will have opportunity to choose another bidder, no obligations from yor side

$30 USD за 3 дні(-в)
(2 відгуків(и))
0.8
RomaUA

I can do this task Send me all information for this task I'm good at Excel VBA, I have had an experience

$35 USD за 3 дні(-в)
(0 відгуків(и))
0.0
marketerlady

' 'I am a private freelancer thats why I have no reviews because I usually got my clients from other freelancers company such as craigslist, easyoutsource, onlinejobs, warrior forum.. Somebody told me to try my luck h Більше

$250 USD за 3 дні(-в)
(0 відгуків(и))
0.0
dudumachado

Ainda não foi fornecida uma proposta

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0