RTI Spreadsheet Add-in for Microsoft
Contents
1. ee T mart ea ee Klicatian a ETI hdanitoar Damar Note Starting the RTI Service does not cause the add in to subscribe to or pub lish user data those features are described in the following lessons 4 5 Chapter 4 4 3 Lesson 3 Monitoring Topics You can use a Topic Monitor to monitor data for a specific DDS topic In this lesson we will create a worksheet that subscribes to all the instances of a specific topic 1 Create an Excel worksheet that will subscribe to or monitor the square topic being published by RTI Shapes Demo a From the RTI Spreadsheet Add in toolbar select RTI Monitor Topic The list on the left shows DDS topics that have been discovered by the add in in the domain you selected in the RTI Config dialog In our case these are the topics being published by RTI Shapes Demo b Click Square The list on the right shows the fields in the Square s data type By default all fields are selected _ se Choose topic and fields Available topics 4 6 4 3 Lesson 3 Monitoring Topics Notice you have a new worksheet with a Topic Monitor table already filled in Each row in the table is monitoring an instance color of the topic named Square Each column contains data for one of the selected fields in the topic s data type color x y and shapesize A B c D The topic monitor 1 Qi ic Square Type ShapeTyp table contains three rows of table header2. 6 T Pan You are creating a range of cells that represent a topic each row will be a sample with a column or each field By filling in this table l in the next step you will be able to publish these samples 5 Fill in one row of the publication table for squares a In the cell under the color column enter a color name Use a color not already being published with RTI Shapes Demo such as CYAN b For x y and shapesize use this formula so the values will vary each time you publish them ROUND RAND 2 100 B4 K ROUND RAND 2 100 PI a m 1 PUBLICATION Topic Square Type Shape 2 eel eee e l 3 You will see later that the values in these three cells change randomly every time you publish 4 12 4 5 Lesson 5 Publishing Data 6 Recall that we started two copies of RTI Shapes Demo So far we ve only used one In the unused copy which we refer to as the Subscriber Demo subscribe to Squares a Under Subscribers select Square b In the Create New Subscriber dialog click OK Your two RTI Shapes Demo windows should look similar to this 2 RTI Data Distribution Service Shapes Demo Domai X RTI Data Distribution Service Shapes Demo Domaind E J File View Publish Subscribe Controls Help File View Publish Subscribe Controls Help Delete All Pause Publishing Pause Publishing Hide History Hide History ANS Confin DNS Confin lame Type Color P
3. B C D 1 SUBSCRIPTION Topic Square Type ShapeType 2 color x y shapesize 4 4 RED 49 121 30 5 GREEN 95 250 30 6 MAGENTA 182 169 30 Lesson 4 Subscribing to Data The previous lesson showed you how to subscribe to data for all instances of a topic Now let s see how to subscribe to a specific instance Remember that the shape s color is its key the data that uniquely identifies different instances We will be adding a subscription to an Excel worksheet that will only receive red squares being published by RTI Shapes Demo 1 Select a cell in an empty worksheet 2 From the RTI Spreadsheet Add in toolbar select d RT Add Subscription 3 Click on the Square topic from the list on the left 4 4 Lesson 4 Subscribing to Data 4 From the list of fields on the right select x y and shapesize as the fields you want to display Choose topic and fields Available topics Fields E color TK_STRING key E E ShapeType lx TK_LONG ly TK_LONG 5 Since the topic s data type has a key you must specify the color of squares that you want to subscribe to by entering a color in the Value cell in the key values table Enter RED Enter key values History position o Bid Tee E Manual Update e You can only specify one value per key field at a time that is you cannot specify RED and GREEN e The key is case sensitive Colors in RTI Shapes Demo are all upper case Chapter 4
4. Change the Auto publish timer interval to 100 ms and click the button next to the interval Click Start RTI Data Distribution Service The add in is publishing triangles and you will see that the tables and charts are filled in and changing Inputs gt gt gt Analysis gt gt gt Outputs The table and chart below display the The table and chart below display statistics The table and chart below display the data values that incoming data values pertaining to the circles pertaining to the incoming data values will be published from this spreadsheet so that they can published by RTI Shapes Demo be viewed from a subscribing RTI Shapes Demo window Feel free to add new colors PUBLICATION Topic Triangle Type ShapeType color x y shapesize YELLOW E BLUE Meanx Median Miny Maxy x Subscribing to data from RTI Analyzing the Publishing data to RTI Shapes Shapes Demo incoming data Demo The input data from the far left table is used as output Notice that the domain ID is now displayed in the RTI Spreadsheet Add in tool bar and the other toolbar commands are enabled RTI Data Distribution Service is running on domain 0 View Add Ins Home Insert Page Layout Data RT Config RTI Add Publication RTI Monitor Domain ei RTI Monitor Topic SF RT Publish Now Stop RTI Service Sd RT Add Subscription RTI Update Now Formulas Running on domain 0 Toolbar Commands
5. From the RTI Spreadsheet Add in toolbar select RTI Monitor Domain 2 Select Publications from the Builtin topic drop down list box to monitor discov ered publications Create a domain monitor Builtin topic m Publications Subscint o Level of detail Particinant Location Basic Current cell Advanced New worksheet Full G9 Create builtin monitor JOHOINL 7 Chapter 4 3 Click Create builtin monitor You ll see the builtin topics such as these 1 SUBSCRIPTION Topic PUBLICATION Type BUILTIN 4 Creation timestamp Deletion timestamp i _3 192 168 2 3 9 9 2009 1 03 42 17 PM writer with key Square ShapeType 4 192 168 2 3 9 9 2009 1 03 49 74 PM writer with key Circle ShapeType 3 192 168 2 3 9 9 2009 1 14 27 03 PM writer with key Square ShapeType Each time a new publication is discovered a new row is added at the bottom of the builtin topic monitor table You may notice that the writer for the cyan squares being published from your Excel worksheet does not appear in this list That s because only entities discov ered from other applications will appear in the builtin topics Since the cyan squares are coming from this same DDS participant the add in they will not appear in the builtin topic 4 In the Publisher Demo s Legend tab at the bottom select the yellow circle and press Delete on your keyboard You will see the corresponding row turn red to show the last publisher o
6. configure RTI Spreadsheet Add in for Microsoft Excel and provides details on each feature Chapter 2 Installation 2 1 This chapter will help you install RTI Spreadsheet Add in for Microsoft Excel and the required license file I Installing Section 2 1 J License Management Section 2 2 L The Excel Throttle Interval RTDThrottleInterval Section 2 3 _J Uninstalling Section 2 4 After installation see Chapter 3 A Quick Demonstration to get a quick idea of the add in s capabilities Then see Chapter 4 Tutorial for a more in depth look at what you can do with RTI Spreadsheet Add in for Microsoft Excel Installing If you have run the installer before and are reinstalling the software be aware that the installer will not automatically remove previous installations as a part of a new installa tion If you want to replace a previous installation RTI recommends that you uninstall the software see Section 2 4 before reinstalling it You may want to keep a copy of your XML configuration files if you have made any changes to them since these files are deleted by the uninstaller These files are in My Documents RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt uoHDIIO SUI Z Chapter 2 2 2 To install RTI Soreadsheet Add in for Microsoft Excel Note The installer must be run by a user with administrator privileges The add in will only be set up for use by the current user initially After the
7. _ a 4 RED 136 241 30 _5 GREEN 209 88 30 Each time a new instance is received a new row is added to the end of the topic monitor table in the worksheet A column header with a darker color indicates that the field is a keyed field in the data type 2 In the Publisher Demo add a square with a new color such as MAGENTA Notice that the new color automatically appears in the worksheet That s because you re already set up to subscribe to all instances colors of the topic Square It s a new row in the table because each instance color gets its own row wi A B C 1 Beene Topic Square Type ShapeType 2 ic olor x y shapesize 4 RED 150 223 30 5 GREEN 210 242 30 6 MAGENTA 18 31 30 3 In the Publisher Demo add another square using one of the same colors already being published such as RED Notice that the worksheet does not have a new row for that square Since it doesn t use a new color it isn t a new instance 4 In the Publisher Demo s Legend tab at the bottom select either one of the red squares and press Delete on your keyboard 4 7 Chapter 4 4 4 4 8 5 In the Publisher Demo s Legend tab at the bottom select the green square and press Delete on your keyboard In the worksheet notice that the row for the green square now appears in red to show it s been deleted The deleted red square doesn t show up in red because you still have a red square A
8. 3 5 Chapter 3 3 6 You will also see the triangles in the RTI Shapes Demo win dow By default Subscribers show the most recent 6 samples this is why you see extra trian gles behind the leading one The most recent shape has a thick colored border Older historical samples have a thinner border of the same color Published shapes have a thin black border Use the cursor to move the cir cles around in the RTI Shapes Demo window Notice that the position of the circles affects the size and position of the triangles The add in reads the x y position of the circles and uses that data as the size of the triangles it is publishing This concludes the demonstration Next we recommend Chapter 4 Tutorial for a more in depth look at what you can do with RTI Spreadsheet Add in for Microsoft Excel FI RTI Data Distribution Service Shapes Demo Domain 0 bhes File View Publish Subscribe Controls Help Delete All Pause Publishing Hide History DDS Config Ready on domain 0 Shapes that are being received subscribed to have a thick colored border Shapes being sent published have a thin black border Chapter 4 Tutorial This tutorial will help you become familiar with RTI Spreadsheet Add in for Microsoft Excel s main features We will use RTI Shapes Demo as an easy way to start a DDS application RTI Shapes Demo is an RTI Data Distribution Service application that can send and receive colore
9. Publish Subscribe Controls Delete All Pause Publishing Hide History DDS Config Help RTI Shapes Demo is available from RTI s download page www rti com downloads in the section titled Interactive DDS Demonstration Before continuing please make sure you have the following software installed I RTI Spreadsheet Add in for Microsoft Excel I RTI Shapes Demo Notes I RTI Shapes Demo uses Domain ID 0 by default If you need to use a different domain ID please see Section A 1 li If you are using a computer that does not have an active network interface please see Section A 2 3 1 uopsuoweaq e Chapter 3 1 Start RTI Shapes Demo from the Windows Start menu If you installed RTI Shapes Demo with the RTI Spreadsheet Add in for Microsoft Excel installer select Start A11 Programs RTI RTI Shapes Demo lt version gt RTI Shapes Demo Depending on your security settings you may see a Windows Security Alert dia log simply click Unblock Windows Security Alert E3 To help protect your computer Windows Firewall has blocked some Features of this program Do you want to keep blocking this program at Name RTI Shapes Demo Publisher Real Time Innovations Keep Blocking Unblock Ask Me Later Windows Firewall has blocked this program from accepting connections from the Internet or a network IF you recognize the program or trust the publisher you can unblock it When sh
10. RTI Spreadsheet Add in for Microsoft Excel for RTI Data Distribution Service Getting Started Guide Version 1 1 RTD 2010 Real Time Innovations Inc All rights reserved Printed in U S A First printing RTI Trademarks Real Time Innovations and RTI are registered trademarks of Real Time Innovations Inc All other trademarks used in this document are the property of their respective owners Copy and Use Restrictions No part of this publication may be reproduced stored in a retrieval system or transmitted in any form including electronic mechanical photocopy and facsimile without the prior written permission of Real Time Innovations Inc The software described in this document is furnished under and subject to the RTI software license agreement The software may be used or copied only under the terms of the license agreement Technical Support Real Time Innovations Inc 385 Moffett Park Drive Sunnyvale CA 94089 Phone 408 990 7444 Email support rti com Website http www rti com support Contents Welcome to RTI Spreadsheet Add in for Microsoft Excel CE Vape Do Big qh cial Luo q eee meen emmr semen ten te merrert E S EE 1 2 Installation PME Ta eNO a T T A E A A E AE T 2 1 Aa KINS e Manan Ve a E T ERS 2 4 2 3 The Excel Throttle Interval RTD THrottlelnterv all ssccsivevsevesiiveicdveaviveavedessavedctocacevsavsvesoavertess 2 5 A U Say e E A 2 6 A Quick Demonstration Tutorial 4r Jes
11. The add in creates this RTD function for each cell Al 9 fe RTD dds2excel connect TYPE ShapeType TOPIC Square FIELD x KEY color RED ee 104 30 iP 7 X y shape size In each row there is a cell for each field selected in the Create Subscription dialog Notice that the table does not have a header row The table will not grow in size over time 7 To prove that the values you are seeing are for red squares click the red square in the Publisher Demo window to hold it still Notice that the values in your work sheet stop updating You can give the square a push with your cursor to get it moving again 4 10 4 5 Lesson 5 Publishing Data 4 5 Lesson 5 Publishing Data So far we have RTI Shapes Demo publishing data and two Excel worksheets subscribing to that data one is subscribing to all squares the other just to red squares Now it s time to see how to publish data from Excel We will be adding a publication to an Excel worksheet that will publish cyan squares and the squares will be received by RTI Shapes Demo 1 Select a cell in an empty worksheet 2 From the RTI Spreadsheet Add in toolbar select ey RTI Add Publication 3 Select the Square topic from the list on the left Choose topic and fields Available topics JONOINL 7 Chapter 4 Your worksheet should resemble this POE vO O S O s O 1 PUBLICATION Topic Square Type Shape A 3 4 5
12. add in is installed on the machine other users including those without administrator privileges can set themselves up to use the add in by going through an addi tional set up process described later in this section Make sure you have administrator privileges Make sure you have opened Excel at least once as the current user before run ning the installer This ensures that Excel user profile is properly initialized before the add in is installed Extract unzip the contents of the distribution file into a folder of your choice this folder is only needed during installation it will not be the final location for the add in Run setup exe not the msi file from that folder and follow the directions on the screen The installer may prompt you for permission to install a patch called Shared Add in Support Update for NET Framework 2 0 Although the prompt indi cates that the patch is for NET Framework 2 0 it is actually for NET 2 0 and higher This patch is required The installer also requires Microsoft NET Framework 3 0 or higher If you do not already have it the installer will open a browser window so you can download the latest version If you install NET Framework you will be asked to reboot your system following installation After the reboot you will need to re run setup exe in order to complete the installation Install the required license file See License Management Section 2 2 Optiona
13. artitions Read Take QoS Settings Reliability Name Type Color Partitions Read Take Qos Settings Reliability Square Pub RED Default Default True Square Sub i Read Default Default False Cirde Pub YELLOW Default Default True Default Default True Ready on domain 0 Publisher Subscriber Notice that the Subscriber s shapes have thick blue borders This is how you can distinguish between Subscribers and Publishers By default Subscribers show the most recent 6 samples this is why you see extra squares behind the leading ones The most recent shape of each color has a thick colored border Older historical samples have a thinner border of the same color Published shapes have a thin black border Also notice that you do not see a cyan square yet although your worksheet is set up to publish them from the work done in Step 5 you haven t actually pub lished from Excel yet 7 From the RTI Spreadsheet Add in toolbar select 7 RTI Publish Now 4 13 Chapter 4 Now you should see a cyan square in the Subscriber Demo Domain 0 Ei File View Publish Subscribe Controls Help Help Square Circle Triangle Square Circle Triangle Delete All Delete All Pause Publishing Pause Publishing Hide History Hide History ANS Confin DNS Confin lame Type Color Partitions Read Take QoS Settings Reliability Name Type Color Partitions Read Take QoS Setti
14. ce these files are deleted by the uninstaller These files are in My Documents RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt The uninstaller will not remove the add in con figuration files for other users You will need to manually remove the files under My Documents RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt for all the other users individually Note There is a known issue regarding uninstalling the toolbar is not removed from the Add ins tab You may remove it manually For example to remove the toolbar with Office 2003 select Tools Customize on the Toolbars page select RTI Spreadsheet Add in for Microsoft Excel then click Delete 1 If you are using the Control Panel s Classic View select Programs and Features directly from the Con trol Panel The best way to learn about RTI Spreadsheet Add in for Microsoft Excel is to start using it The provided demon stration file Shapes_Example xls will give you a quick idea of the add in s capabilities After the demonstration we recommend using the tutorial in Chapter 4 for a more in depth look at what you can do with RTI Spreadsheet Add in for Microsoft Excel Both the demonstration and the tutorial use RTI Shapes Demo an RTI Data Distribution Service application that can send and receive colored moving shapes Chapter 3 A Quick Demonstration a RTI Data Distribution Service Shapes Demo Domain O cche File View
15. color is used as a key simply a way to distinguish between data for multiple instances of the same shape topic Data that belongs to the same instance in the topic shape will have the same key value color I RTI Shapes Demo uses Domain ID 0 by default If you want to use a different Domain ID please see Section A 1 J If you are using a computer that does not have an active network interface please see Section A 2 1 Start two copies of RTI Shapes Demo from the Windows Start menu select Al Programs RTI RTI Shapes Demo lt version gt RTI Shapes Demo Depending on your security settings you may see a Windows Security Alert dialog simply click Unblock S Windows Security Alert AN seria To help protect your computer Windows Firewall has blocked some features of this program Do you want to keep blocking this program at Name RTI Shapes Demo Publisher Real Time Innovations Keep Blocking Unblock Ask Me Later Windows Firewall has blocked thie program from accepting connections from the Internet or a network IF you recognize the program or trust the publisher you can unblock it Wher should unblock a program 4 1 Lesson 1 Setting Up RTI Shapes Demo The RTI Shapes Demo program s main window looks like this 2 In one of the demo windows create 2 squares publishers red and green and 1 yellow circle publisher all with default QoS settings Here are the steps a U
16. created after RTI Spreadsheet Add in for Microsoft Excel is loaded All the documentation the demonstration workbook and the installer for setting up the add in for the current user can all be accessed from the Windows Start menu under All Programs RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt License Management Your RTI Spreadsheet Add in for Microsoft Excel distribution requires a license file which you will receive via email after you download the software Save the license file in any location of your choice When RTI Spreadsheet Add in for Micro soft Excel starts it will look in these locations until it finds a valid license 1 The file rti_license dat in the directory RTI Spreadsheet Add in for Microsoft Excel lt version gt normally in your My Documents RTI directory 2 The file specified in the environment variable RTI_LICENSE_FILE which you may set to point to the full path of the license file including the filename for example C RTI my_rti_license dat 3 The file rti_license dat in the current working directory 4 The file rti_license dat in the directory specified by the environment variable NDDSHOME As RTI Spreadsheet Add in for Microsoft Excel attempts to locate and read your license file you may depending on the terms of the license see a window with messages with details about your license you may close the window If the license file cannot be found or the license has exp
17. d moving shapes squares circles and triangles To work through the tutorial you need RTI Shapes Demo You can download RTI Shapes Demo from RTI s Downloads page http www rti com downloads To learn how to use it read the RTI Shapes Demo User s Manual included with the RTI Shapes Demo instal lation The tutorial assumes you have the following software installed I RTI Spreadsheet Add in for Microsoft Excel I RTI Shapes Demo This chapter includes the following sections J Lesson 1 Setting Up RTI Shapes Demo Section 4 1 J Lesson 2 Starting the Add in Section 4 2 J Lesson 3 Monitoring Topics Section 4 3 J Lesson 4 Subscribing to Data Section 4 4 J Lesson 5 Publishing Data Section 4 5 J Lesson 6 Monitoring a Domain s Built in Topics Section 4 6 4 1 JOHOINL 7 Chapter 4 4 1 4 2 Lesson 1 Seftting Up RTI Shapes Demo RTI Shapes Demo publishes and subscribes to writes and reads colored moving shapes which are displayed in the demo s window Each shape is a topic the shapes color is the topic s key What are Topics and Keys DDS applications publish write and subscribe to read Topics A Topic has a name and a type the type defines the structure of the data RTI Shapes Demo can publish write and subscribe to read three topics Square Circle and Triangle All three topics use the same data type which includes the shape s color x y coordinates and size A shape s
18. e the information may be obsolete by the time the report is ready To get real time data visualization and analysis you have to invest in expensive custom tool ing often an impractical option at the user or the operator level RTI Spreadsheet Add in for Microsoft Excel is different Your queries formulas and charts aren t part of a static report they operate on live data that is continually updated in real time You can even republish the results of your analysis as it changes making it instantly available to team members and other applications There are no custom appli cations to deploy administer or be trained on all of this happens within the Microsoft Excel application that you know and use already With RTI Spreadsheet Add in for Microsoft Excel application developers can truly enable data centric design and focus on putting the data on the network leaving the visualiza tion aspect to the data consumers Dashboards can be created at deployment time and customized according to the needs of the data consumer QWOIIOM I Chapter 1 1 1 1 2 By leveraging a well known and widely used technology such as Excel you can build alerts correlate multiple streams of real time data process and analyze high volume event streams to uncover opportunities and threats as they happen not after the fact You can easily validate cleanse and enrich real time data and inject data back into the network since RTI Spreadsheet Add in f
19. ence of a network interface 1 See lt install dir gt RTI Shapes Demo lt version gt RTI_Shapes_UsersManual pdf A xipueddy vy To change the current QoS profile to use only shared memory 1 Open the QoS file through the RTI Config dialog or open from My Docu ments RII Spreadsheet Add in for Microsoft Excel lt ver sion gt EXCEL_QOS_PROFILES xml at RTI Add in for Microsoft Excel configuration Click here to Configuration change the Domain ID 0 Boos losis r QoS file QoS library ExcelQosLib QoS profile DefauttProfile Open QoS file Q Start RTI Data Distribution Service Throttle interval Interval ms 200 Create configuration sheet Open configuration file Close 2 Find the lt participant_qos gt section in the QoS file The shipped QoS file contains a QoS library ExcelQoSLib which consists of two QoS profiles DefaultProfile and NoHistoryProfile You will find the lt participant_qos gt in each one of those profiles 3 Change the bold line lt participant qos gt lt transport bai ltin gt lt mask gt MASK DEFAULT lt mask gt lt transport_builtin gt lt participant_qos gt to this A 2 lt participant_qgos gt lt transport_builtin gt lt mask gt SHMEM lt mask gt lt transport_builtin gt lt participant_qos gt 4 Save the file For your changes to take effect you will need to restart Excel A 3 A 4
20. f circle has been deleted A B c D E F 1 2 Host IP 3 192 168 2 3 9 10 2009 3 50 07 37 PM 9 10 2009 3 56 09 17 PM writer with key Circle ShapeType 4 192 168 2 3 9 10 2009 3 50 00 15 PM writer with key Square ShapeType 5 192 168 2 3 9 10 2009 3 51 05 13 PM writer with key Square ShapeType This concludes the tutorial For more information please read the User s Manual 4 16 Appendix A Configuration Changes for Special A 1 A 2 Situations Changing the Domain ID for RTI Shapes Demo RTI Shapes Demo uses domain ID 0 by default To use a different ID start RTI Shapes Demo with the domainId lt gt command line option See Appendix A in the RTI Shapes Demo User s Manual for details on running from the command line Important RTI Spreadsheet Add in for Microsoft Excel must use the same domain ID as RTT Shapes Demo or the two applications will not communicate To change the domain ID in RTI Spreadsheet Add in for Microsoft Excel select h RTI Config Running without an Active Network Interface To use RTI Spreadsheet Add in for Microsoft Excel on a computer that does not have an active network interface change the QoS profile to use only shared memory as described below You can make this change in the default QoS profile or in a new profile For more information on profiles see the User s Manual Another option is to install Microsoft Loopback Adapter which simulates the exist
21. ired RIT Spreadsheet Add in for Microsoft Excel will not initialize and you will not be able to use the add in If you have any questions about license installation please contact support rti com 2 3 The Excel Throttle Interval RTDThrottlelInterval 2 3 The Excel Throttle Interval RTDThrottleInterval This section describes changes that RIT Spreadsheet Add in for Microsoft Excel makes to RTDThrottleInterval in the registry a parameter that determines how fast Excel updates real time data streams By default Excel uses a value of 2 seconds for RTDThrottleInterval The installer for RTI Spreadsheet Add in for Microsoft Excel changes RTDThrottleInterval in the registry to 100 milliseconds This value affects all real time data feeds that you may be using in Excel If you need a different value for RTDThrottleInterval you can change it as follows 1 Open the Windows registry editor e On a Windows Vista system select Start All Programs Accessories Run and enter regedit e Ona Windows XP system select Start Accessories Run and enter regedit 2 Go to the following key HKEY_CURRENT_USER Software Microsoft Office lt your version of Microsoft Office gt Excel Options 3 Look up the entry RTDThrottleInterval and change its value as needed in milli seconds 4 Close the registry editor RTDThrottleInterval is the upper limit for the rate at which all data will be updated in Excel that is it
22. is the smallest update interval This value cannot be changed dynami cally and applies to all data If you want to adjust the throttle interval for updating DDS data only it can be changed after RTI Spreadsheet Add in for Microsoft Excel has been installed To lower the update rate for DDS data in all worksheets set the DDS specific data throttle interval to a value larger than RTDThrottleInterval The maximum rate minimum interval at which DDS data can be automatically pub lished is also limited by RTDThrottleInterval This auto publish rate can also be adjusted after RTI Spreadsheet Add in for Microsoft Excel has been installed See the RTI Spreadsheet Add in for Microsoft Excel User s Manual for details on adjusting the DDS data send and receive rate 1 For example the version number for Microsoft Office 2007 is 12 the version number for Microsoft Office 2003 is 11 2 9 uoHDOIIO SUI Z Chapter 2 2 4 2 6 Uninstalling To remove RTI Spreadsheet Add in for Microsoft Excel use the Control Panel L On a Windows Vista system select Start Control Panel Programs Programs and Features 1 On a Windows XP system select Start Control Panel Add or Remove Pro grams The uninstaller can only be run by a user with administrator privileges and it will remove the current user s add in configuration files You may want to keep a copy of your XML configuration files if you have made any changes to them sin
23. l Download and install RTI Shapes Demo This is only required if you want to follow the steps in Chapter 3 A Quick Demonstration and Chapter 4 Tutorial RTI Shapes Demo is available from RTI s Downloads page http www tti com downloads in the section titled Interactive DDS Demonstration RTI Shapes Demo runs on Windows and Linux systems Follow the installation instructions that accompany the distribution file 1 Even if you belong to the administrator group i e you have administrator privileges the installation will only work for you 2 1 Installing To set up RTI Soreadsheet Add in for Microsoft Excel for other users Initially the add in s installer will only set up the add in for the current user If you want to use the add in as another user including those without administra tor privileges 1 Login as the desired user 2 Make sure you have opened Excel at least once as the current user before setting up the add in This ensures that Excel user profile is properly initialized first 3 From the Start menu select All Programs RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt Install Spreadsheet Add in for this user 4 In the pop up window click OK When the installation is done close the pop up window 5 If you haven t put the required license file in a location that is accessible by the current user you can do so now See License Management Section 2 2 In the lt Insta
24. llation Folder gt the default is C Program Files RTI lt version gt RTI Spreadsheet Add in for Microsoft Excel lt version gt you will find I doc Documentation which is also available from the Start menu e RTI_Spreadsheet_Addin_GettingStarted pdf This document which describes installation a demo and a tutorial e RTI_Spreadsheet_Addin_ReleaseNotes pdf Describes compatibility and known issues e RTI_Spreadsheet_Addin_UsersManual pdf Describes how to use the add in _I lib All the required DLLs a sample Visual Basic script DDS2ExcelModule bas and a copy of the original files that are installed under lt My Documents gt RTI RTI Spreadsheet Add in for Microsoft Excel lt ver sion gt see below In lt My Documents gt RTI RTI Spreadsheet Add in for Microsoft Excel lt version gt you will find L Shapes_Example xls A demonstration workbook described in Chapter 3 A Quick Demonstration 2 3 uoHDOIIO SUI Z Chapter 2 2 2 2 4 I EXCEL_QOS_PROFILES xml The QoS profiles that Excel will load including the default QoS library and profile You can add your own profiles here and select which QoS library and profile to use later in the RTI configuration dialog See the RTI Spreadsheet Add in for Microsoft Excel User s Manual Section 3 1 for details on selecting a QoS library and profile I rti_dds_qos_profiles xsd The RTI schema for the QoS profile file _I RTIExcelAddin log Default log file
25. nder Publishers select Square b In the Create New Publisher dialog select RED and click OK Use the defaults for the other settings You should see a red square moving in the display area c Use the same process to create a green square and a yellow circle Now RTI Shapes Demo is publishing data for two topics Square and Circle There are two instances of the topic Square one for each color The color is the key that identifies the two instances We will refer to this as the Publisher Demo window 74 RTI Data Distribution Service Shapes Demo Domain 0 E File View Publish Subscribe Controls Help Delete All Pause Publishing Hide History DDS Config Name Type Color Partitions Read Take QoS Settings Reliability Triangle Delete All Pause Publishing Hide History DDS Config Name Type Color Partitions Read Take QoS Settings Reliability Square Pub RED oo Default Default True Square Pub GREEN Default Default True Cirde Pub YELLOW sCDefault Default True a 4 3 Chapter 4 4 2 Lesson 2 Starting the Add in 1 Start Microsoft Excel RTI Spreadsheet Add in for Microsoft Excel loads automatically when Excel starts up you should see a brief message about loading RTI Spreadsheet Add in in the status bar at the bottom of the Excel window Note This is when the add in reads your license file You may see a window appear
26. ngs Reliability Square Pub RED Default Default True Square Sub Read Default Default False Cirde Pub YELLOW _ Default Default True Square Pub MAGENTA Default Default True LS Publisher subscriber 8 Now let s see another way to publish data from the worksheet using a timer a From the RTI Spreadsheet Add in toolbar select RTI Config b Set the Auto publish timer in milliseconds to 500 c Click d Click Close In the Subscriber Demo you should now see a cyan square of randomly varying size jumping around on the canvas 4 14 4 6 Lesson 6 Monitoring a Domain s Built in Topics 4 6 Lesson 6 Monitoring a Domain s Built in Topics RTI Data Distribution Service must discover and keep track of remote entities such as new participants in the domain This information may also be important to the applica tion itself which may want to react to this discovery information or else access it on demand To support these needs RTI Data Distribution Service provides built in topics and corresponding built in DataReaders that you can use to access this discovery infor mation With RTI Spreadsheet Add in for Microsoft Excel you can use a built in domain monitor to display built in topics for discovered publications subscriptions and participants We will be creating an Excel worksheet that will monitor all the discovered publications To create a built in domain monitor 1
27. or Microsoft Excel can work both as a subscriber and a publisher Wizards make it simple to create publications and subscriptions using a point and click interface Key Benefits of RTI Spreadsheet Add in for Microsoft Excel l Allows spreadsheets to participate seamlessly as peers on a DDS real time soft ware bus along with applications written in C C Java NET and Ada Com plex Event Processing CEP engines databases and mobile and embedded devices I Supports data injection write back I Provides low latency real time analytics and data visualization I Allows introspection status and health monitoring of RTI Data Distribution Ser vice applications 1 Self contained within an Excel Add in requires no separate service or gateway or custom integration code Available Documentation RTI Spreadsheet Add in for Microsoft Excel documentation includes I Getting Started Guide RTI_Spreadsheet_Addin_GettingStarted pdf High lights the benefits of RTI Spreadsheet Add in for Microsoft Excel and provides installa tion instructions It also walks you through a short demonstration and a tutorial so you can quickly see the benefits of using RTI Spreadsheet Add in for Microsoft Excel L Release Notes RTI_Spreadsheet_Addin_ReleaseNotes pdf Describes system requirements and compatibility as well as any version specific changes and known issues I Users Manual RTI_Spreadsheet_Addin_UsersManual pdf Describes how to
28. ould unblock a program 2 In the RTI Shapes Demo window publish 3 circles purple red and green a Under Publishers select Circle b In the Create New Publisher dialog select PURPLE and click OK Use the defaults for the other settings You should see a purple circle moving in the display area c Use the same process to create a red circle and a green circle Now RTI Shapes Demo is publishing data for one topic called Circle There are three instances of the topic one for each color The color is the key that identifies the different instances of the Topic You should see these three circles moving in the RTI Shapes Demo window 3 In the RTT Shapes Demo window subscribe to triangles a Under Subscribers select Triangle Use the defaults for the other settings b Click OK What s happening so far Notice that you don t see any trian gles in the RTI Shapes Demo window Fle View Bullish Sutescribe Contes Help That s because it is subscribing to tri ae i Fublishers angles but so far we re only publish ye guare ing circles Circle Triangle This is where RTI Spreadsheet Add in for Microsoft Excel comes in It s going to subscribe to circles use the data from those circles to fill in data for trian gles then publish triangles Subscribers Delete All 4 Open Shapes_Example xls from the Start menu under Hide History All Programs RTI RTI S
29. preadsheet Add in for Microsoft Excel lt version gt RTI Spreadsheet Add in for Microsoft Excel should load automatically when Excel starts up Note This is when the add in reads your license file You may see a window appear with license information you may close this window If you see a license related error see Section 2 2 to review where your license file needs to be placed The status bar in Excel will show Loading RTI Spreadsheet Add in for Microsoft Excel lt version gt then change to RTI Spreadsheet Add in for Microsoft Excel lt version gt init O K and finally to Ready when the add in has been loaded To see the RTI Spreadsheet Add In toolbar in Excel 2007 select the Add Ins tab on the Ribbon Or if you are using Excel 2003 right click any Excel toolbar and choose RTI Spreadsheet Add in for Microsoft Excel N Home Insert Fage Layout Formulas Data Review View Add Ins M RT Contig RTI Add Publication 3 RTI Monitor Domain ea RTI Monitor Topic a RTI Publish Now b Start RTI Service amp o RTI Add Subscription RTI Update Now Off Toolbar Commands 3 3 uopsuoweaq e Chapter 3 The worksheet in Shapes_Example xls has three sets of tables and charts You will see errors in the data cells because the add in isn t running yet Inputs gt gt gt Analysis gt gt gt Outputs The table and chart below display the The table and chart below di
30. son setnne Up RI apes DeO ensaia RE 4 2 VE aa aO o E E cae se gn cw caesar A E 4 4 AD Leon I Monitorin TOPIC sosa O S 4 6 44 Lesson4 Subpseribing to iat sos caep seca csar ah acute aueoaden su i i iiis 4 8 A5 Leson a rubiin Dal dessan E S A 4 11 4 6 Lesson 6 Monitoring a Domain s Built in TOpiCS e sesssseeseesesersessrserseesrsresesersersreeesees 4 15 Configuration Changes for Special Situations AL Changing the Domain ID tor RILShapes Dei Ossie rte ennonconeenn nes A 1 A2 Running without an Active Network Interf aC ssessrasninteiiiinsi n A 1 Chapter 1 Welcome to RTI Spreadsheet Add in for Microsoft Excel Welcome to RTI Spreadsheet Add in for Microsoft Excel This revolutionary component of RTI Data Distribution Service allows you to rapidly analyze visualize and respond to your real time data transforming information into intelligent action and ultimately business value This powerful tool leverages ubiquitous Microsoft Excel technology to radically increase the productivity of both analysts and decision makers by decreasing the amount of time and effort that stand between the arrival of information and the actions taken in response to that information Traditionally data analysis involves recording the data post processing it perhaps with hand coded programs and creating static summaries and reports by hand Only then can the data be visualized understood and acted upon Not only is this process slow and expensiv
31. splay statistics The table and chart below display the data values that incoming data values pertaining to the circles pertaining to the incoming data values will be published from this spreadsheet so that they can published by RTI Shapes Demo be viewed from a subscribing RTI Shapes Demo color x y Shi not started ERROR RTI DDS is not std Median x not started ERROR RTI DDS is not sta Min y not started ERROR RTI DDS is not sta window Feel free to add new colors ERROR RTI DDS is not started color x y shapesize YELLOW DIV 0 of DV0 BLUE NUM Oo o0 shapesize DIV 0 NUM 250 200 50 150 100 47 150 4 100 E YELLOW 50 E BLUE a a a EE a _ ar _ 7 0 f T T T 300 3 4 Meanx Median Miny Maxy x Optional not required for most users For DDS applications to communicate they must use the same domain ID Since both RTI Spreadsheet Add in for Microsoft Excel and RTI Shapes Demo use a default domain ID of 0 they are already set up to communicate on domain 0 If you need to use a different domain ID for exam ple if you are running RTI Shapes Demo with a non 0 domain ID because you have other DDS applications already using domain 0 select A RTI Config and change the domain ID an integer value in this dialog then click Close From the RTI Spreadsheet Add In toolbar select RTI Config
32. with license information you may close this window If you see a license related error see Section 2 2 to review where your license file needs to be placed To see the RTI Spreadsheet Add In toolbar select the Add Ins tab on the Ribbon in Excel 2007 Or if you are using Excel 2003 right click any Excel toolbar and choose RTI Spreadsheet Add in for Microsoft Excel 4 4 Home Insert Page Layout Formulas Data Review View Add Ins t RTI Config W RTI Add Publication TE RTI Monitor Domain d RTI Monitor Topic ve RTI Publish Now p Start RTI Service G0 RTI Add Subscription _ RTI Update Now Off 2 Optional not required for most users For DDS applications to communicate they must use the same domain ID Since both RTI Spreadsheet Add in for Microsoft Excel and RTI Shapes Demo use a default domain ID of 0 they re already set up to communicate on domain 0 If you need to use a different domain ID for exam ple maybe you started RTI Shapes Demo with a non 0 domain ID because you have other DDS applications already using domain 0 select RTI Config and change the domain ID an integer value in this dialog then click Close 3 Select p Start RTI Service 4 2 Lesson 2 Starting the Add in After you select Start RTI Service notice that the domain ID is displayed in the RTI Spreadsheet Add in toolbar and the other toolbar commands are enabled RTI Data Distribution Service is running on domain 0 Add Ins
Download Pdf Manuals
Related Search