Mathcad + Excel = Major Value to Engineers

I'm just as surprised as you to see polar bears that are so passionate about engineering calculation software. Photo courtesy of http://www.firstpeople.us

The other day I came across a blog post by Robert Mote titled: The battle between Excel and MathCAD. In it, Robert discusses the use of Mathcad vs. Excel for standardized engineering calculations. He relates this to his field of structural engineering, ultimately giving Excel the nod as the tool of choice for an engineer.

Now as I’m sure you might guess, I have a slightly different take on the subject. But I suppose I may be just a little bit biased given my relationship to Mathcad. After all, Mathcad is more readable than Excel, easier to use (natural math notation), self-documenting, units aware, integrates directly with many CAD tools, supports native calculus and programming, etc. etc. right? Clearly most engineers would prefer an application designed for engineering calculations rather than one designed for business and finance, no?

Not Mathcad OR Excel, Mathcad AND Excel

The point of my post here is not to tout all of Mathcad’s strengths, while pushing those that Excel brings to the table under the rug. This would be a disservice not only to Excel (it’s a great app after all), but to our users as well. In my opinion the real value to an engineer is in utilizing and drawing on the strengths of both tools.

Working together to solve engineering problems and bring value to users. Photo Courtesy of simplymarvelous.wordpress.com

Clearly there are certain applications where Excel, or any other spreadsheet application, shines. Spreadsheets allow you to organize large blocks of data effectively, produce basic charts and graphs, and nearly everyone has Excel and has used it at some point. Mathcad benefits from using natural math notation, self documents… and well all that other good stuff I described above. We are fortunate to have a strong relationship with Microsoft and have worked with them over the years to integrate Excel into Mathcad, as well as Mathcad into Excel. We support reading from and writing to Excel files from within Mathcad (.csv too), native Excel containers within Mathcad, we even supply a free add-in to put Mathcad inside your Excel if you want!

With my short tenure I’ve heard about and seen numerous customer examples detailing the power that Mathcad and Excel provide as a team. Just the other day a customer from a multinational engineering firm was showing me how they used Mathcad throughout their entire design calculation, verification, and validation process. In many of these steps Mathcad was interfacing with Excel (and other tools) as the calculation engine and/or documentation interface. They utilized many applications for their specialized features and functions, but always came back to Mathcad as the ‘glue’ that sticks everything together.

What’s your take?

I’d love to show you some specific examples and screen shots, but I think that is another post for another day (in the near future). Stay tuned for some interesting use cases, tips/tricks, and developments regarding Mathcad and Excel. In the meantime, leave me some feedback in the comments. How do you use Mathcad and Excel in your day-to-day design? How have these apps provided value to your development processes? What do you like or would like to see added to our current Excel integration? We’d love your feedback.

-Dave

Disclaimer:  No animals were harmed in the making of this blog post.

This entry was posted in Best Practices, Mathcad and tagged , , . Bookmark the permalink.

2 thoughts on “Mathcad + Excel = Major Value to Engineers”

  1. Rachel Grant says:

    I don’t have a copy of Mathcad and neither do many of the engineers that I work with so Excel is our only option. I have installed a free Excel add-in called XLC which creates mathematical equations automatically from Excel formulas. This gives me all the Mathcad functionality I need so now I can use Excel to make professional looking engineering calculation sheets.

    1. Rachel,

      thanks for sharing the link to your site. We’ll keep an eye on your site and forums and be sure to comment on comparable Mathcad functionality. Looking forward to it! More than 250,000 engineers worldwide are successfully using Mathcad, if you’d like to take a closer look at it, you’re more than welcome to download our free 30-day trial version here: http://www.ptc.com/products/mathcad/mathcad-prime-1-0/free-trial.htm.

      Bettina

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s