simulation

Hello dear community, I am trying to do a Multi-level crypto platform in Excel. It doesn't need any Macros, just a template. I am trying it, but I am not getting the right things. I was wondering if you could help me with a hint or a clue. Any help is much appreciated. Thanks. A platform...

Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...

Trial Number 1 2 3 4 5 ........ 2000000 (two million) Success in nth attempt 12 4 21 5 10 12 Note: Imagine throwing a dice where each outcome has probability of 1/10 (not 1/6 as it is usual for dice). For us "success" means throwing a "3". For each trial (see above) we keep throwing dice until...

PRODUCT. SALES. CONTRIBUTION A. $250. 25% B $350. 35% C. $100 10% D. $300 30% I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a...

Hi guys, hope you can help me out. I am trying to build an emergency fund simulation. Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to F8 on "SALN" tab. Recommended funding multiplies the value of the monthly expenses by 3 and 6...

Dear All, Need your urgent support in solving this simulation test. Cannot figure out the formula construction. Can someone please tell me how to attach the file as well.

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545} </style>I’m trying to create a Monte Carlo simulation using Excel for an engineering project management situation. I have 100 or so project risks that threaten my project. Each one of...

Hi All, Pretty new to VBA, but trying to do somthing a little bit tricky. I have a model whereby a simulation is performed and if the user wants to keep it, they can save it to another worksheet and then run another simulation in the original worksheet. What I want to do is be able to add a new...

Hey, I am currently trying to create a code that will allow me to simulate stock price changes each day (252 days) for 5-10 years. Each change results in a fee being paid if the stock has increased since all previous stock prices. As a result each simulation is in a separate row, each day has...

Hi All, I'd be grateful if you could have a look at the scenario below and contribute any suggestions please: Scenario We have 5,000 widgets available to order We make widgets to order and can produce 50 a day It's important we can tell customers their expected wait time for their widget...

Hi everyone, I have written a code for Monty Hall problem from scratch. I really didn't read anybody else's because it was making everything more confusing. Results are correct. If you switch you win more; however, my code seems a little redundant. I am trying to shorten it and if you are...

Hello I need help with an optimization routine<o:p></o:p> I have a 60 X 20 matrix of values which when combined with 20 factors generates a weighted average value for each row of 60 entries.<o:p></o:p> I have a target range (upper lower bound) for each row and would like to quickly develop an...

I want to understand the best way to run a simulation in excel. Input data: Client orders (normal distribution, time of order placement is random over 24 hours). 1 order is a box (it contains 10 items). Step 1: Compare to Inventory level, do we have over 10 items? If yes > go to step 2...

Hi all, I was wondering if anyone can help me. I have a workbook that does some relatively simple financial modelling with one stochastic variable - annual equity returns (the model assumes they are normally distributed). There are three outputs I want to capture for each simulation - values...

I'am trying to place a macro code to copy Monte Carlo simulation results from a "results" sheet to the "simulation results" sheet. I browsed plenty of forums and solutions bit my macro is still not working as I want. This is my last version that is work but tt copies and paste values only to...

I am trying to build a scheduling model for a clinic. Right now I am focused on building the basic model (random variation elements will be added later). Eventually, I am hoping that I can show wait times for patients and resource utilization patterns based upon different scheduling templates...

Hi there! I am really embarrassed that currently i don't have the skills to start posting replies but only asking for support! Well, if someone could contribute to this, i would be very grateful: Think about 2 men who play a game. Each player has multiple scores within a set ranging from 0 to...

hello all, long time user and benefitter of this site. Thank you in advance for your help. I have developed an algorithum to deal 4 hands of poker randomly. I thought I had developed it so that cards would not repeat (ie two players cant have a queen of diamonds) but roughly 10% of...

Many months ago I posted a file as part of a question I had, and have noticed I still get people opening it here months later, so thought I would post the latest (as of 3 months ago :stickouttounge:) version (much changed/improved over anything posted before) It started as a self-refresher...

Does anyone know what language the production simulation program, Witness (by Lanner group), uses? And where I could get some help learning it. I think it's similar to <ACRONYM title="visual basic for applications">VBA</ACRONYM> but its not exactly the same and Witness doesnt give you any hints.