[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]

Originally Posted by 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?

Yep, I just fixed it.

Good catch.

[Ganchrow]

Originally Posted by 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?

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?