Measurable Organizational Value

Software testing, Software development process, Microsoft Excel

ABSTRACT Thrust & Torque Calculations for MOV’s using Microsoft Office Products Prepared by Michael C. Richard Teledyne Brown Engineering Desktop computing using Microsoft Office products have changed the way that engineering calculations are performed. But, is the change for the better or the worse? Engineering Managers are faced with the task of “computerizing” engineering calculations all the time. This paper presents some guidance on how to choose the method that best suits your calculation needs. Specifically, three methods of calculating thrust and torque for MOV’s will be presented. The three methods consist of an Excel model, an Access model, and a final model which uses Microsoft Visual Basic combined with Access (Microsoft Jet) and Excel. Pro’s and con’s will be presented for each method. Finally, the subject of software validation and verification will be presented with discussions on how this subject applies to the four methods of calculation presented above. The information presented in this paper should provide the Engineering Managers, as well as the engineers responsible for “computerizing” the calculations with the tools they need to make a successful decision.


Engineering calculations have changed significantly over the last ten years. With the emergence of desktop PC's, many different software products have been developed to assist engineers with calculations. In particular, Microsoft has developed a family of "desktop" software products named Office 97 to assist with the many facets of business calculations. Software products, like Office, allow engineers to develop and program their own calculations, instead of relying solely on software engineers who may not have a background in the field of interest. This calculation evolution has on one hand empowered the engineer, but on the other hand has added requirements for new skills. If you were going to develop an engineering calculation or you were going to manage the...
tracking img