How to run a model in excel multiple times

**lindep** · 06-29-2013, 03:29 PM

Hi there!!

I need to run my model multiple times since it is full of random variables and in this matter I want to develop a reliable model. Therefore i need the 95% confidence interval but I don't really now how to apply this. Also I really don't know how to simulate a model and then have excel memories all the previous values so I can draw a graph to see what the distribution of those variables are.

This is the first time I made a quantitative model in Excel, and it's been going quite well but my thesis needs to be deliverd on monday so I really need my model to run !! Thanks in advance!!

**AndyLitch** · 06-30-2013, 06:10 AM

Presumably you have a macro which generates a series of n datapoints based on your model.

What you need is a Master looping macro which will perform three functions :-
1) Run the model
2) Moved the result data to a storage area
3) Repeat

That's easy enough to do but I need to know where your result data series is

**lindep** · 06-30-2013, 06:43 AM

thank you for responding!

What do you mean by result data? The variables of which I'd like to get a graph? Attached I send my workbook, this is my final model with all calulations included.

**lindep** · 06-30-2013, 06:44 AM

So when I have to make a Macro I do it in Developer or something? But what are the codes that I have to type? I've never done this before haha so would be great if you could help me!!

**AndyLitch** · 06-30-2013, 07:50 AM

NP... gimme 10 minutes

........... OK I've had a look and first impression tells me the data layout doesn't really help facilitate simulation ...

I think as a first step you need to select all the cells containing the output results for each sheet and give them a collective name. That way we can step through each cell and transfer results to an output worksheet.

To do that simply hold down the CTRL key , select all the cells and then type a name in the name box