TN HistClient133 Using The Historian Client Analog Tag Analysis In Excel

Description

This article from InSource shows how to quickly and easily take advantage of some pre-built reporting capability in the Historian Client's Excel plug in called the tag analysis. There are 6 different types of tag analysis' built in (analog, batch, scatter, discrete, analog value at discrete transition, and analog-discrete pair). This article will illustrate how to build and manipulate the analog tag analysis.

• Author: Lewis Talley
• Published: 03/10/2017
• Applies to: Historian Client (Excel plug in)

Details

The Excel plug in is a very powerful tool for using the capability of the Historian Client directly from Excel. When Excel is present (or the add-in is manually added) when the Historian Client is installed, there is a new ribbon menu added as shown: The "Tag Analysis" button allows us to access the analog tag analysis feature.

Clicking on "Tag Analysis" will go into a 5 step wizard as shown:

Below you will see the report. Most people do not realize that you can change the values (of the range for instance), and the report will update automatically: