+ Reply to Thread
Results 1 to 2 of 2

Goal seek on multiple cells

Hybrid View

  1. 06-13-2012, 06:36 AM #1
    oakwood
    oakwood is offline
    Registered User
    Join Date
    06-13-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    3

    Goal seek on multiple cells

    Hi All,

    New to this forum. I am looking for a way to do goalseek on an array/multiple cells.

    I am creating a spreadsheet to calculate optimal bet sizes. I have a combination matrix with 2 independent events (Team 1 Wins/Team 1 Loses, and Player 1 Scores/Player 1 Doesn't score. Each of the events have odds assigned to them. Then I have an input table with bet sizes on each of the events.

    Bet Sizes
    Team 1 wins 10
    Team 1 doesn't win 10
    Player 1 scores 10
    Player 1 doesn't score 10

    Odds
    Team 1 wins 3
    Team 1 doesn't win 1.2
    Player 1 scores 10
    Player 1 doesn't score 1.1

    Payout table Team 1 wins Team 1 doesn't win
    Player 1 scores 10 4
    Player 1 doesn't score 12 -8

    What I am looking to do is to alter the bet sizes, in a way that would make payouts equal under all possible outcomes. The numbers are just for illustration pusposes.

    Does anyone know of a way of doing this?

    Thanks
    Reply With QuoteRegister To Reply
  2. 06-13-2012, 07:04 AM #2
    SDruley
    SDruley is offline
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Re: Goal seek on multiple cells

    Very interesting piece of work. You need:

    1) Formulas in second and third matricies that defined the odds and payouts that also include the variables listed in the top matrix
    2) You need to define one cell that expresses the overall payout effectiveness

    then you can use Solver with item 2 as the target and each element of matrix one as the list of variables

    Solver will then optimize the bet sizes for the maximum payout based on the system of equations that you have established
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1