Monte carlo using multipe data sources

I have no idea how to do this.

Full instruction in monte carlo methods is almost certainly beyond the scope of a single internet forum post.

For someone who has no idea how to do this, I would probably suggest that you start with a basic introductory tutorial in Monte Carlo methods. Here are three (found by putting "introduction to monte carlo methods" into a search engine:
https://support.office.com/en-us/art...3-4450d8db16f1
http://www.goldsim.com/Web/Introduct...ic/MonteCarlo/
http://excelmontecarlo.com/02_introduction.html

If you are set on creating your own monte carlo simulation, I would suggest that you review these and other tutorials. If there are parts that you don't understand, bring those questions here and we'll help as best we can. I would suggest that you make these questions as specific as possible ("I don't know how to use Excel's RAND() function.") to keep the discussion focused on the parts that you have real difficulty understanding. I might also suggest that you avoid "short-cuts" to this educational experience. Work through the simple examples given in the tutorials (dice rolling and coin tossing are two examples given). Part of learning this sort of thing is going from simple examples to the more complex real world stuff that your final project is trying to do.

If you are interested in preprogrammed solutions, you might look at Oracle's Crystal Ball software http://www.oracle.com/us/products/ap...iew/index.html or put "open source monte carlo" into your favorite internet search engine. I don't use these applications mysefl, but I have seen users here mention using Crystal Ball. It might be prefferable, even if the software is not free, to use a third party application to perform the monte carlo simulation.

Originally Posted by MrShorty

Full instruction in monte carlo methods is almost certainly beyond the scope of a single internet forum post.

Moreover, for future note, if you (kevinndocherty) have further Excel questions about your implementation, please attach an example Excel file, not an image. Usually, the devil is in the details of the Excel design and implementation, which we usually cannot discern from an image alone.