Converting from mathcad to excel

[grt05]

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

 

[IRstuff]

The short answer is no.

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

 

[NS4U]

Excel can't handle imaginary numbers either... so that could be a problem

 

[GregLocock]

Yes it can.

Not very nicely, admittedly.

Cheers

Greg Locock

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

 

[grt05]

Thanks for the replies. The program I'm building uses these equations to determine deflection and stiffness of bearings. I need to be able to plug in different bearings and have the integral solve the equations, thus the need to solove the integrals symbolically.

Greg,

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

Mike

 

[GregLocock]

imcomplex() etc. I am not familiar with the functions you quote

Cheers

Greg Locock

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

 

[IRstuff]

Then, you can use the Mathcad add-in for Excel to do the actual calculation and send the results to Excel. I still see no rationale for doing a symbolic calculation under any circumstance here, though. Once a DE or integral equation is solved, you only need the numerical equations and answers.

TTFN

FAQ731-376

 

[grt05]

IRstuff

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

 

[IRstuff]

Changing the values of an integral does not require solving the integral again, unless the actual symbolic form of the equation changes.

The add-in is downloadable from the Mathsoft website

TTFN

FAQ731-376

 

[grt05]

That is where my problem is. MathCad won't solve the equations using the symbolic evaluation command because the integrals are too complex.

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.

 

[IRstuff]

No, we're not. If all you're doing is a definite integral, and you have the integrand available, then all you need to do is to stick the definite integral sign on the integrand and numerically evaluate it; an equal sign instead of a right arrow sign.

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

TTFN

FAQ731-376

 

[grt05]

Then what happens when a variable within the integrand changes?

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

 

[jghrist]

I think if you download the Excel Mathcad add-in and look through the Help file in the Mathcad menu item, you will see what IRstuff is talking about.

 

[grt05]

I wish i could, it requires 13.1 and my version is only 7.

 

[jghrist]

Mike,

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.

 

[grt05]

I was able to solve the simpler intergrals symbolically in mathcad and put the solution into excel, but the more complex integrals are giving me the problem-which is why I wanted to know if I coud link excel to mathcad.

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

 

[IRstuff]

Yes, that's correct.

TTFN

FAQ731-376

 

[jghrist]

I still don't understand how you think that linking Excel to Mathcad will get symbolic solutions to integrals for which Mathcad can't find a solution.