Skip to main content
T
TikkaMasala12-Amethyst
12-Amethyst
November 15, 2017
Question

Consolidation formula with montecarlo simulation

  • November 15, 2017
  • 2 replies
  • 1488 views

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

A
AlanStevens19-Tanzanite
19-Tanzanite
November 15, 2017

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

 

    L
    LucMeekes23-Emerald IV
    23-Emerald IV
    November 15, 2017

    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

    Terms & ConditionsAccessibility statement