Using Microsoft Excel as a Analysis and Report Tool – Post 1

January 4, 2017

First Post – Introduction

In writing our free textbook I had to make what I consider to be a huge personal and professional concession. I had to use Microsoft Word. I started out writing the book in Excel but the page formatting and section numbering and referencing issues were too great.

Word is great writing resumes, letters and engineering textbooks. For engineering reports, it has several significant drawbacks. These problems include:

  1. Word tries to do too much and can end up creating very large unstable files that get ‘corrupted’. i.e. Word ends up doing something that even Word rejects and you end up losing data and time.
  2. Word does not let you keep calculations ‘live’. This results in report updates for new loading, geometry or materials taking a significant amount of time as every numerical value has to be updated

We still use Word for writing reports. When a client has an internal reporting system that flows down to us and we must use Word the whole team just has to knuckle down and live with the inefficiency and frustration.

To be fair, Microsoft Excel is a spreadsheet tool that was initially optimized for accounting. Excel has significant limitations:

  1. Excel is not WYSIWYG and looks different at different screen magnifications and needs to be tailored for each different printer it may be printed out on
  2. Excel has limitations on how subscript and superscript characters are processed (more on this later)
  3. Excel is not a word processor or a graphics tool.

To use Microsoft Excel as an efficient technical reporting tool you have to adopt a code of ‘best practice’. Our ‘best practice’ is informed by my experience and the experience of other senior level technical people I have worked with.

Why not use Mathcad? Mathcad is a great tool but it has several drawbacks:

  1. It is expensive
  2. It is not universally used
  3. Mathcad is great a presenting math. My experience of work created and presented in Mathcad is that the user gets carried away with the beautiful mathematics and you end up with a report that consists of page after page of mystifying math with few diagrams and little commentary.

Having listed the main reasons why we do not use any other package and the negative points about Excel let me list the positive aspects.

  1. Excel is a universally used – almost everyone has an Excel license. Analysis files are easily shared and edited.
  2. Excel is the most stable of the Microsoft Office suite of programs.
  3. Excel is a general tool – it does many things moderately well

Reports written in Word tend to have a lot of prose and not enough math. Report written in Mathcad tend to have a lot of math and not enough prose. Reports written in Excel tend to naturally strike a balance between prose and math because it is equally good (and bad) at both.

Excel can also be used as a FE output database for storage and processing. We also use Excel to create input loads files for Finite Element models in the correct .bdf or .dat format.

We also use Excel to create simple engineering drawings and for creating commercial logos and graphics for most of our company needs.

Excel mirrors good practical engineering traits:

Jack of all trades and master of none, But oft times better than a master of one

 Important Terms:

Workbook – a discrete Excel file, usually has .xlsx extension

Worksheet – a sheet tab within a workbook, a workbook can contain hundreds of individual worksheets.

Cell – an individual referenceable item of data within a worksheet, cells are shown as a grid of rectangles on the worksheet.

Print Area – the area of the worksheet that is printed.

Continued in the next post……..

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.


2 Comments on "Using Microsoft Excel as a Analysis and Report Tool – Post 1"

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.