+ Reply to Thread
Results 1 to 4 of 4

Monte Carlo Simulation

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Monte Carlo Simulation

    I'm working on a Monte Carlo Simulation and I need a bit of help. Essentially, I am trying to find out how many units to produce in the next two years when there is an equal 25% probability. The two main problems that I am running into are: there are not always two outcomes, because sometimes one unit being produced too high. Additionally, I cannot get the "Help!" work book to automatically show which units need to be produced each time I run the simulation, which ideally I would like to link up.

    Attached is my workbook, along with a brief write up.

    Thanks in advanced!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Monte Carlo Simulation

    What happens if amounts ranking 2 & 3 are the same, you want just one result, or three?

    e.g.
    5:247
    10:260
    15:245
    20:247

    You want 5 & 20?
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Re: Monte Carlo Simulation

    Well that is another problem that i am having, I need two outputs (one for each year). I used an =if(=>25%) statement and that also produces one value or three.

    Quote Originally Posted by Cheeky Charlie View Post
    What happens if amounts ranking 2 & 3 are the same, you want just one result, or three?

    e.g.
    5:247
    10:260
    15:245
    20:247

    You want 5 & 20?

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Monte Carlo Simulation

    and your answer?
    (please don't quote whole posts in replies, just use reply)

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1