Excel Sheets to create Teams

₹600-1500 INR

En curso

Publicado

hace más de 5 años

₹600-1500 INR

Pagado a la entrega

I have some work, in an Excel spreadsheet. I want to appoint freelancer to draft an excel file where there are any number of players list The conditions are as below :- to Create Team by picking Max 11 players as per the following combinations (P1,P2,P3 P4) within a budget of 100 credits. Step 2: Create your Team Select players for team from all 4 of the categories mentioned below: WK - Wicket-keeper (1) BAT - Batsmen( min 3 & max 5) AR - All-rounders( min 1 & max 3) BWL - Bowlers( min 3 & max 5) So there can be numerous combinations(depending upon the No of players provided every time) for the team which could be created at one click Once all the combinations are created.. we need to check which teams credits sum to 100 credits or less The input will be any number of players players and the credits required and the points earned so far. After that from the shortlisted teams can auto create an combinations of Captain & vice captain for each team & each player. This will be separate sheet where I will enter the players team. The combinations of Captain and vice Captain should output in next excel.

ID del proyecto: 17792237

Información sobre el proyecto

22 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@waqasmoazzam7

₹850 INR en 1 día

0,0

(0 comentarios)

0,0

22 freelancers están ofertando un promedio de ₹1.386 INR por este trabajo

@fatimatuzzohura

Hi, I am a highly trained on Data Entry ,Data Analysis, Copy Typing, Data Mining, Research, Web search, scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel. Thanks

₹5.000 INR en 1 día

4,9

(123 comentarios)

6,2

@archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana

₹4.000 INR en 2 días

4,9

(75 comentarios)

5,7

@sahinbudak

Hello, I am an excel master. I can build the code you need in 2 days. You will get the .xlsm file and the source itself. You may do any changes on the code as you like after receiving it. Best

₹1.500 INR en 2 días

5,0

(3 comentarios)

1,4

@viswakarmaya

I have completed half of the Excel Sheet Kindly award the project I shall submit the sheet immediately. I have experience and expertise in Excel for past 12 years.

₹1.500 INR en 0 día

5,0

(2 comentarios)

1,0

@prafullchavan012

Hello sir, You may have viewed my profile. I will be very happy to work on this. I am very familiar with excel and can work on this. I can work as per your expectation. I can deliver you this in 6 days. I have created several work using Excel can work on this. I can do my best with this work. Please give me chance to work for you. Thanking you. Your's sincerely :- Prafull Chavan

₹1.050 INR en 5 días

0,0

(0 comentarios)

0,0

@spirakos

I have a lot of experience about microsoft office programms especially on excel.

₹750 INR en 2 días

0,0

(0 comentarios)

0,0

@cakrishna2740

Hi sir I will give m best performance I will choose first client satisfaction I have 7 years experience with excel i will do very fast

₹750 INR en 16 días

0,0

(0 comentarios)

0,0

@JITENDERPUNIA71

at present i am working in CA Firm and i have practical exposure in those area and i can do these with proper accuracy,

₹1.300 INR en 1 día

0,0

(0 comentarios)

0,0

@rajputsingh1983

Available Relevant Skills and Experience MS Office

₹1.300 INR en 1 día

0,0

(0 comentarios)

0,0

@ssmith0295

Excel spreadhseets are my speciality. I am confident i will be able to perform this task using some more advanced excel formulas.

₹850 INR en 2 días

0,0

(0 comentarios)

0,0

@simar121993

Procedure - The Uploder has already specified the task in detailed manner. Input will be the players and the credits they hold and the category in which they play and out put is the team (having credits less than 100) and having captain and vice captain. It will require making permutation and combinations of first the number of players in each categories ( because max and min is defined) and then the individual players themselves based on the four categories. After that filter the ones having more than 100 credit. From there the captain and vice captain P&C will be created and shown as output Questions I need to Ask - The output of the project is not clear as per the wording but looking at the whole project I can be done by me. My Skills - I do Financial modelling of companies and currently doing MBA My Experience - Been working on excel for around 7 years now. Deadlines - 12 days (can be negotiated)

₹1.300 INR en 1 día

0,0

(0 comentarios)

0,0

@OD10

There are 17 possible combinations. How do you assign credits and team captains etc? WK - Wicket-keeper (1) BAT - Batsmen( min 3 & max 5) AR - All-rounders( min 1 & max 3) BWL - Bowlers( min 3 & max 5) Total 1 3 1 3 8 1 3 1 4 9 1 3 1 5 10 1 3 2 3 9 1 3 2 4 10 1 3 2 5 11 1 3 3 3 10 1 3 3 4 11 1 3 3 5 12 no 1 4 1 3 9 1 4 1 4 10 1 4 1 5 11 1 4 2 3 10 1 4 2 4 11 1 4 2 5 12 no 1 4 3 3 11 1 4 3 4 12 no 1 4 3 5 13 no 1 5 1 3 10 1 5 1 4 11 1 5 1 5 12 no 1 5 2 3 11 1 5 2 4 12 no 1 5 2 5 13 no 1 5 3 3 12 no 1 5 3 4 13 no 1 5 3 5 14 no

₹850 INR en 1 día

0,0

(0 comentarios)

0,0

@sumitnavani

Hello I am doing it at very low cost because I need good ratings on freelancer.com

₹750 INR en 2 días

0,0

(0 comentarios)

0,0

@Techjil

Good working

₹1.300 INR en 1 día

0,0

(0 comentarios)

0,0

@XLMLuisMatos

It sounds like a fun project! In fact, I'll make this right away just for fun! I've been working with VBA for the last 7 months, I'm expanding my knowledge of it and this seems like a simple enough project that I can get done in just a few of hours. Here's what we have to discuss: - What's the maximum number of players? Should I create a field where you put the number of players? - How will the player database be done? Will the players types be separated in 4 columns or will they all be in the same column? - So each team will have a total credit value. A team must be worth more than 100 credits up to the credit limit set by the game master? - Will you need a "New Game" function and a "Next Round" function? If so, on the Next Round do the teams re-shuffle, meaning, will you make new teams? How do you want the player scores to be entered? Should a prompt be triggered asking the score of P1 then P2 then P3 etc.? - When exactly will the captains and vice-captains be selected?

₹1.100 INR en 1 día