Skip to main content
InSource Solutions

TN HistClient133 Using The Historian Client Analog Tag Analysis In Excel

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

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.

step 1.jpg

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

step 2.jpg step 3.jpgstep 4.jpgstep 5.jpgstep_6.jpg

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:

report done.jpg