VTB COM Server Application in Excel: Endurance Data Tool Kathleen Young youngkdengr'sc'edu The Unive

1
VTB COM Server Application in Excel Endurance
Data Tool Kathleen Young youngkd_at_engr.sc.edu
The University of South Carolina
VTB Conference
September 20th, 2005
2
Outline

• Reason for this application
• Similar approaches
• Excel with VTB as a simulation solution

3
Large Scale System Simulations
Integrated Full Electric Propulsion (IFEP)
Submarine Example
4
Endurance Data Simulation

• Need endurance data from complex ship systems
• Real-time is too slow for some data
• Calculations are tedious

5
Some Other Approaches

• Simulinks Phasor Analysis
• Cambridge Simulation

6
Current Capabilities of Excel with VTB

• VTB can read/write values to/from Excel
• Excel can start/stop/pause VTB simulation
• Excel can change VTB model parameters

7
Advantages of Using Excel with VTB

• Organize Large Amounts of Data
• Easy Access to Software and Documentation
• Run Long Pre-programmed Simulations

8
VTB/Excel COM Communication
CLIENT
SERVER
Controls Solver
VTBServer Class Add-In
Solver
Add-in
Excel
Controls Excel
Excel component
Add-in
CLIENT
SERVER
Many Applications have COM capabilities
9

• Voltage reference changed from Excel
• Changes voltage level in VTB
• Writes RMS Value to Excel

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Visual Basic Editor
VTB
Excel
14
A Final Goal
15
Future Steps for Endurance Data Extraction Project

• Algorithm to minimize simulation time
• Automatic adjustment to reach operating
  conditions (i.e. drive voltage adjusts to obtain
  particular line voltage)
• Technical Manual

16
QUESTIONS?