×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

Converting from mathcad to excel

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

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: Eng-Tips.com Forum Policies

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

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

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

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.

The add-in is downloadable from the Mathsoft website

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

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.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

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

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.

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.

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

(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

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.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close