Skip to main content
C
cdoherty1-Visitor
1-Visitor
January 16, 2014
Question

Running Multiple Scenarios of Worksheet.

  • January 16, 2014
  • 1 reply
  • 1655 views

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.

1 reply

W
Werner_E25-Diamond I
25-Diamond I
January 16, 2014

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.

    C
    cdoherty1-VisitorAuthor
    1-Visitor
    January 16, 2014

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

    W
    Werner_E25-Diamond I
    25-Diamond I
    January 16, 2014

    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

    16.01.png

    you write

    16.01.png

    and use it that way

    16.01.png

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

    16.01.png

    Use it as before

    16.01.png

    Terms & ConditionsAccessibility statement