Excel Training, Excel VBA Training, Excel Software Design

NASA Mars Rover - Microsoft Excel VBA Project

EMAGENIT Nasa Microsoft Excel VBA Project

NASA Certificate of Recognition Award

EMAGENIT worked with NASA JPL to help design conceptual software for the Mars Rover program using Microsoft Excel VBA.

EMAGENIT teamed up with NASA JPL to help create part of its conceptual design software for the Mars Rover in Microsoft Excel VBA. Below is a brief overview of how it was done.

NASA Microsoft Excel VBA Project - The Problem

NASA Microsoft Excel VBA Project - The Problem

NASA JPL approached EMAGENIT with the following engineering problem: Develop a conceptual design environment in Microsoft Excel VBA for Windows and Excel VBA for Mac that would allow various NASA JPL programs written for the Mars Rover in C to have a better more flexible user interface and also be able to communicate with each other passing design information. These programs acting in unison along with the EMAGENIT Excel VBA interface were to allow NASA JPL to rapidly simulate, early in the conceptual design process, the power usage of future Mars rovers and the rover’s mission profile for each day. It was called the Mission Scenario Design Workbench.

NASA Microsoft Excel VBA Project - How We Did It

NASA Microsoft Excel VBA Project - How We Did It

Using a combination of Microsoft Excel, Visual Basic for Applications, C, Pearl Script, Unix Script and Apple Script among other things, EMAGENIT and its associated JPL team were able to develop an integrated design environment in Microsoft Excel that allows JPL mission planners to rapidly simulate a conceptual Mars missions for future rovers. As you noticed from the list just presented, everything used in the program was “off the shelf” allowing it to be developed and tested rapidly. Most important, the program was designed to run in both Excel for Mac and Excel for Windows.

NASA Microsoft Excel VBA Project - Why Did We Use Microsoft Excel?

NASA Microsoft Excel VBA Project - How We Did It

Simple Microsoft Excel's versatility. Microsoft Excel in combination with Visual Basic for Applications has the capability to create dedicated applications that rival programs written in stand alone languages like C and Visual Basic. The strength’s of using Excel is that everybody already knows how to use it, Excel’s environment provides a s et of tools that allows sophisticated interfaces to be developed and tested rapidly, Excel has the unique capability to communicate with multiple databases and computer languages at once and the base line program can have extra functionality added to it by simply using Excel worksheets and formulas. Most of all, since Excel and its functionalities are pre-built; project development time and cost are substantially reduced. The JPL project just mentioned from conception to finished product took about 4 ½ months.

We Can Teach These Same Skills to You - Our Microsoft Excel VBA Training

Beginning Microsoft Excel VBA Training for Business

Beginning Excel VBA Training for Business Professionals

Our 2-day "hands-on" beginning Microsoft Excel VBA training shows you the essential Excel VBA programming skills that you need to immediately develop useful powerful data processing and analytical tools that your business needs now.View Outline

Advanced Microsoft Excel VBA Training for Business

Advanced Excel VBA Training for Business Professionals

Our 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to build advanced data processing tools, analysis tools and dashboard displays using Microsoft Excel VBA that will solve the most difficult business tasks. View Outline

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Beginning Excel VBA Training for Engineers and Scientists

Our 2-day "hands-on" beginning Microsoft Excel VBA training shows you how to use Excel VBA to control key Excel engineering and science features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and data, create report tools and much more. Taught by an engineer. View Outline

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Advanced Excel VBA Training for Engineers and Scientists

Our 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to use Excel VBA to build advanced engineering and science tools that that solve your most difficult data and analysis tasks and help you visualize your data sophisticated interfaces. Taught by an engineer. View Outline



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved