In Progress

Excel Sheets to create Teams

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.

Skills: Excel, Excel Macros, Excel VBA, Visual Basic

See more: microsoft teams file sharing, microsoft teams website tab, editing documents in microsoft teams, microsoft teams file permissions, tabs in teams, microsoft teams excel, microsoft teams tabs, microsoft teams excel tab, compare excel sheets, posting excel sheets web page, differences excel sheets, excel macros create text files excel, customer service excel sheets, excel vba create menubar, combining excel sheets access, company data excel sheets, excel macro create directory mkdir, updating excel sheets manually code visual basic, updating excel sheets manually visual basic, call function excel sheets cell click

About the Employer:
( 0 reviews ) India

Project ID: #17792237

Awarded to:

₹850 INR in 1 day
(0 Reviews)
0.0

22 freelancers are bidding on average ₹1386 for this job

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

₹5000 INR in 1 day
(123 Reviews)
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 utilizat More

₹4000 INR in 2 days
(75 Reviews)
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

₹1500 INR in 2 days
(3 Reviews)
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.

₹1500 INR in 0 days
(2 Reviews)
1.0
₹750 INR in 3 days
(0 Reviews)
0.0
vijetamishra99

Hi, we [login to view URL] on several VBA projects and we can work on this requirement. We may contact you to understand more on your expectations and deliver as per agreed schedule. Pls do consider.

₹1300 INR in 2 days
(0 Reviews)
0.0
Techjil

Good working

₹1300 INR in 1 day
(0 Reviews)
0.0
sumitnavani

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

₹750 INR in 2 days
(0 Reviews)
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 More

₹850 INR in 1 day
(0 Reviews)
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 More

₹1300 INR in 1 day
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
₹1500 INR in 7 days
(0 Reviews)
0.0
₹600 INR in 3 days
(0 Reviews)
0.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. More

₹1050 INR in 5 days
(0 Reviews)
0.0
rajputsingh1983

Available Relevant Skills and Experience MS Office

₹1300 INR in 1 day
(0 Reviews)
0.0
₹1250 INR in 2 days
(0 Reviews)
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,

₹1300 INR in 1 day
(0 Reviews)
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 in 16 days
(0 Reviews)
0.0
₹950 INR in 2 days
(0 Reviews)
0.0
spirakos

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

₹750 INR in 2 days
(0 Reviews)
0.0