Build an excel for permutations and combinations

$10-30 USD

Closed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits. [Image [login to view URL]] Step 2: Create your Team Select players for your Dream11 team from all 4 of the categories mentioned below: WK - Wicket-keeper (1) BAT - Batsmen( min 3 & max 5) BWL - Bowlers( min 3 & max 5) AR - All-rounders( min 1 & max 3) So there are 7 combinations for the team which could be created. Once all the combinations are created.. we need to check which teams credits sum to 100 credits. The input will be 22 players and the credits required and the points earned so far. After that from the shortlisted teams create an combinations of Captain & vice captain for each team. This will be separate sheet where I will enter the 11 players team. The combinations of Captain and vice Captain should output in next excel.

Excel

Project ID: 17136293

About the project

15 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

15 freelancers are bidding on average $35 USD for this job

@sajidkhan45

Hey, I am excel VBA expert and would like to apply for this project. I have worked on a similar project before, however the criteria for selection were also in place like for a batsman it was Basra method (batting average+strike rate). There were other factors as well that i can discuss in chat. Please go through my profile and reviews so that you can be confident about me Hope to chat with you soon Thanks Sajid

$100 USD in 1 day

4.9

(18 reviews)

0.0

@ahsanalisajid

I will do it as i am good in mathematics and i understood your work and will try my best to give best work done

$25 USD in 1 day

0.0

(0 reviews)

0.0

@kvosaravana

Hi, I am interested in your project in creating an Excel Spreadsheet to achieve permutation and combination mathematical function. The Spreadsheet should simulate the creation of two sets of 11 member cricket team. I can perform your defined task with necessary clarity and specification within the defined deadline. I will create a random selection formula to select the team members and then achieve Monto-Corlo simulation to achieve the optimum condition under different scenarios. I assure you my quality support and service. Please consider my proposal and discuss with me your detailed project requirements. Thank you Saravana Prakash

$20 USD in 2 days

5.0

(22 reviews)

0.0

@chauhanvishnu28

I can do your work with good accuracy nd within time given by me nd i m honest for my work Relevant Skills and Experience Good communication,good writing skill nd having good knowledge for writing article

$20 USD in 1 day

0.0

(0 reviews)

0.0

@Moonlightok18

I am good at Microsoft I.e. Word and Excel with many functions that can be applied to your work Relevant Skills and Experience Good in Microsoft and lots of functions in the program

$10 USD in 1 day

0.0

(0 reviews)

0.0

@ABHISHEKRAWAL72

i will do the excel work very well... i will submit the project on time as you describe.....please hire me ...

$15 USD in 1 day

0.0

(0 reviews)

0.0

@prashantneupane6

I have sound knowledge of excel. I will try my best to provide maximum level of satisfaction to my clients.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@Alxoue

I have had many experiences with writing, research and data entry. My knowledge on Microsoft and the English language is above average and I am able to follow instructions to the smallest detail. Relevant Skills and Experience Experienced Customer Service

$25 USD in 1 day

0.0

(0 reviews)

0.0

@mrtrkksarma

I am Sarma T. and I have a masters in Engineering from Birla Institute of Technology & Science, one of the most demanding institutions in India. I am good at User Interface creation, huge data handling & optimization, CSV file extraction, dashboard preparation, mathematical calculations, optimization, budgeting and scheduling, MS Office application integration using Excel Macros in Windows & Mac OS.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been executing projects for Microsoft as a customer across various technologies like DotNet, SQL Server, SSIS, SSRS. have executed many turn key projects for them in their licensing space which is very critical for them. Will be able to leverage this experience to deliver this project successfully. If you can provide more details about the work then will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy

$133 USD in 3 days