LukeClosely
New Member
- Joined
- Aug 6, 2015
- Messages
- 7
[COLOR=rgba(0, 0, 0, 0.701961)]Hello. Please could I have some advice to help solve a problem which has an extraordinary amount of permutations. I feel like I have got lost in the numbers somewhat and could be missing a relatively simple way to solve the problem.[/COLOR][COLOR=rgba(0, 0, 0, 0.701961)]
I have a simple sheet that records 100 bets and each bets potential winnings in ROW 2 to ROW 101.
Each bet involves 4 teams, one from each of 4 leagues (entitled League 1, League 2, League 3, League 4).
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL A = team from League 1[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL C = team from League 2[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL E = team from League 3[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL G = team from League 4[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL H = potential winnings for that individual bet.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]For a bet to be successful ALL 4 TEAMS MUST WIN. If any of the 4 teams does not win the return from that bet is £0.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]There will only be 3 winning teams from League 1,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]3 winning teams from League 2,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]3 winning teams from League 3,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]4 winning teams from League 4.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]This makes 13 winning teams in total.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]However 12 different teams have been selected from League 1 (giving 12 unique values out of 100 entries),[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]16 selected from League 2,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]15 selected from League 3,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]17 selected from League 4.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]My question is what combination of 13 teams would give me the maximum return?[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]Remember only 3 teams will win from Leagues 1,2+3 and 4 teams from League 4.
I am happy to answer any questions as without a photo I may not have explained clearly enough.
Thank You[/COLOR]
I have a simple sheet that records 100 bets and each bets potential winnings in ROW 2 to ROW 101.
Each bet involves 4 teams, one from each of 4 leagues (entitled League 1, League 2, League 3, League 4).
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL A = team from League 1[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL C = team from League 2[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL E = team from League 3[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL G = team from League 4[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]COL H = potential winnings for that individual bet.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]For a bet to be successful ALL 4 TEAMS MUST WIN. If any of the 4 teams does not win the return from that bet is £0.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]There will only be 3 winning teams from League 1,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]3 winning teams from League 2,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]3 winning teams from League 3,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]4 winning teams from League 4.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]This makes 13 winning teams in total.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]However 12 different teams have been selected from League 1 (giving 12 unique values out of 100 entries),[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]16 selected from League 2,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]15 selected from League 3,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]17 selected from League 4.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]My question is what combination of 13 teams would give me the maximum return?[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]Remember only 3 teams will win from Leagues 1,2+3 and 4 teams from League 4.
I am happy to answer any questions as without a photo I may not have explained clearly enough.
Thank You[/COLOR]