Rancho Santa Margarita, CA -- XyoTech Engineering Associates will be offering their popular “Engineering Analysis and Automation using Excel and VBA” short course July 13-16, 2009 in Rockford, IL.
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.
The course instructor, 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.
XyoTech Engineering Associates, A division of XyoTech, LLC, is a leader in engineering short courses including “Design & Development of Automotive HVAC Systems” and “Design & Development of Automotive Engine Cooling Systems”. All XyoTech courses are available to be taught on-site. More information is available on their website at www.xyotechengineering.com or by calling toll-free 1 (877) 234-7586 or (949) 340-0608.
Contact:
Joshua Boxer
XyoTech Engineering Associates
div of XyoTech, LLC
22431 Antonio Parkway
Suite B160-238
Rancho Santa Margarita, CA 92688
1 (877) 234-7586 Toll Free
(949) 340-0608
