Focus This course is available to be taught on-site at your facility. Call PEI today to schedule this course. Course Description This course is designed for technical users who want to use Excel and existing Excel tools to aid in the engineering process. Emphasis is placed on use of structured spreadsheets supported by “off-the-shelf” engineering functions, applications workbooks, add-ins and templates. This course minimizes VBA programming to the level needed to effectively use the tools in a structured spreadsheet environment. A broad range of Excel engineering tools is used for systems modeling and analysis including dynamic system simulation, optimization and trade-off studies. Participants are introduced to commercially available Excel add-ins available for engineering support. Instructor Tom R. Mincer, Ph.D., CEO, SpreadsheetWorld Inc. and Professor of Mechanical Engineering, California State University, Northridge (CSUN). Dr. Mincer initiated the use of EXCEL spreadsheets in the under-graduate and graduate curriculum at CSUN by integrating it into the courses on systems design, computational methods and computer-aided-engineering. For the past 10 years he has worked extensively in the areas of systems design, simulation and optimization using the Excel structured spreadsheet environment. He has taught the SpreadsheetWorld 5-day seminar on Spreadsheet Aided Engineering over 80 times to 1,200 engineers including on-sites at Goodyear Tire, NASA Goddard Space Flight Center, NASA Glenn Research Center, NASA Johnson Space Center, Jet Propulsion Lab, TRW, General Motors, Delco, Delphi, Naval Weapons Center, Naval Warfare Center, L3 Ocean Systems, Edwards Air Force Base Rocket Research Lab, Hamilton Sundstrand, L.A. Water District, Lockheed Martin, Pratt & Whitney & Honda R&D. Ingmar Ögren was born 1941 in Borås, a part of Sweden, known for its many small businesses. In 1948, he first encountered a complex aircraft system at a school visit to an Air Force base where the children were allowed to examine the P51 Mustang. In 1960 Ingmar was accepted at the Royal University of Technology, electronics division. This year he also met his first computer, an analog simulation machine. In 1966 it was time for graduation work on connecting a military aircraft simulator with a Sector Operation Center. By that time there were no such couplings, although they are now a regular part of the Air Force’s pilot training. The examiners expected some "electronic box", but got a system solution that could be implemented first several years later. Through the years he then got opportunities to develop his interest for complex systems: In the sixties he took part of building the Stril 60 computerized Air defense system, with responsibility for ground-to-air data transmission. The work concerned finding fault-tolerant system solutions for mobile computer-controlled communication during jamming. This was a pioneering time when mini- and micro computers entered the technical systems. In the seventies airborne computers were developed for the coming JAS aircraft. The computer concept was called D 80 and was revolutionary for airborne computers with multiprocessors, high level language, etc. Ingmar was trusted to take part in management of this project in cooperation with major industries in Sweden and in the US. It was now also time to replace Stril 60 and Ingmar took part in the work to define requirements for the new Sector Operation Centers. In the eighties Ingmar took part in founding a private company and could use his experience from military systems in civilian systems, such as factory automation and large fire alarms. By then it was also time to introduce the Ada programming language and he started work on how to extend the programming language’s use to analyze, design and document systems in general. This work led to several presentations at international Ada conferences and became the basis for the O4S method. In the nineties he got an opportunity to gather the experience from 30 years’ work with complex systems in the system engineering method O4S. O4S has so far been mostly used in defense projects such as submarines, aircraft, etc. Ingmar’s long work with complex systems has led to unique experience: a "satellite viewpoint" - an ability to overview that is significantly more than "helicopter view". an analyzing approach with ability to put together and explain systems in an understandable and pedagogic way - as simple as possible, but no simpler! the understanding that mistakes can be avoided through experience and that mistakes lead to experience! Ingmar communicates the understanding that a system is more than a computer program, and he has created a possibility to model any system where human operators, software and hardware cooperate in an environment to complete missions. In 1997 Ingmar and his wife Anna (former IBM systems programmer) decided to use the O4S experience to build a systems engineering tool as most existing tools seemed to limited as compared to the real needs. The result was the Tofs, Tool For Systems tool. Together with his wife Anna, Ingmar now runs the Tofs company. The company is located at the seaside, some 70 miles north of Stockholm. Enroll in this course at Professional Education International
