cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Consolidation formula with montecarlo simulation

TikkaMasala
12-Amethyst

Consolidation formula with montecarlo simulation

Hi

 

I'm trying to make a sheet for consolidation of soil with probabilistic analyses using montecarlo function.

 

As attached is a sheet of my initial try, but the formula doesn't compute even if

the units are totally dropper off from the matrices.

 

Can this type of relatively simpel formula be used,

or do I first need to make a vector of ech parameter with the random fluctuation?

The aim is that in final stage the units could be used in the formula.

2 REPLIES 2

Normal distributions require means and standard deviations.  I've never thought much of the inbuilt montecarlo function in MC, it's too restrictive.  I've attached an alternative approach (making some assumptions about means and standard deviations).

 

Alan

 

LucMeekes
23-Emerald III
(To:TikkaMasala)

Your function must be a function of a single variable, which may be an array:

LM_20171115_monteC.png

With regards to using units, you've bad luck. Mathcad (unlike Prime) does not allow differently united elements in a single array.

 

Another error is that you forgot to supply the 3rd parameter Rvals to the montecarlo() function.

 

Success!
Luc

Announcements

Top Tags