Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide User Manual Page 341
- Page / 368
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Micro-PWC CONFIGURATION GUIDE
Appendix A - Excel Functions 321
Appendix A Excel Functions
A.1 Introduction
This section describes the functions available with the Micro-PWC software which provide an interface to
the Microsoft Excel spreadsheet package. These functions are for use with Excel only. Experience and/or
training with Excel is assumed; it is beyond the scope of this Guide to document the use of Excel.
In Excel, a function is invoked by writing an = sign, followed by the function name; for example:
=fpudevice()
In Excel, the parentheses must be included, whether or not the call has parameters.
- CONFIGURATION GUIDE 1
- MicroMod Automation, Inc 2
- Table of Contents 3
- List of Figures 15
- List of Tables 20
- 1.0 Introduction 21
- 1.3.1 User Interface 22
- 1.3.3 Hierarchical Displays 22
- 1.3.4 Graphic Configuration 22
- 1.3.5 Historical Database 22
- 1.4 Document Conventions 24
- 1.5 Reference Documents 25
- 8 Introduction 28
- 2.0 System Configuration 29
- 2.2.3 Logging Out 30
- 2.3 Archival Groups 31
- 2.3.2 Edit an Archival Group 32
- TC00152A 33
- 2.4 Message Configuration 34
- 2.5 Alarm Group Configuration 35
- 2.5.2 Add an Alarm Group 36
- TC00567A 37
- TRL key as each 39
- 2.6.1 Alarm Setup 40
- LT-F11 45
- TC00157A 46
- 2.7 Summary - Alarm Setup 48
- 2.8 Alarm Vectors 49
- TC00172A 51
- TC00241A 51
- 2.8.1 Area Name Assignment 52
- TC00159A 53
- TC00160A 54
- 2.8.3 Printer Assignment 55
- TC00569A 56
- TC00163A 59
- 2.8.4 Message Routing 60
- TC00242A 61
- TC00589A 62
- TC00244A 62
- TC00245A 63
- TC00164A 66
- TC00697A 68
- 2.9 Display Colors 69
- 2.10 Security 70
- 2.10.1 Security Activation 71
- 2.10.2 Default Login 71
- TC00570A 72
- TC00167A 72
- 2.10.3 Function Access 74
- System Configuration 55 75
- 2.10.5 User Login 77
- TC00571A 78
- TC00705A 81
- 2.10.6 Change Password 82
- 2.10.7 Auto-Login 83
- 2.10.8 Summary - Security 85
- 3.0 Hierarchical Displays 87
- 3.2.1 Plant Summary Display 88
- 3.2.2 Group Display 89
- 3.2.3 Point Display 90
- 3.3.1 Summary Configuration 91
- 3.3.2 Group Configuration 91
- TC00177A 92
- TC00255A 94
- 3.3.3 Point Displays 95
- 4.0 The Grafx Editor 97
- 4.2 CREATING MODELS 99
- 100 x 75 0, 0 100, 75 103
- 4.2.2 The Toolbars 104
- 4.2.3 The Status Bar 104
- 4.2.4 The Shape Toolbar 104
- TP81044A 113
- NTER key) 114
- NTER to change to that color 120
- erase color = n 122
- HIFT key) will remove it 124
- HIFT key down, click on all 124
- 4.2.7 Point Operations 128
- 4.2.9 The Menu Bar 131
- Figure 4-9. Open Model Window 133
- Save changes to Graphic? 134
- 4.2.10 Using Model Variables 139
- 4.3 Dynamics 140
- Micro-PWC CONFIGURATION GUIDE 142
- 122 Grafx Editor 142
- 2 + 3 * 4 143
- (2 + 3) * 4 143
- Table 4-5. Operator Aliases 144
- Expression(n of m) 145
- Figure 4-13. Blink Window 149
- 4.3.2 Configuring Submodels 151
- ( * (fcolor bar_color)) 154
- Figure 4-17. Variables Window 155
- 159
- $tag10$#d$atom$ 159
- 4.4 Micro-DCI Submodels 165
- 4.4.2 Bargraphs 167
- DIRECTION fill_dir 170
- DIRECTION DIRECTION VALUE 172
- Resulting Pop-up Window 186
- Grafx Editor 173 193
- 4.4.4 Display Vectoring 203
- 4.4.5 Trends 207
- 4.4.6 Hierarchical Displays 213
- 4.4.7 Miscellaneous Displays 216
- + addition 226
- - subtraction 226
- * multiplication 226
- / division 226
- ^ exponentiation 226
- 4.5 Micro-PWC Symbols 229
- Figure 4-88, Item G 230
- Table 4-11. Mixing Equipment 231
- Table 4-14. Filters 232
- Table 4-16. Separators 232
- Table 4-18. HVAC Equipment 233
- Table 4-19. Miscellaneous 233
- 4.5.1 Symbol Illustrations 234
- Grafx Editor 215 235
- 216 Grafx Editor 236
- A. ISA_LFLT 237
- A. ISA_XCHG1 238
- E. ISA_KILN 238
- H. ISA_FNXR 238
- F. ISA_CTWR G. ISA_EVPR 238
- 4.6 Micro-DCI SUBMODELS 239
- 5.0 Historical Database 241
- 5.2.1 Point Information 242
- 5.2.2 Collection Information 242
- TC00198A 243
- Figure 5-5. Data Type Window 244
- TC00579A 245
- TC00202A 246
- TC00203A 247
- TC00204A 248
- TC00205A 248
- 5.2.3 Storage Information 249
- TC00580A 250
- 5.2.4 Convenience Buttons 252
- TC00590A 253
- 5.2.6 Add Historical Database 254
- 6.0 Logs 257
- 6.3 Event Logs 258
- 6.3.2 Edit Event Logs 260
- 6.3.3 Delete Event Logs 260
- 6.3.4 Schedule Event Logs 261
- 6.3.5 Print Event Logs 263
- 6.4 Spreadsheet Logs 264
- 6.4.2 Edit Spreadsheet Logs 265
- 6.4.3 Delete Spreadsheet Logs 265
- 6.4.5 Printing Example 266
- 6.4.6 Print Spreadsheet Logs 266
- 7.0 Trending 269
- ACKSPACE on the keyboard 270
- TC00250A 271
- 7.3.1 Trend Parameters: Title 272
- 7.3.4 Trace Configuration 273
- TC00214A 274
- 7.3.5 Trend Parameters: Type 276
- 7.4 Summary - Trends 277
- 8.0 System Status Display 279
- 8.2.1 Node Name 280
- 8.2.2 Info Menu 280
- TC00536A 281
- TC00537A 281
- 8.3 The Utilities Menu 282
- TC00039A 283
- 8.3.2 Console Groups Display 284
- 9.0 Utilities 287
- 9.2 Database Maintenance 288
- TS00566A 291
- 9.3 CRT Print 293
- 276 Utilities 296
- 9.5 Time Adjustment 297
- 9.6 Other Applications 298
- 9.7 Micro-PWC Help 299
- 9.8 User Help 300
- 9.9 Quick Keys 303
- 9.9.2 Configuring Quick Keys 304
- 9.10 Summary - Quick Keys 305
- 9.11 CRT Context Keys 306
- TC00091A 307
- Figure 9-22. Find Window 313
- 10.1 Introduction 315
- 10.3 Add Historical Block 316
- 10.3.3 Period and Start Time 317
- 10.3.4 Storage Node 318
- 10.3.5 Number Retained 318
- 10.3.7 Tag Atom Assignment 319
- TS00218A 320
- 10.4 Edit Historical Block 321
- 10.5 Copy an Historical Block 321
- 11.1 Introduction 323
- TC00219A 328
- TC00220A 328
- TC00584A 329
- TC00585A 330
- TC00223A 331
- TC00586A 332
- TC00587A 332
- 11.3.3 Format of Time-Stamps 334
- 11.5 Monitoring 338
- Polled MON_POLL (default) 339
- Deadband-percent MON_DEAD_PCT 339
- 11.5.3 Monitor Request Size 340
- Appendix A Excel Functions 341
- The fpget( ) Function 342
- The fpgetd( ) Function 343
- The fphget( ) Function 344
- The fphgetd( ) Function 345
- The fpsendmsg( ) Function 346
- The fpput( ) Function 347
- The fpputd( ) Function 348
- The fphput( ) Function 349
- The fphputd( ) Function 350
- The fparchive( ) Function 351
- The fpverbose( ) Function 352
- The fpuprint( ) Function 353
- The fpudevice( ) Function 354
- The fpblkarch( ) Function 355
- The fpblkclose( ) Function 356
- The fpblkopen( ) Function 357
- The fpblksample( ) Function 358
- The fpblkvald( ) Function 359
- The fphxnumval( ) Function 360
- Cell Address Cell Contents 361
- The fphxgetval( ) Function 362
- Cell Address Cell Contents 363
- The fpxammts( ) Function 364
© 2020, manymanuals.com. All rights reserved. | 0.036 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals