Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 223)

Chapter 7
Advanced Reporting Topics
The Excel Add-in allows you to retrieve RSBizWare data (general
reporting or grid data, and time-series data) directly in Microsoft
Excel. After the RSBizWare data has been imported into Excel, you
can use any of Excel’s analysis, charting, or scripting features to
further process the data.
When you install the RSBizWare software on a computer, a custom
RSBizWare toolbar is added to Microsoft Excel. The toolbar allows
you to perform the tasks necessary to retrieve the RSBizWare data.
To specify the Excel and Information Services Manager
connectivity settings:
1. On the RSBizWare toolbar, click to display the
RSBizWare Connectivity Settings dialog box.
2. Type the name of the Information Services Manager to which
your Excel workbook will connect.
3. Type the port number that you want to use for RSBizWare
HTTP communications. The default number is 8080.
NOTE
Please contact your RSBizWare administrator for the specific port
number that you should use.
The Excel Add-in
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 223