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