List of possible outcomes

[mikeee]

Hi guys,

Looked everywhere and can't find this...
There are 12 games - each with a favourite and a underdog...
each game has a pointspread for example game 1: Visitors -3, Home +3
I need a list of all the combinations where there is at least a +20 when the
underdogs win (if favourite wins count that as a zero - not the point spread).
Only list the combinations where the total is +20.

thanks mikeee

[pr4t3ek]

Sorry but i don't quite understand your request.

Can you upload a few examples?

[mikeee]

For example
game 1 visitors -3 home +3
game 2 visitors +5 home -5
...
game 12 visitors +7 home -7

so i would need output like this..

hhhhhhhhhhhv
hhhhhhhhhhvv
etc...

for each combo of outcomes i want the total number of all the positive numbers - if over 20 then i will use that combo - if below 20 i will disregard.

hth

[mikeee]

are you allowed to bump these?

[mikerickson]

Its not clear what you desire.

"i want the total number of all the positive numbers - if over 20 then i will use that combo - if below 20 i will disregard."

It sounds like you want all the numbers that are greater than 20. That exceeds Excel memory limits.

[mikeee]

I am not explaining this well enough sorry...
there are 12 games - so i want a list oh all combinations of these 12 games...
the first combo would be all visitors winning...
there are 4098 combos i believe...

Now from those combos i want to eliminate some of them in the following manner:
Add up all the point spreads from all the games and if it equals 20 or more (only use the positive point spreads when adding - disregard the negatives) - this is a good combo - if not eliminate this from the 4098 combos...

[mikerickson]

It sounds like you are looking at the 4096 possibilites if a game has two possible outcomes, Home and Away.

It sound like you want to add a third possibility, Home+20

There are 3^12 possibilties in that case.

The talk of point spreads, I don't understand. Do you have a sheet listing games and point spreads and want to filter them? That can be done with AutoFilter.

[mikeee]

YES - for example this week the games are:
v h
1 -7.5 7.5
2 4.5 -4.5
3 3 -3
4 -4.5 4.5
5 3 -3
6 6.5 -6.5
7 -3 3
8 6.5 -6.5
9 1 -1
10 -3 3
11 -2.5 2.5
12 3 -3

[mikerickson]

Would COUNTIF(A1:A12,">20") do what you want?

[mikeee]

Would COUNTIF(A1:A12,">20") do what you want?

no i dont think so - first off - i need every possibility to be generated by the program - then can maybe use a countif

[mikeee]

can someone just tell me how to generate the list of all the possible outcomes (forget about the spreads for now)

[mikeee]

bumpity bump

[mikeee]

can anyone help with this?