Excel Functions

March 14, 2012

We write all our stress reports in excel because we can keep all of the calculations live and writing and updating reports is much quicker and easier. We also have a modular set of pre-checked and verified analysis spreadsheets we can quickly pull together to create stress reports. There are available for free here.

However Excel does not display the mathematical content of cells in a nice way like Mathcad does. This makes writing nice looking reports relatively arduous and checking excel reports difficult. There are tools out there to help, the XLC addin being the best.

XLC is great as it is a general parser for all mathematical formulae but it creates separate pre formatted graphic objects for the equations and I find that does not meet my needs, I’m not criticizing it, it’s got some really neat visual basic coding. (It’s also written by an old colleague of my father’s – small world huh?)

So we wrote an add-in for excel that meets my needs for displaying equations in our stress reports. We have been developing this for a number of years and we have made it commercially available though a separate venture – XL-Viking.

XL-Viking 2

You can download a 30 day free trial and a yearly license is only USD 5.00. We have tried to keep it as low cost as we can.

All of our free engineering analysis spreadsheets use the add-in, but they work just fine without it, only the math won’t display.

Have A Comment On This Article? Post It Here.

Comments are moderated and will not be published until approved. Your email address will be kept confidential. Please review our Comment Policy before posting your comment.


Previous Post -

Microsoft Excel Spreadsheets

FREE ANALYSIS SPREADSHEETS 3 Over the last 10 years we have developed hundreds of spreadsheet tools to help us with our structural analysis work. We have made these available through the Abbott Aerospace web site and the XL Viking project. We have now brought them into the technical library. They have been updated, improved and the collection has been expanded to cover more analysis methods than ever before.

The XL-Viking Add-In for Excel

XL-Viking 2 We created the XL-Viking Excel add-in to satisfy our own need to make Excel a better engineering tool. XL-Viking shows your Excel Formula in a way that makes sense and brings essential new functionality to Microsoft Excel by providing an additional user interface and easy to use functions.

The Indispensable Tool For Engineers, Mathematicians, Scientists, Accountants and Teaching Professionals!


Technical Papers & Reports

This is our collection of public domain references. All of the material we make available has been placed in the public domain by the authors/owners. If you believe this is not the case and any of the library material is not in the public domain please let us know. If you have any reference material that you would like to see included in the library we would love to hear from you.

Market Analysis and Market Information

Our newest addition to the library is an on-going series of articles on the aircraft and aerospace market. These are part quantitative and part qualitative and introduce a new aspect to the competencies within Abbott Aerospace.