Campbell-scientific LoggerNet Datalogger Support Software Uživatelský manuál Strana 574
- Strana / 580
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Appendix G. Importing Files into Excel
([Year]–1900)*365+1+Int(([Year] –1901)/4)+[Day]+Int([HHMM]/100)/
24+([HHMM]/100-Int([HHMM]/100))*100/60/24+[Sec]/60/60/24
Section of formula:
Results:
[Year]–1900)*365+1+Int(([Year]-
1901/4
Delivers the number of days since the beginning of
the 20
th
century through the end of last year taking
into account leap years
+[Day]
Adds the Julian date to the above
+Int([HHMM]/100/24
Converts the hour portion of the HHMM time field
to a fraction of a day
+([HHMM]/100-
Int([HHMM]/100))*100/60/24
Converts the minutes portion of the HHMM time
field to a fraction of a day
+[Sec]/60/60/24
Converts the seconds field in to a fraction of a day
Once you have entered the formula for one cell you can apply it to multiple
cells using Excel’s Fill function. Selecting the cells and using Format Cells
can set the display format of the timestamp.
G.2 Table-Based Data File Import
Step 1 of 3
Select the Delimited option from the Original Data Type group box. Using the
arrow buttons to the right of the Start Import at Row field, select the number of
the first row of data to be imported. If your data file has headers included, you
can import those or start the import at the first row of data (typically row 3).
Select the Next button.
G-4
- INSTRUCTION MANUAL 1
- License for Use 3
- Limited Warranty 4
- Table of Contents 5
- Product History 19
- LoggerNet Products 22
- Setup Screen 23
- Connect Screen 24
- Status Monitor 24
- Task Master 24
- Short Cut 25
- CRBasic Editor 25
- View Pro 27
- 1.1 Hardware and Software 31
- Backup Procedures 33
- 2.2 Upgrade Notes 34
- 2.3.1.1 Program Directory 35
- 2.3.1.2 Working Directories 35
- 2.3.4 Program Crashes 40
- 2.4.1.1 Write Access 41
- 2.4.1.2 Network Drives 42
- Section 3. Introduction 45
- 3.2.1.1 Toolbar Views 46
- 3.2.1.2 Favorites Category 47
- 3.2.1.3 Toolbar Menus 48
- 3.2.4 Real Time Tools 51
- 3.2.11.1 LoggerNetData 54
- 3.2.11.3 Baler 55
- Networks 57
- 4.2.4 Device Settings 63
- 4.2.4.4 Datalogger 67
- 4.2.4.5 PhoneBase 79
- 4.2.4.6 PhoneRemote 80
- 4.2.4.7 RFBase 81
- 4.2.4.8 RFRemote 82
- 4.2.4.9 RFBase-TD 83
- 4.2.4.10 RF RemoteTD 87
- 4.2.4.11 RFRemote-PB 87
- 4.2.4.12 MD9 Base 88
- 4.2.4.13 MD9 Remote 90
- 4.2.4.14 RF400 91
- 4.2.4.15 RF400 Remote 92
- 4.2.4.16 Generic Modem 94
- 4.2.4.17 PakBusPort 95
- 4.2.4.18 PakBus Router 98
- 4.2.4.19 PakBusPort HD 99
- 4.2.4.20 PakBusTcpServer 100
- 4.2.4.21 SerialPortPool 102
- 4.2.4.22 TerminalPortPool 105
- 4.2.5.2 Intervals 109
- 4.2.6 Setting the Clock 112
- 4.2.8 Setup’s Tools Menu 113
- 4.2.9 Setup’s Backup Menu 116
- 4.2.11 Selecting a View 116
- 4.3 Network Planner 118
- 4.3.5 Adding Stations Links 122
- 4.3.6 Adding Activities 124
- 4.3.7 The Station Summary 127
- 4.3.8 Configuring Devices 128
- 4.3.9 Saving Your Work 134
- Section 5. Real-Time Tools 137
- 5.1.2 Data Collection 139
- 5.1.2.2 Custom Collection 140
- 5.1.3 Ports and Flags 144
- 5.1.4 Datalogger Clock 146
- 5.1.5 Program Management 147
- 5.1.6 Program Association 148
- 5.1.7 Data Displays 149
- 5.1.8 Table Monitor 164
- 5.1.10 Terminal Emulator 169
- 5.1.11 Station Status 170
- 5.1.12 Calibration Wizard 171
- 5.2.1 Development Mode 172
- 5.2.1.1 The RTMC Workspace 173
- 5.2.1.2 Display Components 174
- 5.2.1.4 Expressions 180
- FromNewest(5,Order 181
- AvgRunOverTimeWithReset 188
- MaxRunOverTimeWithReset 188
- MinRunOverTimeWithReset 188
- 5.2.2 RTMC Run-Time 189
- 6.1 Status Monitor 191
- 6.1.2.1 Selecting Columns 193
- 6.1.2.2 Display/Subnet 198
- 6.1.2.4 Reset Device 198
- 6.1.2.6 Pool Statistics 199
- 6.1.2.7 Pool Devices 200
- 6.1.2.8 State of Operations 200
- 6.2 LogTool 202
- 6.2.1 Log Types 203
- 6.2.2 Using LogTool 203
- 6.2.3 Saving Logs to File 204
- 6.3 Comm Test 205
- 6.4 PakBus Graph 206
- 6.5 Troubleshooter 208
- 6.5.1 Status Information 209
- 6.5.2 Buttons 210
- 6.5.3 TD-RF Test 210
- TD-RF QUALITY REPORT 215
- 6.5.3.3 Advanced Features 216
- Datalogger Programs 219
- 7.2 Short Cut 220
- Datalogger 235
- 7.2.3 Short Cut Settings 236
- 7.2.3.5 Sensor Support 237
- 7.2.3.6 Integration 238
- 7.2.3.7 Font 238
- 7.3 CRBasic Editor 239
- 7.3.3 Toolbar 243
- 7.3.3.1 Compile 245
- 7.3.3.4 Templates 249
- 7.3.4 CRBasic Programming 258
- If TCTemp(1) > 100 Then 260
- Call Subroutine1 260
- End If 260
- 7.3.4.5 Line Continuation 261
- 7.3.4.7 Example Program 262
- 7.3.4.8 Data Tables 262
- 7.3.4.10 Numerical Entries 265
- 7.3.4.12 Flags 267
- 7.3.4.13 Parameter Types 267
- 7.4 Edlog 269
- 7.4.1.6 Expression Compiler 270
- 7.4.2.1 Program Structure 272
- 7.4.2.2 Edlog File Types 273
- 7.4.2.5 Program Comments 275
- 7.4.2.6 Expressions 276
- 7.4.3 Library Files 283
- 7.4.5 Display Options 284
- 7.4.6 Input Locations 285
- 7.4.8 Repetitions 286
- 7.4.9 Input Location Editor 287
- 7.4.11 Final Storage Labels 289
- 7.4.13 Program Security 291
- 7.4.15 DLD File Labels 292
- 7.4.14 Final Storage Area 2 292
- 7.4.18 PakBus Settings 294
- 7.5 Transformer Utility 295
- 7.5.2 Controls 297
- 8.1 View Pro 299
- 8.1.2 The Toolbar 300
- 8.1.3 Opening a File 302
- 8.1.5 Importing a CSV File 306
- 8.1.6 Data View 309
- 8.1.7 Graphs 311
- 8.1.7.1 Line Graph 313
- 8.1.7.2 Histogram 317
- 8.1.7.3 XY Plot 320
- 8.1.7.4 Rainflow Histogram 322
- 8.1.7.5 FFT 325
- 8.1.8 Right-click-Menus 328
- 8.1.9 Printing Options 330
- 8.2 Split 331
- 8.2.2 Getting Started 332
- 8.2.3.1 Input Files 338
- become accessible. Enter 340
- Examples: 362
- 8.2.3.2 Output Files 372
- 8.2.4 Help Option 378
- 8.2.5 Editing Commands 379
- 8.3 CardConvert 384
- 8.3.2.1 File Format 386
- 8.3.2.2 File Processing 386
- 8.3.2.3 File Naming 387
- 8.3.3 Converting the File 388
- 9.1 Task Master 391
- 9.1.1 Setup Tab 392
- 9.1.1.2 Logger Event Tasks 393
- 9.1.2 Status Tab 404
- 9.1.4 Task Master Logs 406
- LoggerNet 407
- 10.1.4 Terminal Tab 411
- 10.1.6 Off-line Mode 412
- 10.2 CoraScript 413
- 10.2.2.4 Hole Management 415
- 10.3 RWIS Administrator 416
- 10.3.3.2 Schedule Settings 419
- 10.3.3.3 Snapshots Settings 421
- 10.3.3.4 Clock Settings 422
- 10.3.4 Deleting a Station 424
- 10.4 File Format Convert 425
- 10.4.2 Options 426
- 10.5 Toa_to_tob1 428
- 11.1 Security Manager 429
- Adding an Account 430
- 11.2 Hole Monitor 433
- 11.2.2 Message Log 435
- 11.3 Data Filer 436
- 11.3.2.2 Collection Options 437
- 11.3.3 The Collected Data 439
- 11.4 Data Export 440
- 11.4.2 Theory of Operation 442
- Available for LoggerNet 451
- 12.3 RTMC Run-Time 452
- 12.4 RTMC Pro 452
- 12.5 LNDB 452
- 12.6 Baler 452
- 12.7 CSIOPC Server (PC-OPC) 453
- Communications Links 455
- 13.1.2.3 RF Address 456
- 13.1.2.4 Max Time Online 456
- 13.2 Phone to MD9 457
- 13.2.2.2 MD9 Addresses 458
- 13.2.2.4 Max Time Online 458
- 13.3 TCP/IP to RF 459
- Third-Party 460
- Serial Server 460
- Campbell Scientific 460
- RF Network Base 460
- 14.1 What’s Changed? 463
- 14.2.2 Socket Errors 464
- Attenuation Pads 474
- (10 - 20 dB) 474
- Programmable 474
- Formats 495
- B.1.2 ASCII Printable 496
- B.1.3 TOACI1 496
- B.1.3.1 Field Name Suffixes 497
- B.1.4 TOA5 498
- B.1.5 TOB1 498
- B.1.6 Array Compatible CSV 500
- B.1.7 CSIXML 500
- B.1.7.2 File Syntax 502
- B.1.7.3 The csixml Element 504
- B.1.7.4 File Example 506
- B.1.8 CSIJSON 508
- B.1.8.2 File Syntax 509
- B.1.8.3 File Example 512
- B.2 Datalogger Data Formats 513
- B.3 Binary Data Value Types 515
- B.4.1 Split 516
- B.4.2 View Pro 516
- B.4.3 CardConvert 516
- B.4.4 File Format Convert 516
- B.5 RTMS Format Description 517
- CR200, and CR9000 519
- Programs and Data Storage 520
- C.3 Table Data Overview 523
- C.4 Default Tables 524
- D.2.1 Organization 529
- D.2.2 Operation 529
- D.3 Directory Organization 531
- (Program File Directory) 532
- Appendix E. Log Files 533
- E.1.2 Enabling Log Files 534
- E.2 CQR Log (RF Link) 554
- F.1 Calibration Essentials 555
- F.3.1 Zeroing 557
- F.3.2 Offset Calibration 558
- Control 559
- Calibration 560
- Programs 562
- and press Next 563
- Step 1 of 3 571
- Step 2 of 3 572
- Step 3 of 3 573
Související produkty a manuály pro Software Campbell-scientific LoggerNet Datalogger Support Software
Software Campbell-scientific PONDVIEW Real-Time Monitoring & Control Softwa Uživatelský manuál
(38 stránky)
(38 stránky)
Software Campbell-scientific RTDM Real-Time Data Monitoring Software Uživatelský manuál
(22 stránky)
(22 stránky)
Software Campbell-scientific RTMC Pro Real-Time Monitor and Control Professiona Uživatelský manuál
(76 stránky)
(76 stránky)
Software Campbell-scientific Software Development Kit Beginner's Guide Uživatelský manuál
(22 stránky)
(22 stránky)
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.068 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce