how to run monte carlo simulation in excel for each iteration separately using normrnd command?

how to generate monte carlo simulation in excel separately for each samples of i in this code? anyone pls help me

% clc;
mRob=500;
mRbc=750;
muRob=5;
muRbc=7.5;
SRob=5/4;
SRbc=7.5/3;
Dy=14.5;
x=1;
rop=0;
alpha=50*pi/180;
count=0;
for i=1:10000
      mRobr=mRob+normrnd(muRob,SRob);
      mRbcr=mRbc+normrnd(muRbc,SRbc);
      mx(i)=normrnd(muRob,SRob);
      my(i)=normrnd(muRbc,SRbc);    
      Yact=mRob*cos(alpha)+sqrt(mRbc^2-mRob^2*(sin(alpha)^2));
      Ycal=mRobr*cos(alpha)+sqrt(mRbcr^2-mRobr^2*(sin(alpha)^2));
      Dya=abs(Yact-Ycal);          
          if Dya<=Dy
              count=count+1;
          end
           if Dya>rop
              rop=Dya;
          end
  end
  XX=max(mx);
  YY=min(mx);
  ZZ=max(my);
  AA=min(my);
  rel=count/i;
  unrel=1-rel;

[Walter Roberson]

Are you asking how to create a random value with normrnd and pass that value to an Excel macro to run some command there?

Or are you asking how to create a bunch of random values with normrnd and to write the values to an Excel spreadsheet?

[José-Luis]

You have asked variations of the same question four times. Instead of more or less repeating yourself, please try to provide more details.

Also, if you show what you have already done, people might be more inclined to help you.

[Walter Roberson]

You just edited the question to provide your code, but you did not answer my questions about how Excel is intended to be used.

With the addition of your code, your question is looking like a duplicate of one of your previous questions.

[Pavithra V]

i am asking how to create a random value with normrnd and pass that value to an Excel macro to run some command there?

Answer 1

[Walter Roberson]

https://www.mathworks.com/matlabcentral/answers/100938-how-can-i-run-an-excel-macro-from-matlab