Running Multiple Scenarios of Worksheet.

[cdoherty]

Hi all,

I have a Mathcad work sheet that I would like to create a process to batch a number of inputs and get the outputs in excel and I was wondering if this is possible?

The worksheet determine the stability of a cable under different different wave heights, water depths and currents. Currently I am having to put the information in manually each time I want to check some results however this is taking a long time.

Could someone please let me know if it is possible to batch process using Mathcad?

Thanks

Chris.

[Werner_E]

You have to turn your calculations into a function(functions) depending on the variables you wish to vary and call this function with the different values you want the calculations being done for. Either singly or maybe put in a vector.

[cdoherty]

Hi thanks for your reply. Would you happen to have an example?

[Werner_E]

Chris Doherty wrote:

Hi thanks for your reply. Would you happen to have an example?

OK, lets show what I mean with the simple example of calculating the volume of a cylinder for given radius and height. I used a (normally unnecessary) auxiliary quantity "base" to show that kind of "nested" functions, too, which can make turning a ready made calculation sheet into a function quite a hassle.

Instead of

you write

and use it that way

Another way would be to turn the whole calculation into 1 function, but I think thats not advisable for longer calculations

Use it as before