DATA LOGGING QA-TEMP
D
A
TA
LO
G
G
IN
G
Data (yyyy-mm-dd) & Time
Status ID
Analog
Input
Analog
Output
Input type
Output type
12345678
2014/03/12-14-23-25
0
99.96
2499
3
0
12345678
2014/03/12-14-24-25
0
99.92
2498
3
0
12345678
2014/03/12-14-25-25
0
99.96
2499
3
0
12345678
2014/03/12-14-26-25
0
100
2500
3
0
Q
A
-T
E
M
P
5
09
2015
Serial
Number
The QA-TEMP provides, on a local memory type PEN DRIVE USB (USB KEY) connected to the module via the microUSB, a series of
information concerning the operation of the module, alarm status, type of input, the output type, the reading of the measured
data, the measure of the output value from the module.
For each row correspond to a precise time reference. The module is equipped with an RTC Real Time Clock powered by a backup
battery that lets you record data with YEAR / MONTH / DAY / HOUR - MIN - SEC.
EXAMPLE OF LOG FILE:
for 400ohm 2-wire RESISTOR input, one sample per minute, 0-10V output.
The first number listed is the
SERIAL NUMBER
of the module, which allows it to be uniquely identified.
The second column give you information about:
DATE
(YEAR / MONTH / DAY / HOUR - MIN - SEC).
It is then reported the
STATUS ID
(Registry STATE) in binary mode to 16 bit. The binary number corresponds to the Modbus register
40005 that represents the state of the machine (Status: bit 1 = fail global, bit 2 = alarm, bit 3 = OVER RANGE, bit 4 = UNDER RANGE,
bit 5 = din status, bit 6 = dout status, bit 7 = fail hw, bit 8 = fail log, bit 9 = fail RTC, bit 10 = fail EEPROM, bit 11 = fail sensor).
The fourth column we find the information from
ANALOG INPUT
:
temperature, potentiometer or resistor.
ANALOG OUTPUT:
the value uA or in mV output of the module. This value follows the setting made via FACILE.
INPUT TYPE:
refered to the Modbus Register 101 that indicate the type of the Input sensor (Analog Input type : 2=Potentiometer,
3=Resistor400-2W, 4=Resistor400-3W, 5=Resistor400-4W, 6=Resistor4000-2W, 7=Resistor4000-3W, 8=Resistor4000-4W, 9=NI100-2W,
10=NI100- 3W, 11=NI100-4W, 12=PT100-2W, 13=PT100-3W, 14=PT100-4W, 15=PT500-2W, 16=PT500-3W, 17=PT500-4W, 18=PT1000-
2W, 19=PT1000-3W, 20=PT1000-4W, 21=TC J, 22=TC K, 23=TC R, 24=TC S, 25=TC T, 26=TC B, 27=TC E, 28=TC N).
OUTPUT TYPE:
refered to the
Modbus Register 106
that indicate the output configuration (Output Analog mode: bit
0=Voltage/Current, bit 1-2=analog input,frequency, period, totalizer, bit 3 = fail UNDER RANGE, bit 4 = fail OVER RANGE, bit 5 = fail
hardware, bit 6 = fail log, bit 7 = fail RTC, bit 8 = fail EEPROM, bit 9 = fail alarm, bit 10-11 = 1 threshold high/1 threshold low/2
thresholds external/2 thresholds internal , bit 12 = Manual mode).
AVAILABLE ON THE WEBSITE www.qeed.it the MACRO for charge the .csv file logged directly on a Excel file
HOW TO IMPORT LOG DATA FROM EXCEL VERSION BEFORE 2003:
It‘s possible to import the data stored on the USB Memory Stick at any time (even if the log is not finished). Once you open the file
with Excel (or Open Office), you will have to act on the functionality of the program for wrapping the data as described above. To
do this, you can perform the following steps: Select the first column, go to the option data, click on TEXT COLUMN, then choose
the option that provides for the separation of the data by tabs or commas, the next step endorse the option POINT and COMMA.
Following the procedure as soon as you get the data displayed in columns.
ENGLISH
