I need help with a math project involving cricket team analysis. I have 22 players labeled P1 to P22. From these, I need to pick 11 players for a cricket team.
I have a sheet named "TEAM A" with all possible combinations of 11 players in rows labeled PC1, PC2, and so on, up to PC705432 (total 705432 rows). Each row represents a different combination of players. This sheet is organized in a table named "PossibleSet."
In another sheet named "Team B," I have historical user data. This sheet contains information about users who have created cricket teams of 11 players using different combinations from the 22 players. Each user's team is listed in rows labeled CT-1, CT-2, up to CT-97559. This sheet is organized in a table named "UserData." The size of this table varies as it's based on actual contest data.
I want to determine how many players from each possible combination in the "PossibleSet" table match the players in each team listed in the "UserData" table. I've already used simple SUM and COUNTIF formulas in column O of the "Team B" sheet to count the matching players in each user's team against P1.
Here's what I need to accomplish:
- Calculate the number of matching players between each possible combination (e.g., PC1) and each user's team (e.g., CT-1, CT-2). However, there are over 700,000 possible combinations, which Excel can't handle in columns. I need a different approach/format to perform this analysis.
- Identify which combination sets are popular among users, considering a range of maximum and minimum players. I want to find out which combinations are less favored or ignored.
- Create a dynamic solution that allows me to change the data in the "Team B" sheet to analyze multiple user datasets. I need a complete sheet with formulas, results, and explanations so that I can easily filter and interpret the results later.
In essence, I'm looking for a more efficient way to analyze the matching players between possible combinations and user teams, while also understanding the popularity of specific combination sets and their player count ranges. I'd greatly appreciate assistance in setting up a dynamic analysis sheet with formulas and explanations.
I prefer to use - Excel - may be power query, or any other method.
We can supply data in excel, csv.
I am open for any other Free /open source tool including BI Tools, PHP/ Python program as well.
Let me share your proposal and time required
Hi, there!
My name is Masud and I was glad to see you are looking for an Excel developer.
I'm among this platform's most experienced and skilled Excel VBA developers. I have completed over 90 projects successfully, and I feel confident in achieving your task. I will deliver the best quality as required (we can discuss the milestones; I don't require any payment in front).
I'm looking forward to working with you.
Sincerely,
Masud.
*My quote is indicative and may change (+/-) after discussing the tasks needed in detail.
Hello! My name is Sudip Simkhada and I am a BIM Graduated with extensive knowledge in Excel. I understand how difficult it can be to analyze 22 player cricket team analysis with over 700,000 possible combinations, so I am here to offer my services.
I have the skills necessary to help you complete your project. I am experienced in using - Excel - may be power query, or any other method to analyze large sets of data quickly. Additionally, I have experience in writingLiterature writingVoiceover[only automated not orginal]Google document[docx, sheet, form]Data entryBackground removerConversion of file[any type] with PDF to word within 5-7minProgramming[C, Java, Python, Web Techonology[HTML, CSS, PHP]]
Hi greetings!,
I read your requirements and will provide this with 100 % of your satisfaction level guarantee.
I`ll accomplish your this project in better way.
I have already developed this software which I can show you instantly so as to make your hiring decision easier.
I have also developed several ERP, CRM and custom web applications.
I am an experienced professional Software Developer with 15+ years of experience in PHP, MySQL, Oracle, HTML, CSS, BootStrap, Java, JavaScript, jQuery & so many tools which facilitates robust software development.
I am ready to start work immediately so that this job can be done quickly for you.
Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
Can I show you few samples on Chat?
Thanks & Regards,
Manoj
I’m a senior Data analyst with 2 years of experience and well versed in working with similar kind of problems over months. So I would consider myself to be the fit person for this.
I am data entry worker. I can help you to complete copyright job. My typing speed is very first so I can complete your job in a day. If you will give me the job I will not you let down.
“Your lectures are always incredibly stimulating and encourage excellent debates after class.” Natural – “You are a natural born educator thanks to your compassion, patience and ease with explaining.”
With Python language, I can easily help you accomplish this task, because there are ready-made libraries that support reading and extracting data as you need. Specifically, Python has pandas library which is very convenient for loading and analyzing dataset in table format, like Excel worksheet or CSV files. After reading data into pandas DataFrame, we can use vectorized operations and functions to quickly calculate statistics across rows and columns. The data manipulation capabilities of pandas will enable fast counting of matched players between possible combinations and user teams. Additionally, Python has mature modules for loading/saving Excel and CSV files. So it's very suitable for your requirements of reading input sheets and outputting results to file for future lookup. In summary, Python provides all the necessary tools to efficiently process large datasets like you described. I'm confident I can create a good solution for you in Python. Let me know if you need any other details!
I understand that you are looking for help with a math project involving cricket team analysis and need 11 players picked from 22 players. I believe that my skillset, experience and expertise makes me the best fit for this job.
I have extensive knowledge of Excel and can confidently provide efficient solutions for your project.
I have access to a range of tools including power query which may be more suitable for your needs than Excel.
I am available to provide data in excel or csv if required as well as any other free/open source tools you may require for the project.
