Multiple Sports Betting Excel Spreadsheet
drean7
Posted messages
6
Status
Membre
-
drean7 Posted messages 6 Status Membre -
drean7 Posted messages 6 Status Membre -
Hello,
I would like to create an Excel table for multiple sports bets, but I'm not quite sure how to go about it!
That is, to create a table on the different possible combinations for 4/8 or 5/6 or 12/15 or 13/18, etc.
How many tickets do I need to create for these different selected matches based on all possible combinations?
Is that possible?
Thank you in advance.
I would like to create an Excel table for multiple sports bets, but I'm not quite sure how to go about it!
That is, to create a table on the different possible combinations for 4/8 or 5/6 or 12/15 or 13/18, etc.
How many tickets do I need to create for these different selected matches based on all possible combinations?
Is that possible?
Thank you in advance.
3 réponses
Hello, maybe I'm explaining it poorly. In short, I'll take an easier example. I want to play 4 matches, but since there is always 1 match that makes me lose, I want to do a 3/4, meaning creating 4 tickets with 3 matches each using these 4 matches, so if ever one match loses out of the 4, there will at least be 1 winning ticket!
I have never played sports betting.
However, your explanations are clearly aimed at people who know the rules. So I searched online, and I found the site https://www.pronosoft.com/fr/parions_sport/aide-parions-sport.htm
From what I understood, a 2/3 multiple bet consists of placing 3 combinations of 2 bets on the same ticket; even if one of the 3 combinations loses, you still win: it's as if you bought 3 single bet tickets.
So you don't need to do all this hassle!
Moreover, I saw on this site that the maximum number of matches is 6.
So your reference to combinations of 12/15 or 13/18 seems to not correspond to the rules...
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
However, your explanations are clearly aimed at people who know the rules. So I searched online, and I found the site https://www.pronosoft.com/fr/parions_sport/aide-parions-sport.htm
From what I understood, a 2/3 multiple bet consists of placing 3 combinations of 2 bets on the same ticket; even if one of the 3 combinations loses, you still win: it's as if you bought 3 single bet tickets.
So you don't need to do all this hassle!
Moreover, I saw on this site that the maximum number of matches is 6.
So your reference to combinations of 12/15 or 13/18 seems to not correspond to the rules...
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
Hi, yes, you understood the multiple betting system, but on betting sites, we can only play 6 matches in a multiple bet. That's why I want to create an Excel table that goes beyond 6 matches! This table should indicate the chosen combination (4/5, 8/9 or 10/12...) the number of tickets to create, and which tickets to make! I hope you understand me, and thanks in advance!
If you only need to use the COMBIN function, which provides the following results:
=COMBIN(5;4) which gives 5 possibilities: abcd abce abde acde bcde
=COMBIN(9;8) which gives 9 possibilities: abcdefgh abcdefgi abcdefhi abcdeghi abcdfghi abcefghi abdefghi acdefghi bcdefghi
=COMBIN(12;10) which gives 66 possibilities that I leave for you to find!
=COMBIN(5;4) which gives 5 possibilities: abcd abce abde acde bcde
=COMBIN(9;8) which gives 9 possibilities: abcdefgh abcdefgi abcdefhi abcdeghi abcdfghi abcefghi abdefghi acdefghi bcdefghi
=COMBIN(12;10) which gives 66 possibilities that I leave for you to find!
So I'm giving up!