| Engineering Analysis and Automation using Excel and VBA |
|
This course is available for both Excel 2003 and Excel 2007 versions. Download Brochure Here
August 2-6, 2010 ($1,995/Student, Group Discounts are Available), Also available on-site at your location, call us for pricing information. REGISTER HERE
Engineering Analysis and Automation using Excel and VBA is the foundational component in a comprehensive sequence of hands-on courses that instruct participants in the use of spreadsheets to perform common and repetitive engineering tasks. Many engineers are knowledgeable in the application of spreadsheets to a myriad of engineering analysis tasks. However, as these tools proliferate through an organization due to their powerful utility, deficiencies in well-structured development practices and maintainability arise. Additionally, few engineers are conversant in the Visual Basic for Applications (VBA) language extension provided with all Microsoft Office products. Engineers who take this hands-on course will see immediate benefits in their daily work, saving them and their companies countless hours and; therefore, money.
In this hands-on workshop, students will learn structured techniques for developing and maintaining spreadsheet analysis tools in Microsoft Excel. The VBA automation language that sits behind Excel will be covered in depth, providing students with the ability to streamline analyses and automate repetitive tasks. Only those elements of the spreadsheet application that are pivotal in technical analyses will be covered, and all VBA techniques will be geared towards enabling the student for success in current and future projects as opposed to the common cookbook approach of providing solutions for problems with very limited scope. Topics such as plotting and graphic interface techniques will also be covered with a special emphasis on automation using VBA. Hands-on examples throughout the course help to reinforce the concepts presented while going beyond overly simplistic exercises that are not applicable in a production environment. Students will not only leave the workshop with Excel and VBA skills they can apply immediately to their current project, but also exposure to a wide range of applications of the material.
Instructors:
Steven E. Squier, MS, Research Engineer, Hamilton Sundstrand Aerospace, initiated, developed and continues to promote a computer-aided systems engineering approach to analysis of aircraft subsystems, primarily using Excel. His 26 years of aerospace industry experience at Hamilton Sundstrand and Rockwell International have been primarily focused on the evaluation of vehicle-level system performance impacts due to subsystem design variations. He holds several patents in diverse areas of systems engineering and has experience in electric power, environmental control, thermal analysis, hydraulics, pneumatics, reliability, statistical and uncertainty analysis, neural networks and life cycle costing. As part of the Advanced Systems group within Hamilton Sundstrand, Mr. Squier has conceived and created several custom engineering applications incorporating intuitive graphical user interfaces all within the Microsoft Excel environment, and often coupling Excel with other applications. He has applied the concepts taught in this course to the evaluation of advanced subsystem integration schemes for many commercial and military aircraft platforms, most recently the Boeing 787 Dreamliner and Joint Strike Fighter. Mr. Squier has developed Excel/VBA applications not only for engineering analysis, but also for technical data management, facility/test build configuration documentation (combined with Microsoft Visio as a graphical front end) and automated status reporting of certification testing. Mr. Squier is also an Assistant Professor in the Physical Science Department at Rock Valley College in Rockford, IL, and a former Dean of Liberal Arts and Sciences.
David R McDaniel, MS has been working in the aerospace arena for over 15 years now. He served on active duty in the US Air Force for almost 8 years where his tours included flight test work on the B-1B and B-2A bomber aircraft and teaching aerodynamics and thermodynamics courses at the US Air Force Academy. Mr. McDaniel spent most of his post-military years working as a contract researcher at the USAF Academy in the areas of aerodynamics and computational fluid dynamics. He is currently working as an assistant research professor at the University of Alabama at Birmingham and is on the development team for the fixed-wing virtual aircraft product of the DoD High Performance Computing Modernization Program's CREATE project. He has leveraged the power of Excel/VBA in numerous applications related to his work, and he has taught various spreadsheet engineering short courses for the past ten years.
Matthew E Moran, PE is the owner of Isotherm Technologies LLC and a Senior Engineer at NASA. He has 25 years of experience developing products and systems for aerospace, electronics, military, and power generation applications. He has been a founder or key collaborator in five high-tech startup businesses, including Isotherm Technologies that has been developing pioneering thermal technologies since 1997. Recent projects include: thermal management microsystems, high-powered lasers, fuel cell reactants, super-insulation, solar dynamic cryocoolers, waste heat harvesting, and thermal-powered wireless sensors & devices. Matt is a licensed professional engineer with a Bachelor degree and graduate work in mechanical engineering, and an MBA in systems management. He has published 35 papers and articles; and has two patents, three patents pending, and six invention disclosures.
Course Outline (Can be Customized for On-Site Courses)
|