Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manuale Utente Scaricare il pdf (Pagina 155)

9 ● FactoryTalk Historian DataLink Function Reference

●

147

The following puts the value located in the cell A5 into the FactoryTalk

Historian server of the default FactoryTalk Historian server for midnight

today for the tag testtag:

=PIPutVal("testtag",a5,"t",,e5)

The result of the macro function is placed into cell E5 on the macro sheet.

1 2 ... 150 151 152 153 154 155 156 157 158 159 160 ... 163 164

DATALINK USER GUIDE 1
Copyright 2
Contents 3
Chapter 1 9
Introduction 9
About this Document 10
Support 11
System Requirements 12
Installation and Upgrade 12
Upgrade 13
Configuration 13
Microsoft Excel 2010 14
Chapter 2 15
PI Ribbon 16
Function Task Panes 17
PI Menu 19
Function Dialog Boxes 21
Context Menu 22
2 ● Basics 23
Graphic Function Components 25
Standard Arguments 26
Tagname(s) or Expression 27
Start Time 27
End Time 28
PI Server 28
Output Cell 28
Time Arguments 29
Appended Data 30
Appended Data Array 31
Show Timestamps 32
Interval Timestamps 32
Show Percent Good 33
Show Value Attributes 33
Orientation Controls 34
Display Formats 35
Preference Settings 37
Spreadsheet Construction 39
Chapter 3 41
Functions 41
Archive Value 42
Compressed Data 44
Filtered 45
Sampled Data 47
Timed Data 49
Calculated Data 51
Average 52
Interpolated 53
Time Filtered 56
Chapter 4 59
Attributes 59
Tag Search Tips 61
Attribute Mask to Tag 63
Tag Attributes 64
Chapter 5 65
Module Database Objects 65
Module Database Browse 66
5 ● Module Database Objects 67
Alias to Tag 69
Property to Value 69
 Property 70
 Module Path 70
 Query Date 70
Chapter 6 71
Spreadsheets 71
Triggered Recalculation 72
Manual Recalculation 73
Functions and Array Values 74
Array Management 75
Update Arguments 76
Resize Arrays 77
Share Spreadsheets 78
6 ● Spreadsheets 79
Chapter 7 81
Trend Displays 81
Create a Trend 82
Worksheet Data 83
FactoryTalk Historian Data 84
Manage Traces 85
Specify the Time Range 86
Title and Placement 87
7 ● Trend Displays 89
Chapter 8 91
Supplementary Information 91
Firewall Database 92
FactoryTalk Historian Trusts 93
Point Access Permissions 93
FactoryTalk Historian Time 94
Time Syntax Examples 96
Time Interval Examples 97
Operators 99
Math Functions 102
Aggregate Functions 103
Miscellaneous Functions 103
Point Attributes 105
Time Functions 106
String Conversion 108
Manual Function Entry 109
Use Array Functions 110
Mathematical Functions 110
String Arguments 111
Cell References 111
PIServer Argument 111
Outcodes 112
Example: 113
Troubleshooting 114
Array and Cell Limits 115
Row Limitations 115
Security 116
, shipped with the 117
Chapter 9 119
Function Reference 119
PIArcVal() 120
PIExpVal() 121
Multiple Value Functions 122
PINCompFilDat() 123
PICompDat() 124
PICompFilDat() 125
PISampDat() 126
PISampFilDat() 127
Arguments 128
Returns 128
PIExpDat() 129
PITimeDat() 130
PITimeExpDat() 131
Calculation Functions 132
PIAdvCalcVal() 134
PIAdvCalcFilVal() 135
PIAdvCalcExpVal() 137
PIAdvCalcExpFilVal() 138
PICalcDat() 140
PIAdvCalcDat() 141
PIAdvCalcFilDat() 142
PIAdvCalcExpDat() 144
PIAdvCalcExpFilDat() 145
PITimeFilter() 147
PITimeFilterVal() 148
Tag Functions 149
PIAttributeMaskToTag () 150
PITagAtt() 151
Module Database Functions 152
PIPropertyToValue() 153
Input Functions 154
Chapter 10 157
Worldwide Support 158
Training Programs 158
Consulting Services 158
TechConnect Support 158
Worksheet Data • 75 164
Worldwide Support • 150 164

Commenti su questo manuale

Nessun commento

Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manuale Utente Pagina 155

Commenti su questo manuale

Prodotti e manuali riguardandi Apparecchiature Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide