Measurable Organizational Value
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.
1.0)
Introduction
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
1.0)
Introduction
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
References: for Software Development using Microsoft Office Products 3) Solomon, Christine, "Microsoft Office 97 Developer 's Handbook", Microsoft Press, Redmond,Washington,1997 4) Microsoft Corp.,"Microsoft Office 97 Visual Basic Programmer 's Guide"; Microsoft Press, Redmond,Washington, 1997 5) O 'Brien,T.M. & Pogge,S.J. & White,G.E.,"Microsoft Access 97 Developers Handbook", Microsoft Press, Redmond,Washington, 1997 6) Smith,Robert & Sussman,David,"Beginning Access 97 VBA Programming",Wrox Press Ltd.,Birmingham,UK,1997 7) "Visual Basic Programmer 's Guide, Version 5.0",Document No. DD93011-1296, Microsoft Corp., Redmond,Washington, 1997 8) Craig,J.C. & Webb,J.,"Miscosoft Visual Basic 5.0 Developer 's Workshop", Fourth Edition, Microsoft Press, Redmond,Washington,1997 9) Mann, Anthony,"Visual Basic 5.0 Developer 's Guide",Sams Publishing,Indianapolis,1997 10) Haught,D. & Ferguson,J.,"Microsoft Jet Database Engine Programmer 's Guide",Second Edition,Microsoft Press,Redmond,Washington,1997 Nuclear & Engineering Standards Summary (Partial List) 11) ANSI/IEEE-ANS-7-4.3.2, Application Criteria for Programmable Digital Computer Systems in Safety Systems of Nuclear Power Plants 12) ANSI/ANS-10.2,Recommended Programming Practices to Facilitate the Portability of Scientific and Engineering Computer Programs 13) ANSI/ANS-10.3,Guidleines for the Documentation of Digital Computer Programs 14) ANSI/ANS-10.4,Guidelines for the Verification & Validation of Scientific and Engineering Programs for the Nuclear Industry 15) ANSI/ANS-10.5,Guidelines for Considering User Needs in Computer Program Development 16) ANSI/ASME NQA-1,Quality Assurance Program Requirements for Nuclear Facilities 17) ANSI/ASME NQA-2 Part2.7,Quality Assurance Requirements of Computer Software for Nuclear Facility Applications 18) IEEE STD 1033,IEE Recommended Practice for Application of IEEE STD 828 to Nuclear Power Generating Stations 19) NUREG/CR-4640,Handbook of Software Quality Assurance Techniques Applicable to the Nuclear Industry 20) Regulatory Guide 1.152,Criteria for Programmable Digital Computer System Software in Safety-Related Systems of Nuclear Power Plants. 21) ANSI/IEEE Std 729,Glossary of Software Engineering Terminology 22) ANSI/IEEE Std 730, Software Quality Assurance Plans 23) ANSI/IEEE Std 828,Software Configuration Management 24) ANSI/IEEE Std 829,Software Test Documentation 25) ANSI/IEEE Std 830,Software Requirements Specifications 26) ANSI/IEEE Std 1008,Software Unit Testing 27) ANSI/IEEE Std 1012,Software Verification And Validation Plans 28) ANSI/IEEE Std 1016,Software Design Description 1998 MUG Conference Page 8 of 8