×
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

Going between Mathcad and Excel

Going between Mathcad and Excel

Going between Mathcad and Excel

(OP)
I was asked to set up a Mathcad sheet to analyze data taken from different people in the shop testing different heat exchangers.  The Mathcad sheet is completely built and functioning properly.  The problem is that no one else knows how to use Mathcad and therefore refuses to.  Is there a way for me to have them plug data from testing into Excel and use Mathcad to calculate the desired values and read them back into Excel?  Thanks

RE: Going between Mathcad and Excel

Yes.  There is an Excel add-in that allows you to embed a Mathcad sheet inside an Excel sheet.  You can pass variables to the Mathcad sheet, run the calculations, and pass the answers back.  The add-in should be available for download on the PTC support website.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Going between Mathcad and Excel

I have used the Excel add-in that IRStuff refers to.  When you download it, it also comes with some tutorials/example problems that help you learn how to manage the variable exchange into and back out of the MathCad kernel.

http://www.ptc.com/community/free-downloads.htm

The only problem you might encounter with your application is with licensing.  I think the end user needs to have Mathcad installed on their computer while using this plug-in.  If this is not the case, please let us know - I could make use of a similar application.  

Peter

RE: Going between Mathcad and Excel

If it's merely a matter of importing the data from a worksheet, why not use the Data Input component?  That will handle an Excel worksheet.

RE: Going between Mathcad and Excel

(OP)
Thanks for the suggestions. I am getting an error Message that reads "Microsoft Excel is waiting for another application to complete an OLE application" every time I insert my Mathcad sheet.  I'm thinking the program cannot handle some of the equations in the Mathcad sheet?

RE: Going between Mathcad and Excel

No, that's usually an indication that the installation didn't work right.  You may need to reinstall it.  Note also, that there is often undesirable interactions between different versions of Mathcad...

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

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



News


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