Mathcad or Excel?

Why do you need Mathcad when a spreadsheet program like Microsoft Excel has such a wide range of calculation and graphing functions? We certainly wouldn’t suggest ditching your spreadsheet: but if you want an effective way to progress, document and communicate technical projects, you need Mathcad on your desktop too. This article explains why.

Most of us these days have PCs with Microsoft Office pre-installed, and good compatibility with the Office programs – a significant benefit of Mathcad – is a great aid to productivity. The Microsoft Excel spreadsheet application is very capable and flexible, and is widely used by engineers and just about everyone else who needs to perform calculations and handle data.

Excel does have its limitations, however. There are surely times when you miss being able to write out your formulae in proper maths notation – equations are usually more intuitive than a spreadsheet’s nested arguments. Excel’s cell structure can often be a problem too – it’s not easy to check formulae and verify data when they’re hidden away in cells.

That’s just two of the reasons why so many engineers use Mathcad to supplement, and for many tasks to replace, the spreadsheets. While it can handle all the calculation and graphing functions – and more – that Excel does, its interface is like a word processor’s. You start with a blank page, and place your equations (in real maths notation), text, annotations, graphs, tables and drawings wherever you like.

In that way, Mathcad is more like a desktop publishing program than a word processor, because you can define regions and drag them anywhere on the page. You can format text fonts and maths symbols, add images, use headers and footers – you can even create style sheets to match your corporate standards or publication guidelines. And you can hide and lock away (behind robust, encrypted passwords) any information you don’t want others to see. As well as protecting your intellectual property, that also means you can, as with a spreadsheet, present only summary information and results.

Mathcad works alongside Excel: you can embed spreadsheets into your Mathcad worksheet, or Mathcad routines or whole worksheets into your spreadsheet cells, and use Mathcad to calculate and drive spreadsheet variables. Mathcad is also compatible with most other popular engineering applications running under Windows, including MATLAB and SmartSketch.

So while we certainly don’t suggest you stop using spreadsheets, we do think you should consider the advantages of adding Mathcad to your desktop. When you don’t want to be restricted to a rigid tabular format; when you want to see your calculations and workings clearly in a form that’s easy to check and validate; when you want to combine your calculations with other text and visual information, and document your work as you go: that’s when you’ll appreciate the Mathcad advantage.

What do our Customers say about us?

Your website is hugely informative and a pleasure to visit. Frankly I wouldn’t dream of buying technical software from anyone else.

NR, Inverness, UK

At 13-years old, my daughter’s research manuscript has been accepted for publication in a top tier peer-reviewed Environmental Science journal and OriginPro 8.6 will allow her to export the graphs in a wide variety of formats which can meet any publisher’s requirements. Kudos to OriginLab for designing innovative and intuitive software that can span the needs of both a burgeoning young scientist like my daughter to a PhD expert in their field. It is hard to imagine that other products offer this extraordinary level of user versatility.

Michael Grimmett, MD, FACP, FACS Ophthalmologist Palm Beach Gardens, Florida

Thanks for the quick response. I want to keep this software because your service is incredible….You truly have exceptional service in the software world.

PG, London, UK

Easy to book a place on the course, helpful staff at Adept. Very good introduction to the Endnote software, covered a wide range of topics. Knowledgeable on the Endnote program. Very helpful in answering any questions. Pace of learning was fine. Very good facilities.

Ms N Calver, Manchester, UK

For the time being we are unable to offer the following product ranges although we are currently working hard to increase the number of products we can offer in the future. Please contact us to talk about alternative products that we may be able to offer you.