51
Mathematical Functions
Fig. 6.5:
Graphical log file analysis in Excel
6.3.1 Data Format Example for a Logging File
Rohde&Schwarz HMC8012 -Log-File
Date: 2016-02-08
Start Time: 00:02:53
Stop Time: 00:03:11
Measurement Settings:
#ADC Rate: Fast
#AC Filter: ------
#Input Imp.: 10M
Logging Settings:
#Mode;Unlimited
#Logging Interval[s];1.000
#Specified Logging Count ------
#Specified Logging Time[s] -----
Actual Count: 16
„DCV[V];ACV[V];Flag;Timestamp“
0,031153;0,004516; ;00:02:53:974
0,000214;0,002502; ;00:02:54:974
0,000204;0,002228; ;00:02:55:974
0,020851;0,122963; ;00:02:57:974
0,051176;0,012153; ;00:02:58:974
0,083483;0,002853; ;00:02:59:974
0,115823;0,002878; ;00:03:00:974
0,148169;0,003076; ;00:03:01:974
0,180527;0,003302; ;00:03:02:974
0,219315;0,003569; ;00:03:03:974
0,251651;0,0038; ;00:03:04:974
0,284003;0,004036; ;00:03:05:974
0,316325;0,004269; ;00:03:06:974
0,348678;0,004499; ;00:03:07:974
0,381028;0,004725; ;00:03:08:974
0,413363;0,00495; ;00:03:09:974
6.3.2 Example Calculation of the Logging Time
The following calculation refers to the logging of DCV
values with a maximum sampling rate of 200Sa/s and a
4GByte USB stick.
If the instrument shows „OVER RANGE“ on the display, „clipped“
will be saved as Flag in the CSV file.
❙ The file header includes 374 byte.
❙
One logging line includes 26 byte.
❙
An empty 4GB USB stick has a capacity of approx.
3.72GB.
In this case you can log 153858348 measurement values
max. If the time interval is set to 5ms, you will log 769291s
= approx. 8 days, 41 minutes, 31 seconds.
6.3.3 Data Formatting in Excel/Import Wizard
If a CSV log file is opened with Excel, the measurement
data is displayed correctly. However, we recommend that
you change the formatting of the time stamp (Timestamp)
manually. After opening the CSV file, the formatting of
the time stamp can be adjusted by first selecting the time
stamp values and then clicking the right mouse button for
“Format Cells”. Then, using the “User Defined” function,
the formatting can be configured manually with the key
-
board in the “type” section as follows:
hh:mm:ss,000
Gaps in the logging may occur under the following circumstances:
❙ High load caused by SCPI commands over the interface
❙ Use of a “slow” USB flash drive
❙ Sector in file system is sized too large
Fig. 6.6: Excel Import Wizard (Text Import Wizard)
Summary of Contents for HMC8012
Page 34: ...34 Anhang ...
Page 66: ...66 Appendix ...
Page 67: ...67 Appendix ...
Page 68: ...68 Appendix ...
