Excel / Python/ PHP project
Budget: ₹600 – ₹1,500 INR
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
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