View New Posts
  1. 10-08-07 08:43 PM #1
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,014
    SBR Points: 125
    Message Me

    Default Series Win Probability Spreadsheet

    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.
    Attached Files
    Reply With Quote Reply With Quote

    SBR Founder Join Date: 8/28/2005

  2. 10-08-07 09:42 PM #2
    atakdog
    atakdog's Avatar Become A Pro!
    Join Date: 09-04-07
    Posts: 139
    SBR Points: 0
    Message Me

    Default

    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?
    Reply With Quote Reply With Quote
  3. 10-08-07 09:45 PM #3
    jjgold
    Shari #1
    jjgold's Avatar SBR PRO
    Join Date: 07-20-05
    Posts: 126,170
    SBR Points: 13
    Message Me

    Default

    Why do you not just use excel?

    Nice Work Ganch
    Reply With Quote Reply With Quote

    SBR Founder Join Date: 7/20/2005

  4. 10-08-07 09:46 PM #4
    Justin7
    Justin7's Avatar Moderator
    Join Date: 07-31-06
    Posts: 8,073
    SBR Points: 2595
    Message Me

    Default

    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?
    Reply With Quote Reply With Quote
    File a sportsbook complaint  
  5. 10-08-07 09:52 PM #5
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,014
    SBR Points: 125
    Message Me

    Default

    Quote Originally Posted by Justin7 View Post
    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.
    Reply With Quote Reply With Quote

    SBR Founder Join Date: 8/28/2005

  6. 10-09-07 04:22 AM #6
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,014
    SBR Points: 125
    Message Me

    Default

    Quote Originally Posted by atakdog View Post
    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?
    Reply With Quote Reply With Quote

    SBR Founder Join Date: 8/28/2005

Top
« Previous Thread | Players Talk | Next Thread »