MS Excel Team Generator - Permutations & Combinations

$10-30 USD

Closed

Posted

about 4 years ago

$10-30 USD

Paid on delivery

Looking for a excilent MS Excel Expart to 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 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits. Step 2: Create your Team Select players for your team from all 4 of the categories mentioned below: WK - Wicket-keeper (min 1 & max 2) 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. Max 7 player from a team. 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.

Project ID: 24376694

About the project

29 proposals

Remote project

Active 4 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

29 freelancers are bidding on average $23 USD for this job

@finecodervw

Hi, Keen to work on this project. I can do this using Excel macro with VBA. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

$30 USD in 2 days

4.9

(127 reviews)

6.3

@paulodayto08

Hi, Good Day! I can build a macro for this. Please message me to discuss more about the project and I can also send you some of my works to help you decide on hiring me. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

$30 USD in 1 day

4.9

(49 reviews)

4.8

@developerguru15

Sir/Madam, Greetings! This job captured my interest. I have read the job description and for sure I can handle the task. I have excellent communication skills and can follow instructions pretty easily. I am a hardworking and a dedicated person. I submit work on time and make sure to have the excellent output. Over the years, I've been thoroughly exposed and trained in the fields of administrative support especially MS Office, data mining, online/market research, excel/spreadsheet including macro/vb, google sheets, power point with a typing speed of 63 WPM. I really love excel/spreadsheet. I have more than 10 years on this field. I have also 5 years experienced as a Virtual Assistant. I have patience to perform repetitive tasks with accuracy. I am very organized and see to it that my work is free of errors. I continually seek relevant opportunities.

$20 USD in 7 days

4.9

(3 reviews)

3.5

@pushar71

hello i am a cricket player and understand your requirements, i have played till first class level for MP, please connect with me and award me the job, i assure you i will do the job with best of the quality. I am an excellent excel expert. PS: your details are insufficient, we need to know from the pool pof 22 players who are batsman, bowlers, all rounders and wkt keepers to choose as per the combination you have asked. without which the permutations and combinations can not be created. Hope you understand my question. also there is no information for credit for each player. also there can not be just 7 permutations but there will be easily few hundred ways teams can be formed, from those teams we have to select the ones which have a credit of 100. This is not a simple excel problem but an operations research optimization problem.

$30 USD in 2 days

5.0

(2 reviews)

1.3

@cbjat88881

After completing my assignment you trust me always Relevant Skills and Experience I worked at already in data entry operator regular job in private sector

$25 USD in 1 day

0.0

(0 reviews)

0.0

@rushyadav1997

If you will give me you're work i will do very properly Relevant Skills and Experience I have two year experience in date entry

$25 USD in 1 day

0.0

(0 reviews)

0.0

@mabidpu

I have well knowledge about Permutation and combination Relevant Skills and Experience I have done Bsc with Statistics

$23 USD in 1 day

0.0

(0 reviews)

0.0

@ABHISHEKS3392

i am new for this site but i am perfect for this type of job. please give me this project. i have a lot of experience for this type jobs

$10 USD in 1 day

0.0

(0 reviews)

0.0

@ssudeep808

“I can complete your project on time and within your budget.” 2) “I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations.” 3) “I would love to work on your project.” 4) ” I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.”

$20 USD in 1 day

0.0

(0 reviews)

0.0

@Sahilyadav0511

I can do it Relevant Skills and Experience I am in this work since 2001

$25 USD in 1 day

0.0

(0 reviews)

0.0

@Sasukeoro

Dear Hiring Manager, First of all, I want to say thank you for posting the job. I have read your post. My skills aligns with the qualification you are seeking. I have 2 years of experience in excel, advanced excel, MS access etc. in a corporate IT company as BI analyst. They are my daily go-to tools. The opportunity to work with you made me curious that I can't wait to work and have it complete properly. I can assure you that you will be pleased my work. Here are some of my skills: * Compiling data and creating monthly reports * Updating paper-based system and converting them to computer - based processes * Proficient typing skill and transcription * Organisational and Time management abilities I would like you to know that If I would given a chance to have this opportunity I assure you that I will do my best to make you satisfied in the outcome. I will really do my best. Thank you. Sincerely, Hemanth

$15 USD in 7 days

0.0

(0 reviews)

0.0

@aahuti31

hi i already done this project please contact for further discussion so i can make required changes as per your need thanks

$32 USD in 1 day

0.0

(0 reviews)

0.0

@Kabshawasta

Hello, l im interested in the job offer, you can explain what it is and what i should do specifically, i im at your service and i have availability, i can take some time to quickly and without mistake

$25 USD in 1 day

0.0

(0 reviews)

0.0

@shafiquecity

I have experience more then 5 years this work Relevant Skills and Experience Data entry,Microsoft excel, Microsoft word and typing

$25 USD in 1 day

0.0

(0 reviews)

0.0

@sudarakanisal

I have read your job description and I understand this job. I can do your job 100% perfectly without any mistake. If you give me this job I will give you the best result

$15 USD in 1 day

5.0

(1 review)

0.0

@rgSydney

Hello in advance experienced analyst new to this platform and looking for opportunities like this one. I have a decent idea of how I would undertaker this particular task and keen to assist. Thanks for considering my offer and all the best.

$25 USD in 2 days

0.0

(0 reviews)

0.0

@ashishgche

i have very good command over excel and totally free to work as per target so i can complete work at earliest and also maintain 100 percent accuracy.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@syandyu7

i am a data entry expert, worked from 6 years in many of banking sectors as well as well known in microsoft office work like word excel pdf photo shop and power point webserch and etc.

$35 USD in 1 day

0.0

(0 reviews)

0.0

@Aiubali1111

Iam do this work properly and very carefuly... You can trust me and you can give me this project Relevant Skills and Experience I am new freelancer but you can trust me... I am perfect man for this work

$25 USD in 1 day

0.0

(0 reviews)

0.0

@amanwpkumar

Hello I can do this job with low cost and give a good result And I can do it very quickly so that you can get the best results in a short time. If you do not believe please give me a sample file so that I can show you the quality of my work. Thank you,

$20 USD in 2 days