Series Win Probability Spreadsheet

[Ganchrow]

The following spreadsheet calculates series win probability based on the underlying win probabilities of individual games.

For the spreadsheet to run you'll need to allow Visual Basic macros when prompted.

As always, please report any bugs, errors, or complaints. I'm not proud.

[atakdog]

I run OpenOffice (actually, NeoOffice, on a Mac), and get lots of "unexpected symbol" errors (but I don't know what symbol). Usually, the program runs Excel spreadsheets fine, even with macros.

Any idea how to fix this?

[jjgold]

Why do you not just use excel?

Nice Work Ganch

[Justin7]

Game 6 and 7 probabilities are "cell protected", and I can't change them easily (I'm no excel wizard.)

How do you change that?

[Ganchrow]

Game 6 and 7 probabilities are "cell protected", and I can't change them easily (I'm no excel wizard.)

How do you change that?

Yep, I just fixed it.

Good catch.

[Ganchrow]

I run OpenOffice (actually, NeoOffice, on a Mac), and get lots of "unexpected symbol" errors (but I don't know what symbol). Usually, the program runs Excel spreadsheets fine, even with macros.

Any idea how to fix this?

Wish I could help, but I'm completely unfamiliar with OpenOffice compatibility issues.

At what point and in which Sub/Function are errors being thrown?