## Converting from mathcad to excel

## Converting from mathcad to excel

(OP)

Hi

I have a few very large definate integrals I am trying to solve symbolically in mathcad and then enter them into excel. I'm having difficulty because mathcad won't solve some of them saying they are too large and some of them use imaginary numbers.

My question is this, is there a way I can convert the mathcad solution into excel and still be able to change values in excel and have them calculated by mathcad?

Thanks,

Mike

I have a few very large definate integrals I am trying to solve symbolically in mathcad and then enter them into excel. I'm having difficulty because mathcad won't solve some of them saying they are too large and some of them use imaginary numbers.

My question is this, is there a way I can convert the mathcad solution into excel and still be able to change values in excel and have them calculated by mathcad?

Thanks,

Mike

## RE: Converting from mathcad to excel

I questioning the intent, here. If you're going to put stuff into Excel, why do you need symbolic solutions? As far as I know, Mathcad can usually crank numerical integrals pretty easily.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Converting from mathcad to excel

## RE: Converting from mathcad to excel

Not very nicely, admittedly.

Cheers

Greg Locock

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

## RE: Converting from mathcad to excel

Greg,

When you say excel can handle imaginary problems are you referring to the imaginary(), real(), ect. commands?

Mike

## RE: Converting from mathcad to excel

Cheers

Greg Locock

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

## RE: Converting from mathcad to excel

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Converting from mathcad to excel

I need to be able to change the values of variables within the integral for different bearing applications. That is why I need to solve the integral symbolically so I can then change values in my program.

This add in for excel, where do I get it from?

Thanks,

Mike

## RE: Converting from mathcad to excel

The add-in is downloadable from the Mathsoft website

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Converting from mathcad to excel

On smaller integrals I was able to solve the integral using the symboic evaluation command and then type the solution into excel. I could then change the variables and find a solution for the integral using different variables if I wanted to.

I think we are saying the same thing.

## RE: Converting from mathcad to excel

You've still said nothing that demonstrates a need for a symbolic solution.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Converting from mathcad to excel

If I have the integral solution solved symbolically and entered into excel all I need to do is change that value and I have a new solution for the new value.

I need it solved symbolically so I can then enter the solved equation into excel. I know I can solve it numericaly in mathcad, but that isn't my objective here. In my first post I should have said I want to enter the symbolically solved equation into excel, not just the numeric results.

I apologize if that is where the confusion is.

Mike

## RE: Converting from mathcad to excel

## RE: Converting from mathcad to excel

## RE: Converting from mathcad to excel

If you have Mathcad 7 Professional, you can use an Excel component within Mathcad. Get the input for numeric calculation of the integrals from input variables in the Excel component. Put the results in output variables in the Excel component, which will be put into cells of the Excel workbook.

If you have Mathcad 7 Standard, seriously think about upgrading.

In your OP, you said Mathcad couldn't solve some of the integrals symbolically. I don't understand what you mean by converting the Mathcad solution into Excel if there is no Mathcad solution.

## RE: Converting from mathcad to excel

This raises another question I think I know the answer to. In order to run the excel component the person using the excel program will have to also have mathcad loaded on their computer, correct?

Mike

## RE: Converting from mathcad to excel

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

## RE: Converting from mathcad to excel