header image
Home arrow Key Features
Key Features
Key Features of Plan
  • Use Excel/VBA as a Common Computational Platform
  • Setup Skills Development and Implementation Strategy
  • Develop team of Advanced Excel/VBA Power Users
  • Establish Model Development Standards that Enable a Common Global Computational Platform
  • Train Leadership for Ongoing Process Implementation
  • Define and Implement a Process for Team Integration
  • Build Excel/VBA Function Libraries
  • Build Excel/Access Engineering Information Libraries
  • Build Excel Template Libraries
  • Audit Computer Tool Use and Processes
  • Develop Guidelines for Tool Selection and Integration
  • Use VBA to Communicate Between Engineering Design Tools
  • Develop Excel/VBA Advanced Users Group
  • Use Top-Down System Parameters to Drive Models and Simulation
  • Continue to Build Excel/VBA Power Users in Engineering and Management
Excel has an impressive array of key features which positions Excel to be unchanged to play this important Enterprise role. The following are just a few of the key features of Excel and VBA

 

  • Broad User Base in Both Engineering and Management
  • Popular Development Platform on Both PC/Windows and Macintosh Networks
  • Visual Basic for Applications (VBA): Common Programming Language
  • Global Commercial Third-Party Add-in Development
  • Commercial Internet Add-in Distribution Networks
  • Easily Develop Custom Engineering Function Models
  • Design Team & Software Collaboration Add-ins Available
  • Built-in Iterative Solver (Optimization) and Uncertainty Analysis Capabilities
  • Easy Configuration Selection Capability to Support Trade-off Studies
  • Iterative Worksheet Calculation Capacity for Easily Inverting Functionality
  • Model Object System/Subsystem/Component Structure Architecture
  • Interface with FORTRAN and C Code Using DLLs
  • Graphical User Interface (GUI) Development Using VBA ActiveX Controls
  • Dynamic Internet and Hyperlink Capabilities
  • Command & Control of Engineering Information Database Files
  • The continuing development of the Visual Basic language and its ability to communicate with a growing number of “design tools” via the Application Programming Interface (API) has opened up new possibilities for creating an integrated computing environment for design and optimization.
  • The API allows engineers to write VBA code for any application that uses Visual Basic while being inside another application.  This feature allows Excel/VBA to sit at the system level and drive system parameters down into other applications, which in turn can drive its parameters to other tools down the modeling chain.
[ Back ]
Newsflash

Spreadsheet Aided Engineering Public Courses:

January 14-18, 2008 S. Lake Tahoe, CA

August 4-8, 2007 Frankenmuth, MI