+ Reply to Thread
Results 1 to 4 of 4

Thread: Excel Simulation (Monte Carlo) help

  1. #1
    Points: 15, Level: 1
    Level completed: 29%, Points required for next Level: 35

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Thumbs up Excel Simulation (Monte Carlo) help




    Hi all,

    I've been racking my non-statistical brain on my Excel simulation (monte carlo sim predicts profit). I have created the model and as I review the outputs, I'm not confident that it's correct. With that said, is there anyone who could review it and let me know if you see any obvious mistakes? Given I'm a biologist, you could guess my model is quite simplistic so nothing crazy going on here.

    I have a couple of static inputs and a handful of random variables that are tied to simple frequency tables. I use Excel's data table to run 10,000 simulations and then summary stats finish it off along with a relative frequency table/plot. (I hope I'm using the proper terms here!).

    Anyway, if anyone would like to take a peek at what I created to see if there are any obvious goof-ups, I can share the file.

    Thank you for your consideration.

  2. #2
    TS Contributor
    Points: 22,410, Level: 93
    Level completed: 6%, Points required for next Level: 940

    Posts
    3,020
    Thanks
    12
    Thanked 565 Times in 537 Posts

    Re: Excel Simulation (Monte Carlo) help

    I think some TSers (including me) are willing to help you to check, say those codes and files. But the troublesome issue is that it may not be convenient for other to download external file from forum. Not sure if you can describe more, or sharing the file with online drive, or have some online displaying tools for excel files.

  3. The Following User Says Thank You to BGM For This Useful Post:

    BrentCOS (03-01-2016)

  4. #3
    Points: 15, Level: 1
    Level completed: 29%, Points required for next Level: 35

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel Simulation (Monte Carlo) help

    Quote Originally Posted by BGM View Post
    I think some TSers (including me) are willing to help you to check, say those codes and files. But the troublesome issue is that it may not be convenient for other to download external file from forum. Not sure if you can describe more, or sharing the file with online drive, or have some online displaying tools for excel files.
    Hi BGM,

    Thank you very much for your willingness to take a look. I'll share a Dropbox link with you (PM = private message) and that will provide you access to the Excel file. In the PM I'll share a little bit about what my objective is and what you'll see in the Excel file. If you have any questions, please do not hesitate to reach out to me.

    One primary question about the file I have is: In the output simulation (ie, simulation 1 in row 64), does that mean for the demand of 144,000 units that every unit sold for the exact same "price" and "cost"? If so, that seems nearly impossible. Perhaps I'm interpreting it incorrectly or perhaps I've set up the simulation incorrectly.

    Thank you again,

    Brent

  5. #4
    Points: 15, Level: 1
    Level completed: 29%, Points required for next Level: 35

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel Simulation (Monte Carlo) help


    Quote Originally Posted by BrentCOS View Post
    Hi BGM,

    Thank you very much for your willingness to take a look. I'll share a Dropbox link with you (PM = private message) and that will provide you access to the Excel file. In the PM I'll share a little bit about what my objective is and what you'll see in the Excel file. If you have any questions, please do not hesitate to reach out to me.

    One primary question about the file I have is: In the output simulation (ie, simulation 1 in row 64), does that mean for the demand of 144,000 units that every unit sold for the exact same "price" and "cost"? If so, that seems nearly impossible. Perhaps I'm interpreting it incorrectly or perhaps I've set up the simulation incorrectly.

    Thank you again,

    Brent
    DANG! I drafted a detailed private message to you BGM and then submitted it and the system said I cannot send PMs with under 5 posts! I've lost it all now.

    Would you mind emailing me instead? If so, please PM me. I value your time and I would like to offer to make a small donation (I work for a start-up company so I get paid peanuts!) of $25 to your forum or to Wounded Warriors. Thank you for trying to work with me.

    Brent

+ Reply to Thread

           




Tags for this Thread

Posting Permissions

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






Advertise on Talk Stats