Hi,
I am trying to quantify the accuracy of the volume of a stockpile based on the positional uncertainty of each individual point. So my stockpile shape may have 3000 vertices on it to make a 3d shape and this 3d shape can be compared to a base surface to provide a volume in m³.
My question is that if each of those 3000 points has a standard deviation of (a) e.g. 0.015m for the x co-ordinate (a) for the y co-ordinate and (b) e.g. 0.03m for the z co-ordinate with a normal distribution.
How do I run a monte carlo simulation on each of those individual points n number of times to provide n files with a randomly generated list of co-ordinates with a normal distribution to the original co-ordinates.
So my inputs will be the list of x,y,z co-ordinates, the SD for the x,y & z columns and n for the number of iterations. I am an absolute novice at VBA but my first guess would be that some sort of loop could be used for each co-ordinate with the specified parameters which sits inside another loop that runs through the co-ordinate list n number of times. The output will hopefully be multiple files or at least co-ordinate lists that have been randomly generated within specified limits. The part I'm struggling most with is how to run the monte carlo simulation on each co-ordinate.
Is this feasible in vba or do I need to go up another path?
Thanks for your time.
I am trying to quantify the accuracy of the volume of a stockpile based on the positional uncertainty of each individual point. So my stockpile shape may have 3000 vertices on it to make a 3d shape and this 3d shape can be compared to a base surface to provide a volume in m³.
My question is that if each of those 3000 points has a standard deviation of (a) e.g. 0.015m for the x co-ordinate (a) for the y co-ordinate and (b) e.g. 0.03m for the z co-ordinate with a normal distribution.
How do I run a monte carlo simulation on each of those individual points n number of times to provide n files with a randomly generated list of co-ordinates with a normal distribution to the original co-ordinates.
So my inputs will be the list of x,y,z co-ordinates, the SD for the x,y & z columns and n for the number of iterations. I am an absolute novice at VBA but my first guess would be that some sort of loop could be used for each co-ordinate with the specified parameters which sits inside another loop that runs through the co-ordinate list n number of times. The output will hopefully be multiple files or at least co-ordinate lists that have been randomly generated within specified limits. The part I'm struggling most with is how to run the monte carlo simulation on each co-ordinate.
Is this feasible in vba or do I need to go up another path?
Thanks for your time.