Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manual de usuario Pagina 127
- Pagina / 164
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
9 ● FactoryTalk Historian DataLink Function Reference
●
●
●
●
●
119
Argument
Value
etime (string)
The end time for the range (in FactoryTalk Historian time format).
interval (string)
The interval between sampled values (in FactoryTalk Historian time
format).
outcode (integer)
An output code, either 0, 1, 2, or 3.
PIServer (string)
The target FactoryTalk Historian server.
Returns
Outcode
Sampled Value
Time stamp
0
output cell
none
1
right column
output cell
2
output cell
none
3
row below
output cell
An output code (page 104) of 2 transposes the output array that results
from an output code of 0. An output code of 3 transposes the output array
that results from an output code of 1.
Example:
The following retrieves sampled data for the tag located in cell B1, from
midnight yesterday to midnight today at 3-hour intervals:
=PISampDat(b1,"y","t","3h",1,)
Time stamps are also returned.
PISampFilDat()
Retrieves filtered, sampled FactoryTalk Historian point values
corresponding to a specified time range, using the following syntax:
PISampFilDat(tagname, stime, etime, interval, filtexp,
filtcode, outcode, PI Server)
- 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
Relacionado con productos y manuales para Equipo Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide
Equipo Rockwell-automation Liqui-Flo 1.5 General Purpose and Vector Duty Manual de usuario
(170 paginas)
(170 paginas)
Equipo Rockwell-automation 20D PowerFlex 700S/700H Drives, Frames 10...14 NEM Manual de usuario
(12 paginas)
(12 paginas)
Equipo Rockwell-automation 2094-xxxx Kinetix 6000 and Kinetix 6200/6500 Drive Manual de usuario
(120 paginas)
(120 paginas)
Equipo Rockwell-automation 36С47 DC Drive Output Contactor Kit 300-500HP Manual de usuario
(8 paginas)
(8 paginas)
Equipo Rockwell-automation CEP7-EGJ CEP7 Ground Fault/Jam Accessory Module Manual de usuario
(8 paginas)
(8 paginas)
Equipo Rockwell-automation SB3000 High Pwr SB3000 AC Pwr Modules (RCS) Manual de usuario
(86 paginas)
(86 paginas)
Equipo Rockwell-automation WebPak 3000 ControlNet Communications Board I/O w Manual de usuario
(8 paginas)
(8 paginas)
Equipo Rockwell-automation T6050 SurgeGard Incipient Surge-Conditioning Modul Manual de usuario
(44 paginas)
(44 paginas)
Equipo Rockwell-automation MaxPak Plus Low HP Non RG Bus Bar Support Kit 23C3 Manual de usuario
(2 paginas)
(2 paginas)
Equipo Rockwell-automation T3833 ICS Regent Math Package for Winterpret Manual de usuario
(26 paginas)
(26 paginas)
Equipo Rockwell-automation RDD-B2153 Rotary Direct Drive Bearingless Motors Manual de usuario
(24 paginas)
(24 paginas)
Equipo Rockwell-automation MDF-SBxxxx Kinetix 6000M Integrated Drive Motor In Manual de usuario
(24 paginas)
(24 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.146 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales