Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manuel d'utilisateur Page 138
- Page / 164
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
●
●
●
●
●
FactoryTalk Historian DataLink User Guide
130
Returns
See specific information for PICalcVal() outcodes (page 124).
Example:
The following calculates a time-weighted total for the expression
'cdf144'+'cdt158' from yesterday to today from the default
FactoryTalk Historian server:
=PIAdvCalcExpVal("'cdf144'+'cdt158'","y","t","total","time-
weighted","compressed","10m",50,1,4,)
The result is multiplied by 1. Since compressed is the specified sampling
mode, the sampling frequency is ignored and the expression will be
sampled at the combined compressed events of cdf144 and cdt158.
The minpctgood is 50 percent so result will only be displayed if
percent good is 50 percent or greater. The percent good is returned next to
the total.
PIAdvCalcExpFilVal()
Retrieves a filtered, calculated FactoryTalk Historian point value based on
an expression, using the following syntax:
PIAdvCalcExpFilVal(expression, stime, etime, filtexp, mode,
calcbasis, sampmode, sampfreq, minpctgood, cfactor, outcode,
PIServer)
Arguments
Argument
Explanation
expression (string)
A FactoryTalk Historian calculation expression.
stime (string)
The start time for the range of calculation (in FactoryTalk Historian
time format).
etime (string)
The end time (in FactoryTalk Historian time format).
filtexp (string)
The filter expression used to filter results.
- 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
Produits connexes et manuels pour Équipement Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide
Équipement Rockwell-automation MaxPak Plus NRG 50-100mV Arm Shunt Kit Manuel d'utilisateur
(4 pages)
(4 pages)
Équipement Rockwell-automation MaxPak Plus Fan Loss Detector Kit 23C80 Manuel d'utilisateur
(4 pages)
(4 pages)
Équipement Rockwell-automation Liqui-Flo 1.5 General Purpose and Vector Duty Manuel d'utilisateur
(170 pages)
(170 pages)
Équipement Rockwell-automation T813X Trusted Processor Interface Adaptor Manuel d'utilisateur
(16 pages)
(16 pages)
Équipement Rockwell-automation 2094-xxxx Kinetix 6000 and Kinetix 6200/6500 Drive Manuel d'utilisateur
(120 pages)
(120 pages)
Équipement Rockwell-automation 36С47 DC Drive Output Contactor Kit 300-500HP Manuel d'utilisateur
(8 pages)
(8 pages)
Équipement Rockwell-automation CEP7-EGJ CEP7 Ground Fault/Jam Accessory Module Manuel d'utilisateur
(8 pages)
(8 pages)
Équipement Rockwell-automation SB3000 High Pwr SB3000 AC Pwr Modules (RCS) Manuel d'utilisateur
(86 pages)
(86 pages)
Équipement Rockwell-automation T3833 ICS Regent Math Package for Winterpret Manuel d'utilisateur
(26 pages)
(26 pages)
Équipement Rockwell-automation RDD-B2153 Rotary Direct Drive Bearingless Motors Manuel d'utilisateur
(24 pages)
(24 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.043 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels