×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# 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

### 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.

### RE: Converting from mathcad to excel

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

### RE: Converting from mathcad to excel

Yes it can.

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

(OP)
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

### RE: Converting from mathcad to excel

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

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

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.

### RE: Converting from mathcad to excel

(OP)
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

### RE: Converting from mathcad to excel

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

### RE: Converting from mathcad to excel

(OP)
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.

### RE: Converting from mathcad to excel

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.

### RE: Converting from mathcad to excel

(OP)
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

### RE: Converting from mathcad to excel

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

### RE: Converting from mathcad to excel

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.

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

(OP)
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

### RE: Converting from mathcad to excel

Yes, that's correct.

### RE: Converting from mathcad to excel

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.

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!