How do I build history report from DeltaV (PI as historican database)?

You must use the report generator that is sold with deltaV, since it is a screwed up version of PI, or buy PI-to-PI, setup a real PI server and use excel datalink to extract the values.

I know that the PI server soluti>

A couple of questions. Is this a new installation of 7.3 or was it upgraded from a prior version?

With the older versions, one license for PI DataLink was included with the system. I believe that 7.3 also includes one license for PI Datalink as well. This is the best way to pull data out of the PI system for reports, etc.

While the PI Datalink is not included on the CDs, it may be downloaded from the Foundation Support Site.

DeltaV 7.4 has the new DeltaV Advanced Historian. A excel addin is provided to pull the data from the historian as well.

If you have trouble, your local rep office should be able to help.

I try to use excel-addin from deltaV. I wrote in excel : =DVread(@MOD@/AI1/PV.CV) and get the real time value of the poit. After that I build small VBA or macro for excel, the folowing sub is a macro in excel.

sub histOnExcel() Dim ROW,COL as integer ROW = Range("K1").Value ROW = ROW + 1 COL = 1 ' COL can be an index if we got more then one point. Cells(ROW,COL).Value = Cells(5,COL) Cells(1,11).Value = ROW ' Cell "K1" keep the value of the row end sub The problem is that I don't know how I make it run evry minute so I collect data.

If you there have any suggestion pleas send a reaply

Thanx Shai

Try this:

Sub AutoRun() Static pttimeSet As Double

pttimeSet = Now + TimeValue("00:01:00") Application.OnTime pttimeSet, "Sheet1.mainCodeSub"

End Sub

Sub mainCodeSub() ... put your code here... AutoRun ' Runs the scheduler again End Sub

The autorun sub starts when the worksheet is opened. It schedules the main code to run in one minute. The main code macro runs on schedule and then calls the autorun command to reschedule itself after one minute.

Hope this helps.

I'll have to look at my plugin when I get to work on Monday. I tend to use @now and PI archived value from the PI menu In a column vertically below the @now, I subtract time to get historical times at set intervals, or use PI to select timed or # of responses.

This format will update everytime any cell >I try to use excel-addin from deltaV.

Hello Shai,

I would think the easiest way would be to use OSI's Excel add-in, but you can take a look at our iManageData software. It enables you to extract a series of PI tags over a specified date/time start/stop (or number of rows), then visually inspect the data (trends, scatters, histograms, etc.), filter it and export it to a delimited text file so you can import it into Excel. Info here:

presently offer a free 30 day license for evaluation Note that the client machine must have PI API licensed from OSI and installed.

May I ask why?

Private replies are welcome at cmcook@ the domain below.

Carl Cook BioComp Systems, Inc.