top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  
With Excel / VBA

ATI's Thermal & Fluid Systems Modeling course

Share |


    Technical Training Short On Site Course Quote

      This three-day course is for engineers, scientists, and others interested in developing custom thermal and fluid system models. Principles and practices are established for creating integrated models using Excel and its built-in programming environment, Visual Basic for Applications (VBA). Real-world techniques and tips not found in any other course, book, or other resource are revealed. Step-bystep implementation, instructor-led interactive examples, and integrated participant exercises solidify the concepts introduced. Application examples are demonstrated from the instructor’s experience in unmanned underwater vehicles, LEO spacecraft, cryogenic propulsion systems, aerospace & military power systems, avionics thermal management, and other projects.
      View course sampler


      Matthew E. Moran, PE is a Senior Engineer at NASA, and an instructor in the graduate school at Walsh University. He has 27 years experience developing products and systems for aerospace, electronics, military, and power generation applications. He has created Excel/VBA thermal & fluid system models for the Air Force, Office of Naval Research, Missile Defense Agency, NASA, and other organizations. Matt is Professional Engineer (Ohio), with a B.S. & graduate work in Mechanical Engineering, and an MBA in Systems Management. He has published 37 papers, and has 2 patents and 3 patents pending, in the areas of thermal systems, cryogenics, MEMS/microsystems, power generation systems, and electronics cooling.

      Contact this instructor (please mention course name in the subject line)


      "Lots of useful information, and a good combination of lecture and hands-on."

      "Great detail…informative and responsive to questions. Offered lots of useful info to use beyond the class."

    What You Will Learn:

    • Exploit the full power of Excel for building thermal & fluid models.
    • Master the built-in VBA programming environment.
    • Implement advanced data I/O, manipulation, analysis, and display.
    • Create full featured graphical interfaces and interactive content.
    • Optimize performance for multi-parameter systems and designs.
    • Integrate interdisciplinary capabilities into thermal & fluid models.

      This course will provide the knowledge and methods to create custom thermal & fluid system models for analyzing conceptual designs, performing system trades, and optimizing system performance with Excel/VBA.

    Course Outline:

    1. Excel/VBA Review. Excel capabilities. Visual Basic for Applications (VBA). Input/output (I/O) basics. Integrating functions & subroutines.

    2. Identifying Scope & Capabilities. Defining model requirements. Project scope. User inputs. Model outputs.

    3. Quick Prototyping. Creating key functions. Testing I/O & calculations. Confirming overall approach.

    4. Defining Model Structure. Refining model architecture. Identifying input mechanisms. Defining output data & graphics.

    5. Designing Graphical User Interfaces. Using ActiveX controls. Custom user-forms. Creating system diagrams & other graphics. Model navigation.

    6. Building & Tuning the VBA Engine. Programming techniques. VBA integrated development environment. Best practices for performance.

    7. Customizing Output Results. Data tables. Plots. Interactive output.

    8. Exploiting Built-in Excel Functions. Advanced math functions. Data handling.

    9. Integrating External Data. Retrieving online data. Array handling. Curve fitting.

    10. Adding Interdisciplinary Capabilities. Integrating other technical analyses. Financial/cost models.

    11. Unleashing GoalSeek & Solver. Single variable, single target using GoalSeek. Multivariable optimization using Solver.

    12. Incorporating Scenarios. Comparing multiple designs. Tradeoff comparisons. Parameter sensitivities. Quick what-if evaluations.

    13. Documentation, References, & Links. Documenting inputs, methodology, and results. Incorporating references. Adding links to files & online data.

    14. Formatting & Protection. Optimizing formatting for reporting. Protecting algorithms & proprietary data. Distribution tips.

    15. Flexibility, Standardization, & Configuration Control. Building user flexibility and extensibility. Standardizing algorithms. Version & configuration control.

    16. Other Useful Tips & Tricks. Practical hands-on techniques & tips.

    17. Application Topics. Tailored to participant interests.


      Tuition for this three-day course is $1740 per person at one of our scheduled public courses. Onsite pricing is available. Please call us at 410-956-8805 or send an email to