E The PI DataLink (Legacy) ges such as ActiveX, at ha
nou security sks Active controls can have unrestricted access to your
‘computer and therefore can acces your local le ystem and change your
‘operating-system-registy settings. Ia hacker ures an ActiveX take
our computer the damage cane significant
To activate an application add-in, you must have administrator privileges onthe
computer, yo are not an administrator, right-click Excel exe in Windows Explore
nd then click Ron as administrator to nun Microsoft Excel san administrator.
‘To ativat an application add-in you must have administrator privi
puter Ifyou are not an administra
and
=
N
PA DataLink supports only the default 1900 date system supported by ExeL PI DaaLink
oes ot suppor els 1904 date system, and returns incorrect time stamp if th
PA DataLink inserts thelist of root paths in column ALL ofyour worksheet If that
cour contains data, PEDataLnk insert the paths inthe next availabe column to
Tp
Function arrays are particularly useful when the function results chan
frequently. However, faction array recalalation, which ocurs each tine you
open a worksheet, can be low. By contras values are useful when you donot
ect results to change and do not want to walt for function array realeation.
Note
P¥DataLink inserts the ist of root paths In column ALL of your worksheet. that
«column contains data PIDataink insert the paths inthe next availabe column the
rit
. sun . _
| 11
Te
To ind events with amore specific relationship this time period, such a events
that started or ended during this time period expand More search options and
Sao Se
Note:
{Datalink does not synchronize selections inthis win
splay lst in the task pane. In this winds
valable or selected in he column tin the
“tribute more than once tothe column it in he task pane
ve withthe Columns to
yon can select an attribute already
sk pane; doing so adds the same
Tp
Y To find events with amore specific relationship to this time period, such a events
(hat started or ended during this time period expand More earch options and
sk ative method from the Search mode ist
Tp
To find events with amore specie relationship this time period, such as events
that started or ended during this time period expand More search options an
sect an alternative red from the Search mode st
Erdine
Fossett)
Foot)
Phase
Forexanpleityouright click the Event name tribute (the Event
‘tent PI Dataliningets the Even name attribute (the Event
Evene
Mara Fo rig lie Ever name atte
and Cle nt P Datalink inert the leva
state (ie Eventnane atu of te grandparen even,
net ons
ret nm
Tr
To ind events with amore specie relationship to this time period such as events
at started oF ended during this tine period expand More search options and
mative method from the Search mode ist
28-Aug-1220:40:38
+ PI Data Archive server name he data em sal pin
Ponkithe data tem Pl pain onthe ea Data Archive serve.
‘One or nore P poi mes or PLA atte name, for wih he iin,
See Expresion ee
Retum the vale that act matches or precedes the pcg tne
Returns the interpolated vale atthe speci ime
Values store in the archive ofPI Data Archive undergo a compresion algorithm that
removes al values that represent the same slope. Vales stored in the PI Data Archive
snapshot have not undergone his compression algorithm. Ifyou specify the current time
inthe time period ofthe Compressed Data function the function retrieves a snapsh
value for that time. That sapahot vale might nat be subsequent stored inthe achive
due to compresion
dat Data
Solares hanthe renting Ann ary, Pl Datainkpstesthe fon
PLDataLink shows vale attribut
rer avalos anti nit Fr ample, enter 1 (15 rest tuna
Retumsimepolatd va respondo specified tine stamps. F
Solares hanthe renting Ann ary, Pl Datainkpstesthe fon
a anat did move at min st
anata and ick) J atte rom it
ces al fiction input
And. On aa ARPA seve corte
anatibute ant 4]
a amater
an at ak (Sg) o eve e aut
categories, description vom ant pipa
eit ean Datalink coule daa
rango dove and othe ight ofthe utp cel as ect o ete
‘You must move or lear an entire function array, inching al els otherwise PL
DataLin returns an error message: You cannot change part of an array
the frequency of updates when Automate Update isnt in use, check your
Excel calculation preferences to ensure that both the worksheet and application are set
‘tomatic rather than Manual calculation, Keep in mind that this might impact
ESTI
0000-00 (min) on the 25th of he caret month
0000-00 (night) om the cure dae
0000.00 (mini)
| Jl
Oucode = ya!
Note:
Function support different bits and therefore OutCode argument values. Those valid for
‘one function are not necessarily vali for another function See the Function reference for
the it tat ach funcion support in ts Out Code specification
Ian OutCode argument specifies th display multiple columns or rows but the
‘worksheet does not how lem it. he funcion aay and choose Recleulate/
Resize to revit the function array
put ota
Note:
‘Traces ar dren in By default trend also includes colr-bind
even spaced along a trace and donot indicate archived data point
into PI points mi
netions in Pt Datank
Note:
Ifthe Copy PI Data Archive name setting (see ) isenabled
FI Datalink also coples the corresponding Pl Data Archive server name
‘The fiction cannot esoh perty objectinto Pl pont without a modak
path The path ‘point
You must hay an acount on atleast one PI AF serve
subscribed to at least one notifica
rule to receive noifctions
For software version requirements g to the
and ik the PI Databink product lik to
see Information about PI DataLink, including the eurent system requirements.
further information on PI Notations, see the P
sapins
Note
Include the Acmnowledge coli to add nk the workshetto acknowlch
receipt of antification, and include the Ackrowedge With Comment column to add a
link nh worksheet to make a comment on anotiaton
stat ine mr
that coral P pol ames or LA
The tho the ata kam Se Data.
‘which values to retrieve near STine or ETime
re la Se ioe ptt
The nd ofthe tie perio for wich he a
west tervals When he xp
responding values See Filter
m EN
Expression
Swing The sanping method he un
aan expression
evaluate Expression an FE.
FAL Exp lSampde ist o interpolated. Entera va
An un For exalt 10 (0 mines toren
an nterpalaad vale for every Laie interval See Tie
2ifaconrsontatr inet meded For tine weight ta
‘alert the ever deft ine (tf 29)
‘Nini, maxima or range)
The run that be men erahansExpresshon if
Same nut nterpolated. ava se te
taut For example eto 26m (0 tes) etna
Umit that pees te Jero the neral For xa
ARLES Sampode ie to interpolated. Ener val
ab tine un Por example, et 1 (LO mints) to rem.
The patho the dae reference he expression See
Descriptor Sing Descriptor from pin
Engunits s Engineering to retro pin
Nodulebath
Noter
Inthe current version PI Dataink there ie no difference between the PIPUtVal
function andthe PIPutValX function. In PI Datalink versions sale than PI Datalink
2013, the PIPutval function only supported thre traditional PI point types real
integer, and digital In hose versions ofl Datalink the PIPvtVaXx funtion added
suppor for string points and subaecond time stampa.