[smokin1]

ok, I am really ashamed of myself for wasting someone elses time on this but I have honestly been racking my brain all night. I went 4-0 today and couldnt even enjoy watching the games lol

What I am trying to calculate is the combined winning percentage of 2 or more games.

For example, say I have 3 picks today, one with 56% another with 64% and the last with 54%

How do I calculate the odds I will win none, 1, 2 or all on that particular day.

Thanks for anyone who can throw me a bone so I can get some sleep lol

[Ganchrow]

You could use the P2L() array function in my my http://www.sportsbookreview.com/forum/handicappe...tml#post256487.

See attached spreadsheet for a couple of usage examples.

Btw, it isn't necessary to download the template in order to use the example spreadsheet.

[Ganchrow]

In the example you've given, btw, the relevant calculations would be:

P(3 wins) = 56%*64%*54% ≈ 19.35%
P(2 wins) = (1-56%)*64%*54% + 56%*(1-64%)*54% + 56%*64%*(1-54%) ≈ 42.58%
P(1 wins) = (1-56%)*(1-64%)*54% + 56%*(1-64%)*(1-54%) + (1-56%)*64%*(1-54%) ≈ 30.78%
P(0 wins) = (1-56%)*(1-64%)*(1-54%) ≈ 7.29%

Obviously, the more games you were to include the more involved the calculations would become. This is why I'd recommend just downloading the template and letting the P2L() function do all the work for you.

[smokin1]

I was just coming from bookmarking your intro to betting lines and %s guide

that looks like exactly what I was talking about, I give it a whirl. Thanks very much