Download RTI Spreadsheet Add-in for Microsoft

Transcript
Contents
1
Welcome to RTI Spreadsheet Add-in for Microsoft Excel
1.1 Available Documentation.......................................................................................................1-2
2
Learning the Basics
2.1 The RTI Spreadsheet Add-in Toolbar ...................................................................................2-1
2.2 Starting RTI Data Distribution Service.................................................................................2-3
2.3 Monitoring Topics ...................................................................................................................2-4
2.3.1 Filter Expression Details ..............................................................................................2-9
2.4 Subscribing to Data ............................................................................................................... 2-11
2.5 Publishing Data .....................................................................................................................2-15
2.5.1 Creating a Publication Table......................................................................................2-15
2.5.2 Filling in the Data to be Published ...........................................................................2-17
2.5.3 Publishing the Data ....................................................................................................2-17
2.6 Monitoring Built-in Topics ...................................................................................................2-18
3
Configuring RTI Spreadsheet Add-in
3.1 Configuration Parameters ......................................................................................................3-1
3.2 Changing the Data Refresh Frequency (Throttle Interval) and Auto-publish Rate.......3-8
3.2.1 Update Frequency for Subscribing Cells ...................................................................3-8
3.2.2 Auto Publish Frequency...............................................................................................3-9
3.3 Using Different Domains at the Same Time ......................................................................3-10
4
Visual Basic for Applications (VBA) Functions for RTI Spreadsheet
Add-in
4.1 Enabling Visual Basic Support ..............................................................................................4-1
4.2 Supported VBA Functions .....................................................................................................4-2
4.3 Using VBA Functions..............................................................................................................4-3
A
Subscribing to Data with the Real-Time Data (RTD) Function
B
DDS Entity Creation and Destruction
C
Controlling File Locations with Registry Settings
iii