Skip to main content
R
rdelascasas12-Amethyst
12-Amethyst
September 17, 2016
Solved

exporting equation's results from one mathcad file to other

  • September 17, 2016
  • 2 replies
  • 3791 views

Hello to all,

I have to calculate equations for different locations, where the equations are the same but the variable entry data will change per locations.

I would like to export the data per each calculation file to a master file where I can put them together in just one graph.

Is there any way to do this?

thank you in advance,

Rogelio

Best answer by AlvaroDíaz

Hi Rogelio.

You can reference your worksheets from one other, the 'main' one.

Check the attached.

Best regards.

Alvaro.

ref.gif

2 replies

A
AlvaroDíaz12-AmethystAnswer
12-Amethyst
September 17, 2016

Hi Rogelio.

You can reference your worksheets from one other, the 'main' one.

Check the attached.

Best regards.

Alvaro.

ref.gif

    W
    Werner_E25-Diamond I
    25-Diamond I
    September 17, 2016

    You may reference your calculation sheet several times, feeding it every time with different input values, similar to what Alvaro has shown. If only the input values differ, it would not be necessary to create a separate sheet for every calculation.

    Another way would be to turn the calculation into a function but this, being a long standing wish (among a lot of others) of the user community, is a feature which is still not implemented and possibly never will.

    So a cumbersome option could be that you turn all your calculations into functions depending on your input values.

    As an example, instead of writing

    you would create functions like this

    The drawback is, that if your calculation sheet is fairly large and complex, this can be a lot of work and the sheet could look much more cluttered and unclear.

    Werner

      R
      rdelascasas12-AmethystAuthor
      12-Amethyst
      September 17, 2016

      It seems that the respond options here does not allow me to say that both answers are correct.

      but both answers are correct on this matter.

      Thank you very much to both respondents,

      the job is now much easier.

      Best regards,

      Rogelio

      R
      rdelascasas12-AmethystAuthor
      12-Amethyst
      September 18, 2016

      The procedure provided above did work when the functions have only one variable.

      If the function has more one variable, i have not being able to do it.

      any advice?

      Terms & ConditionsAccessibility statement